Beispiel #1
0
def searchGame(data):
    conn, cur = connectDb()

    return makedicts(
        cur,
        "SELECT * FROM juego WHERE {f} LIKE '%{v}%'".format(f=data["field"],
                                                            v=data["value"]))
Beispiel #2
0
def getGameById(gameId=0):
    conn, cur = connectDb()

    return makedicts(cur, 'SELECT * FROM juego WHERE id = ?', (gameId, ))
Beispiel #3
0
def searchAllGame():
    conn, cur = connectDb()

    return makedicts(cur, 'SELECT * FROM juego')
Beispiel #4
0
def getUserByNick(nick):
    conn, cur = connectDb()

    return makedicts(cur,'SELECT * FROM usuario WHERE nick = ?', (nick, ))
Beispiel #5
0
def searchAllUser():
    conn, cur = connectDb()

    return makedicts(cur,'SELECT * FROM usuario WHERE ? = ?')
Beispiel #6
0
def searchUser(data):
    conn, cur = connectDb()

    return makedicts(cur, "SELECT * FROM usuario WHERE {f} LIKE '%{v}%'".format(f=data["field"], v=data["value"]))
Beispiel #7
0
def getUserByNick(nick):
    conn, cur = connectDb()

    return makedicts(cur, 'SELECT * FROM usuario WHERE nick = ?', (nick, ))
Beispiel #8
0
def searchAllUser():
    conn, cur = connectDb()

    return makedicts(cur, 'SELECT * FROM usuario WHERE ? = ?')
Beispiel #9
0
def searchAllGame():
    conn, cur = connectDb()

    return makedicts(cur, 'SELECT * FROM juego')
Beispiel #10
0
def getGameById(gameId = 0):
    conn, cur = connectDb()

    return makedicts(cur, 'SELECT * FROM juego WHERE id = ?', (gameId, ))