Exemplos de DB.execute em Python

Exemplo n.º 1

def insert_new_user(name, pwd):
    ret = DB.execute('''INSERT INTO user VALUES (NULL,"%s","%s");''' %
                     (name, pwd))
    ret = fetch_user_by_name(name)
    return ret

Exemplo n.º 2

def fetch_user_by_name(name):
    ret = DB.execute('SELECT * FROM user WHERE name="%s"' % (name))
    return ret[0] if ret else None