Can I use postgresql "CURRENT_TIMESTAMP" as a default value?

[GiyoMoon]

Hey, I'm using sea-orm with sea-query to create migrations which set up my postgresql database. I was wondering if it is possible to set CURRENT_TIMESTAMP as the default value for a timestamp colum. If yes, how would I do this?

Table::create()
    .table(User::Entity)
    .if_not_exists()
    .col(ColumnDef::new(User::Id).uuid().not_null().primary_key())
    .col(
        ColumnDef::new(User::CreatedAt)
            .timestamp()
            .default()  // <== HERE, I would like to set CURRENT_TIMESTAMP as the default value
            .not_null(),
    );

#[derive(Iden)]
pub enum User {
    Entity,
    Id,
    CreatedAt,
}

Should generate:

CREATE TABLE user (
    id UUID PRIMARY KEY
    created_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP
);

Btw awesome query builder and ORM crates! I love using them :)

[billy1624]

Hey @GiyoMoon, currently there is no official way of doing it. I just opened an issue tracking this:

• Table Column with Default Expression #347

At the meantime, you can use extra method as a workaround:

• sea-query/tests/mysql/table.rs

  Lines 114 to 133 in 6c9527a

  	#[test]
  	fn create_4() {
  	assert_eq!(
  	Table::create()
  	.table(Glyph::Table)
  	.col(
  	ColumnDef::new(Glyph::Id)
  	.integer()
  	.not_null()
  	.extra("ANYTHING I WANT TO SAY".to_owned())
  	)
  	.to_string(MysqlQueryBuilder),
  	vec![
  	"CREATE TABLE `glyph` (",
  	"`id` int NOT NULL ANYTHING I WANT TO SAY",
  	")",
  	]
  	.join(" ")
  	);
  	}

• e.g. .extra("DEFAULT CURRENT_TIMESTAMP".to_string())

[GiyoMoon]

Exactly what I need. Thank you very much!

[billy1624]

Welcome! Stay tuned for #347