def searchGame(data):
conn, cur = connectDb()
return makedicts(
cur,
"SELECT * FROM juego WHERE {f} LIKE '%{v}%'".format(f=data["field"],
v=data["value"]))
def getGameById(gameId=0):
conn, cur = connectDb()
return makedicts(cur, 'SELECT * FROM juego WHERE id = ?', (gameId, ))
def searchAllGame():
conn, cur = connectDb()
return makedicts(cur, 'SELECT * FROM juego')
def getUserByNick(nick):
conn, cur = connectDb()
return makedicts(cur,'SELECT * FROM usuario WHERE nick = ?', (nick, ))
def searchAllUser():
conn, cur = connectDb()
return makedicts(cur,'SELECT * FROM usuario WHERE ? = ?')
def searchUser(data):
conn, cur = connectDb()
return makedicts(cur, "SELECT * FROM usuario WHERE {f} LIKE '%{v}%'".format(f=data["field"], v=data["value"]))
def getUserByNick(nick):
conn, cur = connectDb()
return makedicts(cur, 'SELECT * FROM usuario WHERE nick = ?', (nick, ))
def searchAllUser():
conn, cur = connectDb()
return makedicts(cur, 'SELECT * FROM usuario WHERE ? = ?')
def searchAllGame():
conn, cur = connectDb()
return makedicts(cur, 'SELECT * FROM juego')
def getGameById(gameId = 0):
conn, cur = connectDb()
return makedicts(cur, 'SELECT * FROM juego WHERE id = ?', (gameId, ))
