// @Test
public void exportSmart1() throws Ili2dbException {
File data = new File("test/data/InheritanceSmart1/Inheritance1a-out.xtf");
Config config = initConfig(data.getPath(), DBSCHEMA, data.getPath() + ".log");
config.setDatasetName(DATASETNAME);
config.setFunction(Config.FC_EXPORT);
Ili2db.readSettingsFromDb(config);
Ili2db.run(config, null);
}
@Test
public void importSmart1() throws Exception {
File data = new File("test/data/InheritanceSmart1/Inheritance1a.xtf");
Connection jdbcConnection = null;
try {
Class driverClass = Class.forName("org.postgresql.Driver");
jdbcConnection = DriverManager.getConnection(dburl, dbuser, dbpwd);
Statement stmt = jdbcConnection.createStatement();
stmt.execute("DROP SCHEMA IF EXISTS " + DBSCHEMA + " CASCADE");
Config config = initConfig(data.getPath(), DBSCHEMA, data.getPath() + ".log");
config.setFunction(Config.FC_IMPORT);
config.setCreateFk(Config.CREATE_FK_YES);
config.setInheritanceTrafo(Config.INHERITANCE_TRAFO_SMART1);
config.setDatasetName(DATASETNAME);
config.setTidHandling(Config.TID_HANDLING_PROPERTY);
config.setBasketHandling(Config.BASKET_HANDLING_READWRITE);
config.setCreatescript(data.getPath() + ".sql");
Ili2db.readSettingsFromDb(config);
Ili2db.run(config, null);
Assert.assertTrue(
stmt.execute("SELECT attra3,attra3b FROM " + DBSCHEMA + ".classa3 WHERE t_ili_tid='7'"));
ResultSet rs = stmt.getResultSet();
Assert.assertTrue(rs.next());
Assert.assertEquals("a3", rs.getString(1));
Assert.assertEquals("a3b", rs.getString(2));
} finally {
if (jdbcConnection != null) {
jdbcConnection.close();
}
}
exportSmart1();
}
public void aboutToHidePanel() {
Config config = ((Ili2dbWizard) getWizard()).getIli2dbConfig();
GpkgDbPanel panel = (GpkgDbPanel) getPanelComponent();
config.setDbdatabase(panel.getDbname());
config.setDbhost(panel.getDbhost());
config.setDbport(panel.getDbport());
config.setDbusr(panel.getDbusr());
config.setDbpwd(panel.getDbpwd());
try {
config.setDburl(panel.getDbUrlConverter().makeUrl(config));
Ili2db.readSettingsFromDb(config);
} catch (Ili2dbException e) {
EhiLogger.logError(e);
}
super.aboutToHidePanel();
}
public Config initConfig(String xtfFilename, String dbschema, String logfile) {
Config config = new Config();
new ch.ehi.ili2pg.PgMain().initConfig(config);
config.setDburl(dburl);
config.setDbusr(dbuser);
config.setDbpwd(dbpwd);
if (dbschema != null) {
config.setDbschema(dbschema);
}
if (logfile != null) {
config.setLogfile(logfile);
}
config.setXtffile(xtfFilename);
if (Ili2db.isItfFilename(xtfFilename)) {
config.setItfTransferfile(true);
}
return config;
}