/** * @return the name of the staging table to be used for testing. */ public String getStagingTableName() { return getTableName() + "_STAGE"; }
@Override protected String getTableName() { return super.getTableName().toLowerCase(); }
@Override protected String getTableName() { return super.getTableName().toLowerCase(); }
/** * @return an argv for the CodeGenTool to use when creating tables to export. */ protected String [] getCodeGenArgv(String... extraArgs) { List<String> codeGenArgv = new ArrayList<String>(); if (null != extraArgs) { for (String arg : extraArgs) { codeGenArgv.add(arg); } } codeGenArgv.add("--table"); codeGenArgv.add(getTableName()); codeGenArgv.add("--connect"); codeGenArgv.add(getConnectString()); codeGenArgv.add("--fields-terminated-by"); codeGenArgv.add("\\t"); codeGenArgv.add("--lines-terminated-by"); codeGenArgv.add("\\n"); return codeGenArgv.toArray(new String[0]); }
/** Verify that on a given row, a column has a given value. * @param id the id column specifying the row to test. */ private void assertColValForRowId(int id, String colName, String expectedVal) throws SQLException { Connection conn = getConnection(); LOG.info("Verifying column " + colName + " has value " + expectedVal); PreparedStatement statement = conn.prepareStatement( "SELECT \"" + colName + "\" FROM " + getTableName() + " WHERE \"ID\" = " + id, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY); String actualVal = null; try { ResultSet rs = statement.executeQuery(); try { rs.next(); actualVal = rs.getString(1); } finally { rs.close(); } } finally { statement.close(); } assertEquals("Got unexpected column value", expectedVal, actualVal); }
Connection conn = getConnection(); PreparedStatement statement = conn.prepareStatement( getDropTableStatement(getTableName()), ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY); try { sb.append(getTableName()); sb.append(" (\"ID\" INT NOT NULL PRIMARY KEY, \"MSG\" VARCHAR(64)"); int colNum = 0;