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, |