DbPsql.h

/* -*- Mode: C++; c-file-style: "stroustrup"; indent-tabs-mode: nil -*- */
/*
 * DbPsql.h
 *
 * $Id: DbPsql.h,v 1.14 2003/04/24 04:44:56 benoit Exp $
 *
 * Copyright (c) 2000, 2001 Remi Lefebvre <remi@debian.org>
 * Copyright (c) 2000 Benoit Joly <benoit@dhis.net>
 *
 * DDT comes with ABSOLUTELY NO WARRANTY and is licenced under the
 * GNU General Public License (version 2 or later). This license
 * can be retrieved from http://www.gnu.org/copyleft/gnu.html.
 *
 */

#ifndef DBPSQL_H
#define DBPSQL_H

using namespace std;

#define DLLIMPORT
#define HAVE_CXX_STRING_HEADER
#define HAVE_NAMESPACE_STD
#include <libpq++.h>

#include "Db.h"
#include "Dns.h"
#include "Logger.h"


class DbPsql : public Db
{
  public:

    ~DbPsql();

    DbPsql(Logger *log, const char *dbname, const char *dbuser,
           const char *dbpass);


    // operations on user accounts

    int addUserAccount(UserAccount *account);

    void delUserAccount(int id);

    bool accountIdExists(int id);

    void modUserAccount(int id, char *field, char *value);
    void modUserAccount(int id, char *field, int value);

    
    bool fetchAccountInfo(int id, UserAccount *account);

    int findUserAccountIdFromFqdn(const char *fqdn);

    unsigned long fetchAcctAddr(int id);

//    void updateLastAccess(int id);

    void getActiveAccounts();
    


    // dns db opperations //
    
    void addDnsRecord(int id, const char *dname, DnsRecordType type,
                      const char *data);

    void delDnsRecords(int id);

    void delDnsRecord(int id, const char *dname, DnsRecordType type,
                      const char *data);

    void listDnsRecords(int id, std::vector<DnsRecord> &dnsRecordList);

    int getNbOfDnsRecords(int accountId, DnsRecordType type);


    int pruneActiveAccount(void (*func)(int, unsigned long, time_t));

  protected:
    int allocateUserAccountId();

    PgDatabase *pg;

  private:
    DbPsql();
};

#endif // DBPSQL_H

---