예제 #1
0
Sqlite::Sqlite() {
	dbHandle = NULL;
	int out;
	sqlite3_config(SQLITE_CONFIG_URI, 1);
	std::string sqlString;
	std::string dbFile;
	dbFile = "file:";
	dbFile.append(getenv("HOME"));
	dbFile.append("/files.db");
	out = sqlite3_open_v2(dbFile.c_str(), &dbHandle, SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE | SQLITE_OPEN_FULLMUTEX, NULL);
	if (out != SQLITE_OK || dbHandle == NULL) {
		std::cerr << "(" << __FILE__ << ":" << __LINE__ << ") " << out << dbFile.c_str() << " - " << sqlite3_errmsg(dbHandle) << std::endl;
	}
	initialiseDatabase();

	sqlString = "INSERT INTO gpsdata (time,latitude,longitude,altitude,heading) "
			"VALUES (?,?,?,?,?);";
	out = sqlite3_prepare_v2(dbHandle, sqlString.c_str(), sqlString.length(), &insert, NULL);
	if (out != SQLITE_OK) {
		std::cerr << "(" << __FILE__ << ":" << __LINE__ << ") " << out << " - " << sqlite3_errmsg(dbHandle) << std::endl;
	}
	sqlString = "SELECT * FROM gpsdata "
			"WHERE pkey IS ?;";
	out = sqlite3_prepare_v2(dbHandle, sqlString.c_str(), sqlString.length(), &query, NULL);
	if (out != SQLITE_OK) {
		std::cerr << "(" << __FILE__ << ":" << __LINE__ << ") " << out << " - " << sqlite3_errmsg(dbHandle) << std::endl;
	}
	// TODO Auto-generated constructor stub

}
예제 #2
0
void tst_QDjangoWhere::initTestCase()
{
    QVERIFY(initialiseDatabase());
}
예제 #3
0
void tst_QDjango::initTestCase()
{
    QCOMPARE(QDjango::database().isOpen(), false);
    QVERIFY(initialiseDatabase());
    QCOMPARE(QDjango::database().isOpen(), true);
}
예제 #4
0
void tst_QDjangoMetaModel::initTestCase()
{
    QVERIFY(initialiseDatabase());
}