Beispiel #1
0
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;
}
Beispiel #2
0
ByteArray ConnectorMySQL::Delete(const ByteArray &command, ErrorCode &error_code)
{
	return AffectedRows(command, error_code);
}