text: #!/usr/bin/env python
  # coding: utf-8
  
  import MySQLdb
  
  from clocwalk.libs.core.datatype import AttribDict
  
  
  class MySQLHelper(object):
  
      def __init__(self, **kwargs):
          """
  
          :param db_path:
          :param is_create:
          """
          user = kwargs.get('user', 'root')
          password = kwargs.get('passwd', '')
          db = kwargs.get('db', 'cve_cpe')
          port = kwargs.get('port', 3306)
  
          self.connect = MySQLdb.connect(passwd=password, db=db, user=user, port=port)
          self.cursor = self.connect.cursor()
  
      def create_cpe_bulk(self, items):
          """
  
          :param items:
          :return:
          """
          try:
              self.cursor.executemany(
                  "INSERT INTO cpe_match (`vendor`, `product`, `version`, `update`, `cpe23uri`, "
                  "`edition`, `language` , `sw_edition`, `target_sw`, `target_hw`, `other`) "
                  "VALUES(%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);", items
              )
              self.connect.commit()
          except Exception as ex:
              import traceback;
              traceback.print_exc()
  
      def create_cve_bulk(self, items):
          """
  
          :param items:
          :return:
          """
          try:
              self.cursor.executemany(
                  "INSERT INTO cve (`cve`, `cpe23uri`, `description`, `links`, `problemtype`, `year`, `cvss_v2_severity`, "
                  "`cvss_v2_impactscore`, `cvss_v3_impactscore`) VALUES(%s, %s, %s, %s, %s, %s, %s, %s, %s);",
                  items
              )
              self.connect.commit()
          except Exception as ex:
              import traceback;
              traceback.print_exc()
  