Ejemplo n.º 1
0
  @Override
  @SuppressWarnings("ValueOfIncrementOrDecrementUsed")
  protected void fill(final PreparedStatement pstm, final Pou item, final boolean update)
      throws SQLException {
    final PreparedStatementEx pstmEx = new PreparedStatementEx(pstm);
    int index = 1;
    pstm.setString(index++, item.getNazev());
    pstmEx.setBoolean(index++, item.getNespravny());
    pstm.setInt(index++, item.getOrpKod());
    pstm.setInt(index++, item.getSpravniObecKod());
    pstm.setLong(index++, item.getIdTransRuian());
    pstmEx.setDate(index++, item.getPlatiOd());
    pstm.setLong(index++, item.getNzIdGlobalni());
    pstmEx.setBoolean(index++, item.getZmenaGrafiky());

    if (!Config.isNoGis()) {
      pstm.setString(index++, item.getDefinicniBod());
      pstm.setString(index++, item.getHranice());
    }

    pstm.setInt(index++, item.getKod());

    if (update) {
      pstmEx.setLong(index++, item.getIdTransRuian());
    }
  }
Ejemplo n.º 2
0
  /**
   * Runs SQL statements from specified resource.
   *
   * @param con database connection
   * @param resourceName name of the resource from which to read the SQL statements
   */
  private static void runSQLFromResource(final Connection con, final String resourceName) {
    if (Config.isDryRun()) {
      return;
    }

    final StringBuilder sbSQL = new StringBuilder(10_240);

    try (final BufferedReader reader =
            new BufferedReader(
                new InputStreamReader(
                    MainConvertor.class.getResourceAsStream(resourceName), "UTF-8"));
        final Statement stm = con.createStatement()) {
      String line = reader.readLine();

      while (line != null) {
        sbSQL.append(line);

        if (line.endsWith(";")) {
          stm.execute(sbSQL.toString());
          sbSQL.setLength(0);
        } else {
          sbSQL.append('\n');
        }

        line = reader.readLine();
      }
    } catch (final SQLException ex) {
      throw new RuntimeException("Statement failed: " + sbSQL.toString(), ex);
    } catch (final IOException ex) {
      throw new RuntimeException("Failed to read SQL statements from resource", ex);
    }
  }
Ejemplo n.º 3
0
  /**
   * Converts all files with .xml.gz and .xml extensions from specified directory into database.
   *
   * @throws XMLStreamException Thrown if problem occurred while reading XML stream.
   * @throws SQLException Thrown if problem occurred while communicating with database.
   */
  public static void convert() throws XMLStreamException, SQLException {
    final long startTimestamp = System.currentTimeMillis();

    try (final Connection con = DriverManager.getConnection(Config.getDbConnectionUrl())) {
      exchangeFormatConvertor = new ExchangeFormatConvertor(con);
      specialExchangeFormatConvertor = new SpecialExchangeFormatConvertor(con);

      con.setAutoCommit(false);

      if (Config.isCreateTables()) {
        Log.write("Recreating tables...");

        if (Config.isNoGis() || Config.isMysqlDriver()) {
          if (Config.isMysqlDriver()) {
            runSQLFromResource(con, "/sql/schema_no_gis_mysql_tbl.sql");
          } else {
            runSQLFromResource(con, "/sql/schema_no_gis_tbl.sql");
          }
        } else {
          runSQLFromResource(con, "/sql/schema_tbl.sql");
        }
      }

      if (!Config.isNoGis() && !Config.isMysqlDriver()) {
        Log.write("Recreating RÚIAN statistics views...");
        runSQLFromResource(con, "/sql/ruian_stats.sql");
        runSQLFromResource(con, "/sql/ruian_stats_full.sql");
      }

      if (Config.isTruncateAll()) {
        Log.write("Truncating all data tables...");
        runSQLFromResource(con, "/sql/truncate_all.sql");
      }

      if (Config.isResetTransactionIds()) {
        Log.write("Resetting transaction ids...");
        runSQLFromResource(con, "/sql/reset_transaction_ids.sql");
      }

      if (!Config.isNoGis()
          && !Config.isMysqlDriver()
          && !Config.isConvertToEWKT()
          && GMLUtils.checkMultipointBug(con)) {
        Log.write(
            "Installed version of Postgis is affected by "
                + "multipoint bug "
                + "http://trac.osgeo.org/postgis/ticket/1928, enabling "
                + "workaround...");
        GMLUtils.setMultipointBugWorkaround(true);
      }

      con.commit();

      for (final Path file : getInputFiles(Config.getInputDirPath())) {
        processFile(file);
        con.commit();
      }

      if (Config.isCreateTables()) {
        Log.write("Creating indexes...");

        if (Config.isNoGis() || Config.isMysqlDriver()) {
          if (Config.isMysqlDriver()) {
            runSQLFromResource(con, "/sql/schema_no_gis_mysql_idx.sql");
          } else {
            runSQLFromResource(con, "/sql/schema_no_gis_idx.sql");
          }
        } else {
          runSQLFromResource(con, "/sql/schema_idx.sql");
        }
      }

      Log.write("Total duration: " + (System.currentTimeMillis() - startTimestamp) + " ms");
    }
  }