/* -*- 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 &macro,
              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);

  // 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__*/