Spaces:
Paused
Paused
CBV01
feat: anti-ban delivery suite with 4-speed controls, post-campaign sweep, consecutive post shield, and permanent blacklist management
e767948 Download backend/migrate.py from adekolateam/arkitel: direct link, hf CLI and curl.
- Browser
- Download file 1.43 kB
-
https://huggingface.co/spaces/adekolateam/arkitel/resolve/main/backend/migrate.py
- Command line
-
hf download hf://spaces/adekolateam/arkitel/backend/migrate.py
-
curl -L -o migrate.py https://huggingface.co/spaces/adekolateam/arkitel/resolve/main/backend/migrate.py
1.43 kB
| import os | |
| from dotenv import load_dotenv | |
| from database import get_db_connection | |
| load_dotenv() | |
| def migrate(): | |
| conn = get_db_connection() | |
| print("Starting migration...") | |
| # List of alter table commands to ensure columns exist | |
| # SQLite/LibSQL doesn't have "IF NOT EXISTS" for ADD COLUMN, so we try/except | |
| alter_queries = [ | |
| ("users", "role", "TEXT DEFAULT 'user'"), | |
| ("users", "is_active", "INTEGER DEFAULT 1"), | |
| ("users", "passkey_verified", "INTEGER DEFAULT 0"), | |
| ("tasks", "interval_hours", "INTEGER DEFAULT 0"), | |
| ("tasks", "scheduled_time", "TEXT DEFAULT ''"), # In case it was missing | |
| ("tasks", "speed_mode", "TEXT DEFAULT 'balanced'"), | |
| ("tasks", "sweep_status", "TEXT DEFAULT 'idle'"), | |
| ("tasks", "deleted_groups", "TEXT DEFAULT '[]'"), | |
| ] | |
| for table, column, definition in alter_queries: | |
| try: | |
| print(f"Adding column {column} to {table}...") | |
| conn.execute(f"ALTER TABLE {table} ADD COLUMN {column} {definition}") | |
| print(f"Success: Added {column} to {table}") | |
| except Exception as e: | |
| # Most likely column already exists | |
| print(f"Skipped: {column} in {table} (Error: {str(e)})") | |
| if hasattr(conn, "commit"): conn.commit() | |
| if hasattr(conn, "close"): conn.close() | |
| print("Migration finished.") | |
| if __name__ == "__main__": | |
| migrate() | |