ElogStatus.cxx

Go to the documentation of this file.

// ----------------------------------------------------------------------
//                    ElogStatus cxx file
//                      Generated 13-04-2026
// ----------------------------------------------------------------------
 
#include "ElogStatus.h"
 
#include "TSQLServer.h"
#include "TSQLStatement.h"
 
#include <iostream>
using namespace std;
 
/* GENERATED CLASS MEMBERS (SHOULD NOT BE CHANGED MANUALLY) */
// -----   Constructor with database connection   -----------------------
ElogStatus::ElogStatus(ElogConnection* db_connect, int status_id, TString status_text)
{
    connectionDB = db_connect;
 
    i_status_id = status_id;
    str_status_text = status_text;
}
 
// -----   Destructor   -------------------------------------------------
ElogStatus::~ElogStatus()
{
    if (connectionDB)
        delete connectionDB;
}
 
// -----   Creating new status in the database  ---------------------------
ElogStatus* ElogStatus::CreateStatus(TString status_text)
{
    ElogConnection* connDb = ElogConnection::Open();
    if (connDb == nullptr)
        return nullptr;
 
    TSQLServer* db_server = connDb->GetSQLServer();
 
    TString sql = TString::Format("insert into status_(status_text) "
                                  "values ($1)");
    TSQLStatement* stmt = db_server->Statement(sql);
 
    stmt->NextIteration();
    stmt->SetString(0, status_text);
 
    // inserting new status to the Database
    if (!stmt->Process()) {
        cout << "ERROR: inserting new status to the Database has been failed" << endl;
        delete stmt;
        delete connDb;
        return nullptr;
    }
 
    delete stmt;
 
    // getting last inserted ID
    int status_id;
    TSQLStatement* stmt_last = db_server->Statement("SELECT currval(pg_get_serial_sequence('status_','status_id'))");
 
    // process getting last id
    if (stmt_last->Process()) {
        // store result of statement in buffer
        stmt_last->StoreResult();
 
        // if there is no last id then exit with error
        if (!stmt_last->NextResultRow()) {
            cout << "ERROR: no last ID in DB!" << endl;
            delete stmt_last;
            return nullptr;
        } else {
            status_id = stmt_last->GetInt(0);
            delete stmt_last;
        }
    } else {
        cout << "ERROR: getting last ID has been failed!" << endl;
        delete stmt_last;
        return nullptr;
    }
 
    int tmp_status_id;
    tmp_status_id = status_id;
    TString tmp_status_text;
    tmp_status_text = status_text;
 
    return new ElogStatus(connDb, tmp_status_id, tmp_status_text);
}
 
// -----  Get status from the database  ---------------------------
ElogStatus* ElogStatus::GetStatus(int status_id)
{
    ElogConnection* connDb = ElogConnection::Open();
    if (connDb == nullptr)
        return nullptr;
 
    TSQLServer* db_server = connDb->GetSQLServer();
 
    TString sql = TString::Format("select status_id, status_text "
                                  "from status_ "
                                  "where status_id = %d",
                                  status_id);
    TSQLStatement* stmt = db_server->Statement(sql);
 
    // get status from the database
    if (!stmt->Process()) {
        cout << "ERROR: getting status 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: status was not found in the database" << endl;
 
        delete stmt;
        delete connDb;
        return nullptr;
    }
 
    int tmp_status_id;
    tmp_status_id = stmt->GetInt(0);
    TString tmp_status_text;
    tmp_status_text = stmt->GetString(1);
 
    delete stmt;
 
    return new ElogStatus(connDb, tmp_status_id, tmp_status_text);
}
 
// -----  Get status from the database by unique key  --------------
ElogStatus* ElogStatus::GetStatus(TString status_text)
{
    ElogConnection* connDb = ElogConnection::Open();
    if (connDb == nullptr)
        return nullptr;
 
    TSQLServer* db_server = connDb->GetSQLServer();
 
    TString sql = TString::Format("select status_id, status_text "
                                  "from status_ "
                                  "where lower(status_text) = lower('%s')",
                                  status_text.Data());
    TSQLStatement* stmt = db_server->Statement(sql);
 
    // get status from the database
    if (!stmt->Process()) {
        cout << "ERROR: getting status 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: status was not found in the database" << endl;
 
        delete stmt;
        delete connDb;
        return nullptr;
    }
 
    int tmp_status_id;
    tmp_status_id = stmt->GetInt(0);
    TString tmp_status_text;
    tmp_status_text = stmt->GetString(1);
 
    delete stmt;
 
    return new ElogStatus(connDb, tmp_status_id, tmp_status_text);
}
 
// -----  Check status exists in the database  ---------------------------
int ElogStatus::CheckStatusExists(int status_id)
{
    ElogConnection* connDb = ElogConnection::Open();
    if (connDb == nullptr)
        return -1;
 
    TSQLServer* db_server = connDb->GetSQLServer();
 
    TString sql = TString::Format("select 1 "
                                  "from status_ "
                                  "where status_id = %d",
                                  status_id);
    TSQLStatement* stmt = db_server->Statement(sql);
 
    // get status from the database
    if (!stmt->Process()) {
        cout << "ERROR: getting status 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;
}
 
// -----  Check status exists in the database by unique key  --------------
int ElogStatus::CheckStatusExists(TString status_text)
{
    ElogConnection* connDb = ElogConnection::Open();
    if (connDb == nullptr)
        return -1;
 
    TSQLServer* db_server = connDb->GetSQLServer();
 
    TString sql = TString::Format("select 1 "
                                  "from status_ "
                                  "where lower(status_text) = lower('%s')",
                                  status_text.Data());
    TSQLStatement* stmt = db_server->Statement(sql);
 
    // get status from the database
    if (!stmt->Process()) {
        cout << "ERROR: getting status 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 status from the database  ---------------------------
int ElogStatus::DeleteStatus(int status_id)
{
    ElogConnection* connDb = ElogConnection::Open();
    if (connDb == nullptr)
        return -1;
 
    TSQLServer* db_server = connDb->GetSQLServer();
 
    TString sql = TString::Format("delete from status_ "
                                  "where status_id = $1");
    TSQLStatement* stmt = db_server->Statement(sql);
 
    stmt->NextIteration();
    stmt->SetInt(0, status_id);
 
    // delete status from the dataBase
    if (!stmt->Process()) {
        cout << "ERROR: deleting status from the dataBase has been failed" << endl;
 
        delete stmt;
        delete connDb;
        return -2;
    }
 
    delete stmt;
    delete connDb;
    return 0;
}
 
// -----  Delete status from the database by unique key  --------------
int ElogStatus::DeleteStatus(TString status_text)
{
    ElogConnection* connDb = ElogConnection::Open();
    if (connDb == nullptr)
        return -1;
 
    TSQLServer* db_server = connDb->GetSQLServer();
 
    TString sql = TString::Format("delete from status_ "
                                  "where lower(status_text) = lower($1)");
    TSQLStatement* stmt = db_server->Statement(sql);
 
    stmt->NextIteration();
    stmt->SetString(0, status_text);
 
    // delete status from the dataBase
    if (!stmt->Process()) {
        cout << "ERROR: deleting status from the DataBase has been failed" << endl;
 
        delete stmt;
        delete connDb;
        return -2;
    }
 
    delete stmt;
    delete connDb;
    return 0;
}
 
// -----  Print all 'statuss'  ---------------------------------
int ElogStatus::PrintAll()
{
    ElogConnection* connDb = ElogConnection::Open();
    if (connDb == nullptr)
        return -1;
 
    TSQLServer* db_server = connDb->GetSQLServer();
 
    TString sql = TString::Format("select status_id, status_text "
                                  "from status_");
    TSQLStatement* stmt = db_server->Statement(sql);
 
    // get all 'statuss' from the database
    if (!stmt->Process()) {
        cout << "ERROR: getting all 'statuss' 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 'status_':" << endl;
    while (stmt->NextResultRow()) {
        cout << "status_id: ";
        cout << (stmt->GetInt(0));
        cout << ", status_text: ";
        cout << (stmt->GetString(1));
        cout << "." << endl;
    }
 
    delete stmt;
    delete connDb;
 
    return 0;
}
 
// Setters functions
int ElogStatus::SetStatusText(TString status_text)
{
    if (!connectionDB) {
        cout << "CRITICAL ERROR: Connection object is null" << endl;
        return -1;
    }
 
    TSQLServer* db_server = connectionDB->GetSQLServer();
 
    TString sql = TString::Format("update status_ "
                                  "set status_text = $1 "
                                  "where status_id = $2");
    TSQLStatement* stmt = db_server->Statement(sql);
 
    stmt->NextIteration();
    stmt->SetString(0, status_text);
    stmt->SetInt(1, i_status_id);
 
    // write new value to the database
    if (!stmt->Process()) {
        cout << "ERROR: updating information about status has been failed" << endl;
 
        delete stmt;
        return -2;
    }
 
    str_status_text = status_text;
 
    delete stmt;
    return 0;
}
 
// -----  Print current status  ---------------------------------------
void ElogStatus::Print()
{
    cout << "Table 'status_'";
    cout << ". status_id: " << i_status_id << ". status_text: " << str_status_text << endl;
 
    return;
}
/* END OF GENERATED CLASS PART (SHOULD NOT BE CHANGED MANUALLY) */