单刀直入

钻研的问题：如果我插入一个 datetime 的 tzinfo 北京时区的，peewee insert 的时候，会帮我转成 utc 再插入吗？

答案：不会

钻研过程

咱们通过

  • peewee 返回对的 sql
  • peewee 外部的 sql
  • 以及 wireshark 抓包获取的 sql

三者验证判断

from loguru import loggerimport settingsfrom peewee import *from datetime import datetime, timedelta, timezoneimport timeimport contextlibdef get_min_utc_timestamp() -> datetime:    return (datetime(year=1970, month=1, day=1) + timedelta(seconds=1)).replace(tzinfo=timezone.utc)def get_utc_now_timestamp() -> datetime:    """ https://blog.csdn.net/ball4022/article/details/101670024 """    return datetime.utcnow().replace(tzinfo=timezone.utc)def get_cst_now_timestamp() -> datetime:    """ https://segmentfault.com/q/1010000043912065 """    try:        from zoneinfo import ZoneInfo        tz = ZoneInfo('Asia/Shanghai')        return datetime.now(tz)    except ImportError:        beijing_offset = timedelta(hours=8)        current_time = datetime.now(timezone(beijing_offset))        return current_timehost = settings.MYSQL_CONFIG.hostport = settings.MYSQL_CONFIG.portusername = settings.MYSQL_CONFIG.usernamepassword = settings.MYSQL_CONFIG.passworddatabase_name = settings.MYSQL_CONFIG.database_namedb = MySQLDatabase(    database=database_name,    host=host,    port=port,    user=username,    password=password,    charset='utf8mb4')class User(Model):    name = CharField(unique=True)    age = IntegerField(null=True)    address = CharField(null=True)    city = CharField(null=True)    birth = DateTimeField(null=True)    created_at = DateTimeField(        null=False,        constraints=[SQL('DEFAULT CURRENT_TIMESTAMP')],        help_text='应用数据库工夫'    )    updated_at = DateTimeField(        null=False,        constraints=[            SQL('DEFAULT CURRENT_TIMESTAMP'),            SQL('ON UPDATE CURRENT_TIMESTAMP'),        ]    )    class Meta:        database = db        table_name = 'user'model_set = [User]db.drop_tables(model_set)db.create_tables(model_set)d = get_cst_now_timestamp()print(d)q = User.select().where(    User.age == 1,    User.birth == d)print('> sql', str(q))list(q)q = User.insert({'created_at': d})logger.debug(str(q))q.execute()

而后批改 peewee 的源码：

而后运行代码

输入如下：

>>> execute_sql sql SELECT table_name FROM information_schema.tables WHERE table_schema = DATABASE() AND table_type != %s ORDER BY table_name>> execute sql DROP TABLE IF EXISTS `user`>>> execute_sql sql DROP TABLE IF EXISTS `user`>>> execute_sql sql SELECT table_name FROM information_schema.tables WHERE table_schema = DATABASE() AND table_type != %s ORDER BY table_name>> execute sql CREATE TABLE IF NOT EXISTS `user` (`id` INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY, `name` VARCHAR(255) NOT NULL, `age` INTEGER, `address` VARCHAR(255), `city` VARCHAR(255), `birth` DATETIME, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP)>>> execute_sql sql CREATE TABLE IF NOT EXISTS `user` (`id` INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY, `name` VARCHAR(255) NOT NULL, `age` INTEGER, `address` VARCHAR(255), `city` VARCHAR(255), `birth` DATETIME, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP)>> execute sql CREATE UNIQUE INDEX `user_name` ON `user` (`name`)>>> execute_sql sql CREATE UNIQUE INDEX `user_name` ON `user` (`name`)2023-06-17 14:26:22.111281+08:00> sql SELECT `t1`.`id`, `t1`.`name`, `t1`.`age`, `t1`.`address`, `t1`.`city`, `t1`.`birth`, `t1`.`created_at`, `t1`.`updated_at` FROM `user` AS `t1` WHERE ((`t1`.`age` = 1) AND (`t1`.`birth` = '2023-06-17 14:26:22.111281+08:00'))>> execute sql SELECT `t1`.`id`, `t1`.`name`, `t1`.`age`, `t1`.`address`, `t1`.`city`, `t1`.`birth`, `t1`.`created_at`, `t1`.`updated_at` FROM `user` AS `t1` WHERE ((`t1`.`age` = %s) AND (`t1`.`birth` = %s))>>> execute_sql sql SELECT `t1`.`id`, `t1`.`name`, `t1`.`age`, `t1`.`address`, `t1`.`city`, `t1`.`birth`, `t1`.`created_at`, `t1`.`updated_at` FROM `user` AS `t1` WHERE ((`t1`.`age` = %s) AND (`t1`.`birth` = %s))2023-06-17 14:26:22.116 | DEBUG    | __main__:<module>:68 - INSERT INTO `user` (`created_at`) VALUES ('2023-06-17 14:26:22.111281+08:00')>> execute sql INSERT INTO `user` (`created_at`) VALUES (%s)>>> execute_sql sql INSERT INTO `user` (`created_at`) VALUES (%s)self._query_type 0
留神，我当初测试的工夫，就是北京工夫下午2点

查看 wireshark 的工夫

能够看到，抓包取得的工夫，都是下午2点，阐明没有产生时区转换

数据中写入的工夫，也是下午两点，阐明没错