TEST(MySQLTestsBase, load_test) {
hyrise::storage::atable_ptr_t t = Loader::load(
Loader::params().setInput(
MySQLInput(
MySQLInput::params()
.setSchema("information_schema")
.setTable("TABLES")
)
)
);
}
TEST_F(MySQLTests, convert_date_to_int) {
// Load SAP base schema, import KNA1, VBAP, VBAK into MySQL
hyrise::storage::atable_ptr_t t = Loader::load(
Loader::params().setInput(
MySQLInput(
MySQLInput::params()
.setSchema(_schema)
.setTable("VBAK")
)));
ASSERT_EQ(IntegerType, t->typeOfColumn(2));
ASSERT_EQ(IntegerType, t->typeOfColumn(5));
}
TEST_F(MySQLTests, load_sap_schema) {
// Load SAP base schema, import KNA1, VBAP, VBAK into MySQL
std::vector<const char *> tables { "KNA1", "VBAP", "VBAK"};
for(std::string table: tables) {
hyrise::storage::atable_ptr_t t = Loader::load(
Loader::params().setInput(
MySQLInput(
MySQLInput::params()
.setSchema(_schema)
.setTable(table)
)
)
);
ASSERT_EQ(t->size(), 5u) << table << " should have 5 entries";
}
}
void MySQLTableLoad::executePlanOperation() {
StorageManager *sm = StorageManager::getInstance();
storage::atable_ptr_t t;
if (sm->exists(_table_name)) {
t = sm->getTable(_table_name);
addResult(t);
} else {
t = Loader::load(
Loader::params().setInput(
MySQLInput(
MySQLInput::params()
.setSchema(_database_name)
.setTable(_table_name)
.setLimit(_load_limit)
)
));
sm->loadTable(_table_name, t);
addResult(t);
}
}
