Bash Script to rename an hashtag at bulk

[raviwarrier]

While the devs work on implementing a bulk tag editor feature, here's a bash script that is vibe-coded to do just that. Please check the code (if you are a developer) and let me know if there are any issues and I'll get it fixed before re-upping it.

1. copy paste the code below into rename_tags.sh
2. run chmod +x rename_tags.sh
3. run the script ./rename_tags.sh

#!/usr/bin/env bash

set -euo pipefail

echo "=== Memos SQLite Bulk Tag Editor ==="
echo ""

# 1. Check and install sqlite3 if missing
if ! command -v sqlite3 &> /dev/null; then
    echo "sqlite3 is not installed."
    read -p "Would you like to install sqlite3 now? (y/N): " INSTALL_CONFIRM
    if [[ "$INSTALL_CONFIRM" =~ ^[Yy]$ ]]; then
        echo "Installing sqlite3..."
        if command -v apt-get &> /dev/null; then
            sudo apt-get update && sudo apt-get install -y sqlite3
        elif command -v apk &> /dev/null; then
            sudo apk add sqlite3
        else
            echo "Error: Package manager not supported automatically. Please install sqlite3 manually."
            exit 1
        fi
    else
        echo "sqlite3 is required to run this script. Exiting."
        exit 1
    fi
fi

# 2. Prompt for Inputs
read -p "Enter path to Memos DB [/srv/ssd/Appdata/local/memos/memos_prod.db]: " DB_PATH
DB_PATH="${DB_PATH:-/srv/ssd/Appdata/local/memos/memos_prod.db}"

if [ ! -f "$DB_PATH" ]; then
    echo "Error: Database file not found at '$DB_PATH'."
    exit 1
fi

read -p "Enter Username (leave blank to search ALL users): " USERNAME
read -p "Enter Old Tag (without #, e.g. 'thisthing'): " OLD_TAG
read -p "Enter New Tag (without #, e.g. 'thatthing'): " NEW_TAG

# Strip '#' if user accidentally typed it
OLD_TAG="${OLD_TAG#\#}"
NEW_TAG="${NEW_TAG#\#}"

if [ -z "$OLD_TAG" ] || [ -z "$NEW_TAG" ]; then
    echo "Error: Old tag and new tag cannot be empty."
    exit 1
fi

# 3. Resolve User ID (if provided)
USER_FILTER=""
if [ -n "$USERNAME" ]; then
    USER_ID=$(sqlite3 "$DB_PATH" "SELECT id FROM user WHERE username='$USERNAME';" 2>/dev/null || true)
    
    if [ -z "$USER_ID" ]; then
        echo "Error: User '$USERNAME' not found in database."
        exit 1
    fi
    echo "Found user '$USERNAME' with ID: $USER_ID"
    USER_FILTER="AND creator_id = $USER_ID"
fi

# 4. Check for matching memos before making changes
SEARCH_QUERY="SELECT COUNT(*) FROM memo WHERE content LIKE '%#${OLD_TAG}%' ${USER_FILTER};"
MATCH_COUNT=$(sqlite3 "$DB_PATH" "$SEARCH_QUERY")

if [ "$MATCH_COUNT" -eq "0" ]; then
    echo "No memos found containing '#${OLD_TAG}'."
    exit 0
fi

echo ""
echo "Found $MATCH_COUNT memo(s) containing '#${OLD_TAG}'."
read -p "Are you sure you want to replace '#${OLD_TAG}' with '#${NEW_TAG}'? (y/N): " CONFIRM

if [[ ! "$CONFIRM" =~ ^[Yy]$ ]]; then
    echo "Operation canceled."
    exit 0
fi

# 5. Create an automatic backup before modifying
BACKUP_PATH="${DB_PATH}.bak.$(date +%Y%m%d%H%M%S)"
echo ""
echo "Creating safety backup at: $BACKUP_PATH"
cp "$DB_PATH" "$BACKUP_PATH"

# 6. Perform Tag Replacement
echo "Updating memos..."

# Update raw markdown content in memo table
UPDATE_CONTENT_SQL="UPDATE memo 
SET content = REPLACE(content, '#${OLD_TAG}', '#${NEW_TAG}') 
WHERE content LIKE '%#${OLD_TAG}%' ${USER_FILTER};"

sqlite3 "$DB_PATH" "$UPDATE_CONTENT_SQL"

# Update tag table if present (newer schema versions)
TAG_TABLE_EXISTS=$(sqlite3 "$DB_PATH" "SELECT count(*) FROM sqlite_master WHERE type='table' AND name='tag';")
if [ "$TAG_TABLE_EXISTS" -eq "1" ]; then
    UPDATE_TAG_SQL="UPDATE tag SET name = '$NEW_TAG' WHERE name = '$OLD_TAG';"
    sqlite3 "$DB_PATH" "$UPDATE_TAG_SQL" 2>/dev/null || true
fi

echo ""
echo "Success! Replaced '#${OLD_TAG}' with '#${NEW_TAG}' across $MATCH_COUNT memo(s)."

# 7. Prompt to restart Docker container
read -p "Would you like to restart the Memos container now to refresh its cache? (y/N): " RESTART_CONFIRM

if [[ "$RESTART_CONFIRM" =~ ^[Yy]$ ]]; then
    read -p "Enter container name [memos]: " CONTAINER_NAME
    CONTAINER_NAME="${CONTAINER_NAME:-memos}"
    
    if command -v docker &> /dev/null; then
        echo "Restarting container '$CONTAINER_NAME'..."
        docker restart "$CONTAINER_NAME"
        echo "Container restarted successfully."
    else
        echo "Docker binary not found. Skipping container restart."
    fi
else
    echo "Skipped container restart. Remember to restart it manually later so UI caches update."
fi