def _get_by_ip(conn, host): sql_string = "SELECT * FROM host_tbl h WHERE h.ipv4 = %s" data = _sql._get_an_item(conn, sql_string, tuple([host["ipv4"]])) return data
def get_code_by_user(conn, user_name): sql_string = "SELECT * FROM verify_tbl WHERE user_name = %s" result = _sql._get_an_item(conn, sql_string, tuple([user_name])) if result is None: return None return _convert.verify_code_to_dict(result)
def _get_verify_code(conn, user): sql_string = "SELECT * FROM verify_tbl WHERE user_name = %s" result = _sql._get_an_item(conn, sql_string, tuple([user["userName"]])) return result
def _get_from_db(conn, data): sql_string = "SELECT * FROM task_tbl WHERE user_name = %s AND ipv4 = %s" result = _sql._get_an_item(conn, sql_string, tuple([data["userName"],data["ipv4"]])) return result
def _get_list_new(conn): sql_string = "SELECT * FROM task_tbl WHERE status = 0 ORDER BY time_stamp DESC" result = _sql._get_an_item(conn, sql_string, None) return result
def _get_credits(conn, user_name): sql_string = """SELECT credits FROM user_tbl WHERE user_name = %s""" result = _sql._get_an_item(conn, sql_string, tuple([user_name])) return result
def _get_by_email(conn, email): sql_string = """SELECT user_name FROM user_tbl WHERE email = %s""" result = _sql._get_an_item(conn, sql_string, tuple([email])) return result
def _get_by_name(conn, user_name): sql_string = """SELECT * FROM user_tbl WHERE user_name = %s""" data = _sql._get_an_item(conn, sql_string, tuple([user_name])) if data is None: return None return _convert.user_list_to_dict(data)
def _check_exits(conn, port_id, cve_num): sql_string = "SELECT * FROM port_vuln_tbl WHERE port_id = %s AND cve_num = %s" result = _sql._get_an_item(conn, sql_string, tuple([port_id, cve_num])) return result
def _check_exits_on_db(conn, host_ip, port_num): sql_string = "SELECT * FROM port_tbl p WHERE p.port_num = %s AND p.host_ip = %s" data = _sql._get_an_item(conn, sql_string, tuple([port_num,host_ip])) return data
def _get_by_id(conn, port): sql_string = "SELECT * FROM port_tbl p WHERE p.port_id = %s" data = _sql._get_an_item(conn, sql_string, tuple([port["port_id"]])) return data
def get_by_num(conn, cve_num): sql_string = "SELECT * FROM vuln_tbl WHERE cve_num = %s" result = _sql._get_an_item(conn, sql_string, tuple([cve_num])) return result