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);