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

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

(Adding new DB support) Adding a new "getfileextension()" function that is implemented differently between gdbmclass (which is endian-specific) and sqlitedbclass (which isn't).

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 file extension string
48  text_t getfileextension ();
49
50  // returns true on success
51  bool getkeydata (const text_t& key, text_t &data);
52
53  // returns array of keys
54  text_tarray getkeys ();
55
56  // returns true on success
57  bool setkeydata (const text_t &key, const text_t &data);
58
59protected:
60  text_t openfile;
61  sqlite3* sqlitefile;
62
63  bool sqlexec (const text_t &sql_cmd);
64  bool sqlgetarray (const text_t &sql_cmd, vector<text_tmap> &sql_results);
65  bool sqltableexists (const text_t &table_name);
66};
67
68
69#endif
Note: See TracBrowser for help on using the browser.