AI_Spokesgirl/api/test.py

import util.user
import dataset
import models
from passlib.context import CryptContext
import time
import mailer
import first

def prof():
    db = dataset.connect('mysql://choozmo:pAssw0rd@db.ptt.cx:3306/AI_anchor?charset=utf8mb4')
    user_id = 36


    user_obj = next(iter(db.query('SELECT * FROM users where id ="'+str(user_id)+'"')))
    data = {'username':user_obj['username'],'email':'ming'}
    db['users'].update(dict(data), ['username'])

prof()