社区讨论V2EX 技术
前端想学后端，但是看完这段代码就已经力竭了
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", (TAR…
内容摘要
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 的函数作用和事务处理。每一个知识点又能扩展很多内容🤯
资讯来源
V2EX