nutools::dbi::Util Class Reference

#include "Util.h"

Static Public Member Functions
static bool	CheckConnection (std::string dbname, std::string server, std::string user="", std::string port="")
static std::string	GetFarPastTimeAsString ()
static std::string	GetCurrentTimeAsString ()
static std::string	GetCurrentDateAsString ()
static std::string	GetFarFutureTimeAsString ()
static bool	TimeAsStringToTime_t (std::string ts, time_t &t)
static bool	DateAsStringToTime_t (std::string date, time_t &t)
static bool	RunningOnGrid ()

Detailed Description

Generalized Database Table Interface Utilities

Author

Jonathan Paley

Version

Id

Util.h,v 1.9 2011/08/08 16:03:04 jpaley Exp

Definition at line 16 of file Util.h.

Member Function Documentation

bool nutools::dbi::Util::CheckConnection ( std::string  dbname, std::string  server, std::string  user = "", std::string  port = ""  )

static

Definition at line 13 of file Util.cpp.

    {
      bool retVal = true;
      
      std::string cmd = "dbname = " + dbname + " host = " + host;
      if (user != "")
        cmd += " user = " + user;
      if (port != "")
        cmd += " port = " + port;
      
      PGconn* conn = PQconnectdb(cmd.c_str());
      if (conn) {
        if (PQstatus(conn) != CONNECTION_OK) {
          std::cerr << "Connection to " << host << ":" << dbname << " failed: " 
                    << PQerrorMessage(conn) << std::endl;
          retVal = false;
        }
        else 
          PQfinish(conn);      
      }
      else
        retVal = false;
      
      return retVal;
      
    }

bool nutools::dbi::Util::DateAsStringToTime_t ( std::string  date, time_t &  t  )

static

Definition at line 106 of file Util.cpp.

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

    {
      bool isOk = false;
      struct tm ta;
      if ( (sscanf(ts.c_str(),"%d/%d/%d",
                   &ta.tm_year,&ta.tm_mon,&ta.tm_mday) == 3))
        isOk = true;
      if (!isOk)
        if ( (sscanf(ts.c_str(),"%d-%d-%d",
                     &ta.tm_year,&ta.tm_mon,&ta.tm_mday) == 3))
          isOk = true;
      
      if (isOk) {
        ta.tm_year -= 1900;
        ta.tm_mon -= 1;
        ta.tm_hour = 0;
        ta.tm_min = 0;
        ta.tm_sec = 0;
        t = timegm(&ta);
      }
      
      return isOk;
      
    }

std::string nutools::dbi::Util::GetCurrentDateAsString ( )

static

Definition at line 56 of file Util.cpp.

    {
      time_t rawtime;
      struct tm* timeinfo;
      char buffer[256];
      time(&rawtime);
      timeinfo = gmtime(&rawtime);
      strftime(buffer,256,"%Y-%m-%d",timeinfo);
      
      return std::string(buffer);
      
    }

std::string nutools::dbi::Util::GetCurrentTimeAsString ( )

static

Definition at line 42 of file Util.cpp.

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

    {
      time_t rawtime;
      struct tm* timeinfo;
      char buffer[256];
      time(&rawtime);
      timeinfo = gmtime(&rawtime);
      strftime(buffer,256,"%Y-%m-%d %H:%M:%S",timeinfo);
      
      return std::string(buffer);
      
    }

std::string nutools::dbi::Util::GetFarFutureTimeAsString ( )

static

Definition at line 75 of file Util.cpp.

    {
      return "2099-12-31 23:59:59";
    }

std::string nutools::dbi::Util::GetFarPastTimeAsString ( )

static

Definition at line 70 of file Util.cpp.

    {
      return "1900-01-01 00:00:00";
    }

bool nutools::dbi::Util::RunningOnGrid ( )

static

Definition at line 132 of file Util.cpp.

Referenced by nutools::dbi::Table::GetConnection(), nutools::dbi::Table::Load(), nutools::dbi::Table::LoadConditionsTable(), nutools::dbi::Table::LoadUnstructuredConditionsTable(), and nutools::dbi::Table::Write().

    {
      char* tStr = getenv("_CONDOR_SCRATCH_DIR");
      return (tStr != 0);
    }

bool nutools::dbi::Util::TimeAsStringToTime_t ( std::string  ts, time_t &  t  )

static

Definition at line 81 of file Util.cpp.

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

    {
      bool isOk = false;
      struct tm ta;
      if ( (sscanf(ts.c_str(),"%d/%d/%d %d:%d:%d",
                   &ta.tm_year,&ta.tm_mon,&ta.tm_mday,
                   &ta.tm_hour,&ta.tm_min,&ta.tm_sec) == 6))
        isOk = true;
      if (!isOk)
        if ( (sscanf(ts.c_str(),"%d-%d-%d %d:%d:%d",
                     &ta.tm_year,&ta.tm_mon,&ta.tm_mday,
                     &ta.tm_hour,&ta.tm_min,&ta.tm_sec) == 6))
          isOk = true;
      
      if (isOk) {
        ta.tm_year -= 1900;
        ta.tm_mon -= 1;
        t = timegm(&ta);
      }
      
      return isOk;
      
    }

---

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

• nutools/IFDatabase/Util.h
• nutools/IFDatabase/Util.cpp