demo_with_rollback.cxx File Reference

#include "TVldTimeStamp.hxx"
#include "TDbi.hxx"
#include "TSK_DBI_Context.hxx"
#include "TDemo2_DB_Table.hxx"
#include "TResultSetHandle.hxx"
#include <iostream>
#include <string>

Include dependency graph for demo_with_rollback.cxx:

Go to the source code of this file.

Functions
Int_t	DateTimeToUnixTime (const std::string &dateTime)
std::string	UnixTimeToDateTime (Int_t unixSecs)
int	main ()

---

Function Documentation

Int_t DateTimeToUnixTime

(

const std::string &

dateTime

)

Definition at line 29 of file demo_with_rollback.cxx.

References TVldTimeStamp::GetSec(), and TDbi::MakeTimeStamp().

                                                    {
  return TDbi::MakeTimeStamp(dateTime).GetSec();
}

Here is the call graph for this function:

int main

(

)

Definition at line 46 of file demo_with_rollback.cxx.

References DateTimeToUnixTime(), TDbiResultSetHandle< T >::GetNumRows(), TDbiResultSetHandle< T >::GetRow(), TDbiResultSetHandle< T >::GetRowByIndex(), TDemo2_DB_Table::Print(), TSK_DBI_Context::SetTimeStamp(), SK_DBI_Log, and UnixTimeToDateTime().

           {


  // Examine the Database table DEMO_DB_TABLE every 5 days between the start
  // and end date.

  std::string start_date_time = "2008-12-30 00:00:00";
  std::string end_date_time   = "2009-03-01 00:00:00";

  Int_t start_unix_time = DateTimeToUnixTime(start_date_time);
  Int_t end_unix_time   = DateTimeToUnixTime(end_date_time);

  UInt_t required_id      = 1;

  for (Int_t current_unix_time = start_unix_time; current_unix_time <= end_unix_time; current_unix_time += 5*24*60*60) {
    TSK_DBI_Context context;
    context.SetTimeStamp(current_unix_time);
    TResultSetHandle<TDemo2_DB_Table> rs(context);
    SK_DBI_Log("_______________________________________________________________________________");
    Int_t numRows(rs.GetNumRows());
    if ( ! numRows )  SK_DBI_Log("Applying query at " << UnixTimeToDateTime(current_unix_time) << " ... failed to find any results.");
    else {
      SK_DBI_Log("Applying query at " << UnixTimeToDateTime(current_unix_time) << " ... result set contains " 
                                    << numRows << " rows as follows:-");
      for (Int_t irow = 0; irow<numRows; ++irow) rs.GetRow(irow)->Print();
      const TDemo2_DB_Table* required_row = rs.GetRowByIndex(required_id);
      if ( required_row ) {
        SK_DBI_Log("  required row " << 1);
        required_row->Print();
      }
      else SK_DBI_Log("  cannot find required row " << 1);      
    }
  }

  return 0;
}

Here is the call graph for this function:

std::string UnixTimeToDateTime

(

Int_t

unixSecs

)

Definition at line 33 of file demo_with_rollback.cxx.

References TDbi::MakeDateTimeString().

                                             {
  return TDbi::MakeDateTimeString(TVldTimeStamp(unixSecs,0));
}

Here is the call graph for this function: