1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
######################################################################
#
# File: doc/sqlite_account_info_schema.py
#
# Copyright 2019 Backblaze Inc. All Rights Reserved.
#
# License https://www.backblaze.com/using_b2_code.html
#
######################################################################
""" generates a dot file with SqliteAccountInfo database structure """
from __future__ import annotations
import tempfile
import operator
from sadisplay import describe, render
from sqlalchemy import create_engine, MetaData
from b2sdk._internal.account_info.sqlite_account_info import SqliteAccountInfo
def main():
with tempfile.NamedTemporaryFile() as fp:
sqlite_db_name = fp.name
SqliteAccountInfo(sqlite_db_name)
engine = create_engine('sqlite:///' + sqlite_db_name)
meta = MetaData()
meta.reflect(bind=engine)
tables = set(meta.tables.keys())
desc = describe(map(lambda x: operator.getitem(meta.tables, x), sorted(tables)))
print(getattr(render, 'dot')(desc).encode('utf-8'))
if __name__ == '__main__':
main()
|
