DAtest.py 文件源码

def token_saver(token):
    """Saves the token json/dict format inside deviantartdb.sqlite on Table: deviantart_session.
    token_saver argument parameters:
    - token:    The argument should be a variable in json/dict format:
            {"expires_in": 3600,  "status": "success",  "access_token": "Alph4num3r1ct0k3nv4lu3",  "token_type": "Bearer"}"""
    conn = sqlite3.connect('deviantartdb.sqlite')
    cur = conn.cursor()
    cur.executescript('''DROP TABLE IF EXISTS deviantart_session;
    CREATE TABLE deviantart_session( `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,`token` TEXT, 'expires_at' varchar(64) )''')
    token_dump=json.dumps(token)
    token=json.loads(token_dump)
    expires_at=time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(token['expires_at']))
    cur.execute('''INSERT INTO deviantart_session (token, expires_at) VALUES ( ?, ? ) ''', (token_dump, expires_at)  )
    conn.commit()
    cur.close()