int main() {
try {
DBI::DatabaseAttributes attr;
auto dbh = new DBI::SQLiteDatabaseHandle();
dbh->Connect("test.db", "", "", "", attr);
if (!dbh) {
PrintErr("Failure to connect.");
return 1;
}
dbh->Do("DROP TABLE IF EXISTS db_test");
dbh->Do("CREATE TABLE db_test ("
"id INTEGER,"
"int_value INTEGER,"
"real_value REAL,"
"text_value TEXT,"
"blob_value BLOB)");
dbh->Ping();
dbh->Begin();
auto rs = dbh->Do("INSERT INTO db_test (id, int_value, real_value, text_value, blob_value) VALUES(?, ?, ?, ?, ?)",
1,
nullptr,
nullptr,
nullptr,
nullptr);
if (rs->AffectedRows() != 1) {
PrintErr("Failure to insert value");
return 1;
}
std::string blob_value;
blob_value.assign("hello\0world\0", 12);
rs = dbh->Do("INSERT INTO db_test (id, int_value, real_value, text_value, blob_value) VALUES(?, ?, ?, ?, ?)",
2,
(uint8_t)5,
(float)125.90,
std::string("A test value"),
blob_value);
if (rs->AffectedRows() != 1) {
PrintErr("Failure to insert value");
return 1;
}
rs = dbh->Do("INSERT INTO db_test (id, int_value, real_value, text_value, blob_value) VALUES(?, ?, ?, ?, ?)",
3,
(uint16_t)556,
(double)125.90,
nullptr,
nullptr);
if (rs->AffectedRows() != 1) {
PrintErr("Failure to insert value");
return 1;
}
rs = dbh->Do("INSERT INTO db_test (id, int_value, real_value, text_value, blob_value) VALUES(?, ?, ?, ?, ?)",
4,
(uint32_t)518012,
nullptr,
nullptr,
nullptr);
if (rs->AffectedRows() != 1) {
PrintErr("Failure to insert value");
return 1;
}
rs = dbh->Do("INSERT INTO db_test (id, int_value, real_value, text_value, blob_value) VALUES(?, ?, ?, ?, ?)",
5,
(uint64_t)42949672960,
nullptr,
nullptr,
nullptr);
if (rs->AffectedRows() != 1) {
PrintErr("Failure to insert value");
return 1;
}
dbh->Commit();
auto sth = dbh->Prepare("INSERT INTO db_test (id, int_value, real_value, text_value, blob_value) VALUES(?, ?, ?, ?, ?)");
rs = sth->Execute(6, 2134, 125.9, std::string("Test value"), blob_value);
if(rs->AffectedRows() != 1) {
PrintErr("Failure to insert value");
return 1;
}
sth = dbh->Prepare("SELECT int_value, real_value, text_value, blob_value FROM db_test WHERE id = ?");
rs = sth->Execute(1);
if(rs->AffectedRows() != 1) {
PrintErr("Failure to select value");
return 1;
}
auto row = (*rs->Rows().begin());
if(!row["int_value"].is_null) {
PrintErr("Row int_value was incorrect value in row 1");
return 1;
}
if(!row["real_value"].is_null) {
PrintErr("Row real_value was incorrect value in row 1");
return 1;
}
if(!row["text_value"].is_null) {
PrintErr("Row text_value was incorrect value in row 1");
return 1;
}
if(!row["blob_value"].is_null) {
PrintErr("Row blob_value was incorrect value in row 1");
return 1;
}
rs = sth->Execute(2);
if(rs->AffectedRows() != 1) {
PrintErr("Failure to select value");
return 1;
}
row = (*rs->Rows().begin());
if(row["int_value"].is_null) {
PrintErr("Row int_value was incorrect value in row 2");
return 1;
} else {
uint64_t val = std::stoll(row["int_value"].value);
if(val != 5) {
PrintErr("Row int_value was incorrect value in row 2");
return 1;
}
}
if(row["real_value"].is_null) {
PrintErr("Row real_value was incorrect value in row 2");
return 1;
} else {
double val = std::stod(row["real_value"].value);
if(val > 126.0 || val < 125.8) {
PrintErr("Row real_value was incorrect value in row 2");
return 1;
}
}
if(row["text_value"].is_null) {
PrintErr("Row text_value was incorrect value in row 2");
return 1;
} else {
if(row["text_value"].value.compare("A test value") != 0) {
PrintErr("Row text_value was incorrect value in row 2");
return 1;
}
}
if(row["blob_value"].is_null) {
PrintErr("Row blob_value was incorrect value in row 2");
return 1;
} else {
if(row["blob_value"].value.length() != 12) {
PrintErr("Row blob_value was incorrect length in row 2");
return 1;
}
if(memcmp(row["blob_value"].value.c_str(), "hello\0world\0", 12) != 0) {
PrintErr("Row blob_value was incorrect value in row 2");
return 1;
}
}
rs = sth->Execute(3);
if(rs->AffectedRows() != 1) {
PrintErr("Failure to select value");
return 1;
}
row = (*rs->Rows().begin());
if(row["int_value"].is_null) {
PrintErr("Row int_value was incorrect value in row 3");
return 1;
} else {
uint64_t val = std::stoll(row["int_value"].value);
if(val != 556) {
PrintErr("Row int_value was incorrect value in row 3");
return 1;
}
}
if(row["real_value"].is_null) {
PrintErr("Row real_value was incorrect value in row 3");
return 1;
} else {
double val = std::stod(row["real_value"].value);
if(val > 126.0 || val < 125.8) {
PrintErr("Row real_value was incorrect value in row 3");
return 1;
}
}
if(!row["text_value"].is_null) {
PrintErr("Row text_value was incorrect value in row 3");
return 1;
}
if(!row["blob_value"].is_null) {
PrintErr("Row blob_value was incorrect value in row 3");
return 1;
}
rs = sth->Execute(4);
if(rs->AffectedRows() != 1) {
PrintErr("Failure to select value");
return 1;
}
row = (*rs->Rows().begin());
if(row["int_value"].is_null) {
PrintErr("Row int_value was incorrect value in row 4");
return 1;
} else {
uint64_t val = std::stoll(row["int_value"].value);
if(val != 518012) {
PrintErr("Row int_value was incorrect value in row 4");
return 1;
}
}
if(!row["real_value"].is_null) {
PrintErr("Row real_value was incorrect value in row 4");
return 1;
}
if(!row["text_value"].is_null) {
PrintErr("Row text_value was incorrect value in row 4");
return 1;
}
if(!row["blob_value"].is_null) {
PrintErr("Row blob_value was incorrect value in row 4");
return 1;
}
rs = sth->Execute(5);
if(rs->AffectedRows() != 1) {
PrintErr("Failure to select value");
return 1;
}
row = (*rs->Rows().begin());
if(row["int_value"].is_null) {
PrintErr("Row int_value was incorrect value in row 5");
return 1;
} else {
uint64_t val = std::stoll(row["int_value"].value);
if(val != 42949672960) {
PrintErr("Row int_value was incorrect value in row 5");
return 1;
}
}
if(!row["real_value"].is_null) {
PrintErr("Row real_value was incorrect value in row 5");
return 1;
}
if(!row["text_value"].is_null) {
PrintErr("Row text_value was incorrect value in row 5");
return 1;
}
if(!row["blob_value"].is_null) {
PrintErr("Row blob_value was incorrect value in row 5");
return 1;
}
rs = sth->Execute(6);
if(rs->AffectedRows() != 1) {
PrintErr("Failure to select value");
return 1;
}
row = (*rs->Rows().begin());
if(row["int_value"].is_null) {
PrintErr("Row int_value was incorrect value in row 6");
return 1;
} else {
uint64_t val = std::stoll(row["int_value"].value);
if(val != 2134) {
PrintErr("Row int_value was incorrect value in row 6");
return 1;
}
}
if(row["real_value"].is_null) {
PrintErr("Row real_value was incorrect value in row 6");
return 1;
} else {
double val = std::stod(row["real_value"].value);
if(val > 126.0 || val < 125.8) {
PrintErr("Row real_value was incorrect value in row 6");
return 1;
}
}
if(row["text_value"].is_null) {
PrintErr("Row text_value was incorrect value in row 6");
return 1;
} else {
if(row["text_value"].value.compare("Test value") != 0) {
PrintErr("Row text_value was incorrect value in row 6");
return 1;
}
}
if(row["blob_value"].is_null) {
PrintErr("Row blob_value was incorrect value in row 6");
return 1;
} else {
if(row["blob_value"].value.length() != 12) {
PrintErr("Row blob_value was incorrect length in row 6");
return 1;
}
if(memcmp(row["blob_value"].value.c_str(), "hello\0world\0", 12) != 0) {
PrintErr("Row blob_value was incorrect value in row 6");
return 1;
}
}
}
catch (std::exception &ex) {
printf("Tests failed with message: %s", ex.what());
return 1;
}
printf("Tests passed");
return 0;
}
ByteArray ConnectorMySQL::Delete(const ByteArray &command, ErrorCode &error_code)
{
return AffectedRows(command, error_code);
}