DL Process Control applications - database connectivity and build process.

Note on the C++ binaries and the database connectivity.

Build Process

The binaries reside in /pcli/run

with the source in /app/src

Additionally, there are other source files in /pcli/src/ such as for logview.

To compile the source;

1. run make in /app/src/appname
2. then kill the current appname using monit stop appname
3. then copy the new binary from /app/bin/appname/ to /pcli/bin/appname/
4. finally start the app with monit start appname

---

Database configuration (and other things in) /pcli/conf/system.ini

I believe in the application the database  details are read in by the following (example);

 //=================================
    // Collect any parameters from the|
    // system config file             |
    //=================================
    CSimpleIniA ini(true, true, true);
    SI_Error rc = ini.LoadFile("/pcli/conf/system.ini");



with database settings as per the example below;

//====================
    // Database settings |
    //====================
    DB.set_db("DB-MAIN");
    DB.set_debug(0);
    DB.connect(SYSVAR->SYS_ONLINE);

    DBMCC.set_db("DB-MCC");
    DBMCC.set_debug(0);
    DBMCC.connect(SYSVAR->SYS_ONLINE);

    DBFCC.set_db("DB-MF-MQ-LINK");
    DBFCC.set_debug(0);
    DBFCC.connect(SYSVAR->SYS_ONLINE);


Where DB-MAIN refers to the information in system.ini

The query is built as per the example below;

sprintf(sql, "select id,msg_doe from fec.mes_7600 where processed=0 order by id limit 1");

OR

sql << "update fec.mes_7600 set processed=1 where id='" << id << "'" << endl;

With the database actions being similar to the example below;

DB.select(SYSVAR->SYS_ONLINE, &sql, &res);

OR

DB.execute(SYSVAR->SYS_ONLINE, &sql);