dataRemover_examples.sh

#!/bin/bash

# Example usage of dataRemover.py

echo "=== Data Remover Examples ==="
echo ""

echo "=== Example 1: Delete specific numeric UIDs ==="
echo "python3 dataRemover.py --host localhost --username user --password pass --database mydb --uid-filter '1,5,10'"
echo ""

echo "=== Example 2: Delete specific string UIDs ==="
echo "python3 dataRemover.py --host localhost --username user --password pass --database mydb --uid-filter 'user1,admin,abc123'"
echo ""

echo "=== Example 3: Delete UIDs with special characters (REQUIRES QUOTES) ==="
echo "python3 dataRemover.py --host localhost --username user --password pass --database mydb --uid-filter '\"user@domain.com\",\"admin.test\",\"user+tag@example.org\"'"
echo ""

echo "=== Example 4: Delete mixed numeric and string UIDs ==="
echo "python3 dataRemover.py --host localhost --username user --password pass --database mydb --uid-filter '1,user2,\"admin@test.com\",100'"
echo ""

echo "=== Example 5: Delete UIDs with special characters using single quotes ==="
echo "python3 dataRemover.py --host localhost --username user --password pass --database mydb --uid-filter \"'user@domain.com','admin.test','user+tag@example.org'\""
echo ""

echo "Note: Replace 'localhost', 'user', 'pass', and 'mydb' with your actual MySQL connection details"
echo ""
echo "IMPORTANT: UIDs with special characters (@, ., +, etc.) MUST be quoted!"
echo "IMPORTANT: This script will ask for confirmation before deleting each user!"
echo "IMPORTANT: Both account and sod records will be deleted for each user!"
echo ""
echo "Examples of special characters that require quotes:"
echo "  - Email addresses: user@domain.com"
echo "  - Domain names: admin.test"
echo "  - URLs: user+tag@example.org"
echo "  - Any UID containing spaces, symbols, or special characters"