Mercurial > hg > orthanc-databases
comparison Framework/Plugins/IndexBackend.cpp @ 399:19bd3ee1f0b3 db-protobuf
support for labels in sqlite
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Fri, 07 Apr 2023 15:28:47 +0200 |
parents | 8dedfd982b83 |
children | 897253c21208 |
comparison
equal
deleted
inserted
replaced
398:8dedfd982b83 | 399:19bd3ee1f0b3 |
---|---|
2624 statement.reset(new DatabaseManager::CachedStatement( | 2624 statement.reset(new DatabaseManager::CachedStatement( |
2625 STATEMENT_FROM_HERE, manager, | 2625 STATEMENT_FROM_HERE, manager, |
2626 "INSERT INTO Labels VALUES(${id}, ${label}) ON CONFLICT DO NOTHING")); | 2626 "INSERT INTO Labels VALUES(${id}, ${label}) ON CONFLICT DO NOTHING")); |
2627 break; | 2627 break; |
2628 | 2628 |
2629 case Dialect_SQLite: | |
2630 statement.reset(new DatabaseManager::CachedStatement( | |
2631 STATEMENT_FROM_HERE, manager, | |
2632 "INSERT OR IGNORE INTO Labels VALUES(${id}, ${label})")); | |
2633 break; | |
2634 | |
2629 default: | 2635 default: |
2630 throw Orthanc::OrthancException(Orthanc::ErrorCode_NotImplemented); | 2636 throw Orthanc::OrthancException(Orthanc::ErrorCode_NotImplemented); |
2631 } | 2637 } |
2632 | 2638 |
2633 statement->SetParameterType("id", ValueType_Integer64); | 2639 statement->SetParameterType("id", ValueType_Integer64); |