mirror of
https://github.com/norohind/FDEV-CAPI-Handler.git
synced 2025-04-16 07:20:32 +03:00
norohind
b6392f8d20
Because user can don't have a game so no nickname, but his FDEV tokens still suits for not CAPI requests (i.e. squadrons api)
53 lines
1.2 KiB
Python
53 lines
1.2 KiB
Python
import sqlite3
|
|
import capi
|
|
|
|
db = sqlite3.connect('companion-api.sqlite')
|
|
|
|
|
|
backup_table_request = "ALTER TABLE authorizations RENAME TO authorizations_bak;"
|
|
|
|
restore_table_request = """
|
|
INSERT INTO authorizations (
|
|
code_verifier,
|
|
state,
|
|
timestamp_init,
|
|
code,
|
|
access_token,
|
|
refresh_token,
|
|
expires_in,
|
|
timestamp_got_expires_in,
|
|
nickname,
|
|
refresh_tries,
|
|
usages
|
|
)
|
|
SELECT
|
|
code_verifier,
|
|
state,
|
|
timestamp_init,
|
|
code,
|
|
access_token,
|
|
refresh_token,
|
|
expires_in,
|
|
timestamp_got_expires_in,
|
|
nickname,
|
|
refresh_tries,
|
|
usages
|
|
FROM authorizations_bak;
|
|
"""
|
|
|
|
drop_old_table_request = "drop table authorizations_bak;"
|
|
|
|
with db:
|
|
db.execute(backup_table_request)
|
|
db.execute(capi.sqlite_requests.schema)
|
|
db.execute(restore_table_request)
|
|
db.execute(drop_old_table_request)
|
|
|
|
db.close() # schema migration ended, begin inserting fids
|
|
|
|
all_records = capi.capi_authorizer.list_all_records()
|
|
for record in all_records:
|
|
if record['fid'] is None and record['nickname'] is not None:
|
|
fid = capi.utils.get_fid(record['access_token'])
|
|
capi.capi_authorizer.model.set_fid(fid, record['state'])
|