今天查询pymysql的使用,看到推荐文档写了用了 with as 语法,以前只在打开文件时用了没有深入了解。
with…as,就是个python控制流语句,像 if ,while一样。
with…as可以认为是简化版的try except finally语句。如打开文件可以自动关闭。
with 对象1 as 返回值1, 对象2 as 返回值2:
do something with 返回值1,返回值2
对象必须包含两个方法:enter() ,exit()
返回值就是:enter()定义中返回的值,任何值都行,只要你知道如何处理。
class Case:
def enter(self):
return self
def exit(self, type, value, trace): //若发生错误,将打印
print “type:”, type // 相当于把 except finally 包装到函数中
print “value:”, value
print “trace:”, trace
def my_funcation(self):
return ‘ok’
"""https://pymysql.readthedocs.io/en/latest/user/examples.html"""
import pymysql.cursors
# Connect to the database
connection = pymysql.connect(host='localhost',
user='user',
password='passwd',
database='db',
charset='utf8mb4',
cursorclass=pymysql.cursors.DictCursor)
with connection:
with connection.cursor() as cursor:
# Create a new record
sql = "INSERT INTO `users` (`email`, `password`) VALUES (%s, %s)"
cursor.execute(sql, ('webmaster@python.org', 'very-secret'))
# connection is not autocommit by default. So you must commit to save
# your changes.
connection.commit()
with connection.cursor() as cursor:
# Read a single record
sql = "SELECT `id`, `password` FROM `users` WHERE `email`=%s"
cursor.execute(sql, ('webmaster@python.org',))
result = cursor.fetchone()
print(result)