migrate config from medis to AnotherRedisDesktopManager

medis-export.py

import base64
import os
import json
from sqlalchemy import create_engine

path = os.path.expanduser('~/Library/Containers/li.zihua.medis/Data/Library/Application Support/Medis/Local Storage/file__0.localstorage')
engine = create_engine(f'sqlite:///{path}')
res = engine.execute("select * from main.ItemTable where `key`='favorites'").fetchone()
res = dict(res)
old = json.loads(res['value'])
new = []
for item in old:
    if not item.get("host"):
        print(f"skip {item!r}")
        continue
    new.append({
        "auth": item.get('password', ''),
        "host": item["host"],
        "key": item["key"],
        "name": item["name"],
        "port": item["port"],
    })

print(json.dumps(new, indent=4, ensure_ascii=False))
with open('redis-conn.ano', 'wb') as fp:
    fp.write(base64.b64encode(json.dumps(new).encode('utf8')))