---

IDBrunmap.cxx

Go to the documentation of this file.

//
// $Id: IDBrunmap.cxx,v 1.5 2000/02/29 12:46:39 mueller Exp $
//

#include "CTB.hxx"
#include "CTBodbc.hxx"
#include "CTBodbcConnect.hxx"
#include "CTBodbcStatement.hxx"
#include "CTBodbcTime.hxx"

#include "IDB.hxx"
#include "IDBrunmap.hxx"

//------------------------------------------+-----------------------------------

IDBrunmap::IDBrunmap()
  : m_idbc(IDBconnect::Default())
{}

//------------------------------------------+-----------------------------------

IDBrunmap::IDBrunmap(IDBconnect& idbc)
  : m_idbc(idbc)
{}

//------------------------------------------+-----------------------------------

IDBrunmap::~IDBrunmap()
{}

//------------------------------------------+-----------------------------------

int IDBrunmap::UrnFromHeadTime(const char* c_headtime)
{
  CTBodbcStatement  stmt(m_idbc.Dbc());
  CTBcstring<19>    c_htime(c_headtime);

  if (c_htime[0] == ' ') c_htime[0] = '0';  // infamous ' 1-JUL' -> '01-JUL'

  stmt.Prepare("SELECT urn FROM runmap WHERE headtime = ?");
  stmt.BindIParameter(1,SQL_CHAR,c_htime);
  stmt.Execute();

  if (stmt.Fetch()) {
    int  i_urn = -1;
    bool b_null;
    stmt.GetData(1,i_urn,b_null);
    return i_urn;
  }

  return -1;
}

//------------------------------------------+-----------------------------------

const char* IDBrunmap::HeadTimeFromUrn(int i_urn)
{
  CTBodbcStatement  stmt(m_idbc.Dbc());

  stmt.Prepare("SELECT headtime FROM runmap WHERE urn = ?");
  stmt.BindIParameter(1,SQL_INTEGER,i_urn);
  stmt.Execute();

  if (stmt.Fetch()) {
    bool b_null;
    stmt.GetData(1,mc_headtime,mc_headtime.Size(),b_null);
    return mc_headtime;
  }

  return "";
}

//------------------------------------------+-----------------------------------

int IDBrunmap::OrnFromUrn(int i_urn)
{
  CTBodbcStatement  stmt(m_idbc.Dbc());

  stmt.Prepare("SELECT orn FROM runmap WHERE urn = ?");
  stmt.BindIParameter(1,SQL_INTEGER,i_urn);
  stmt.Execute();

  if (stmt.Fetch()) {
    int  i_orn = -1;
    bool b_null;
    stmt.GetData(1,i_orn,b_null);
    return i_orn;
  }

  return -1;
}

//------------------------------------------+-----------------------------------

int IDBrunmap::TheadFromUrn(int i_urn)
{
  CTBodbcStatement  stmt(m_idbc.Dbc());

  stmt.Prepare("SELECT thead FROM runmap WHERE urn = ?");
  stmt.BindIParameter(1,SQL_INTEGER,i_urn);
  stmt.Execute();

  if (stmt.Fetch()) {
    CTBodbcTime  time;
    bool         b_null;
    stmt.GetData(1,time,b_null);
    return time.ToUTime();
  }

  return -1;
}

---