src/examples/occi_datatypes.cpp

Go to the documentation of this file.

#include <QApplication>
#include <QtSql>

#include <iostream>
using namespace std;

/* Change these to match your database */
#define HOST   "127.0.0.1"
#define DB     "xe"
#define PORT   1521
#define USER   "testbed"
#define PASSWD "secret"

const char create_sql[] = 
    "create table occi_datatype_example_tb ( \
        name       varchar(25), \
        age        number, \
        letter     char(2), \
        some_date  date, \
        some_time  timestamp, \
        bin_data   blob)";
 
// standard insert
const char insert_sql_1[] = 
    "insert into occi_datatype_example_tb \
    (name, age, letter, some_date, some_time) \
    values \
    ('foobar', 25, 'jg', sysdate, sysdate)";

// use bindings...
const char insert_sql_2[] = 
    "insert into occi_datatype_example_tb \
    (name, age, letter, some_date, some_time, bin_data) \
    values \
    (:1, :2, :3, :4, :5, :6)";

const char select_sql[] = 
    "select name, age, letter, some_date, some_time, bin_data \
    from occi_datatype_example_tb \
    where name = 'joe'";
    
const char random_data[] = {43, 242, 13, 01, 00, 123, 2, 4};

int main(int argc, char *argv[])
{
    QApplication app(argc, argv);
 
    QSqlDatabase qDB = QSqlDatabase::addDatabase("QOpenOCCI");
    
    qDB.setHostName(HOST);
    qDB.setDatabaseName(DB);
    qDB.setPort(PORT);
    qDB.setUserName(USER);
    qDB.setPassword(PASSWD);
    
    /* Probably overkill ;) */
    qDB.setConnectOptions("Prefetch_Memory=5242880;Prefetch_Rows=250");
    
    if (qDB.open() == FALSE) {
        cerr << "Error: opening DB failed because " << qDB.lastError().text().toStdString() << endl;
        return -1;
    }

    QSqlQuery query(qDB);
    
    // drop the old table and we don't care if it fails..
    query.exec("drop table occi_datatype_example_tb");
    
    if (query.exec(create_sql) == FALSE) {
        cerr << "Error: query failed because " << query.lastError().text().toStdString() << endl;
        return -1;
    }
    
    if (query.exec(insert_sql_1) == FALSE) {
        cerr << "Error: query failed because " << query.lastError().text().toStdString() << endl;
        return -1;
    }
    
    if (query.prepare(insert_sql_2) == FALSE) {
        cerr << "Error: prepare failed because " << query.lastError().text().toStdString() << endl;
        return -1;
    }
    
    query.addBindValue(QString("joe"));
    query.addBindValue(13);
    query.addBindValue(QString("bo"));
    query.addBindValue(QDate(2008, 02, 16));
    query.addBindValue(QDateTime(QDate(2008, 01, 01), QTime(12, 00, 00)));
    query.addBindValue(QByteArray(random_data, 8));
    
    if (query.exec() == FALSE) {
        cerr << "Error: exec failed because " << query.lastError().text().toStdString() << endl;
        return -1;
    }
    
    if (query.exec(select_sql) == FALSE) {
        cerr << "Error: query failed because " << query.lastError().text().toStdString() << endl;
        return -1;
    }    
    
    while (query.next()) {
        cout << "Name: " << query.value(0).toString().toStdString() << endl;
        cout << "Age: " << query.value(1).toInt() << endl;
        cout << "Code: " << query.value(2).toString().toStdString() << endl;
        cout << "Date: " << query.value(3).toDate().toString(Qt::TextDate).toStdString() << endl;
        cout << "Time: " << query.value(4).toDateTime().toString(Qt::TextDate).toStdString() << endl;
        // cast the data as two ints and print out their value in hex 
        cout << "Data: " << hex <<  ((int*)(query.value(5).toByteArray().data()))[0] << ((int*)(query.value(5).toByteArray().data()))[1] << endl;
    }
    return 0;
}

---