python基于pymysql连接数据库

#encoding=utf-8


import pymysql as mysql_module
import queue
import threading


class sql_operate():
    dcur = 0
    USER = 0
    PASSWD = 1
    HOST = 2
    DB = 3
    CHAR_SET = 4
    g_conn = 0
    workqueue = queue.Queue(100)


    def __init__(self,sql_init):
        if isinstance(sql_init,list) and (len(sql_init) >= 4):


            try:
                conn = mysql_module.connect(user=sql_init[self.USER],passwd=sql_init[self.PASSWD],host=sql_init[self.HOST],db=sql_init[self.DB],charset = 'utf8')
                print(type(conn))
                self.g_conn = conn


             #   print(type(dd))
            except:
                print('connect err