diff options
author | Kyomotoi <[email protected]> | 2020-08-12 00:05:21 +0800 |
---|---|---|
committer | Kyomotoi <[email protected]> | 2020-08-12 00:05:21 +0800 |
commit | b11b204043451334c33d827b776f230b6c8e84ce (patch) | |
tree | 32a1e42a3871e34401775bf7843444f3eeaa904a /ATRI/plugins/upload_sqlite.py | |
parent | 0cd82d9166c38fa455895cc236f406902e8e6549 (diff) | |
download | ATRI-b11b204043451334c33d827b776f230b6c8e84ce.tar.gz ATRI-b11b204043451334c33d827b776f230b6c8e84ce.tar.bz2 ATRI-b11b204043451334c33d827b776f230b6c8e84ce.zip |
[Fix]
Diffstat (limited to 'ATRI/plugins/upload_sqlite.py')
-rw-r--r-- | ATRI/plugins/upload_sqlite.py | 71 |
1 files changed, 39 insertions, 32 deletions
diff --git a/ATRI/plugins/upload_sqlite.py b/ATRI/plugins/upload_sqlite.py index a7c5b75..b399281 100644 --- a/ATRI/plugins/upload_sqlite.py +++ b/ATRI/plugins/upload_sqlite.py @@ -139,35 +139,42 @@ async def _(session: CommandSession): @on_command('data_list', aliases = ['查看上传数据', '数据总量'], only_to_me = False) async def _(session: CommandSession): - con = sqlite3.connect(Path('.') / 'ATRI' / 'data' / 'sqlite' / 'setu' / 'normal.db') # setu-normal - cur = con.cursor() - cur.execute("select * from normal") - data_normal = len(cur.fetchall()) - con.close() - - con = sqlite3.connect(Path('.') / 'ATRI' / 'data' / 'sqlite' / 'setu' / 'nearR18.db') # setu-nearR18 - cur = con.cursor() - cur.execute("select * from nearR18") - data_nearR18 = len(cur.fetchall()) - con.close() - - con = sqlite3.connect(Path('.') / 'ATRI' / 'data' / 'sqlite' / 'setu' / 'r18.db') # setu-r18 - cur = con.cursor() - cur.execute("select * from r18") - data_r18 = len(cur.fetchall()) - con.close() - - con = sqlite3.connect(Path('.') / 'ATRI' / 'data' / 'sqlite' / 'cloudmusic' / 'cloudmusic.db') # cloudmusic - cur = con.cursor() - cur.execute("select * from cloudmusic") - data_cloudmusic = len(cur.fetchall()) - con.close() - - await session.send( - f"""目前螃蟹™数据库收录了: -涩图: - normal: {data_normal} - nearR18: {data_nearR18} - r18:{data_r18} -网抑云语录:{data_cloudmusic}""" - )
\ No newline at end of file + user = session.event.user_id + with open('ATRI/plugins/noobList/noobList.json', 'r') as f: + data = json.load(f) + + if data[f"{user}"] == str(user): + pass + else: + con = sqlite3.connect(Path('.') / 'ATRI' / 'data' / 'sqlite' / 'setu' / 'normal.db') # setu-normal + cur = con.cursor() + cur.execute("select * from normal") + data_normal = len(cur.fetchall()) + con.close() + + con = sqlite3.connect(Path('.') / 'ATRI' / 'data' / 'sqlite' / 'setu' / 'nearR18.db') # setu-nearR18 + cur = con.cursor() + cur.execute("select * from nearR18") + data_nearR18 = len(cur.fetchall()) + con.close() + + con = sqlite3.connect(Path('.') / 'ATRI' / 'data' / 'sqlite' / 'setu' / 'r18.db') # setu-r18 + cur = con.cursor() + cur.execute("select * from r18") + data_r18 = len(cur.fetchall()) + con.close() + + con = sqlite3.connect(Path('.') / 'ATRI' / 'data' / 'sqlite' / 'cloudmusic' / 'cloudmusic.db') # cloudmusic + cur = con.cursor() + cur.execute("select * from cloudmusic") + data_cloudmusic = len(cur.fetchall()) + con.close() + + await session.send( + f"""目前螃蟹™数据库收录了: + 涩图: + normal: {data_normal} + nearR18: {data_nearR18} + r18:{data_r18} + 网抑云语录:{data_cloudmusic}""" + )
\ No newline at end of file |