private static void checkRow(Row row) {
   int id = row.getInt("id");
   String value = row.getString("data");
   String valuePrefix = "rowdata-" + id;
   assertTrue(value.startsWith(valuePrefix));
   assertEquals(valuePrefix.length() + 100, value.length());
 }
Example #2
0
  private static void exportTables(
      Database database, String namesep, String genericOutputPath, String fieldsep, String rowsep) {
    try {
      for (Table table : database) {
        // Prepare the full csv file path, an integer is added if the file already exists
        String outputPath = constructOutputPath(genericOutputPath, namesep, table);
        FileWriter outputFileWriter = new FileWriter(outputPath);
        BufferedWriter outputBufferedWriter = new BufferedWriter(outputFileWriter);

        // Write the column names to the csv file
        ArrayList<String> columns = new ArrayList<String>();
        for (Column column : table.getColumns()) {
          columns.add(column.getName());
        }
        outputBufferedWriter.write(StringUtils.join(columns, fieldsep));
        outputBufferedWriter.write(rowsep);

        // Write the rows to the csv file
        for (Row row : table) {
          outputBufferedWriter.write(StringUtils.join(row.values(), fieldsep));
          outputBufferedWriter.write(rowsep);
        }
        outputBufferedWriter.close();
        outputFileWriter.close();
      }
    } catch (IOException ioe) {
      System.out.println("ERROR: unable to write the csv file to the file system");
      closeDatabase(database);
      System.exit(1);
    }
  }
Example #3
0
 public Discipline(Row disziplin, String ruleNumber) {
   id = (int) disziplin.get("DisziplinID");
   name = (String) disziplin.get("Bezeichnung");
   wertung = (byte) disziplin.get("Wertung");
   schusszahl = (short) disziplin.get("Schusszahl");
   schiesszeit = (short) disziplin.get("Schiesszeit");
   stellungsanzahl = (byte) disziplin.get("Stellungsanzahl");
   probeschuesse = (short) disziplin.get("Probeschuesse");
   probezeit = (short) disziplin.get("Probezeit");
   serienlaenge = (short) disziplin.get("Serienlaenge");
   this.ruleNumber = ruleNumber;
 }