def db_find_result(lotto_id, params): query_sql = "SELECT * FROM lotto_result_{} WHERE 1=1 ".format(lotto_id) if params.get("issue"): query_sql += " AND issue=%(issue)s " if params.get("status"): query_sql += " AND status=%(status)s " return query_for_list(query_sql, params)
def db_find_lotto_push(params): query_sql = "SELECT * FROM lotto_push WHERE 1=1 " if params.get("id"): query_sql += " AND id=%(id)s " if params.get("status"): query_sql += " AND status=%(status)s " return query_for_list(query_sql, params)
def db_find_lotto_factory(params=None): if params is None: params = {} query_sql = "SELECT * FROM issue_factory WHERE 1=1" if params.get("lotto_id"): query_sql += " AND lotto_id=%(lotto_id)s " if params.get("status"): query_sql += " AND status=%(status)s " return query_for_list(query_sql, params)
def db_find_lotto_parser_url(params=None): if params is None: params = {} query_sql = "SELECT * FROM lotto_parser_url WHERE 1=1 " if params.get("id"): query_sql += " AND id=%(id)s " if params.get("lotto_id"): query_sql += " AND lotto_id=%(lotto_id)s " if params.get("status"): query_sql += " AND status=%(status)s " return query_for_list(query_sql, params)
def db_find_result(lotto_id, count): lotto_id = get_int(lotto_id) count = get_int(count) query_sql = "SELECT issue, draw_number FROM lotto_result_{} WHERE status=1 ORDER BY issue DESC LIMIT %s".format( lotto_id) return query_for_list(query_sql, count)