Esempio n. 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"]))
Esempio n. 2
0
def getGameById(gameId=0):
    conn, cur = connectDb()

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

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

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

    return makedicts(cur,'SELECT * FROM usuario WHERE ? = ?')
Esempio n. 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"]))
Esempio n. 7
0
def getUserByNick(nick):
    conn, cur = connectDb()

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

    return makedicts(cur, 'SELECT * FROM usuario WHERE ? = ?')
Esempio n. 9
0
File: juego.py Progetto: Kherdu/GIW 
def searchAllGame():
    conn, cur = connectDb()

    return makedicts(cur, 'SELECT * FROM juego')
Esempio n. 10
0
File: juego.py Progetto: Kherdu/GIW 
def getGameById(gameId = 0):
    conn, cur = connectDb()

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