mysq日志文件

1、安装库 ：pip3 install pymysql

2、python执行MySQL的增删改查，代码如下：

import pymysql


# def insertOne():
# 	"""单挑语句"""
# 	try:
# 		conn=pymysql.connect(host='127.0.0.1',user='root',passwd='123456',db='testDev')
# 	except Exception as e:
# 		raise e.args
# 	else:
# 		#创建游标
# 		cur=conn.cursor()
# 		sql='insert into user  values(%s,%s,%s,%s,%s,%s)'
# 		params=(11,'hi','hi name',19,'boy',1008)
# 		cur.execute(sql,params)
# 		#必须commit，不commit数据是提交不了的
# 		conn.commit()
# 	finally:
# 		cur.close()
# 		conn.close()
#
# insertOne()


def insertOne():
	try:
		"""插入多条语句"""
		conn=pymysql.connect(host='127.0.0.1',user='root',passwd='123456',db='testDev')
	except Exception as e:
		raise e.args
	else:
		#创建游标
		cur=conn.cursor()
		sql='insert into user  values(%s,%s,%s,%s,%s,%s)'
		params=[
			(2,'hi','hi name',19,'boy',1008),
			(3,'hi', 'hi name', 19, 'boy', 1008)
		]
		cur.executemany(sql,params)
		#必须commit，不commit数据是提交不了的
		conn.commit()
	finally:
		cur.close()
		conn.close()

# insertOne()


# def queryMany():
# 	try:
# 		"""读取多条语句"""
# 		conn = pymysql.connect(host='127.0.0.1', user='root', passwd='123456', db='testDev')
# 	except Exception as e:
# 		raise e.args
# 	else:
# 		cur=conn.cursor()
# 		sql="select * from user;"
# 		cur.execute(sql)
# 		#获取查询的结果数据
# 		data=cur.fetchall()
# 		for item in data:
# 			print(item)
# 	finally:
# 		cur.close()
# 		conn.close()
#
# queryMany()


def queryMany():
	try:
		"""读取单条语句"""
		conn = pymysql.connect(host=readJson()["login"]['host'],
		                       user=readJson()['login']['user'],
		                       passwd=readJson()['login']['passwd'],
		                       db=readJson()['login']['db'])
	except Exception as e:
		raise e.args
	else:
		cur=conn.cursor()
		sql="select * from user where  id=%s;"
		params=(2,)
		cur.execute(sql,params)
		#获取查询的结果数据
		data=cur.fetchone()
		print(data)
	finally:
		cur.close()
		conn.close()

queryMany()


# def updateOne():
# 	try:
# 		"""修改单条语句"""
# 		conn = pymysql.connect(host='127.0.0.1', user='root', passwd='123456', db='testDev')
# 	except Exception as e:
# 		raise e.args
# 	else:
# 		cur=conn.cursor()
# 		sql="update user set first_name=%s  where id=%s ;"
# 		params=('Hi',2)
# 		cur.execute(sql,params)
# 		conn.commit()
# 	finally:
# 		cur.close()
# 		conn.close()
#
# updateOne()


# def deleteOne():
# 	try:
# 		"""删除单条语句"""
# 		conn = pymysql.connect(host='127.0.0.1', user='root', passwd='123456', db='testDev')
# 	except Exception as e:
# 		raise e.args
# 	else:
# 		cur=conn.cursor()
# 		sql="delete from user where  id=%s ;"
# 		params=(10,)
# 		cur.execute(sql,params)
# 		conn.commit()
# 	finally:
# 		cur.close()
# 		conn.close()
#
# deleteOne()

　　

 

3、分离文件

（1）创建一个json文件，把要分离的内容写进去

 

 

 （2）创建一个utils包，在utils包下面创建一个pathUtils.py文件，获取当前工程的路径

import os
def base_dir():
	"""获取当前工程的路径"""
	return os.path.dirname(os.path.dirname(__file__))
print(base_dir())

def filePath(directory='data',fileName=None):
	#找到文件的路径
	return os.path.join(base_dir(),directory,fileName)

　　

（3）获取文件的内容

import json
from utils.pathUtils import base_dir,filePath
import os

def readJson():
	return json.load(open(filePath(fileName='sina.json'),encoding='utf-8'))
print(readJson())

　　执行代码，输出结果：

 

 （4）在执行代码的时候调用该方法

import pymysql
from utils.joinUtils import readJson


def queryMany():
	try:
		"""读取单条语句"""
		conn = pymysql.connect(host=readJson()["login"]['host'],
		                       user=readJson()['login']['user'],
		                       passwd=readJson()['login']['passwd'],
		                       db=readJson()['login']['db'])
	except Exception as e:
		raise e.args
	else:
		cur=conn.cursor()
		sql="select * from user where  id=%s;"
		params=(2,)
		cur.execute(sql,params)
		#获取查询的结果数据
		data=cur.fetchone()
		print(data)
	finally:
		cur.close()
		conn.close()

queryMany()

　　执行以上代码：