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 getGameById(gameId = 0): conn, cur = connectDb() return makedicts(cur, 'SELECT * FROM juego WHERE id = ?', (gameId, ))