Mercurial > hg > orthanc-databases
comparison PostgreSQL/Plugins/PostgreSQLIndex.cpp @ 396:7b3acfa95bd8 db-protobuf
implementation of list/add/remove labels in postgresql
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Thu, 06 Apr 2023 19:00:29 +0200 |
parents | 3d6886f3e5b3 |
children | 91124cc8a8c7 |
comparison
equal
deleted
inserted
replaced
395:a7a029043670 | 396:7b3acfa95bd8 |
---|---|
295 t.GetDatabaseTransaction().ExecuteMultiLines("ALTER TABLE AttachedFiles ADD COLUMN revision INTEGER"); | 295 t.GetDatabaseTransaction().ExecuteMultiLines("ALTER TABLE AttachedFiles ADD COLUMN revision INTEGER"); |
296 } | 296 } |
297 | 297 |
298 t.Commit(); | 298 t.Commit(); |
299 } | 299 } |
300 | |
301 | |
302 { | |
303 // New in release 5.0 to deal with labels | |
304 DatabaseManager::Transaction t(manager, TransactionType_ReadWrite); | |
305 | |
306 if (!t.GetDatabaseTransaction().DoesTableExist("Labels")) | |
307 { | |
308 t.GetDatabaseTransaction().ExecuteMultiLines( | |
309 "CREATE TABLE Labels(" | |
310 "id BIGINT REFERENCES Resources(internalId) ON DELETE CASCADE," | |
311 "label TEXT, PRIMARY KEY(id, label));" | |
312 "CREATE INDEX LabelsIndex1 ON LABELS(id);" | |
313 "CREATE INDEX LabelsIndex2 ON LABELS(label);"); | |
314 } | |
315 | |
316 t.Commit(); | |
317 } | |
300 } | 318 } |
301 } | 319 } |
302 | 320 |
303 | 321 |
304 int64_t PostgreSQLIndex::CreateResource(DatabaseManager& manager, | 322 int64_t PostgreSQLIndex::CreateResource(DatabaseManager& manager, |