---

IDBrunnote.cxx

Go to the documentation of this file.

//
// $Id: IDBrunnote.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 "IDBrunnote.hxx"

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

IDBrunnote::IDBrunnote()
  : m_idbc(IDBconnect::Default()),
    mp_stmt(0),
    mb_select_urn(false),
    mb_fetch_ok(false)
{}

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

IDBrunnote::IDBrunnote(IDBconnect& idbc)
  : m_idbc(idbc),
    mp_stmt(0),
    mb_select_urn(false),
    mb_fetch_ok(false)
{}

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

IDBrunnote::~IDBrunnote()
{
  if (mp_stmt != 0) delete mp_stmt;
}

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

bool IDBrunnote::SelectUrn(int i_urn)
{
  mb_fetch_ok   = false;
  mb_select_urn = true;
  mi_urnbeg_sel = i_urn;                    // do a validity check here ???
  mi_urnend_sel = i_urn;
  return true;
}

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

bool IDBrunnote::SelectUrn(const CTBrange& urns)
{
  mb_fetch_ok   = false;
  mb_select_urn = true;
  mi_urnbeg_sel = urns.Begin();             // do a validity check here ???
  mi_urnend_sel = urns.End();
  return true;
}

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

bool IDBrunnote::SelectUrn()
{
  mb_fetch_ok   = false;
  mb_select_urn = false;
  return true;
}

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

bool IDBrunnote::Execute()
{
  CTBcstring<512> c_sql;
  
  mb_fetch_ok = false;

  if (mp_stmt == 0) {
    mp_stmt = new CTBodbcStatement(m_idbc.Dbc());
  } else {
    mp_stmt->Close();
    mp_stmt->UnbindParameter();
  }
  
  c_sql = "SELECT note_id,urn_beg,urn_end,date_create,date_revoke,"
                  "username,note"
          " FROM runnote";

  if (mb_select_urn) {
    c_sql += " WHERE ? <= urn_end AND ? >= urn_beg";
    mp_stmt->BindIParameter( 1,SQL_INTEGER,mi_urnbeg_sel);
    mp_stmt->BindIParameter( 2,SQL_INTEGER,mi_urnend_sel);
  }

  c_sql += " ORDER BY urn_beg,urn_end,date_create";

  return mp_stmt->Prepare(c_sql) && mp_stmt->Execute();
}

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

bool IDBrunnote::Fetch()
{
  bool        b_null;
  int         i_urnbeg = -1;
  int         i_urnend = -1;
  CTBodbcTime date;
  
  mb_fetch_ok = false;
  if (mp_stmt == 0 || ! mp_stmt->Fetch()) return false;

  if(!mp_stmt->GetData(1,mi_id,b_null)) return false;

  if(!mp_stmt->GetData(2,i_urnbeg,b_null)) return false;
  if(!mp_stmt->GetData(3,i_urnend,b_null)) return false;
  m_urn_valid.Begin(i_urnbeg);
  m_urn_valid.End(i_urnend);

  if(!mp_stmt->GetData(4,date,b_null)) return false;
  mi_datecreate = date.ToUTime();

  if(!mp_stmt->GetData(5,date,b_null)) return false;
  mi_daterevoke = (b_null) ? -1 : date.ToUTime();

  if(!mp_stmt->GetData(6,mc_user,mc_user.Size(),b_null)) return false;

  if(!mp_stmt->GetData(7,mc_note,mc_note.Size(),b_null)) return false;

  mb_fetch_ok = true;
  return true;
}

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

bool IDBrunnote::GetID(int& i_id)
{
  if (!mb_fetch_ok) return false;
  i_id = mi_id;
  return true;
}

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

bool IDBrunnote::GetUrn(CTBrange& urns)
{
  if (!mb_fetch_ok) return false;
  urns = m_urn_valid;
  return true;
}

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

bool IDBrunnote::GetDateCreate(int& i_datecreate)
{
  if (!mb_fetch_ok) return false;
  i_datecreate = mi_datecreate;
  return true;
}

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

bool IDBrunnote::GetDateRevoke(int& i_daterevoke)
{
  if (!mb_fetch_ok || i_daterevoke == -1) return false;
  i_daterevoke = mi_daterevoke;
  return true;
}

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

bool IDBrunnote::GetUser(const char*& c_user)
{
  if (!mb_fetch_ok) return false;
  c_user = mc_user;
  return true;
}

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

bool IDBrunnote::GetNote(const char*& c_note)
{
  if (!mb_fetch_ok) return false;
  c_note = mc_note;
  return true;
}

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

bool IDBrunnote::Add(const CTBrange& , const char* )
{
  cerr << "IDBrunnote::Add not yet implemented" << endl;
  return false;
  
}

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

bool IDBrunnote::Revoke(int )
{
  cerr << "IDBrunnote::Revoke not yet implemented" << endl;
  return false;
  
}

---