python mysql util_python - 接口自动化测试 - MysqlUtil - 数据库操作封装

# -*- coding:utf-8 -*-

'''

@project: ApiAutoTest

@author: Jimmy

@file: mysql_util.py

@ide: PyCharm Community Edition

@time: 2018-12-22 10:30

@blog: https://www.cnblogs.com/gotesting/

'''

'''

1. 连接数据库

2. 查询

3. 建立游标

4. 执行

'''

import pymysql

import traceback

from Common.read_config import ReadConfig

class MysqlUtil:

# 读取配置文件中的数据库配置信息，连接数据库

def __init__(self):

read_config = ReadConfig()

host = read_config.get_config_str('mysql','host')

port = read_config.get_config_int('mysql','po