summaryrefslogtreecommitdiff
path: root/server/src/database.h
blob: 0958b158e8832ce7c7f3779df05ba869747bfdd8 (plain)
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
/* -*- 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 <pqxx/pqxx>

#include <string>
#include "transaction.h"
#include "template.h"
#include <time.h>

#include <map>

class Value {
public:
  std::string value;
  time_t timestamp;
};
typedef std::map< std::string, Value > Values;

class Database {
public:
  Database(std::string hostname = "localhost",
           std::string user = "pracro",
           std::string password = "pracro");
  ~Database();

  // Make a commit to the db
  void commit(std::string user,
              std::string cpr,
              Macro &macro,
              Fields &fields,
              time_t now = time(NULL));

  // Get a list of values from the db
  Values getValues(std::string cpr,
                   std::vector< std::string > &fieldnames,
                   time_t oldest = 0);

  // Connect to the db
  void connect() {}

  // Disconnect from the db
  void disconnect() {}

private:
  pqxx::connection c;
};

#endif/*__PRACRO_DATABASE_H__*/