Tech
[Python] 前端想学后端，但是看完这段代码就已经力竭了
def fetch_created_at():
conn = pymysql.connect(
host=MYSQL_HOST, port=MYSQL_PORT, user=MYSQL_USER,
password=MYSQL_PASSWORD, database=MYSQL_DATABASE, charset="utf8mb4",
)
try:
with conn.cursor() as cur:
cur.execute("SELECT created_at FROM A WHERE uid=%s", (TARGET_UID,))
return [r[0] for r in cur.fetchall()]
finally:
conn.close()
就是一段读库操作，就涉及 py 的基础操作和上下文管理，PyMySQL 数据库操作。其中数据库操作又涉及 pymysql 的函数作用和事务处理。每一个知识点又能扩展很多内容🤯
Read the full discussion on V2EX
This article was aggregated from V2EX. Click to join the conversation.
View on V2EX