Sqlite

output.txt

D:\Documents\Dropbox\Projects\mRPG>python sqltest.py
In getage

sqltest.py

# Using the "dbmodule" from the previous example, create a ConnectionPool 
from twisted.enterprise import adbapi 
from twisted.internet import reactor, defer

dbpool = adbapi.ConnectionPool('sqlite3', "mrpg.db", check_same_thread=False)

# equivalent of cursor.execute(statement), return cursor.fetchall():
def getAge(user):
    print "In getage"
    return dbpool.runQuery("SELECT username FROM users WHERE username = ?", (user,))

def printResult(l):
    print "In printresult"
    if l:
        print(l)
        print l[0][0], " years old"
    else:
        print "No such user"

getAge("richard").addCallback(printResult)

reactor.run()