{
"event": "PreToolUse",
"tool_name": "Bash",
"tool_input": {
"command": "\/var\/www\/scripts\/pipeline\/venv\/bin\/python -c \"\nimport sys\nsys.path.insert(0, '\/var\/www\/scripts\/pipeline')\nfrom config import DB_CONFIG\nimport mysql.connector\n\nfor db in ('crawler', 'crawler_test'):\n c = mysql.connector.connect(host=DB_CONFIG['host'], user=DB_CONFIG['user'], password=DB_CONFIG['password'], database=db)\n cur = c.cursor()\n try:\n cur.execute('ALTER TABLE page_tokens ADD COLUMN lemma VARCHAR(80) NULL AFTER token, ADD INDEX idx_lemma (lemma)')\n print(f'{db}: lemma added')\n except mysql.connector.Error as e:\n print(f'{db}: {e}')\n cur.execute('''CREATE TABLE IF NOT EXISTS reference_corpus_de (\n id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,\n corpus VARCHAR(40) NOT NULL,\n token VARCHAR(80) NOT NULL,\n frequency BIGINT UNSIGNED NOT NULL,\n UNIQUE KEY uq_corpus_token (corpus, token),\n INDEX idx_token (token)\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci''')\n print(f'{db}: reference_corpus_de ready')\n c.commit()\n c.close()\n\"",
"description": "Migrate DBs"
}
}
{
"tool_response": {
"stdout": "crawler: lemma added\ncrawler: reference_corpus_de ready\ncrawler_test: lemma added\ncrawler_test: reference_corpus_de ready",
"stderr": "",
"interrupted": false,
"isImage": false,
"noOutputExpected": false
}
}