/*
* Create our database using the appropriate schema.
*/
bool DBHandler::dbCreateInstance()
{
QMutexLocker locker(&dbMutex);
int error = 0; // Number of SQL queries
QSqlQuery query(db);
if (db.isOpen())
{
qDebug() << "Creating Tables";
QString address_book_create = "CREATE TABLE address_book (id INTEGER PRIMARY KEY, nym_id TEXT, nym_display_name TEXT)";
// --------------------------------------------
QString default_nym_create = "CREATE TABLE default_nym (default_id INTEGER PRIMARY KEY, nym TEXT)";
QString default_server_create = "CREATE TABLE default_server (default_id INTEGER PRIMARY KEY, server TEXT)";
QString default_asset_create = "CREATE TABLE default_asset (default_id INTEGER PRIMARY KEY, asset TEXT)";
QString default_account_create = "CREATE TABLE default_account (default_id INTEGER PRIMARY KEY, account TEXT)";
QString settings = "CREATE TABLE settings (setting TEXT PRIMARY KEY, parameter1 TEXT)";
// --------------------------------------------
QString create_contact = "CREATE TABLE contact(contact_id INTEGER PRIMARY KEY, contact_display_name TEXT)";
QString create_nym = "CREATE TABLE nym(nym_id TEXT PRIMARY KEY, contact_id INTEGER, nym_display_name)";
QString create_server = "CREATE TABLE nym_server(nym_id TEXT, server_id TEXT, PRIMARY KEY(nym_id, server_id))";
QString create_account = "CREATE TABLE nym_account(account_id TEXT PRIMARY KEY, server_id TEXT, nym_id TEXT, asset_id TEXT, account_display_name TEXT)";
// --------------------------------------------
error += query.exec(address_book_create);
error += query.exec(default_nym_create);
error += query.exec(default_server_create);
error += query.exec(default_asset_create);
error += query.exec(default_account_create);
error += query.exec(settings);
// --------------------------------------------
error += query.exec(create_contact);
error += query.exec(create_nym);
error += query.exec(create_server);
error += query.exec(create_account);
// ------------------------------------------
if(error != 10) //every querie passed?
{
qDebug() << "dbCreateInstance Error: " << dbConnectErrorStr + " " + dbCreationStr;
FileHandler rm;
db.close();
rm.removeFile(QString(OTPaths::AppDataFolder().Get()) + dbFileNameStr);
// rm.removeFile(QCoreApplication::applicationDirPath() + dbFileNameStr);
}
else
qDebug() << "Database " + dbFileNameStr + " created.";
}
return error;
}
void
TFileHandler::removeFile () {
FileHandler fh;
QVERIFY (fh.removeFile(tFilename) == true);
}
/*
* Create our database using the appropriate schema.
*/
bool DBHandler::dbCreateInstance()
{
QMutexLocker locker(&dbMutex);
int error = 0; // Number of SQL queries
QSqlQuery query(db);
if (db.isOpen())
{
qDebug() << "Creating Tables";
QString address_book_create = "CREATE TABLE address_book (id INTEGER PRIMARY KEY, nym_id TEXT, nym_display_name TEXT)";
// --------------------------------------------
QString default_nym_create = "CREATE TABLE default_nym (default_id INTEGER PRIMARY KEY, nym TEXT)";
QString default_server_create = "CREATE TABLE default_server (default_id INTEGER PRIMARY KEY, server TEXT)";
QString default_asset_create = "CREATE TABLE default_asset (default_id INTEGER PRIMARY KEY, asset TEXT)";
QString default_account_create = "CREATE TABLE default_account (default_id INTEGER PRIMARY KEY, account TEXT)";
QString settings = "CREATE TABLE settings (setting TEXT PRIMARY KEY, parameter1 TEXT)";
// --------------------------------------------
QString create_contact = "CREATE TABLE contact(contact_id INTEGER PRIMARY KEY, contact_display_name TEXT)";
QString create_nym = "CREATE TABLE nym(nym_id TEXT PRIMARY KEY, contact_id INTEGER, nym_display_name TEXT)";
QString create_server = "CREATE TABLE nym_server(nym_id TEXT, server_id TEXT, PRIMARY KEY(nym_id, server_id))";
QString create_account = "CREATE TABLE nym_account(account_id TEXT PRIMARY KEY, server_id TEXT, nym_id TEXT, asset_id TEXT, account_display_name TEXT)";
// --------------------------------------------
QString create_msg_method = "CREATE TABLE msg_method"
" (method_id INTEGER PRIMARY KEY," // 1, 2, etc.
" method_display_name TEXT," // "Localhost"
" method_type TEXT," // "bitmessage"
" method_type_display TEXT," // "Bitmessage"
" method_connect TEXT)"; // "http://*****:*****@http://127.0.0.1:8332/"
// --------------------------------------------
// Messaging methods set for various nyms or contacts.
//
QString create_nym_method = "CREATE TABLE nym_method(nym_id TEXT, method_id INTEGER, address TEXT, PRIMARY KEY(nym_id, method_id, address))";
QString create_contact_method = "CREATE TABLE contact_method(contact_id INTEGER, method_type TEXT, address TEXT, PRIMARY KEY(contact_id, method_type, address))";
// --------------------------------------------
/* Keep track of Namecoin names registered for the purpose of
OTX. They are always related to a Nym and credential
hash, so those are kept here, too, so we can easily find
corresponding names (although the name itself depends on the
credential hash). 'active' is true if the name registration
process has been finished; if not, 'regData' contains the
JSON string describing the nmcrpc::NameRegistration object
of the ongoing registration. 'updateTx' contains the
transaction ID of the last name_update that has been issued,
mainly to keep track of still unconfirmed update transactions
(after the first confirmation, we can find it via the name). */
QString create_nmc = "CREATE TABLE nmc_names"
" (name TEXT PRIMARY KEY,"
" nym TEXT,"
" cred TEXT,"
" active BOOLEAN,"
" regData TEXT,"
" updateTx TEXT)";
// --------------------------------------------
error += query.exec(address_book_create);
error += query.exec(default_nym_create);
error += query.exec(default_server_create);
error += query.exec(default_asset_create);
error += query.exec(default_account_create);
error += query.exec(settings);
// --------------------------------------------
error += query.exec(create_contact);
error += query.exec(create_nym);
error += query.exec(create_server);
error += query.exec(create_account);
// ------------------------------------------
error += query.exec(create_msg_method);
error += query.exec(create_nym_method);
error += query.exec(create_contact_method);
// ------------------------------------------
error += query.exec(create_nmc);
// ------------------------------------------
if(error != 14) //every query passed?
{
qDebug() << "dbCreateInstance Error: " << dbConnectErrorStr + " " + dbCreationStr;
FileHandler rm;
db.close();
rm.removeFile(QString(OTPaths::AppDataFolder().Get()) + dbFileNameStr);
// rm.removeFile(QCoreApplication::applicationDirPath() + dbFileNameStr);
}
else
qDebug() << "Database " + dbFileNameStr + " created.";
}
return error;
}
