How to set a default value for timestamp column?

[frederikhors]

Can you help me understand how to set a default value for timestamp column?

ColumnDef::new(Player::CreatedAt)
    .timestamp()
    .not_null()
    .default(/*WHAT?*/)

[frederikhors]

I found out how (for now): SeaQL/sea-query#346.

[ikrivosheev]

@frederikhors hello! We are working on this)

[billy1624]

Tracking PR and issue:

• ColumnDef with default expression sea-query#428
• Table Column with Default Expression sea-query#347

[christopherc1331]

Thanks for the link to the pull request! (I see that it was merged :D)

@frederikhors Now we can solve this with something like this:

.col(ColumnDef::new(Users::UpdatedTS).timestamp().default(SimpleExpr::Keyword(Keyword::CurrentTimestamp)).not_null())

[barsdeveloper]

I am creating my tables from the Model using schema.create_table_from_entity
Is there a way to set the current timestamp as a default value in the model?

#[derive(Clone, Debug, PartialEq, DeriveEntityModel)]
#[sea_orm(table_name = "configuration")]
pub struct Model {
    #[sea_orm(primary_key)]
    pub id: i32,
    #[sea_orm(default_value = CURRENT_TIMESTAMP)]
    pub some_timestamp: String,
}

This does not work because it expects some literal value.

[YCCDSZXH]

I found this code works..

#[derive(Clone, Debug, PartialEq, DeriveEntityModel)]
#[sea_orm(table_name = "configuration")]
pub struct Model {
    #[sea_orm(primary_key)]
    pub id: i32,
    #[sea_orm(default_expr = "Expr::current_timestamp()")]
    pub some_timestamp: String,
}

This code also works, and it generate sql with expected type

chrono::DateTime<Utc>
#[derive(Clone, Debug, PartialEq, DeriveEntityModel)]
#[sea_orm(table_name = "configuration")]
pub struct Model {
    #[sea_orm(primary_key)]
    pub id: i32,
    #[sea_orm(default_expr = "Expr::current_timestamp()")]
    pub some_timestamp: chrono::DateTime<Utc>,
}

`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,