@Test public void testBuildSqlWithOrderbyId() { PrimaryKeyDesc primaryKeyDesc = new PrimaryKeyDesc(); primaryKeyDesc.addColumnName("ID1"); primaryKeyDesc.addColumnName("ID2"); TableDesc tableDesc = new TableDesc(); tableDesc.setCatalogName("AAA"); tableDesc.setSchemaName("BBB"); tableDesc.setName("HOGE"); tableDesc.setPrimaryKeyDesc(primaryKeyDesc); assertEquals("select * from AAA.BBB.HOGE order by ID1, ID2", dumper .buildSqlWithSort(tableDesc)); }
protected String buildSqlWithSort(TableDesc tableDesc) { StringBuilder buf = new StringBuilder(); buf.append("select * from "); buf.append(tableDesc.getFullName()); if (tableDesc.getPrimaryKeyDesc() != null) { List<String> pkColumnNameList = tableDesc.getPrimaryKeyDesc() .getColumnNameList(); if (pkColumnNameList.size() > 0) { buf.append(" order by "); for (String columnName : pkColumnNameList) { buf.append(columnName); buf.append(", "); } buf.setLength(buf.length() - 2); } } return buf.toString(); }
DumperImpl implements Dumper { protected String buildSqlWithSort(TableDesc tableDesc) { StringBuilder buf = new StringBuilder(); buf.append("select * from "); buf.append(tableDesc.getFullName()); if (tableDesc.getPrimaryKeyDesc() != null) { List<String> pkColumnNameList = tableDesc.getPrimaryKeyDesc() .getColumnNameList(); if (pkColumnNameList.size() > 0) { buf.append(" order by "); for (String columnName : pkColumnNameList) { buf.append(columnName); buf.append(", "); } buf.setLength(buf.length() - 2); } } return buf.toString(); } }
DumperImpl implements Dumper { protected String buildSqlWithSort(TableDesc tableDesc) { StringBuilder buf = new StringBuilder(); buf.append("select * from "); buf.append(tableDesc.getFullName()); if (tableDesc.getPrimaryKeyDesc() != null) { List<String> pkColumnNameList = tableDesc.getPrimaryKeyDesc() .getColumnNameList(); if (pkColumnNameList.size() > 0) { buf.append(" order by "); for (String columnName : pkColumnNameList) { buf.append(columnName); buf.append(", "); } buf.setLength(buf.length() - 2); } } return buf.toString(); } DumperImpl(GenDialect dialect, String dumpFileEncoding); }
DumperImpl implements Dumper { protected String buildSqlWithSort(TableDesc tableDesc) { StringBuilder buf = new StringBuilder(); buf.append("select * from "); buf.append(tableDesc.getFullName()); if (tableDesc.getPrimaryKeyDesc() != null) { List<String> pkColumnNameList = tableDesc.getPrimaryKeyDesc() .getColumnNameList(); if (pkColumnNameList.size() > 0) { buf.append(" order by "); for (String columnName : pkColumnNameList) { buf.append(columnName); buf.append(", "); } buf.setLength(buf.length() - 2); } } return buf.toString(); } DumperImpl(GenDialect dialect, String dumpFileEncoding); void dump(SqlExecutionContext sqlExecutionContext,
            DatabaseDesc databaseDesc, File dumpDir); }
DumperImpl implements Dumper { protected String buildSqlWithSort(TableDesc tableDesc) { StringBuilder buf = new StringBuilder(); buf.append("select * from "); buf.append(tableDesc.getFullName()); if (tableDesc.getPrimaryKeyDesc() != null) { List<String> pkColumnNameList = tableDesc.getPrimaryKeyDesc() .getColumnNameList(); if (pkColumnNameList.size() > 0) { buf.append(" order by "); for (String columnName : pkColumnNameList) { buf.append(columnName); buf.append(", "); } buf.setLength(buf.length() - 2); } } return buf.toString(); } DumperImpl(GenDialect dialect, String dumpFileEncoding); void dump(SqlExecutionContext sqlExecutionContext,
            DatabaseDesc databaseDesc, File dumpDir);  }