root/gsdl/trunk/lib/sqlitedbclass.h @ 15655

Revision 15655, 1.9 KB (checked in by mdewsnip, 11 years ago)

(Adding new DB support) Created default implementations of getinfo() and setinfo() in dbclass so they don't necessarily be re-implemented for every subclass.

Line 
1/**********************************************************************
2 *
3 * sqlitedbclass.h --
4 * Copyright (C) 2008  DL Consulting Ltd
5 *
6 * A component of the Greenstone digital library software
7 * from the New Zealand Digital Library Project at the
8 * University of Waikato, New Zealand.
9 *
10 * This program is free software; you can redistribute it and/or modify
11 * it under the terms of the GNU General Public License as published by
12 * the Free Software Foundation; either version 2 of the License, or
13 * (at your option) any later version.
14 *
15 * This program is distributed in the hope that it will be useful,
16 * but WITHOUT ANY WARRANTY; without even the implied warranty of
17 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
18 * GNU General Public License for more details.
19 *
20 * You should have received a copy of the GNU General Public License
21 * along with this program; if not, write to the Free Software
22 * Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
23 *
24 *********************************************************************/
25
26#ifndef SQLITEDBCLASS_H
27#define SQLITEDBCLASS_H
28
29
30#include "dbclass.h"
31#include "sqlite3.h"
32
33
34class sqlitedbclass : public dbclass
35{
36public:
37  sqlitedbclass() { sqlitefile = NULL; }
38  ~sqlitedbclass();
39
40  // returns true if opened
41  bool opendatabase (const text_t &filename, int mode, int num_retrys, bool need_filelock);
42
43  void closedatabase ();
44
45  void deletekey (const text_t &key);
46
47  // returns true on success
48  bool getkeydata (const text_t& key, text_t &data);
49
50  // returns array of keys
51  text_tarray getkeys ();
52
53  // returns true on success
54  bool setkeydata (const text_t &key, const text_t &data);
55
56protected:
57  text_t openfile;
58  sqlite3* sqlitefile;
59
60  bool sqlexec (const text_t &sql_cmd);
61  bool sqlgetarray (const text_t &sql_cmd, vector<text_tmap> &sql_results);
62  bool sqltableexists (const text_t &table_name);
63};
64
65
66#endif
Note: See TracBrowser for help on using the browser.