@Test public void testDatesAndTimes() throws IOException, SQLException { final int TOTAL_RECORDS = 10; ColumnGenerator genDate = getDateColumnGenerator(); ColumnGenerator genTime = getTimeColumnGenerator(); createTextFile(0, TOTAL_RECORDS, false, genDate, genTime); createTable(genDate, genTime); runExport(getArgv(true, 10, 10)); verifyExport(TOTAL_RECORDS); assertColMinAndMax(forIdx(0), genDate); assertColMinAndMax(forIdx(1), genTime); }
assertColMinAndMax(forIdx(0), gen0); assertColMinAndMax(forIdx(2), gen2); assertColMinAndMax(forIdx(1), genNull);
runExport(getArgv(true, 10, 10)); verifyExport(TOTAL_RECORDS); assertColMinAndMax(forIdx(0), genFloat); assertColMinAndMax(forIdx(1), genNumeric);
runExport(getArgv(true, 10, 10)); verifyExport(TOTAL_RECORDS); assertColMinAndMax(forIdx(0), genInteger); assertColMinAndMax(forIdx(1), genNull);
assertColMinAndMax(forIdx(0), genString); assertColMinAndMax(forIdx(1), genNull);
@Test public void testIntCol() throws IOException, SQLException { final int TOTAL_RECORDS = 10; // generate a column equivalent to rownum. ColumnGenerator gen = new ColumnGenerator() { public String getExportText(int rowNum) { return "" + rowNum; } public String getVerifyText(int rowNum) { return "" + rowNum; } public String getType() { return "INTEGER"; } }; createTextFile(0, TOTAL_RECORDS, false, gen); createTable(gen); runExport(getArgv(true, 10, 10)); verifyExport(TOTAL_RECORDS); assertColMinAndMax(forIdx(0), gen); }
runExport(getArgv(true, 10, 10, "--input-null-non-string", "INT_NULL")); verifyExport(TOTAL_RECORDS * 2); assertColMinAndMax(forIdx(0), genInt); assertColMinAndMax(forIdx(1), new NullColumnGenerator());
@Test public void testBigIntCol() throws IOException, SQLException { final int TOTAL_RECORDS = 10; // generate a column that won't fit in a normal int. ColumnGenerator gen = new ColumnGenerator() { public String getExportText(int rowNum) { long val = (long) rowNum * 1000000000; return "" + val; } public String getVerifyText(int rowNum) { long val = (long) rowNum * 1000000000; return "" + val; } public String getType() { return getBigIntType(); } }; createTextFile(0, TOTAL_RECORDS, false, gen); createTable(gen); runExport(getArgv(true, 10, 10)); verifyExport(TOTAL_RECORDS); assertColMinAndMax(forIdx(0), gen); }