连接数据库

# coding=utf-8
import pymysql

"""
在mysql中使用下面这个命令登入MySQL: mysql -uroot -p password 
进入你项目使用的数据库 use yourdata_base 
输入以下命令： 
grant usage on *.* to 你项目使用的user@localhost identified by'你的密码'; 
例如： grant usage on *.* to root@localhost identified by'password'; 
最后输入： FLUSH PRIVILEGES;  

"""
def mysql_conn():
    # conn=pymysql.connect(host='localhost',user='pdiuser01',passwd='h87skwu62k',db='pdi_manager',charset='utf8')
    conn = pymysql.connect(host='211.103.199.115', port=3306, user='pdm002', passwd='pdm#Ko0307min', db='pdi_data', charset='utf8')

    return conn


def get_list(sql):
    conn = mysql_conn()
    cur = conn.cursor()
    # print(sql)
    cur.execute(sql)
    ds = cur.fetchall()
    cur.close()
    conn.close()
    return ds


def get_one(sql):
    conn = mysql_conn()
    cur = conn.cursor()
    cur.execute(sql)
    ds = cur.fetchone()
    cur.close()
    conn.close()
    return ds


def execute_sql(sql):
    conn = mysql_conn()
    cur = conn.cursor()
    cur.execute(sql)
    conn.commit()
    cur.close()
    conn.close()


def execute_proc(proname, val):
    conn = mysql_conn()
    cur = conn.cursor()
    cur.callproc(proname, val)
    reval = cur.fetchone()
    cur.close()
    conn.commit()
    conn.close()
    return reval