1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
|
/*
//
// Copyright 2010 SRI International
//
// This file is part of the Computational Morphometry Toolkit.
//
// http://www.nitrc.org/projects/cmtk/
//
// The Computational Morphometry Toolkit is free software: you can
// redistribute it and/or modify it under the terms of the GNU General Public
// License as published by the Free Software Foundation, either version 3 of
// the License, or (at your option) any later version.
//
// The Computational Morphometry Toolkit is distributed in the hope that it
// will be useful, but WITHOUT ANY WARRANTY; without even the implied
// warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License along
// with the Computational Morphometry Toolkit. If not, see
// <http://www.gnu.org/licenses/>.
//
// $Revision: 5436 $
//
// $LastChangedDate: 2018-12-10 19:01:20 -0800 (Mon, 10 Dec 2018) $
//
// $LastChangedBy: torstenrohlfing $
//
*/
#include "cmtkSQLite.h"
#include <System/cmtkConsole.h>
#include <stdlib.h>
cmtk::SQLite::SQLite
( const std::string& dbPath, const bool readOnly )
: m_Good( false ),
m_DebugMode( false )
{
if ( readOnly )
{
this->m_Good = (sqlite3_open_v2( dbPath.c_str(), &this->m_DB, SQLITE_OPEN_READONLY, NULL /*zVFS*/ ) == SQLITE_OK);
}
else
{
this->m_Good = (sqlite3_open_v2( dbPath.c_str(), &this->m_DB, SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, NULL /*zVFS*/ ) == SQLITE_OK);
}
}
cmtk::SQLite::~SQLite()
{
if ( this->m_Good )
sqlite3_close( this->m_DB );
}
void
cmtk::SQLite::Exec( const std::string& sql )
{
if ( ! this->Good() )
throw Self::Exception( "Attempting operation on invalid SQLite database object" );
if ( this->m_DebugMode )
{
StdErr << sql << "\n";
}
char* err = NULL;
if ( sqlite3_exec( this->m_DB, sql.c_str(), NULL, NULL, &err ) != SQLITE_OK )
{
StdErr << "Exec " << sql << "\nSQL error: " << err << "\n";
sqlite3_free( err );
}
}
/// Callback for SQLite: add rows to results table.
extern "C"
int
cmtkSQLiteQueryCallback( void* pTable, int ncols, char** rowdata, char** )
{
cmtk::SQLite::TableType* table = static_cast<cmtk::SQLite::TableType*>( pTable );
std::vector< std::string > tableRow( ncols );
for ( int col = 0; col < ncols; ++col )
{
if ( rowdata[col] )
tableRow[col] = std::string( rowdata[col] );
else
tableRow[col] = std::string( "NULL" );
}
table->push_back( tableRow );
return 0;
}
void
cmtk::SQLite::Query( const std::string& sql, cmtk::SQLite::TableType& table ) const
{
if ( ! this->Good() )
throw Self::Exception( "Attempting operation on invalid SQLite database object" );
if ( this->m_DebugMode )
{
StdErr << sql << "\n";
}
table.resize( 0 );
char* err = NULL;
if ( sqlite3_exec( this->m_DB, sql.c_str(), cmtkSQLiteQueryCallback, &table, &err ) != SQLITE_OK )
{
StdErr << "Query " << sql << "\nSQL error: " << err << "\n";
sqlite3_free( err );
}
}
bool
cmtk::SQLite::TableExists( const std::string& tableName ) const
{
Self::TableType table;
this->Query( "SELECT name FROM SQLite_Master WHERE name='"+tableName+"'", table );
return table.size() && table[0].size() && (table[0][0] == tableName);
}
|
