Mercurial > hg > orthanc-databases
annotate Framework/MySQL/MySQLResult.cpp @ 581:a80775ee5eea find-refactoring
MySQL: Added support for ExtendedFind
author | Alain Mazy <am@orthanc.team> |
---|---|
date | Mon, 21 Oct 2024 14:34:57 +0200 |
parents | 54d518dcd74a |
children |
rev | line source |
---|---|
0 | 1 /** |
2 * Orthanc - A Lightweight, RESTful DICOM Store | |
3 * Copyright (C) 2012-2016 Sebastien Jodogne, Medical Physics | |
4 * Department, University Hospital of Liege, Belgium | |
507
54d518dcd74a
updated copyright, as Orthanc Team now replaces Osimis
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
459
diff
changeset
|
5 * Copyright (C) 2017-2023 Osimis S.A., Belgium |
54d518dcd74a
updated copyright, as Orthanc Team now replaces Osimis
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
459
diff
changeset
|
6 * Copyright (C) 2024-2024 Orthanc Team SRL, Belgium |
459
ecd0b719cff5
update year to 2024
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
389
diff
changeset
|
7 * Copyright (C) 2021-2024 Sebastien Jodogne, ICTEAM UCLouvain, Belgium |
0 | 8 * |
9 * This program is free software: you can redistribute it and/or | |
10 * modify it under the terms of the GNU Affero General Public License | |
11 * as published by the Free Software Foundation, either version 3 of | |
12 * the License, or (at your option) any later version. | |
13 * | |
14 * This program is distributed in the hope that it will be useful, but | |
15 * WITHOUT ANY WARRANTY; without even the implied warranty of | |
16 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU | |
17 * Affero General Public License for more details. | |
18 * | |
19 * You should have received a copy of the GNU Affero General Public License | |
20 * along with this program. If not, see <http://www.gnu.org/licenses/>. | |
21 **/ | |
22 | |
23 | |
24 #include "MySQLResult.h" | |
25 | |
152 | 26 #include <Logging.h> |
27 #include <OrthancException.h> | |
0 | 28 |
6 | 29 #include <errmsg.h> |
0 | 30 #include <mysqld_error.h> |
31 | |
32 namespace OrthancDatabases | |
33 { | |
34 void MySQLResult::Step() | |
35 { | |
36 int code = mysql_stmt_fetch(statement_.GetObject()); | |
37 | |
38 if (code == 1) | |
39 { | |
40 unsigned int error = mysql_errno(database_.GetObject()); | |
16
9e419261f1c9
mysql storage area working
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
6
diff
changeset
|
41 |
0 | 42 if (error == 0) |
43 { | |
16
9e419261f1c9
mysql storage area working
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
6
diff
changeset
|
44 // This case occurs in requests without a result (e.g. if the |
9e419261f1c9
mysql storage area working
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
6
diff
changeset
|
45 // SQL request is not a SELECT) |
0 | 46 done_ = true; |
47 } | |
48 else | |
49 { | |
240
c82c2cf84ae8
added handling of CR_COMMANDS_OUT_OF_SYNC
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
50 database_.ThrowException(); |
0 | 51 } |
52 } | |
53 else | |
54 { | |
55 done_ = (code != 0 && | |
56 code != MYSQL_DATA_TRUNCATED); // Occurs if mysql_stmt_fetch_column() must be called | |
57 | |
58 FetchFields(); | |
59 } | |
60 } | |
61 | |
62 | |
63 IValue* MySQLResult::FetchField(size_t index) | |
64 { | |
65 return statement_.FetchResultField(index); | |
66 } | |
67 | |
68 | |
69 MySQLResult::MySQLResult(MySQLDatabase& db, | |
70 MySQLStatement& statement) : | |
71 database_(db), | |
72 statement_(statement) | |
73 { | |
74 // !!! https://dev.mysql.com/doc/refman/5.7/en/mysql-stmt-fetch.html | |
75 // https://gist.github.com/hoterran/6365915 | |
76 // https://github.com/hholzgra/connector-c-examples/blob/master/mysql_stmt_bind_result.c | |
77 | |
78 SetFieldsCount(statement_.GetResultFieldsCount()); | |
240
c82c2cf84ae8
added handling of CR_COMMANDS_OUT_OF_SYNC
Sebastien Jodogne <s.jodogne@gmail.com>
parents:
193
diff
changeset
|
79 |
0 | 80 Step(); |
81 } | |
82 | |
83 | |
84 MySQLResult::~MySQLResult() | |
85 { | |
86 // Reset the statement for further use | |
87 if (mysql_stmt_reset(statement_.GetObject()) != 0) | |
88 { | |
89 LOG(ERROR) << "Cannot reset the statement, expect an error"; | |
90 } | |
91 } | |
92 | |
93 | |
94 void MySQLResult::Next() | |
95 { | |
96 if (IsDone()) | |
97 { | |
98 throw Orthanc::OrthancException(Orthanc::ErrorCode_BadSequenceOfCalls); | |
99 } | |
100 else | |
101 { | |
102 Step(); | |
103 } | |
104 } | |
105 } |