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
|
/* -*- Mode: C++; tab-width: 2; indent-tabs-mode: nil; c-basic-offset: 2 -*- */
/***************************************************************************
* database.h
*
* Thu Sep 6 10:59:07 CEST 2007
* Copyright 2007 Bent Bisballe Nyeng
* deva@aasimon.org
****************************************************************************/
/*
* This file is part of Pracro.
*
* Pracro 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 2 of the License, or
* (at your option) any later version.
*
* Pracro 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 Pracro; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
*/
#ifndef __PRACRO_DATABASE_H__
#define __PRACRO_DATABASE_H__
#include <config.h>
#include <pqxx/pqxx>
#include <string>
#include "transaction.h"
#include "template.h"
#include <time.h>
#include <map>
class Value {
public:
Value() : value(""), timestamp(0) {}
std::string value;
time_t timestamp;
};
typedef std::map< std::string, Value > Values;
typedef std::vector< std::string > Fieldnames;
class Database {
public:
Database(std::string hostname,
std::string user,
std::string password);
~Database();
// Make a commit to the db
void commit(std::string user,
std::string cpr,
Macro ¯o,
Fields &fields,
time_t now = time(NULL));
// Get a list of values from the db
Values getValues(std::string cpr,
Fieldnames &fieldnames,
time_t oldest = 0);
// Check if a macro has been committed.
bool checkMacro(std::string cpr,
std::string macro,
time_t oldest = 0);
// Put an entry in the journal table
void putJournal(std::string user,
std::string cpr,
Macro &_macro,
std::string resume,
time_t now);
// Get latest resume of a given macro
std::string getResume(std::string cpr,
std::string macro,
time_t oldest);
// Connect to the db
void connect() {}
// Disconnect from the db
void disconnect() {}
private:
#ifndef WITHOUT_DB
pqxx::connection c;
#endif/*WITHOUT_DB*/
};
#endif/*__PRACRO_DATABASE_H__*/
|
