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)