ElogContact.cxx

Go to the documentation of this file.

// ----------------------------------------------------------------------
//                    ElogContact cxx file
//                      Generated 13-04-2026
// ----------------------------------------------------------------------
 
#include "ElogContact.h"
 
#include "TSQLServer.h"
#include "TSQLStatement.h"
 
#include <iostream>
using namespace std;
 
/* GENERATED CLASS MEMBERS (SHOULD NOT BE CHANGED MANUALLY) */
// -----   Constructor with database connection   -----------------------
ElogContact::ElogContact(ElogConnection* db_connect,
                         int contact_id,
                         TString* contact_name,
                         TString contact_desc,
                         TString* phones,
                         TString* email)
{
    connectionDB = db_connect;
 
    i_contact_id = contact_id;
    str_contact_name = contact_name;
    str_contact_desc = contact_desc;
    str_phones = phones;
    str_email = email;
}
 
// -----   Destructor   -------------------------------------------------
ElogContact::~ElogContact()
{
    if (connectionDB)
        delete connectionDB;
    if (str_contact_name)
        delete str_contact_name;
    if (str_phones)
        delete str_phones;
    if (str_email)
        delete str_email;
}
 
// -----   Creating new contact in the database  ---------------------------
ElogContact* ElogContact::CreateContact(TString* contact_name, TString contact_desc, TString* phones, TString* email)
{
    ElogConnection* connDb = ElogConnection::Open();
    if (connDb == nullptr)
        return nullptr;
 
    TSQLServer* db_server = connDb->GetSQLServer();
 
    TString sql = TString::Format("insert into contact_(contact_name, contact_desc, phones, email) "
                                  "values ($1, $2, $3, $4)");
    TSQLStatement* stmt = db_server->Statement(sql);
 
    stmt->NextIteration();
    if (contact_name == nullptr)
        stmt->SetNull(0);
    else
        stmt->SetString(0, *contact_name);
    stmt->SetString(1, contact_desc);
    if (phones == nullptr)
        stmt->SetNull(2);
    else
        stmt->SetString(2, *phones);
    if (email == nullptr)
        stmt->SetNull(3);
    else
        stmt->SetString(3, *email);
 
    // inserting new contact to the Database
    if (!stmt->Process()) {
        cout << "ERROR: inserting new contact to the Database has been failed" << endl;
        delete stmt;
        delete connDb;
        return nullptr;
    }
 
    delete stmt;
 
    // getting last inserted ID
    int contact_id;
    TSQLStatement* stmt_last = db_server->Statement("SELECT currval(pg_get_serial_sequence('contact_','contact_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 {
            contact_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_contact_id;
    tmp_contact_id = contact_id;
    TString* tmp_contact_name;
    if (contact_name == nullptr)
        tmp_contact_name = nullptr;
    else
        tmp_contact_name = new TString(*contact_name);
    TString tmp_contact_desc;
    tmp_contact_desc = contact_desc;
    TString* tmp_phones;
    if (phones == nullptr)
        tmp_phones = nullptr;
    else
        tmp_phones = new TString(*phones);
    TString* tmp_email;
    if (email == nullptr)
        tmp_email = nullptr;
    else
        tmp_email = new TString(*email);
 
    return new ElogContact(connDb, tmp_contact_id, tmp_contact_name, tmp_contact_desc, tmp_phones, tmp_email);
}
 
// -----  Get contact from the database  ---------------------------
ElogContact* ElogContact::GetContact(int contact_id)
{
    ElogConnection* connDb = ElogConnection::Open();
    if (connDb == nullptr)
        return nullptr;
 
    TSQLServer* db_server = connDb->GetSQLServer();
 
    TString sql = TString::Format("select contact_id, contact_name, contact_desc, phones, email "
                                  "from contact_ "
                                  "where contact_id = %d",
                                  contact_id);
    TSQLStatement* stmt = db_server->Statement(sql);
 
    // get contact from the database
    if (!stmt->Process()) {
        cout << "ERROR: getting contact 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: contact was not found in the database" << endl;
 
        delete stmt;
        delete connDb;
        return nullptr;
    }
 
    int tmp_contact_id;
    tmp_contact_id = stmt->GetInt(0);
    TString* tmp_contact_name;
    if (stmt->IsNull(1))
        tmp_contact_name = nullptr;
    else
        tmp_contact_name = new TString(stmt->GetString(1));
    TString tmp_contact_desc;
    tmp_contact_desc = stmt->GetString(2);
    TString* tmp_phones;
    if (stmt->IsNull(3))
        tmp_phones = nullptr;
    else
        tmp_phones = new TString(stmt->GetString(3));
    TString* tmp_email;
    if (stmt->IsNull(4))
        tmp_email = nullptr;
    else
        tmp_email = new TString(stmt->GetString(4));
 
    delete stmt;
 
    return new ElogContact(connDb, tmp_contact_id, tmp_contact_name, tmp_contact_desc, tmp_phones, tmp_email);
}
 
// -----  Check contact exists in the database  ---------------------------
int ElogContact::CheckContactExists(int contact_id)
{
    ElogConnection* connDb = ElogConnection::Open();
    if (connDb == nullptr)
        return -1;
 
    TSQLServer* db_server = connDb->GetSQLServer();
 
    TString sql = TString::Format("select 1 "
                                  "from contact_ "
                                  "where contact_id = %d",
                                  contact_id);
    TSQLStatement* stmt = db_server->Statement(sql);
 
    // get contact from the database
    if (!stmt->Process()) {
        cout << "ERROR: getting contact 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 contact from the database  ---------------------------
int ElogContact::DeleteContact(int contact_id)
{
    ElogConnection* connDb = ElogConnection::Open();
    if (connDb == nullptr)
        return -1;
 
    TSQLServer* db_server = connDb->GetSQLServer();
 
    TString sql = TString::Format("delete from contact_ "
                                  "where contact_id = $1");
    TSQLStatement* stmt = db_server->Statement(sql);
 
    stmt->NextIteration();
    stmt->SetInt(0, contact_id);
 
    // delete contact from the dataBase
    if (!stmt->Process()) {
        cout << "ERROR: deleting contact from the dataBase has been failed" << endl;
 
        delete stmt;
        delete connDb;
        return -2;
    }
 
    delete stmt;
    delete connDb;
    return 0;
}
 
// -----  Print all 'contacts'  ---------------------------------
int ElogContact::PrintAll()
{
    ElogConnection* connDb = ElogConnection::Open();
    if (connDb == nullptr)
        return -1;
 
    TSQLServer* db_server = connDb->GetSQLServer();
 
    TString sql = TString::Format("select contact_id, contact_name, contact_desc, phones, email "
                                  "from contact_");
    TSQLStatement* stmt = db_server->Statement(sql);
 
    // get all 'contacts' from the database
    if (!stmt->Process()) {
        cout << "ERROR: getting all 'contacts' 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 'contact_':" << endl;
    while (stmt->NextResultRow()) {
        cout << "contact_id: ";
        cout << (stmt->GetInt(0));
        cout << ", contact_name: ";
        if (stmt->IsNull(1))
            cout << "nullptr";
        else
            cout << stmt->GetString(1);
        cout << ", contact_desc: ";
        cout << (stmt->GetString(2));
        cout << ", phones: ";
        if (stmt->IsNull(3))
            cout << "nullptr";
        else
            cout << stmt->GetString(3);
        cout << ", email: ";
        if (stmt->IsNull(4))
            cout << "nullptr";
        else
            cout << stmt->GetString(4);
        cout << "." << endl;
    }
 
    delete stmt;
    delete connDb;
 
    return 0;
}
 
// Setters functions
int ElogContact::SetContactName(TString* contact_name)
{
    if (!connectionDB) {
        cout << "CRITICAL ERROR: Connection object is null" << endl;
        return -1;
    }
 
    TSQLServer* db_server = connectionDB->GetSQLServer();
 
    TString sql = TString::Format("update contact_ "
                                  "set contact_name = $1 "
                                  "where contact_id = $2");
    TSQLStatement* stmt = db_server->Statement(sql);
 
    stmt->NextIteration();
    if (contact_name == nullptr)
        stmt->SetNull(0);
    else
        stmt->SetString(0, *contact_name);
    stmt->SetInt(1, i_contact_id);
 
    // write new value to the database
    if (!stmt->Process()) {
        cout << "ERROR: updating information about contact has been failed" << endl;
 
        delete stmt;
        return -2;
    }
 
    if (str_contact_name)
        delete str_contact_name;
    if (contact_name == nullptr)
        str_contact_name = nullptr;
    else
        str_contact_name = new TString(*contact_name);
 
    delete stmt;
    return 0;
}
 
int ElogContact::SetContactDesc(TString contact_desc)
{
    if (!connectionDB) {
        cout << "CRITICAL ERROR: Connection object is null" << endl;
        return -1;
    }
 
    TSQLServer* db_server = connectionDB->GetSQLServer();
 
    TString sql = TString::Format("update contact_ "
                                  "set contact_desc = $1 "
                                  "where contact_id = $2");
    TSQLStatement* stmt = db_server->Statement(sql);
 
    stmt->NextIteration();
    stmt->SetString(0, contact_desc);
    stmt->SetInt(1, i_contact_id);
 
    // write new value to the database
    if (!stmt->Process()) {
        cout << "ERROR: updating information about contact has been failed" << endl;
 
        delete stmt;
        return -2;
    }
 
    str_contact_desc = contact_desc;
 
    delete stmt;
    return 0;
}
 
int ElogContact::SetPhones(TString* phones)
{
    if (!connectionDB) {
        cout << "CRITICAL ERROR: Connection object is null" << endl;
        return -1;
    }
 
    TSQLServer* db_server = connectionDB->GetSQLServer();
 
    TString sql = TString::Format("update contact_ "
                                  "set phones = $1 "
                                  "where contact_id = $2");
    TSQLStatement* stmt = db_server->Statement(sql);
 
    stmt->NextIteration();
    if (phones == nullptr)
        stmt->SetNull(0);
    else
        stmt->SetString(0, *phones);
    stmt->SetInt(1, i_contact_id);
 
    // write new value to the database
    if (!stmt->Process()) {
        cout << "ERROR: updating information about contact has been failed" << endl;
 
        delete stmt;
        return -2;
    }
 
    if (str_phones)
        delete str_phones;
    if (phones == nullptr)
        str_phones = nullptr;
    else
        str_phones = new TString(*phones);
 
    delete stmt;
    return 0;
}
 
int ElogContact::SetEmail(TString* email)
{
    if (!connectionDB) {
        cout << "CRITICAL ERROR: Connection object is null" << endl;
        return -1;
    }
 
    TSQLServer* db_server = connectionDB->GetSQLServer();
 
    TString sql = TString::Format("update contact_ "
                                  "set email = $1 "
                                  "where contact_id = $2");
    TSQLStatement* stmt = db_server->Statement(sql);
 
    stmt->NextIteration();
    if (email == nullptr)
        stmt->SetNull(0);
    else
        stmt->SetString(0, *email);
    stmt->SetInt(1, i_contact_id);
 
    // write new value to the database
    if (!stmt->Process()) {
        cout << "ERROR: updating information about contact has been failed" << endl;
 
        delete stmt;
        return -2;
    }
 
    if (str_email)
        delete str_email;
    if (email == nullptr)
        str_email = nullptr;
    else
        str_email = new TString(*email);
 
    delete stmt;
    return 0;
}
 
// -----  Print current contact  ---------------------------------------
void ElogContact::Print()
{
    cout << "Table 'contact_'";
    cout << ". contact_id: " << i_contact_id
         << ". contact_name: " << (str_contact_name == nullptr ? "nullptr" : *str_contact_name)
         << ". contact_desc: " << str_contact_desc << ". phones: " << (str_phones == nullptr ? "nullptr" : *str_phones)
         << ". email: " << (str_email == nullptr ? "nullptr" : *str_email) << endl;
 
    return;
}
/* END OF GENERATED CLASS PART (SHOULD NOT BE CHANGED MANUALLY) */