nutools::dbi::Column Class Reference

#include "Column.h"

Public Member Functions
	Column ()
	Column (const ColumnDef &c)
	Column (const Column &c)
	~Column ()
uint8_t	Type () const
std::string	Value () const
bool	IsNull () const
bool	Modified () const
void	Clear ()
void	SetType (uint8_t t)
void	FastSet (std::string v)
void	FastSet (const char *v)
template<class T >
bool	Get (T &val) const
template<class T >
bool	Set (const T &val, bool ignoreAutoIncr=false)
template<class T >
bool	Update (const T &val)
bool	operator>= (const Column &c) const
bool	operator<= (const Column &c) const
bool	operator> (const Column &c) const
bool	operator< (const Column &c) const
bool	operator== (const Column &c) const

Private Attributes
bool	fModified
uint16_t	fType
char *	fValue

Friends
std::ostream &	operator<< (std::ostream &stream, const Column &col)

Detailed Description

Generalized Database Column Interface

Author

Jonathan Paley

Version

Id

Column.h,v 1.24 2013/03/12 19:53:02 jpaley Exp

Definition at line 32 of file Column.h.

Constructor & Destructor Documentation

nutools::dbi::Column::Column ( )

inline

Definition at line 35 of file Column.h.

References fType, fValue, nutools::dbi::kIntLike, and ~Column().

{fValue=0; fType=kIntLike;};

nutools::dbi::Column::Column

(

const ColumnDef &

c

)

Definition at line 17 of file Column.cpp.

References fType, fValue, nutools::dbi::kAutoIncr, nutools::dbi::kBool, nutools::dbi::kDateStamp, nutools::dbi::kFloatLike, nutools::dbi::kIntLike, nutools::dbi::kString, nutools::dbi::kTimeStamp, and nutools::dbi::ColumnDef::Type().

                                     :
        fModified(false)
    {
      fValue = 0;
      fType = kIntLike;

      std::string t = c.Type();
      if (t == "timestamp") fType = kTimeStamp;
      else if (t == "date") fType = kDateStamp;
      else if (t == "bool") fType = kBool;
      else if (t == "float" || t == "double") fType = kFloatLike;
      else if (t == "string" || t == "text") fType = kString;
      else if (t == "autoincr") fType = kAutoIncr;

    }

nutools::dbi::Column::Column

(

const Column &

c

)

Definition at line 35 of file Column.cpp.

References fModified, fType, and fValue.

    {
      if (!c.fValue)
        fValue=0;
      else {
        fValue = new char[strlen(c.fValue)+1];
        strcpy(fValue,c.fValue);
      }
      fType = c.fType;
      fModified = c.fModified;

    }

nutools::dbi::Column::~Column

(

)

Definition at line 50 of file Column.cpp.

References fValue.

Referenced by Column().

    {
      if (fValue) delete[] fValue;
    }

Member Function Documentation

void nutools::dbi::Column::Clear

(

)

Definition at line 56 of file Column.cpp.

References fModified, and fValue.

Referenced by Modified().

    {
      if (fValue) {
        delete fValue;
        fValue = 0;
      }
      //      fIsNull = true;
      fModified = false; 
    }

void nutools::dbi::Column::FastSet ( std::string  v )

inline

Definition at line 53 of file Column.h.

References fValue.

                                       {
        if (fValue) {
          delete fValue;
          fValue=0;
        }
        fValue = new char[v.length()+1];
        strcpy(fValue,v.c_str());
      }

void nutools::dbi::Column::FastSet ( const char *  v )

inline

Definition at line 62 of file Column.h.

References fValue.

                                         {
        if (fValue) {
          delete fValue;
          fValue=0;
        }
        fValue = new char[strlen(v)+1];
        strcpy(fValue,v);
      }

template<class T >

bool nutools::dbi::Column::Get ( T &  val ) const

inline

Definition at line 72 of file Column.h.

References fValue.

Referenced by operator<(), operator<=(), operator>(), and operator>=().

                               { 
        if (fValue) {
          try {
            val = boost::lexical_cast<T>(std::string(fValue)); 
          }
          catch (boost::bad_lexical_cast &) {
            std::cerr << "Column::Get(): Bad_lexical_cast! Value = " 
                      << fValue << std::endl;
            return false;
          }
          return true;
        }

        return false;
      }

bool nutools::dbi::Column::IsNull ( ) const

inline

Definition at line 44 of file Column.h.

References fValue.

Referenced by nutools::dbi::Table::AddRow().

{ return (!fValue); }

bool nutools::dbi::Column::Modified ( ) const

inline

Definition at line 45 of file Column.h.

References Clear(), and fModified.

Referenced by nutools::dbi::Table::WriteToDB().

{ return fModified; }

bool nutools::dbi::Column::operator<

(

const Column &

c

)

const

Definition at line 236 of file Column.cpp.

References nutools::dbi::Util::DateAsStringToTime_t(), fType, fValue, Get(), nutools::dbi::kBool, nutools::dbi::kDateStamp, nutools::dbi::kFloatLike, nutools::dbi::kIntLike, nutools::dbi::kString, nutools::dbi::kTimeStamp, and nutools::dbi::Util::TimeAsStringToTime_t().

Referenced by Update().

    {
      if (c.fType != fType) return false;
      
      std::string val1 = fValue;
      std::string val2 = c.fValue;
      
      if (fType == kBool) {
        bool a = (val1 == "1");
        bool b = (val2 == "1");
        return (!a&b);
      }
      
      if (fType == kIntLike) {
        long a = boost::lexical_cast<long>(val1);
        long b = boost::lexical_cast<long>(val2);
        return (a < b);
      }
      
      if (fType == kFloatLike) {
        double a = boost::lexical_cast<double>(val1);
        double b = boost::lexical_cast<double>(val2);
        return (a < b);
      }
      
      if (fType == kString) 
        return (val1 < val2);
      
      if (fType == kTimeStamp) {
        std::string a, b;
        if (this->Get(a) && c.Get(b)) {
          time_t tta, ttb;
          if (nutools::dbi::Util::TimeAsStringToTime_t(a,tta) && 
              nutools::dbi::Util::TimeAsStringToTime_t(b,ttb) ) 
            return (tta < ttb);
        }
        else 
          return false;
      }
      
      if (fType == kDateStamp) {
        std::string a, b;
        if (this->Get(a) && c.Get(b)) {
          time_t tta, ttb;
          if (nutools::dbi::Util::DateAsStringToTime_t(a,tta) && 
              nutools::dbi::Util::DateAsStringToTime_t(b,ttb) ) 
            return (tta < ttb);
        }
        else 
          return false;
      }
      
      return false;
      
    }

bool nutools::dbi::Column::operator<=

(

const Column &

c

)

const

Definition at line 179 of file Column.cpp.

References nutools::dbi::Util::DateAsStringToTime_t(), fType, fValue, Get(), nutools::dbi::kBool, nutools::dbi::kDateStamp, nutools::dbi::kFloatLike, nutools::dbi::kIntLike, nutools::dbi::kString, nutools::dbi::kTimeStamp, and nutools::dbi::Util::TimeAsStringToTime_t().

Referenced by Update().

    {
      if (c.fType != fType) return false;
      
      std::string val1 = fValue;
      std::string val2 = c.fValue;
      
      if (fType == kBool) {
        bool a = (val1 == "1");
        bool b = (val2 == "1");
        return ((a == b) || (!a&b));
      }
      
      if (fType == kIntLike) {
        long a = boost::lexical_cast<long>(val1);
        long b = boost::lexical_cast<long>(val2);
        return (a <= b);
      }
      
      if (fType == kFloatLike) {
        double a = boost::lexical_cast<double>(val1);
        double b = boost::lexical_cast<double>(val2);
        return (a <= b);
      }
      
      if (fType == kString) 
        return (val1 <= val2);
      
      if (fType == kTimeStamp) {
        std::string a, b;
        if (this->Get(a) && c.Get(b)) {
          time_t tta, ttb;
          if (nutools::dbi::Util::TimeAsStringToTime_t(a,tta) && 
              nutools::dbi::Util::TimeAsStringToTime_t(b,ttb) ) 
            return (tta <= ttb);
        }
        else 
          return false;
      }
      
      if (fType == kDateStamp) {
        std::string a, b;
        if (this->Get(a) && c.Get(b)) {
          time_t tta, ttb;
          if (nutools::dbi::Util::DateAsStringToTime_t(a,tta) && 
              nutools::dbi::Util::DateAsStringToTime_t(b,ttb) ) 
            return (tta <= ttb);
        }
        else 
          return false;
      }
      
      return false;
      
    }

bool nutools::dbi::Column::operator==

(

const Column &

c

)

const

Definition at line 292 of file Column.cpp.

References fType, and fValue.

Referenced by Update().

    {
      if (c.fType != fType) return false;

      if (fValue == 0 && (fValue==c.fValue)) return true;

      return (strcmp(fValue,c.fValue)==0);
      
    }

bool nutools::dbi::Column::operator>

(

const Column &

c

)

const

Definition at line 123 of file Column.cpp.

References nutools::dbi::Util::DateAsStringToTime_t(), fType, fValue, Get(), nutools::dbi::kBool, nutools::dbi::kDateStamp, nutools::dbi::kFloatLike, nutools::dbi::kIntLike, nutools::dbi::kString, nutools::dbi::kTimeStamp, nutools::dbi::Util::TimeAsStringToTime_t(), and Type().

Referenced by Update().

    {
      if (c.Type() != fType) return false;
      
      std::string val1 = fValue;
      std::string val2 = c.fValue;
      
      if (fType == kBool) {
        bool a = (val1 == "1");
        bool b = (val2 == "1");
        return (a&!b);
      }
      
      if (fType == kIntLike) {
        long a = boost::lexical_cast<long>(val1);
        long b = boost::lexical_cast<long>(val2);
        return (a > b);
      }
      
      if (fType == kFloatLike) {
        double a = boost::lexical_cast<double>(val1);
        double b = boost::lexical_cast<double>(val2);
        return (a > b);
      }
      
      if (fType == kString) 
        return (val1 > val2);
      
      if (fType == kTimeStamp) {
        std::string a, b;
        if (this->Get(a) && c.Get(b)) {
          time_t tta, ttb;
          if (nutools::dbi::Util::TimeAsStringToTime_t(a,tta) && 
              nutools::dbi::Util::TimeAsStringToTime_t(b,ttb) ) 
            return (tta > ttb);
        }
        else 
          return false;
      }
      
      if (fType == kDateStamp) {
        std::string a, b;
        if (this->Get(a) && c.Get(b)) {
          time_t tta, ttb;
          if (nutools::dbi::Util::DateAsStringToTime_t(a,tta) && 
              nutools::dbi::Util::DateAsStringToTime_t(b,ttb) ) 
            return (tta > ttb);
        }
        else 
          return false;
      }
      return false;
      
    }

bool nutools::dbi::Column::operator>=

(

const Column &

c

)

const

Definition at line 67 of file Column.cpp.

References nutools::dbi::Util::DateAsStringToTime_t(), fType, fValue, Get(), nutools::dbi::kBool, nutools::dbi::kDateStamp, nutools::dbi::kFloatLike, nutools::dbi::kIntLike, nutools::dbi::kString, nutools::dbi::kTimeStamp, nutools::dbi::Util::TimeAsStringToTime_t(), and Type().

Referenced by Update().

    {
      if (c.Type() != fType) return false;
      
      std::string val1 = fValue;
      std::string val2 = c.fValue;
      
      if (fType == kBool) {
        bool a = (val1 == "1");
        bool b = (val2 == "1");
        return ((a == b) || (a&!b));
      }
      
      if (fType == kIntLike) {
        long a = boost::lexical_cast<long>(val1);
        long b = boost::lexical_cast<long>(val2);
        return (a >= b);
      }
      
      if (fType == kFloatLike) {
        double a = boost::lexical_cast<double>(val1);
        double b = boost::lexical_cast<double>(val2);
        return (a >= b);
      }
      
      if (fType == kString) 
        return (val1 >= val2);
      
      if (fType == kTimeStamp) {
        std::string a, b;
        if (this->Get(a) && c.Get(b)) {
          time_t tta, ttb;
          if (nutools::dbi::Util::TimeAsStringToTime_t(a,tta) && 
              nutools::dbi::Util::TimeAsStringToTime_t(b,ttb) ) 
            return (tta >= ttb);
        }
        else 
          return false;
      }
      
      if (fType == kDateStamp) {
        std::string a, b;
        if (this->Get(a) && c.Get(b)) {
          time_t tta, ttb;
          if (nutools::dbi::Util::DateAsStringToTime_t(a,tta) && 
              nutools::dbi::Util::DateAsStringToTime_t(b,ttb) ) 
            return (tta >= ttb);
        }
        else 
          return false;
      }
      return false;
      
    }

template<class T >

bool nutools::dbi::Column::Set ( const T &  val, bool  ignoreAutoIncr = false  )

inline

Definition at line 89 of file Column.h.

References fType, fValue, nutools::dbi::kAutoIncr, and nutools::dbi::kBool.

Referenced by Update().

                                                         { 
        if (!ignoreAutoIncr && fType==kAutoIncr) {
          std::cerr << "Cannot set a column of type \"autoincr\"!" 
                    << std::endl;
          return false;
        }
        try {     
          if (fValue) {
            delete fValue;
            fValue=0;
          }
          std::string tstr = boost::lexical_cast<std::string>(val);
          if (tstr == "" || tstr=="NULL") {
            return true;
          }
          if (fType == kBool) {
            fValue = new char[1];
            if (tstr == "TRUE" || tstr == "t" || tstr == "true" || 
                tstr == "y" || tstr == "yes" || tstr == "1" || tstr == "on") 
              fValue[0] = '1';
            else 
              fValue[1] = '0';
            return true;
          }
          else {
            fValue = new char[tstr.length()];
            strcpy(fValue,tstr.c_str());
            return true;
          }
        }
        catch (boost::bad_lexical_cast &) {
          std::cerr << "Column::Set(): Bad lexical cast! Value = " 
               << val << std::endl;
          return false;
        }
        return false;
      }

void nutools::dbi::Column::SetType ( uint8_t  t )

inline

Definition at line 49 of file Column.h.

References fType.

{ fType = t; }

uint8_t nutools::dbi::Column::Type ( ) const

inline

Definition at line 40 of file Column.h.

References fType.

Referenced by operator>(), and operator>=().

{ return fType;}

template<class T >

bool nutools::dbi::Column::Update ( const T &  val )

inline

Definition at line 128 of file Column.h.

References col, fModified, operator<(), operator<<, operator<=(), operator==(), operator>(), operator>=(), and Set().

                                  { 
        if (Set(val)) {
          fModified = true; return true; }
        else
          return false;
      }

std::string nutools::dbi::Column::Value ( ) const

inline

Definition at line 41 of file Column.h.

References fValue.

                                  { 
        if (!fValue) return std::string("");
        else return std::string(fValue); }

Friends And Related Function Documentation

std::ostream& operator<< ( std::ostream &  stream, const Column &  col  )

friend

Definition at line 152 of file Column.h.

Referenced by Update().

                                                                          { 
      if (!col.fValue) {
        stream << "NULL";
      }
      else {
        if (col.fType == kBool) {
          if (col.fValue[0] == '1')
            stream << "true";
          else
            stream << "false";
        }
        else {
          bool needsQuotes = (col.fType == kString || 
                              col.fType == kTimeStamp || 
                              col.fType == kDateStamp );
          if (needsQuotes)      stream << "\'";
          stream << col.fValue;
          if (needsQuotes)      stream << "\'";
        }
      }
      return stream;
    }

Member Data Documentation

bool nutools::dbi::Column::fModified

private

Definition at line 144 of file Column.h.

Referenced by Clear(), Column(), Modified(), and Update().

uint16_t nutools::dbi::Column::fType

private

Definition at line 145 of file Column.h.

Referenced by Column(), operator<(), nutools::dbi::operator<<(), operator<=(), operator==(), operator>(), operator>=(), Set(), SetType(), and Type().

char* nutools::dbi::Column::fValue

private

Definition at line 146 of file Column.h.

Referenced by Clear(), Column(), FastSet(), Get(), IsNull(), operator<(), nutools::dbi::operator<<(), operator<=(), operator==(), operator>(), operator>=(), Set(), Value(), and ~Column().

---

The documentation for this class was generated from the following files:

• nutools/IFDatabase/Column.h
• nutools/IFDatabase/Column.cpp