db_module.h

// tacppd database description types
// (c) Copyright 2000-2005 by tacppd team and contributors
// see http://tacppd.org for more information

//  This program 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.
//
//  This program 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 this program; if not, write to the Free Software
//  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

// all comments which start from /**<CR> - this is comments for KDoc
//  for classes
//    @short [short description of the class]
//    @author [class author]
//    @version [class version]
//    @see [references to other classes or methods]
//  for methods
//    @see [references]
//    @return [sentence describing the return value]
//    @exception [list the exeptions that could be thrown]
//    @param [name id] [description] - can be multiple

#ifndef __DB_MODULE_H__
#define __DB_MODULE_H__

#ifndef _PTHREADS
#define   _PTHREADS   // enable STL pthread-safe code
#endif //_PTHREADS

#ifndef _REENTRANT
#define   _REENTRANT  // Pthread safe stuff in the stdlibs
#endif //_REENTRANT   // or you should compile with -pthread key

#include <iostream>
#include <stdio.h>
#include <stdarg.h>
#include <time.h>

#ifdef SOLARIS
#include <strings.h>
#endif //SOLARIS

#include <pthread.h>
#include <string>
#include <list>

#include "ipaddr.h"

using std::list;
using std::string;
using namespace tacpp;

#define T_INT_TYPE      (int)0
#define T_UINT_TYPE     (unsigned int)0
#define T_STR_TYPE      ""
#define T_DATE_TYPE     (time_t)0
#define T_BOOL_TYPE     false
#define T_FLOAT_TYPE    (float)0
#define T_IP_TYPE       ipaddr()

#define T_NOIDX         0
#define T_INDEX         1
#define T_UNIQUE        2

#define DB_MODULE_ERRLEN  300

class DbField {
  pthread_mutex_t mutex_;
  void lock() {
    pthread_mutex_lock(&mutex_);
  }
  void unlock() {
    pthread_mutex_unlock(&mutex_);
  }
  string name_;
  string description_;
  string defv_;
  int t_;
  bool update_;
  bool request_;
  bool bool_type_;
  unsigned long int int_type_;
  float float_type_;
  string string_type_;
  int string_len_;
  time_t date_type_;
  ipaddr ip_type_;
  int idx_;
 public:
  string getName() {
    lock();
    string ret = name_;
    unlock();
    return ret;
  }
  void setName(string d) {
    lock();
    name_ = d;
    unlock();
  }
  string getDescription() {
    lock();
    string ret = description_;
    unlock();
    return ret;
  }
  void setDescription(string d) {
    lock();
    description_ = d;
    unlock();
  }
  string getDefv() {
    string ret;
    lock();
    ret = defv_;
    unlock();
    return ret;
  }
  void setDefv(string d) {
    lock();
    defv_ = d;
    unlock();
  }
  int getT() {
    int ret;
    lock();
    ret = t_;
    unlock();
    return ret;
  }
  void setT(int d) {
    lock();
    t_ = d;
    unlock();
  }
  bool getUpdate() {
    bool ret;
    lock();
    ret = update_;
    unlock();
    return ret;
  }
  void setUpdate(bool d) {
    lock();
    update_ = d;
    unlock();
  }
  bool getRequest() {
    bool ret;
    lock();
    ret = request_;
    unlock();
    return ret;
  }
  void setRequest(bool d) {
    lock();
    request_ = d;
    unlock();
  }
  bool getBoolType() {
    bool ret;
    lock();
    ret = bool_type_;
    unlock();
    return ret;
  }
  void setBoolType(bool d) {
    lock();
    bool_type_ = d;
    unlock();
  }
  unsigned long int getIntType() {
    unsigned long int ret;
    lock();
    ret = int_type_;
    unlock();
    return ret;
  }
  void setIntType(unsigned long int d) {
    lock();
    int_type_ = d;
    unlock();
  }
  float getFloatType() {
    float ret;
    lock();
    ret = float_type_;
    unlock();
    return ret;
  }
  void setFloatType(float d) {
    lock();
    float_type_ = d;
    unlock();
  }
  string getStringType() {
    string ret;
    lock();
    ret = string_type_;
    unlock();
    return ret;
  }
  void setStringType(string d) {
    lock();
    string_type_ = d;
    unlock();
  }
  int getStringLen() {
    int ret;
    lock();
    ret = string_len_;
    unlock();
    return ret;
  }
  void setStringLen(int d) {
    lock();
    string_len_ = d;
    unlock();
  }
  time_t getDateType() {
    time_t ret;
    lock();
    ret = date_type_;
    unlock();
    return ret;
  }
  void setDateType(time_t d) {
    lock();
    date_type_ = d;
    unlock();
  }
  ipaddr getIpType() {
    ipaddr ret;
    lock();
    ret = ip_type_;
    unlock();
    return ret;
  }
  void setIpType(ipaddr d) {
    lock();
    ip_type_ = d;
    unlock();
  }
  int getIdx() {
    int ret;
    lock();
    ret = idx_;
    unlock();
    return ret;
  }
  void setIdx(int d) {
    lock();
    idx_ = d;
    unlock();
  }
  ~DbField() {
    pthread_mutex_destroy(&mutex_);
  }
  DbField(const string n,const string d,const string f,bool v,int ix=0) {
    pthread_mutex_init(&mutex_,0);
    lock();
    t_ = 1;  // 1-bool,2-int/uint/ulong,3-float,4-string/char*,5-time_t,6-ipaddr
    update_ = false;
    request_ = false;
    name_ = n;
    description_ = d;
    defv_ = f;
    bool_type_ = v;
    int_type_ = 0;
    float_type_ = 0;
    string_len_ = 0;
    date_type_ = 0;
    ip_type_ = UNKNOWN_IP;
    idx_ = ix;
    unlock();
  }
  DbField(const string n,const string d,const string f,int v,int ix=0) {
    pthread_mutex_init(&mutex_,0);
    lock();
    t_ = 2; // 1-bool,2-int/uint/ulong,3-float,4-string/char*,5-time_t,6-ipaddr
    update_ = false;
    request_ = false;
    name_ = n;
    description_ = d;
    defv_ = f;
    bool_type_ = false;
    int_type_ = (unsigned long int)v;
    float_type_ = 0;
    string_len_ = 0;
    date_type_ = 0;
    ip_type_ = UNKNOWN_IP;
    idx_ = ix;
    unlock();
  }
  DbField(const string n,const string d,const string f,unsigned int v,int ix=0) {
    pthread_mutex_init(&mutex_,0);
    lock();
    t_ = 2; // 1-bool,2-int/uint/ulong,3-float,4-string/char*,5-time_t,6-ipaddr
    update_ = false;
    request_ = false;
    name_ = n;
    description_ = d;
    defv_ = f;
    bool_type_ = false;
    int_type_ = (unsigned long int)v;
    float_type_ = 0;
    string_len_ = 0;
    date_type_ = 0;
    ip_type_ = UNKNOWN_IP;
    idx_ = ix;
    unlock();
  }
  DbField(const string n,const string d,const string f,unsigned long int v,int ix=0) {
    pthread_mutex_init(&mutex_,0);
    lock();
    t_ = 2; // 1-bool,2-int/uint/ulong,3-float,4-string/char*,5-time_t,6-ipaddr
    update_ = false;
    request_ = false;
    name_ = n;
    description_ = d;
    defv_ = f;
    bool_type_ = false;
    int_type_ = v;
    float_type_ = 0;
    string_len_ = 0;
    date_type_ = 0;
    ip_type_ = UNKNOWN_IP;
    idx_ = ix;
    unlock();
  }
  DbField(const string n,const string d,const string f,float v,int ix=0) {
    pthread_mutex_init(&mutex_,0);
    lock();
    t_ = 3; // 1-bool,2-int/uint/ulong,3-float,4-string/char*,5-time_t,6-ipaddr
    update_ = false;
    request_ = false;
    name_ = n;
    description_ = d;
    defv_ = f;
    bool_type_ = false;
    int_type_ = 0;
    float_type_ = v;
    string_len_ = 0;
    date_type_ = 0;
    ip_type_ = UNKNOWN_IP;
    idx_ = ix;
    unlock();
  }
  DbField(const string n,const string d,const string f,string v,int l,int ix=0) {
    pthread_mutex_init(&mutex_,0);
    lock();
    t_ = 4; // 1-bool,2-int/uint/ulong,3-float,4-string/char*,5-time_t,6-ipaddr
    update_ = false;
    request_ = false;
    name_ = n;
    description_ = d;
    defv_ = f;
    bool_type_ = false;
    int_type_ = 0;
    float_type_ = 0;
    string_type_ = v;
    string_len_ = l;
    date_type_ = 0;
    ip_type_ = UNKNOWN_IP;
    idx_ = ix;
    unlock();
  }
  DbField(const string n,const string d,const string f,char *v,int l,int ix=0) {
    pthread_mutex_init(&mutex_,0);
    lock();
    t_ = 4; // 1-bool,2-int/uint/ulong,3-float,4-string/char*,5-time_t,6-ipaddr
    update_ = false;
    request_ = false;
    name_ = n;
    description_ = d;
    defv_ = f;
    bool_type_ = false;
    int_type_ = 0;
    float_type_ = 0;
    string_type_ = v;
    string_len_ = l;
    date_type_ = 0;
    ip_type_ = UNKNOWN_IP;
    idx_ = ix;
    unlock();
  }
  DbField(const string n,const string d,const string f,time_t v,int ix=0) {
    pthread_mutex_init(&mutex_,0);
    lock();
    t_ = 5; // 1-bool,2-int/uint/ulong,3-float,4-string/char*,5-time_t,6-ipaddr
    update_ = false;
    request_ = false;
    name_ = n;
    description_ = d;
    defv_ = f;
    bool_type_ = false;
    int_type_ = 0;
    float_type_ = 0;
    string_len_ = 0;
    date_type_ = v;
    ip_type_ = UNKNOWN_IP;
    idx_ = ix;
    unlock();
  }
  DbField(const string n,const string d,const string f,ipaddr v,int ix=0) {
    pthread_mutex_init(&mutex_,0);
    lock();
    t_ = 6; // 1-bool,2-int/uint/ulong,3-float,4-string/char*,5-time_t,6-ipaddr
    update_ = false;
    request_ = false;
    name_ = n;
    description_ = d;
    defv_ = f;
    bool_type_ = false;
    int_type_ = 0;
    float_type_ = 0;
    string_len_ = 0;
    date_type_ = 0;
    ip_type_ = v;
    idx_ = ix;
    unlock();
  }
};

class DbTable {
  pthread_mutex_t mutex_;
  void lock() {
    pthread_mutex_lock(&mutex_);
  }
  void unlock() {
    pthread_mutex_unlock(&mutex_);
  }
  list<DbField*> f_;
  string name_;
  string namemask_;
  string description_;
 public:
  string getName() {
    string ret;
    lock();
    ret = name_;
    unlock();
    return ret;
  }
  void setName(string d) {
    lock();
    name_ = d;
    unlock();
  }
  string getNamemask() {
    string ret;
    lock();
    ret = namemask_;
    unlock();
    return ret;
  }
  void setNamemask(string d) {
    lock();
    namemask_ = d;
    unlock();
  }
  string getDescription() {
    string ret;
    lock();
    ret = description_;
    unlock();
    return ret;
  }
  void setDescription(string d) {
    lock();
    description_ = d;
    unlock();
  }
  int size() {
    int ret;
    lock();
    ret = f_.size();
    unlock();
    return ret;
  }
  DbTable(const string n,const string m,const string d) {
    pthread_mutex_init(&mutex_,0);
    lock();
    description_ = d;
    namemask_ = m;
    name_ = n;
    unlock();
  }
  ~DbTable() {
    lock();
    DbField *tmp;
    for(list<DbField*>::iterator i=f_.begin();i!=f_.end() && !f_.empty();) {
      tmp = *i;
      i = f_.erase(i);
      delete tmp;
    }
    f_.clear();
    unlock();
    pthread_mutex_destroy(&mutex_);
  }
  void clear() {
    DbField *tmp;
    lock();
    for(list<DbField*>::iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      unlock();
      tmp->setRequest(false);
      tmp->setUpdate(false);
      tmp->setBoolType(false);
      tmp->setIntType(0);
      tmp->setFloatType(0);
      tmp->setStringType("");
      tmp->setStringLen(0);
      tmp->setDateType(0);
      tmp->setIpType(UNKNOWN_IP);
      lock();
    }
    unlock();
  }
  void set_request(const string n) {
    DbField *tmp;
    lock();
    for(list<DbField*>::iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n)
        tmp->setRequest(true);
    }
    unlock();
  }
  void set_update(const string n) {
    DbField *tmp;
    lock();
    for(list<DbField*>::iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n)
        tmp->setUpdate(true);
    }
    unlock();
  }
  void add(const string n,const string d,const string df,bool v,int ix=0) {
    DbField *tmp;
    lock();
    for(list<DbField*>::iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        tmp->setBoolType(v);
        unlock();
        return;
      }
    }
    f_.push_back(new DbField(n,d,df,v,ix));
    unlock();
  }
  void add(const string n,bool v) {
    add(n,"","",v);
  }
  void add(const string n,const string d,const string df,int v,int ix=0) {
    DbField *tmp;
    lock();
    for(list<DbField*>::iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        tmp->setIntType((unsigned long int)v);
        unlock();
        return;
      }
    }
    f_.push_back(new DbField(n,d,df,v,ix));
    unlock();
  }
  void add(const string n,int v) {
    add(n,"","",v);
  }
  void add(const string n,const string d,const string df,unsigned int v,int ix=0) {
    DbField *tmp;
    lock();
    for(list<DbField*>::iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        tmp->setIntType((unsigned long int)v);
        unlock();
        return;
      }
    }
    f_.push_back(new DbField(n,d,df,v,ix));
    unlock();
  }
  void add(const string n,unsigned int v) {
    add(n,"","",v);
  }
  void add(const string n,const string d,const string df,unsigned long int v,int ix=0) {
    DbField *tmp;
    lock();
    for(list<DbField*>::iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        tmp->setIntType(v);
        unlock();
        return;
      }
    }
    f_.push_back(new DbField(n,d,df,v,ix));
    unlock();
  }
  void add(const string n,unsigned long int v) {
    add(n,"","",v);
  }
  void add(const string n,const string d,const string df,float v,int ix=0) {
    DbField *tmp;
    lock();
    for(list<DbField*>::iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        tmp->setFloatType(v);
        unlock();
        return;
      }
    }
    f_.push_back(new DbField(n,d,df,v,ix));
    unlock();
  }
  void add(const string n,float v) {
    add(n,"","",v);
  }
  void add(const string n,const string d,const string df,string v,int l,int ix=0) {
    DbField *tmp;
    lock();
    for(list<DbField*>::iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        tmp->setStringType(v);
        unlock();
        return;
      }
    }
    f_.push_back(new DbField(n,d,df,v,l,ix));
    unlock();
  }
  void add(const string n,string v,int l=0) {
    add(n,"","",v,l);
  }
  void add(const string n,const string d,const string df,char *v,int l,int ix=0) {
    DbField *tmp;
    lock();
    string stmp = v;
    for(list<DbField*>::iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        tmp->setStringType(stmp);
        unlock();
        return;
      }
    }
    f_.push_back(new DbField(n,d,df,stmp,l,ix));
    unlock();
  }
  void add(const string n,char *v,int l=0) {
    add(n,"","",v,l);
  }
  void add(const string n,const string d,const string df,time_t v,int ix=0) {
    DbField *tmp;
    lock();
    for(list<DbField*>::iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        tmp->setDateType(v);
        unlock();
        return;
      }
    }
    f_.push_back(new DbField(n,d,df,v,ix));
    unlock();
  }
  void add(const string n,time_t v) {
    add(n,"","",v);
  }
  void add(const string n,const string d,const string df,ipaddr v,int ix=0) {
    DbField *tmp;
    lock();
    for(list<DbField*>::iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        tmp->setIpType(v);
        unlock();
        return;
      }
    }
    f_.push_back(new DbField(n,d,df,v,ix));
    unlock();
  }
  void add(const string n,ipaddr v) {
    add(n,"","",v);
  }
  string get_name(int n) {
    string ret;
    lock();
    if(f_.size() > 0 && (int)f_.size() > n) {
      DbField *tmp = 0;
      int count = 0;
      list<DbField*>::const_iterator i;
      for(i=f_.begin();i!=f_.end();i++,count++) {
        if(count == n) {
          tmp = *i;
          ret = tmp->getName();
          break;
        }
      }
    }
    unlock();
    return ret;
  }
  string get_descr(int n) {
    string ret;
    lock();
    if(f_.size() > 0 && (int)f_.size() > n) {
      DbField *tmp = 0;
      int count = 0;
      list<DbField*>::const_iterator i;
      for(i=f_.begin();i!=f_.end();i++,count++) {
        if(count == n) {
          tmp = *i;
          ret = tmp->getDescription();
          break;
        }
      }
    }
    unlock();
    return ret;
  }
  string get_defv(int n) {
    string ret;
    lock();
    if(f_.size() > 0 && (int)f_.size() > n) {
      DbField *tmp = 0;
      int count = 0;
      list<DbField*>::const_iterator i;
      for(i=f_.begin();i!=f_.end();i++,count++) {
        if(count == n) {
          tmp = *i;
          ret = tmp->getDefv();
          break;
        }
      }
    }
    unlock();
    return ret;
  }
  int get_type(int n) {
    int ret;
    lock();
    ret = 0;
    if(f_.size() > 0 && (int)f_.size() > n) {
      DbField *tmp = 0;
      int count = 0;
      list<DbField*>::const_iterator i;
      for(i=f_.begin();i!=f_.end();i++,count++) {
        if(count == n) {
          tmp = *i;
          ret = tmp->getT();
          break;
        }
      }
    }
    unlock();
    return ret;
  }
  int get_idx(int n) {
    int ret;
    lock();
    ret = 0;
    if(f_.size() > 0 && (int)f_.size() > n) {
      DbField *tmp = 0;
      int count = 0;
      list<DbField*>::const_iterator i;
      for(i=f_.begin();i!=f_.end();i++,count++) {
        if(count == n) {
          tmp = *i;
          ret = tmp->getIdx();
          break;
        }
      }
    }
    unlock();
    return ret;
  }
  bool get_request(int n) {
    bool ret;
    lock();
    ret = false;
    if(f_.size() > 0 && (int)f_.size() > n) {
      DbField *tmp = 0;
      int count = 0;
      list<DbField*>::const_iterator i;
      for(i=f_.begin();i!=f_.end();i++,count++) {
        if(count == n) {
          tmp = *i;
          ret = tmp->getRequest();
          break;
        }
      }
    }
    unlock();
    return ret;
  }
  bool get_update(int n) {
    bool ret;
    lock();
    ret = false;
    if(f_.size() > 0 && (int)f_.size() > n) {
      DbField *tmp = 0;
      int count = 0;
      list<DbField*>::const_iterator i;
      for(i=f_.begin();i!=f_.end();i++,count++) {
        if(count == n) {
          tmp = *i;
          ret = tmp->getUpdate();
          break;
        }
      }
    }
    unlock();
    return ret;
  }
  bool get(const string n,bool *v) {
    DbField *tmp;
    lock();
    for(list<DbField*>::const_iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        if(tmp->getT() != 1) {
          unlock();
          return false;
        }
        *v = tmp->getBoolType();
        unlock();
        return true;
      }
    }
    unlock();
    return false;
  }
  void set(const string n,bool v) {
    DbField *tmp;
    lock();
    for(list<DbField*>::const_iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        if(tmp->getT() != 1) {
          unlock();
          return;
        }
        tmp->setBoolType(v);
        unlock();
        return;
      }
    }
    unlock();
    return;
  }
  bool get(const string n,int *v) {
    DbField *tmp;
    lock();
    for(list<DbField*>::const_iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        if(tmp->getT() != 2) {
          unlock();
          return false;
        }
        *v = tmp->getIntType();
        unlock();
        return true;
      }
    }
    unlock();
    return false;
  }
  void set(const string n,int v) {
    DbField *tmp;
    lock();
    for(list<DbField*>::const_iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        if(tmp->getT() != 2) {
          unlock();
          return;
        }
        tmp->setIntType(v);
        unlock();
        return;
      }
    }
    unlock();
    return;
  }
  bool get(const string n,float *v) {
    DbField *tmp;
    lock();
    for(list<DbField*>::const_iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        if(tmp->getT() != 3) {
          unlock();
          return false;
        }
        *v = tmp->getFloatType();
        unlock();
        return true;
      }
    }
    unlock();
    return false;
  }
  void set(const string n,float v) {
    DbField *tmp;
    lock();
    for(list<DbField*>::const_iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        if(tmp->getT() != 3) {
          unlock();
          return;
        }
        tmp->setFloatType(v);
        unlock();
        return;
      }
    }
    unlock();
    return;
  }
  bool get(const string n,char *v) {
    DbField *tmp;
    lock();
    for(list<DbField*>::const_iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        if(tmp->getT() != 4) {
          unlock();
          return false;
        }
        strncpy(v,tmp->getStringType().c_str(),300);
        unlock();
        return true;
      }
    }
    unlock();
    return false;
  }
  bool get(const string n,string *v) {
    DbField *tmp;
    lock();
    for(list<DbField*>::const_iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        if(tmp->getT() != 4) {
          unlock();
          return false;
        }
        *v = tmp->getStringType();
        unlock();
        return true;
      }
    }
    unlock();
    return false;
  }
  int getslen(const string n) {
    DbField *tmp;
    int ret;
    lock();
    ret = 0;
    for(list<DbField*>::const_iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        ret = tmp->getStringLen();
        unlock();
        return ret;
      }
    }
    unlock();
    return ret;
  }
  void set(const string n,string v) {
    DbField *tmp;
    lock();
    for(list<DbField*>::const_iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        if(tmp->getT() != 4) {
          unlock();
          return;
        }
        tmp->setStringType(v);
        unlock();
        return;
      }
    }
    unlock();
    return;
  }
  bool get(const string n,time_t *v) {
    DbField *tmp;
    lock();
    for(list<DbField*>::const_iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        if(tmp->getT() != 5) {
          unlock();
          return false;
        }
        *v = tmp->getDateType();
        unlock();
        return true;
      }
    }
    unlock();
    return false;
  }
  void set(const string n,time_t v) {
    DbField *tmp;
    lock();
    for(list<DbField*>::const_iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        if(tmp->getT() != 5) {
          unlock();
          return;
        }
        tmp->setDateType(v);
        unlock();
        return;
      }
    }
    unlock();
    return;
  }
  bool get(const string n,ipaddr *v) {
    DbField *tmp;
    lock();
    for(list<DbField*>::const_iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        if(tmp->getT() != 6) {
          unlock();
          return false;
        }
        *v = tmp->getIpType();
        unlock();
        return true;
      }
    }
    unlock();
    return false;
  }
  void set(const string n,ipaddr v) {
    DbField *tmp;
    lock();
    for(list<DbField*>::const_iterator i=f_.begin();i!=f_.end();i++) {
      tmp = *i;
      if(tmp->getName() == n) {
        if(tmp->getT() != 6) {
          unlock();
          return;
        }
        tmp->setIpType(v);
        unlock();
        return;
      }
    }
    unlock();
    return;
  }
};

#endif //__DB_MODULE_H__

---