ElogTarget.cxx

Go to the documentation of this file.

// ----------------------------------------------------------------------
//                    ElogTarget cxx file
//                      Generated 27-11-2017
// ----------------------------------------------------------------------
 
#include "ElogTarget.h"
 
#include "TSQLServer.h"
#include "TSQLStatement.h"
 
#include <iostream>
using namespace std;
 
/* GENERATED CLASS MEMBERS (SHOULD NOT BE CHANGED MANUALLY) */
// -----   Constructor with database connection   -----------------------
ElogTarget::ElogTarget(ElogConnection* db_connect, TString target, bool is_active)
{
    connectionDB = db_connect;
 
    str_target = target;
    b_is_active = is_active;
}
 
// -----   Destructor   -------------------------------------------------
ElogTarget::~ElogTarget()
{
    if (connectionDB)
        delete connectionDB;
}
 
// -----   Creating new target in the database  ---------------------------
ElogTarget* ElogTarget::CreateTarget(TString target, bool is_active)
{
    ElogConnection* connDb = ElogConnection::Open();
    if (connDb == nullptr)
        return nullptr;
 
    TSQLServer* db_server = connDb->GetSQLServer();
 
    TString sql = TString::Format("insert into target_(target, is_active) "
                                  "values ($1, $2)");
    TSQLStatement* stmt = db_server->Statement(sql);
 
    stmt->NextIteration();
    stmt->SetString(0, target);
    stmt->SetInt(1, is_active);
 
    // inserting new target to the Database
    if (!stmt->Process()) {
        cout << "ERROR: inserting new target to the Database has been failed" << endl;
        delete stmt;
        delete connDb;
        return nullptr;
    }
 
    delete stmt;
 
    TString tmp_target;
    tmp_target = target;
    bool tmp_is_active;
    tmp_is_active = is_active;
 
    return new ElogTarget(connDb, tmp_target, tmp_is_active);
}
 
// -----  Get target from the database  ---------------------------
ElogTarget* ElogTarget::GetTarget(TString target)
{
    ElogConnection* connDb = ElogConnection::Open();
    if (connDb == nullptr)
        return nullptr;
 
    TSQLServer* db_server = connDb->GetSQLServer();
 
    TString sql = TString::Format("select target, is_active "
                                  "from target_ "
                                  "where lower(target) = lower('%s')",
                                  target.Data());
    TSQLStatement* stmt = db_server->Statement(sql);
 
    // get target from the database
    if (!stmt->Process()) {
        cout << "ERROR: getting target from the database has been failed" << endl;
 
        delete stmt;
        delete connDb;
        return nullptr;
    }
 
    // store result of statement in buffer
    stmt->StoreResult();
 
    // extract row
    if (!stmt->NextResultRow()) {
        cout << "ERROR: target was not found in the database" << endl;
 
        delete stmt;
        delete connDb;
        return nullptr;
    }
 
    TString tmp_target;
    tmp_target = stmt->GetString(0);
    bool tmp_is_active;
    tmp_is_active = stmt->GetInt(1);
 
    delete stmt;
 
    return new ElogTarget(connDb, tmp_target, tmp_is_active);
}
 
// -----  Check target exists in the database  ---------------------------
int ElogTarget::CheckTargetExists(TString target)
{
    ElogConnection* connDb = ElogConnection::Open();
    if (connDb == nullptr)
        return -1;
 
    TSQLServer* db_server = connDb->GetSQLServer();
 
    TString sql = TString::Format("select 1 "
                                  "from target_ "
                                  "where lower(target) = lower('%s')",
                                  target.Data());
    TSQLStatement* stmt = db_server->Statement(sql);
 
    // get target from the database
    if (!stmt->Process()) {
        cout << "ERROR: getting target from the database has been failed" << endl;
 
        delete stmt;
        delete connDb;
        return -2;
    }
 
    // store result of statement in buffer
    stmt->StoreResult();
 
    // extract row
    if (!stmt->NextResultRow()) {
        delete stmt;
        delete connDb;
        return 0;
    }
 
    delete stmt;
    delete connDb;
 
    return 1;
}
 
// -----  Delete target from the database  ---------------------------
int ElogTarget::DeleteTarget(TString target)
{
    ElogConnection* connDb = ElogConnection::Open();
    if (connDb == nullptr)
        return -1;
 
    TSQLServer* db_server = connDb->GetSQLServer();
 
    TString sql = TString::Format("delete from target_ "
                                  "where lower(target) = lower($1)");
    TSQLStatement* stmt = db_server->Statement(sql);
 
    stmt->NextIteration();
    stmt->SetString(0, target);
 
    // delete target from the dataBase
    if (!stmt->Process()) {
        cout << "ERROR: deleting target from the dataBase has been failed" << endl;
 
        delete stmt;
        delete connDb;
        return -2;
    }
 
    delete stmt;
    delete connDb;
    return 0;
}
 
// -----  Print all 'targets'  ---------------------------------
int ElogTarget::PrintAll()
{
    ElogConnection* connDb = ElogConnection::Open();
    if (connDb == nullptr)
        return -1;
 
    TSQLServer* db_server = connDb->GetSQLServer();
 
    TString sql = TString::Format("select target, is_active "
                                  "from target_");
    TSQLStatement* stmt = db_server->Statement(sql);
 
    // get all 'targets' from the database
    if (!stmt->Process()) {
        cout << "ERROR: getting all 'targets' from the dataBase has been failed" << endl;
 
        delete stmt;
        delete connDb;
        return -2;
    }
 
    // store result of statement in buffer
    stmt->StoreResult();
 
    // print rows
    cout << "Table 'target_':" << endl;
    while (stmt->NextResultRow()) {
        cout << "target: ";
        cout << (stmt->GetString(0));
        cout << ", is_active: ";
        cout << (stmt->GetInt(1));
        cout << "." << endl;
    }
 
    delete stmt;
    delete connDb;
 
    return 0;
}
 
// Setters functions
int ElogTarget::SetTarget(TString target)
{
    if (!connectionDB) {
        cout << "CRITICAL ERROR: Connection object is null" << endl;
        return -1;
    }
 
    TSQLServer* db_server = connectionDB->GetSQLServer();
 
    TString sql = TString::Format("update target_ "
                                  "set target = $1 "
                                  "where target = $2");
    TSQLStatement* stmt = db_server->Statement(sql);
 
    stmt->NextIteration();
    stmt->SetString(0, target);
    stmt->SetString(1, str_target);
 
    // write new value to the database
    if (!stmt->Process()) {
        cout << "ERROR: updating information about target has been failed" << endl;
 
        delete stmt;
        return -2;
    }
 
    str_target = target;
 
    delete stmt;
    return 0;
}
 
int ElogTarget::SetIsActive(bool is_active)
{
    if (!connectionDB) {
        cout << "CRITICAL ERROR: Connection object is null" << endl;
        return -1;
    }
 
    TSQLServer* db_server = connectionDB->GetSQLServer();
 
    TString sql = TString::Format("update target_ "
                                  "set is_active = $1 "
                                  "where target = $2");
    TSQLStatement* stmt = db_server->Statement(sql);
 
    stmt->NextIteration();
    stmt->SetInt(0, is_active);
    stmt->SetString(1, str_target);
 
    // write new value to the database
    if (!stmt->Process()) {
        cout << "ERROR: updating information about target has been failed" << endl;
 
        delete stmt;
        return -2;
    }
 
    b_is_active = is_active;
 
    delete stmt;
    return 0;
}
 
// -----  Print current target  ---------------------------------------
void ElogTarget::Print()
{
    cout << "Table 'target_'";
    cout << ". target: " << str_target << ". is_active: " << b_is_active << endl;
 
    return;
}
/* END OF GENERATED CLASS PART (SHOULD NOT BE CHANGED MANUALLY) */