def insert_yaml_detail_data(pg_detail_id, yaml_key, yaml_value, mysql): """ insert data details """ insert_sql = "insert into cve_git_package_info(git_id,package_name," \ "version,origin_url,create_time,update_time,decription,status) " \ "values(%s,%s,%s,%s,%s,%s,%s,%s)" val = (pg_detail_id, yaml_key, yaml_value["version"], yaml_value["url"], times.get_current_time(), times.get_current_time(), "", 0) last_id = mysql.insertOne(insert_sql, val) return last_id
def insert_yaml_data(package_id, yaml_key, yaml_value, mysql): """ insert data """ insert_sql = "insert into cve_git_open_euler(package_id,package_name," \ "version,origin_url,create_time,update_time,cpe_packname,status) " \ "values(%s,%s,%s,%s,%s,%s,%s,%s)" val = (package_id, yaml_key, yaml_value["version"], yaml_value["url"], times.get_current_time(), times.get_current_time(), yaml_value["cpeName"], 1) last_id = mysql.insertOne(insert_sql, val) return last_id
def insert_yaml_origin_data(yaml_key, yaml_value, mysql): """ insert origin data """ insert_sql = "insert into cve_open_guss_yaml(package_name," \ "version,origin_url, status, cpe_name,create_time,update_time, mark_bit, repo_name) " \ "values(%s,%s,%s,%s,%s,%s,%s,%s,%s)" val = (yaml_key, yaml_value["version"], yaml_value["url"], 1, yaml_value["cpeName"], times.get_current_time(), times.get_current_time(), 1, "security") last_id = mysql.insertOne(insert_sql, val) mysql.dispose() return last_id
def update_yaml_detail_data(pg_detail_id, yaml_key, yaml_value, mysql): """ Update data details """ update_sql = "update cve_git_package_info set package_name = %s,version = %s, " \ "origin_url = %s, update_time = %s,status=%s where git_id = %s" val = (yaml_key, yaml_value["version"], yaml_value["url"], times.get_current_time(), 0, pg_detail_id) mysql.update(update_sql, val)
def update_yaml_origin_data(pg_origin_id, yaml_value, mysql): """ Update origin data """ update_sql = "update cve_open_guss_yaml set origin_url = %s,status = %s, " \ "cpe_name = %s, update_time = %s,repo_name=%s, mark_bit = %s where id = %s" val = (yaml_value["url"], 1, yaml_value["cpeName"], times.get_current_time(), "security", 1, pg_origin_id) mysql.update(update_sql, val) mysql.dispose()
def update_yaml_data(package_id, yaml_key, yaml_value, mysql): """ update data """ update_sql = "update cve_git_open_euler set origin_url = %s,update_time = %s, " \ "cpe_packname = %s,status=%s where package_id = %s " \ "and package_name =%s and version = %s" val = (yaml_value["url"], times.get_current_time(), yaml_value["cpeName"], 1, package_id, yaml_key, yaml_value["version"]) mysql.update(update_sql, val)