コード例 #1
0
 // @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);
 }
コード例 #2
0
  @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();
  }
コード例 #3
0
 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();
 }
コード例 #4
0
  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;
  }