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)
