如何在sqlalchemy中定义计算列date
列应根据timestamp
列计算(该列具有默认值,但也可由客户端设置)
这是我的表定义(mysql):
Create Table: CREATE TABLE `events` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL,
`timestamp` datetime DEFAULT CURRENT_TIMESTAMP,
`date` date GENERATED ALWAYS AS (cast(`timestamp` as date)) STORED,
PRIMARY KEY (`id`)
)
这是我的模型,date
服务器默认应该是什么?
class MyModel(db.Model):
__tablename__ = "my_table"
timestamp = db.Column(DateTime(), server_default = func.now())
date = db.Column(Date(), server_default = <??>)
dd
date = db.Column(Date(), server_default = func.date(timestamp))