connect_db.py

#coding:utf-8
import pymysql
import pymysql.cursors
from base.rwconfig import RWConfig
class OperationMysql:
    def __init__(self):
        self.db=RWConfig()
        self.conn = pymysql.connect(
            host=self.db.get_option_value("mysql-database","host"),
            user=self.db.get_option_value("mysql-database","user"),
            password=self.db.get_option_value("mysql-database","password"),
            database=self.db.get_option_value("mysql-database","database"),
            charset='utf8',
            cursorclass=pymysql.cursors.DictCursor
            )
        self.cur = self.conn.cursor()

    #查询一条数据
    def search_one(self,sql):
        self.cur.execute(sql)
        result = self.cur.fetchone()
        return result

    #查询多条数据
    def operation(self,sql):
        self.cur=self.conn.cursor(cursor=pymysql.cursors.DictCursor)
        self.cur.execute(sql)
        result = self.cur.fetchall()
        return result

if __name__ == '__main__':

    op_mysql = OperationMysql()
    user="IUOPU6eb460be2d38444cb9fb4ec6248a0b40"
    a=("SELECT * FROM icrm_customer_address WHERE defaultcode=1 AND user_code='{}'".format(user))
    b="SELECT id,order_no,type FROM order_posting WHERE user_code='IUOPU6eb460be2d38444cb9fb4ec6248a0b40' "
    res=op_mysql.operation(a)
    r=op_mysql.search_one(b)
    print(res)
    print(r)