aboutsummaryrefslogtreecommitdiff
path: root/migration/v01.16.00-aliases.py
diff options
context:
space:
mode:
authorGravatar jesopo2019-11-20 11:57:38 +0000
committerGravatar jesopo2019-11-20 11:57:38 +0000
commit8eb26a5bd2569aab30f1b304320992c53438583c (patch)
tree5d26f64bd2f457b5d85a0e11fdbc133dc81fc509 /migration/v01.16.00-aliases.py
parentadd migration script for old aliases (diff)
signature
better printing for alias migration script
Diffstat (limited to 'migration/v01.16.00-aliases.py')
-rw-r--r--migration/v01.16.00-aliases.py7
1 files changed, 5 insertions, 2 deletions
diff --git a/migration/v01.16.00-aliases.py b/migration/v01.16.00-aliases.py
index ec0dd2cc..17cc9a2c 100644
--- a/migration/v01.16.00-aliases.py
+++ b/migration/v01.16.00-aliases.py
@@ -14,12 +14,15 @@ cursor.execute(
"""SELECT server_id, value FROM server_settings
WHERE setting='command-aliases'""")
results = cursor.fetchall()
-print(results)
+
+cursor.execute("SELECT server_id, alias FROM servers")
+servers = dict(cursor.fetchall())
for server_id, value in results:
aliases = json.loads(value)
for alias, command in aliases.items():
- print(server_id, alias, command)
+ print("[%s] Migrating '%s' ('%s')" %
+ (servers[server_id], alias, command))
cursor.execute("INSERT INTO server_settings VALUES (?, ?, ?)",
[server_id, "alias-%s" % alias, json.dumps(command)])
database.commit()