[Introspection] "created_at timestamp with time zone not null default now()" doesn't work

[matthewmueller]

Many postgres schemas have something like:

    CREATE TABLE note(
        id serial PRIMARY KEY,
        created_at TIMESTAMP WITH TIME ZONE not null DEFAULT now()
    );

or

    CREATE TABLE note(
        note_id serial PRIMARY KEY,
        created_at TIMESTAMP WITH TIME ZONE not null DEFAULT CURRENT_TIMESTAMP
    );

I've talked to @do4gr and he says we handle this wrong:

let default = col.get("column_default").and_then(|param_value| {
    param_value
        .to_string()
        .map(|x| x.replace("\'", "").replace("::text", ""))
});

[janpio]

Can you provide an example what currently happens with tables like this @matthewmueller? Does it throw an error? Is the inferred model incorrect?

[pantharshit00]

Right now we just don't have a default value for such fields:

[janpio]

Next steps:

• Research what variants exist
• Create a table that has some/all of them
• Then see how this is introspected
• If something is wrong, fix it

[janpio]

Related to #487

[danilofuchs]

Just in case another example is needed for testing, I created a simple schema in MySQL:

CREATE TABLE Todo (
  id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
  description VARCHAR(255),
  completedAt DATETIME,
  createdAt DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updatedAt DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

The output schema.prisma:

model Todo {
  completedAt DateTime?
  createdAt   DateTime
  description String?
  id          Int       @default(autoincrement()) @id
  updatedAt   DateTime
}

@default decorators are not being set to createdAt and updatedAt fields.

[janpio]

This should be fixed in the current alpha version now.

Can you try and confirm this behaves as expected @matthewmueller and @danilofuchs? Thanks.

[danilofuchs]

Yes, indeed!
OLD:

model Todo {
  completedAt DateTime?
  createdAt   DateTime
  description String?
  id          Int       @default(autoincrement()) @id
  updatedAt   DateTime
}

NEW:

model Todo {
  completedAt DateTime?
  createdAt   DateTime  @default(now())
  description String
  id          Int       @default(autoincrement()) @id
  updatedAt   DateTime  @default(now())
}