root/gsdl/trunk/lib/sqliteclass.h @ 15623

Revision 15623, 2.2 KB (checked in by mdewsnip, 12 years ago)

(Adding new DB support) Implemented a first cut at the getinfo() function.

Line 
1/**********************************************************************
2 *
3 * sqliteclass.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 SQLITECLASS_H
27#define SQLITECLASS_H
28
29
30#include "dbclass.h"
31#include "sqlite3.h"
32
33
34class sqliteclass : public dbclass
35{
36public:
37  sqliteclass() { sqlitefile = NULL; }
38  ~sqliteclass();
39
40  // returns true if opened
41  bool opendatabase (const text_t &filename, int mode, int num_retrys,
42             bool need_filelock);
43  void closedatabase ();
44
45  // returns true on success
46  bool getinfo (const text_t& key, infodbclass &info);
47
48  // returns true if exists
49  bool exists (const text_t& key);
50
51  // returns true on success
52  bool setinfo (const text_t &key, const infodbclass &info);
53
54  void deletekey (const text_t &key);
55
56  // getfirstkey and getnextkey are used for traversing the database
57  // no insertions or deletions should be carried out while traversing
58  // the database. when there are no keys left to visit in the database
59  // an empty string is returned.
60  text_t getfirstkey ();
61  text_t getnextkey (const text_t &key);
62
63protected:
64  text_t openfile;
65  sqlite3* sqlitefile;
66
67  bool getinfoline (text_t::iterator &here, text_t::iterator end,
68            text_t &key, text_t &value);
69
70  bool sqlgetarray (const text_t &sql_cmd, vector<text_tmap> &sql_results);
71  bool sqlexec (const text_t &sql_cmd);
72};
73
74
75#endif
Note: See TracBrowser for help on using the browser.