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

Revision 15753, 2.0 KB (checked in by mdewsnip, 12 years ago)

(Adding dynamic classifiers) Created sqldbclass, which inherits from dbclass and will be the abstract parent of all SQL db classes. Currently it specifies just the getmetadatavalues() function. Changed sqlitedbclass to inherit from sqldbclass instead of dbclass.

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 "sqldbclass.h"
31#include "sqlite3.h"
32
33
34class sqlitedbclass : public sqldbclass
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 array of values
57  text_tarray getmetadatavalues (const text_t &metadata_element_name);
58
59  // returns true on success
60  bool setkeydata (const text_t &key, const text_t &data);
61
62protected:
63  text_t openfile;
64  sqlite3* sqlitefile;
65
66  bool sqlexec (const text_t &sql_cmd);
67  bool sqlgetarray (const text_t &sql_cmd, vector<text_tmap> &sql_results);
68  bool sqltableexists (const text_t &table_name);
69};
70
71
72#endif
Note: See TracBrowser for help on using the browser.