Python db示例

示例#1

def addRunk(name):
    connection = dbAccessor.db()
    user = connection.query(__getUserQuery, (name, ), False, True)
    if not user:
        connection.query(__insertUserQuery, (name, ), True)
    timestamp = datetime.today().isoformat()
    params = (name, timestamp)
    execution = connection.query(__addRunkQuery, params, True)
    return execution

示例#2

def delCommand(phrase):
    connection = dbAccessor.db()
    return connection.query(__delCommandQuery, (phrase, ), True)

示例#3

def listCommands():
    connection = dbAccessor.db()
    return connection.query(__getAllCommandsQuery)

示例#4

def getCommand(phrase):
    connection = dbAccessor.db()
    return connection.query(__getCommandQuery, (phrase, ), False, True)

示例#5

def addCommand(phrase, msg):
    connection = dbAccessor.db()
    params = (phrase, msg)
    connection.query(__addCommandQuery, params, True)

示例#6

def getRunkHighscore():
    connection = dbAccessor.db()
    return connection.query(__getRunksHighscoreQuery)

示例#7

def getRunkHighscoreByUsername(name):
    connection = dbAccessor.db()
    return connection.query(__getRunksHighscoreByUserQuery, (name, ),
                            single=True)

示例#8

def getUser(name):
    connection = dbAccessor.db()
    return connection.query(__getUserQuery, (name, ), False, True)

示例#9

def saveUser(name):
    connection = dbAccessor.db()
    connection.query(__insertUserQuery, (name, ), True)