private void testWithResult(String query, Object... expectedResult) throws Exception { TestBuilder builder = testBuilder() .sqlQuery(query) .ordered() .baselineColumns("columns"); for (Object o : expectedResult) { builder = builder.baselineValues(o); } builder.build().run(); }
@Test public void testTextHeader() throws Exception { String headerTableName = genCSVTable("testTextHeader", "b|a", "b|0", "b|1"); testWithResult(format("select columns from table(%s(type => 'TeXT', fieldDelimiter => '|', skipFirstLine => true))", headerTableName), listOf("b", "0"), listOf("b", "1") ); testBuilder() .sqlQuery(format("select a, b from table(%s(type => 'TeXT', fieldDelimiter => '|', extractHeader => true))", headerTableName)) .ordered() .baselineColumns("b", "a") .baselineValues("b", "0") .baselineValues("b", "1") .build().run(); }
"select count(*) as cnt from table(%s(type => 'TeXT', fieldDelimiter => '|', extractHeader => true))", headerTableName); testBuilder() .sqlQuery(query) .ordered() "select count(*) as cnt from table(%s(type => 'TeXT', fieldDelimiter => '|', extractHeader => false))", headerTableName); testBuilder() .sqlQuery(query) .ordered() "select count(*) as cnt from table(%s(type => 'TeXT', fieldDelimiter => '|', skipFirstLine => true))", headerTableName); testBuilder() .sqlQuery(query) .ordered() " extractHeader => true))", headerTableName); testBuilder() .sqlQuery(query) .ordered()