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); } }