Mercurial > hg > orthanc
annotate OrthancFramework/Sources/SQLite/FunctionContext.cpp @ 5807:8279eaab0d1d attach-custom-data
merged default -> attach-custom-data
| author | Alain Mazy <am@orthanc.team> |
|---|---|
| date | Tue, 24 Sep 2024 11:39:52 +0200 |
| parents | f7adfb22e20e |
| children |
| rev | line source |
|---|---|
| 0 | 1 /** |
| 59 | 2 * Orthanc - A Lightweight, RESTful DICOM Store |
|
1220
9b9026560a5f
SQLite wrapper is now fully independent of Orthanc
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
824
diff
changeset
|
3 * |
| 3063 | 4 * Copyright (C) 2012-2016 Sebastien Jodogne <s.jodogne@orthanc-labs.com>, |
|
1220
9b9026560a5f
SQLite wrapper is now fully independent of Orthanc
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
824
diff
changeset
|
5 * Medical Physics Department, CHU of Liege, Belgium |
|
5640
f7adfb22e20e
updated copyright, as Orthanc Team now replaces Osimis
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5485
diff
changeset
|
6 * Copyright (C) 2017-2023 Osimis S.A., Belgium |
|
f7adfb22e20e
updated copyright, as Orthanc Team now replaces Osimis
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5485
diff
changeset
|
7 * Copyright (C) 2024-2024 Orthanc Team SRL, Belgium |
|
5485
48b8dae6dc77
upgrade to year 2024
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
5185
diff
changeset
|
8 * Copyright (C) 2021-2024 Sebastien Jodogne, ICTEAM UCLouvain, Belgium |
| 0 | 9 * |
| 17 | 10 * Redistribution and use in source and binary forms, with or without |
| 11 * modification, are permitted provided that the following conditions are | |
| 12 * met: | |
| 0 | 13 * |
| 17 | 14 * * Redistributions of source code must retain the above copyright |
| 15 * notice, this list of conditions and the following disclaimer. | |
| 16 * * Redistributions in binary form must reproduce the above | |
| 17 * copyright notice, this list of conditions and the following disclaimer | |
| 18 * in the documentation and/or other materials provided with the | |
| 19 * distribution. | |
| 20 * * Neither the name of the CHU of Liege, nor the names of its | |
| 21 * contributors may be used to endorse or promote products derived | |
| 22 * from this software without specific prior written permission. | |
| 23 * | |
| 24 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS | |
| 25 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT | |
| 26 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR | |
| 27 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT | |
| 28 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, | |
| 29 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT | |
| 30 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, | |
| 31 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY | |
| 32 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT | |
| 33 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE | |
| 34 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. | |
| 0 | 35 **/ |
| 36 | |
| 37 | |
|
1220
9b9026560a5f
SQLite wrapper is now fully independent of Orthanc
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
824
diff
changeset
|
38 #if ORTHANC_SQLITE_STANDALONE != 1 |
|
824
a811bdf8b8eb
precompiled headers
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
694
diff
changeset
|
39 #include "../PrecompiledHeaders.h" |
|
1220
9b9026560a5f
SQLite wrapper is now fully independent of Orthanc
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
824
diff
changeset
|
40 #endif |
|
9b9026560a5f
SQLite wrapper is now fully independent of Orthanc
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
824
diff
changeset
|
41 |
| 0 | 42 #include "FunctionContext.h" |
|
1220
9b9026560a5f
SQLite wrapper is now fully independent of Orthanc
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
824
diff
changeset
|
43 #include "OrthancSQLiteException.h" |
| 0 | 44 |
| 4304 | 45 #include <cassert> |
| 1464 | 46 #include <string> |
| 0 | 47 |
|
1474
3b68924ffb24
fix path to sqlite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
1464
diff
changeset
|
48 #include "sqlite3.h" |
|
3b68924ffb24
fix path to sqlite
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
1464
diff
changeset
|
49 |
| 59 | 50 namespace Orthanc |
| 0 | 51 { |
| 52 namespace SQLite | |
| 53 { | |
| 54 FunctionContext::FunctionContext(struct sqlite3_context* context, | |
| 55 int argc, | |
|
2302
f31dfb131dee
fix backward compatibility with SQLite < 3.19.0
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
2301
diff
changeset
|
56 Internals::SQLiteValue** argv) |
| 0 | 57 { |
| 58 assert(context != NULL); | |
| 59 assert(argc >= 0); | |
| 60 assert(argv != NULL); | |
| 61 | |
| 62 context_ = context; | |
| 63 argc_ = static_cast<unsigned int>(argc); | |
| 64 argv_ = argv; | |
| 65 } | |
| 66 | |
| 67 void FunctionContext::CheckIndex(unsigned int index) const | |
| 68 { | |
| 69 if (index >= argc_) | |
| 70 { | |
|
1582
bd1889029cbb
encoding of exceptions
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
1474
diff
changeset
|
71 throw OrthancSQLiteException(ErrorCode_ParameterOutOfRange); |
| 0 | 72 } |
| 73 } | |
| 74 | |
| 75 ColumnType FunctionContext::GetColumnType(unsigned int index) const | |
| 76 { | |
| 77 CheckIndex(index); | |
| 78 return static_cast<SQLite::ColumnType>(sqlite3_value_type(argv_[index])); | |
| 79 } | |
| 80 | |
| 4304 | 81 unsigned int FunctionContext::GetParameterCount() const |
| 82 { | |
| 83 return argc_; | |
| 84 } | |
| 85 | |
| 0 | 86 int FunctionContext::GetIntValue(unsigned int index) const |
| 87 { | |
| 88 CheckIndex(index); | |
| 89 return sqlite3_value_int(argv_[index]); | |
| 90 } | |
| 91 | |
|
273
d384af918264
more detailed signal about deleted file
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
59
diff
changeset
|
92 int64_t FunctionContext::GetInt64Value(unsigned int index) const |
|
d384af918264
more detailed signal about deleted file
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
59
diff
changeset
|
93 { |
|
d384af918264
more detailed signal about deleted file
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
59
diff
changeset
|
94 CheckIndex(index); |
|
d384af918264
more detailed signal about deleted file
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
59
diff
changeset
|
95 return sqlite3_value_int64(argv_[index]); |
|
d384af918264
more detailed signal about deleted file
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
59
diff
changeset
|
96 } |
|
d384af918264
more detailed signal about deleted file
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
59
diff
changeset
|
97 |
| 0 | 98 double FunctionContext::GetDoubleValue(unsigned int index) const |
| 99 { | |
| 100 CheckIndex(index); | |
| 101 return sqlite3_value_double(argv_[index]); | |
| 102 } | |
| 103 | |
| 104 std::string FunctionContext::GetStringValue(unsigned int index) const | |
| 105 { | |
| 106 CheckIndex(index); | |
| 107 return std::string(reinterpret_cast<const char*>(sqlite3_value_text(argv_[index]))); | |
| 108 } | |
|
694
72dc919a028c
upgrade database from v3 to v4
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
689
diff
changeset
|
109 |
|
72dc919a028c
upgrade database from v3 to v4
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
689
diff
changeset
|
110 bool FunctionContext::IsNullValue(unsigned int index) const |
|
72dc919a028c
upgrade database from v3 to v4
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
689
diff
changeset
|
111 { |
|
72dc919a028c
upgrade database from v3 to v4
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
689
diff
changeset
|
112 CheckIndex(index); |
|
72dc919a028c
upgrade database from v3 to v4
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
689
diff
changeset
|
113 return sqlite3_value_type(argv_[index]) == SQLITE_NULL; |
|
72dc919a028c
upgrade database from v3 to v4
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
689
diff
changeset
|
114 } |
| 0 | 115 |
| 116 void FunctionContext::SetNullResult() | |
| 117 { | |
| 118 sqlite3_result_null(context_); | |
| 119 } | |
| 120 | |
| 121 void FunctionContext::SetIntResult(int value) | |
| 122 { | |
| 123 sqlite3_result_int(context_, value); | |
| 124 } | |
| 125 | |
| 126 void FunctionContext::SetDoubleResult(double value) | |
| 127 { | |
| 128 sqlite3_result_double(context_, value); | |
| 129 } | |
| 130 | |
| 131 void FunctionContext::SetStringResult(const std::string& str) | |
| 132 { | |
|
3585
113a9643e8bb
Suppressed a few warnings when building with emscripten (clang) + numeric truncation warnings
Benjamin Golinvaux <bgo@osimis.io>
parents:
3063
diff
changeset
|
133 sqlite3_result_text(context_, str.data(), static_cast<int>(str.size()), SQLITE_TRANSIENT); |
| 0 | 134 } |
| 135 } | |
| 136 } |