diff options
author | Christopher Baines <mail@cbaines.net> | 2020-01-24 19:47:43 +0000 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2020-01-25 22:22:39 +0000 |
commit | fa412cdb5985ec4199f89510d8d8cde9b7664e2d (patch) | |
tree | d4650e78333873df4837840a11560e60ab83928c /src/cuirass/database.scm | |
parent | 9eb96d1b197d674d34daf4de8c75fa9ee337f583 (diff) | |
download | cuirass-fa412cdb5985ec4199f89510d8d8cde9b7664e2d.tar cuirass-fa412cdb5985ec4199f89510d8d8cde9b7664e2d.tar.gz |
Alter the Builds table to have an id fieldimprove-handling-of-rowids
The internal rowid's are used for builds as you can request builds by using
the rowid in the URL.
The motivation here is to enable running VACUUM operations in SQLite, without
risking the rowid's for Builds changing. It would be bad if they change, as
they're used in the URL's for builds.
* src/schema.sql (Builds): Add id column.
* src/curiass/dataabse.scm (db-add-build): Change PRIMARYKEY constraint to
UNIQUE constraint.
* src/sql/upgrade-6.sql: New file.
* Makefile.am (dist_sql_DATA): Add it.
Diffstat (limited to 'src/cuirass/database.scm')
-rw-r--r-- | src/cuirass/database.scm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/cuirass/database.scm b/src/cuirass/database.scm index 1643916..14cbbda 100644 --- a/src/cuirass/database.scm +++ b/src/cuirass/database.scm @@ -540,7 +540,7 @@ VALUES (" ;; If we get a unique-constraint-failed error, that means we have ;; already inserted the same build. That happens when several jobs ;; produce the same derivation, and we can ignore it. - (on SQLITE_CONSTRAINT_PRIMARYKEY + (on SQLITE_CONSTRAINT_UNIQUE => (sqlite-exec db "ROLLBACK;") #f)))) |