Method createTable

sql/configstore.cpp:53–74

Create the table & set the initial values

// Create the table & set the initial values
//********************************************
void ConfigStore::createTable() {
    QLOG_TRACE() << "Entering ConfigStore::createTable()";

    QLOG_DEBUG() << "Creating table ConfigStore";
    NSqlQuery sql(db);

    db->lockForWrite();
    // build the SQL command & cretae the table
    QString command("Create table if not exists ConfigStore (" +
                  QString("key integer primary key not null unique,") +
                  QString("value blob)"));
    if (!sql.exec(command)) {
        QLOG_ERROR() << "Creation of ConfigStore table failed: " << sql.lastError();
        sql.finish();
        db->unlock();
    } else {
        // insert default values into the new table
        this->initTable();
        sql.finish();
        db->unlock();
    }
}