Python MySQL数据库连接池组件

'password': 'root',

'database': 'test'

}

def connection_pool():

# Return a connection pool instance

pool = ConnectionPool(**config)

pool.connect()

return pool

# 直接拜访并获取一个 cursor 对象，主动 commit 模式会在这种方法下启用

with connection_pool().cursor() as cursor:

print('Truncate table user')

cursor.execute('TRUNCATE user')

print('Insert one record')

result = cursor.execute('INSERT INTO user (name, age) VALUES (%s, %s)', ('Jerry', 20))

print(result, cursor.lastrowid)

print('Insert multiple records')

users = [(name, age) for name in ['Jacky', 'Mary', 'Micheal'] for age in range(10, 15)]

result = cursor.executemany('INSERT INTO user (name, age) VALUES (%s, %s)', users)

print(result)

print('View items in table user')

cursor.execute('SELECT * FROM user')

for user in cursor:

print(user)

print('Update the name of one user in the table')

cursor.execute('UPDATE user SET name="Chris", age=29 WHERE id = 16'

　　推荐阅读

　　6个月融资超50亿元，云计算创业团队正做得风生水起？

此外，私有云市场对技巧请求低于公有云市场，同时又有各类开源技巧，也导致了该范畴内的竞争厂商数量明显多于公有云。在以前的180天里，在云计算范畴共有18家创虻公司获得融资，金额总数跨>>>详细阅读

地址：http://www.17bianji.com/lsqh/35872.html