mysql - Vapor MySQL 时间戳默认值

Question

我正在尝试创建一个具有各种时间戳(createdAt、updatedAt、deletedAt)和默认值的模型。如何实现？我尝试使用 prepare 方法，但无济于事。提前谢谢你。

这是我现在的类(class):

Answer 1

Vapor 提供以下内容:

 static func prepare(on connection: MySQLConnection) -> Future<Void> {
        return Database.create(self, on: connection) { builder in
             builder.field(for: \.iq, type: .int, .default(.literal("123456")))
            ...

这也适用于日期。

或者您可以尝试在自定义初始化中设置它们:

 required init(id:Int?, adressLine1:String, adressLine2:String?, city:String, state:String, zip:String) {
    self.id = id
    self.adressLine1 = adressLine1
    self.adressLine2 = adressLine2
    self.city:String = city:String
    self.state = state
    self.zip = zip
    self.createdAt = Date() //<---- here
    self.updatedAt = Date() //<---- here 
    self.deletedAt = Date() //<---- here
}

或:

required init(id:Int?, adressLine1:String, adressLine2:String?, city:String, state:String, zip:String, 
createdAt:Date = Date()/*<--- here*/, updatedAt:Date = Date()/*<--- here*/,deletedAt:Date = Date()/*<--- here*/) {
        self.id = id
        self.adressLine1 = adressLine1
        self.adressLine2 = adressLine2
        self.city:String = city:String
        self.state = state
        self.zip = zip
        self.createdAt = createdAt
        self.updatedAt = updatedAt
        self.deletedAt = deletedAt
    }