diff options
| author | Fuwn <[email protected]> | 2024-05-14 08:25:33 +0000 |
|---|---|---|
| committer | Fuwn <[email protected]> | 2024-05-14 08:33:58 +0000 |
| commit | 50314eba1f00b5ec8c57ab82031792df80f4bb4e (patch) | |
| tree | 103d8cdbd8f7b1b69423e9e4aea58307d8482564 | |
| parent | feat(database): Ok assertions (diff) | |
| download | mayu-50314eba1f00b5ec8c57ab82031792df80f4bb4e.tar.xz mayu-50314eba1f00b5ec8c57ab82031792df80f4bb4e.zip | |
fix(database): non-constant defaults sqlite
| -rw-r--r-- | src/database.gleam | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/src/database.gleam b/src/database.gleam index d4d2c0b..8e8d320 100644 --- a/src/database.gleam +++ b/src/database.gleam @@ -21,9 +21,12 @@ pub fn setup(connection) { let add_column = fn(name) { let _ = sqlight.exec( - "alter table tb_count add column " - <> name - <> " text default current_timestamp;", + "alter table tb_count add column " <> name <> " text;", + connection, + ) + let _ = + sqlight.exec( + "update tb_count set " <> name <> " = current_timestamp;", connection, ) |