net.sf.farrago.test
Class FarragoSqlTestWrapper

java.lang.Object
  extended by junit.framework.Assert
      extended by junit.framework.TestCase
          extended by org.eigenbase.test.DiffTestCase
              extended by net.sf.farrago.test.ResultSetTestCase
                  extended by net.sf.farrago.test.FarragoTestCase
                      extended by net.sf.farrago.test.FarragoSqlTestWrapper
All Implemented Interfaces:
Test

public class FarragoSqlTestWrapper
extends FarragoTestCase

Wraps .sql file diff-based tests with JUnit test methods for convenient execution from within your favorite JUnit-aware IDE.


Nested Class Summary
 
Nested classes/interfaces inherited from class net.sf.farrago.test.FarragoTestCase
FarragoTestCase.Cleanup, FarragoTestCase.CleanupFactory
 
Field Summary
 
Fields inherited from class net.sf.farrago.test.FarragoTestCase
allocOwner, connection, preparedStmt, repos, stmt, tracer
 
Fields inherited from class net.sf.farrago.test.ResultSetTestCase
resultSet
 
Fields inherited from class org.eigenbase.test.DiffTestCase
logFile, logOutputStream, refFile
 
Constructor Summary
FarragoSqlTestWrapper(String testName)
           
 
Method Summary
protected  void setUp()
           
 void test_unitsql_constraints_misc_sql()
           
 void test_unitsql_constraints_notnull_sql()
           
 void test_unitsql_constraints_unique_sql()
           
 void test_unitsql_ddl_alterTableStruct_sql()
           
 void test_unitsql_ddl_auth_sql()
           
 void test_unitsql_ddl_catalog_sql()
           
 void test_unitsql_ddl_char_sql()
           
 void test_unitsql_ddl_collectionTypes_sql()
           
 void test_unitsql_ddl_datetime_sql()
           
 void test_unitsql_ddl_ddlgen_sql()
           
 void test_unitsql_ddl_decimal_sql()
           
 void test_unitsql_ddl_dependencies_sql()
           
 void test_unitsql_ddl_explain_sql()
           
 void test_unitsql_ddl_jar_sql()
           
 void test_unitsql_ddl_labels_sql()
           
 void test_unitsql_ddl_med_sql()
           
 void test_unitsql_ddl_misc_sql()
           
 void test_unitsql_ddl_params_sql()
           
 void test_unitsql_ddl_privs_sql()
           
 void test_unitsql_ddl_rename_sql()
           
 void test_unitsql_ddl_replace_sql()
           
 void test_unitsql_ddl_replaceView_sql()
           
 void test_unitsql_ddl_row_sql()
           
 void test_unitsql_ddl_sample_sql()
           
 void test_unitsql_ddl_schema_sql()
           
 void test_unitsql_ddl_sequence_sql()
           
 void test_unitsql_ddl_stale_sql()
           
 void test_unitsql_ddl_udf_sql()
           
 void test_unitsql_ddl_udt_sql()
           
 void test_unitsql_ddl_view_sql()
           
 void test_unitsql_expressions_constants_sql()
           
 void test_unitsql_expressions_datatypes_sql()
           
 void test_unitsql_expressions_datetime_sql()
           
 void test_unitsql_expressions_default_sql()
           
 void test_unitsql_expressions_identifiers_sql()
           
 void test_unitsql_expressions_nullable_sql()
           
 void test_unitsql_expressions_orderby_sql()
           
 void test_unitsql_expressions_row_sql()
           
 void test_unitsql_expressions_strCasts_sql()
           
 void test_unitsql_expressions_tablesample_sql()
           
 void test_unitsql_expressions_udfInvocation_sql()
           
 void test_unitsql_expressions_unicode_sql()
           
 void test_unitsql_expressions_values_sql()
           
 void test_unitsql_jdbc_medmetadata_sql()
           
 void test_unitsql_jdbc_metadata_sql()
           
 void test_unitsql_med_csv_sql()
           
 void test_unitsql_med_flatfile_sql()
           
 void test_unitsql_med_loopback_sql()
           
 void test_unitsql_med_mock_sql()
           
 void test_unitsql_optimizer_agg_sql()
           
 void test_unitsql_optimizer_aggDistinct_sql()
           
 void test_unitsql_optimizer_calc_sql()
           
 void test_unitsql_optimizer_cartesian_sql()
           
 void test_unitsql_optimizer_commonRelSubExpr_sql()
           
 void test_unitsql_optimizer_distinct_sql()
           
 void test_unitsql_optimizer_filter_sql()
           
 void test_unitsql_optimizer_hashexe_sql()
           
 void test_unitsql_optimizer_index_sql()
           
 void test_unitsql_optimizer_iterator_sql()
           
 void test_unitsql_optimizer_joinorder_sql()
           
 void test_unitsql_optimizer_joinUsing_sql()
           
 void test_unitsql_optimizer_lbm_sql()
           
 void test_unitsql_optimizer_lcs_sql()
           
 void test_unitsql_optimizer_lcsdelete_sql()
           
 void test_unitsql_optimizer_lcsrid_sql()
           
 void test_unitsql_optimizer_merge_sql()
           
 void test_unitsql_optimizer_mergeNoIndexes_sql()
           
 void test_unitsql_optimizer_mergeOptimizations_sql()
           
 void test_unitsql_optimizer_mergeUniqIndex_sql()
           
 void test_unitsql_optimizer_multiset_sql()
           
 void test_unitsql_optimizer_namespace_sql()
           
 void test_unitsql_optimizer_nestedLoopJoin_sql()
           
 void test_unitsql_optimizer_outerJoin_sql()
           
 void test_unitsql_optimizer_pushfilter_sql()
           
 void test_unitsql_optimizer_pushProject_sql()
           
 void test_unitsql_optimizer_removeSelfJoins_sql()
           
 void test_unitsql_optimizer_reshape_sql()
           
 void test_unitsql_optimizer_residualfilter_sql()
           
 void test_unitsql_optimizer_semijoin_sql()
           
 void test_unitsql_optimizer_setop_sql()
           
 void test_unitsql_optimizer_sort_sql()
           
 void test_unitsql_optimizer_stat_sql()
           
 void test_unitsql_optimizer_statHistograms_sql()
           
 void test_unitsql_optimizer_subquery_sql()
           
 void test_unitsql_optimizer_union_sql()
           
 void test_unitsql_optimizer_unionEliminator_sql()
           
 void test_unitsql_optimizer_update_sql()
           
 void test_unitsql_optimizer_view_sql()
           
 void test_unitsql_sqlline_display_sql()
           
 void test_unitsql_sqlline_incremental_sql()
           
 void test_unitsql_syslib_cancel_sql()
           
 void test_unitsql_syslib_exportImport_sql()
           
 void test_unitsql_syslib_mgmt_sql()
           
 void test_unitsql_syslib_presort_sql()
           
 
Methods inherited from class net.sf.farrago.test.FarragoTestCase
forceShutdown, getJdbcUri, getSession, getTestlogRoot, getTestlogRootStatic, newConnection, newJdbcEngineDriver, restoreParameters, restoreParameters, runCleanup, runSqlLineTest, runSqlLineTest, saveParameters, saveParameters, setRefFileDiffMasks, shouldDiff, staticSetUp, staticTearDown, tearDown, tearDownImpl, wrappedSuite, wrappedSuite
 
Methods inherited from class net.sf.farrago.test.ResultSetTestCase
compareResultList, compareResultLists, compareResultSet, compareResultSetWithDelta, compareResultSetWithPattern, getResultSetCount
 
Methods inherited from class org.eigenbase.test.DiffTestCase
addDiffMask, addIgnorePattern, diffFile, diffLines, diffTestLog, fileContents, openTestLog, openTestLogOutputStream, setGC, setVerbose
 
Methods inherited from class junit.framework.TestCase
countTestCases, createResult, getName, run, run, runBare, runTest, setName, toString
 
Methods inherited from class junit.framework.Assert
assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertFalse, assertFalse, assertNotNull, assertNotNull, assertNotSame, assertNotSame, assertNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, fail, fail, failNotEquals, failNotSame, failSame, format
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Constructor Detail

FarragoSqlTestWrapper

public FarragoSqlTestWrapper(String testName)
                      throws Exception
Throws:
Exception
Method Detail

setUp

protected void setUp()
              throws Exception
Overrides:
setUp in class FarragoTestCase
Throws:
Exception

test_unitsql_constraints_misc_sql

public void test_unitsql_constraints_misc_sql()
                                       throws Exception
Throws:
Exception

test_unitsql_constraints_notnull_sql

public void test_unitsql_constraints_notnull_sql()
                                          throws Exception
Throws:
Exception

test_unitsql_constraints_unique_sql

public void test_unitsql_constraints_unique_sql()
                                         throws Exception
Throws:
Exception

test_unitsql_ddl_alterTableStruct_sql

public void test_unitsql_ddl_alterTableStruct_sql()
                                           throws Exception
Throws:
Exception

test_unitsql_ddl_auth_sql

public void test_unitsql_ddl_auth_sql()
                               throws Exception
Throws:
Exception

test_unitsql_ddl_catalog_sql

public void test_unitsql_ddl_catalog_sql()
                                  throws Exception
Throws:
Exception

test_unitsql_ddl_char_sql

public void test_unitsql_ddl_char_sql()
                               throws Exception
Throws:
Exception

test_unitsql_ddl_collectionTypes_sql

public void test_unitsql_ddl_collectionTypes_sql()
                                          throws Exception
Throws:
Exception

test_unitsql_ddl_datetime_sql

public void test_unitsql_ddl_datetime_sql()
                                   throws Exception
Throws:
Exception

test_unitsql_ddl_ddlgen_sql

public void test_unitsql_ddl_ddlgen_sql()
                                 throws Exception
Throws:
Exception

test_unitsql_ddl_decimal_sql

public void test_unitsql_ddl_decimal_sql()
                                  throws Exception
Throws:
Exception

test_unitsql_ddl_dependencies_sql

public void test_unitsql_ddl_dependencies_sql()
                                       throws Exception
Throws:
Exception

test_unitsql_ddl_explain_sql

public void test_unitsql_ddl_explain_sql()
                                  throws Exception
Throws:
Exception

test_unitsql_ddl_jar_sql

public void test_unitsql_ddl_jar_sql()
                              throws Exception
Throws:
Exception

test_unitsql_ddl_labels_sql

public void test_unitsql_ddl_labels_sql()
                                 throws Exception
Throws:
Exception

test_unitsql_ddl_med_sql

public void test_unitsql_ddl_med_sql()
                              throws Exception
Throws:
Exception

test_unitsql_ddl_misc_sql

public void test_unitsql_ddl_misc_sql()
                               throws Exception
Throws:
Exception

test_unitsql_ddl_params_sql

public void test_unitsql_ddl_params_sql()
                                 throws Exception
Throws:
Exception

test_unitsql_ddl_privs_sql

public void test_unitsql_ddl_privs_sql()
                                throws Exception
Throws:
Exception

test_unitsql_ddl_rename_sql

public void test_unitsql_ddl_rename_sql()
                                 throws Exception
Throws:
Exception

test_unitsql_ddl_replace_sql

public void test_unitsql_ddl_replace_sql()
                                  throws Exception
Throws:
Exception

test_unitsql_ddl_replaceView_sql

public void test_unitsql_ddl_replaceView_sql()
                                      throws Exception
Throws:
Exception

test_unitsql_ddl_row_sql

public void test_unitsql_ddl_row_sql()
                              throws Exception
Throws:
Exception

test_unitsql_ddl_sample_sql

public void test_unitsql_ddl_sample_sql()
                                 throws Exception
Throws:
Exception

test_unitsql_ddl_schema_sql

public void test_unitsql_ddl_schema_sql()
                                 throws Exception
Throws:
Exception

test_unitsql_ddl_sequence_sql

public void test_unitsql_ddl_sequence_sql()
                                   throws Exception
Throws:
Exception

test_unitsql_ddl_stale_sql

public void test_unitsql_ddl_stale_sql()
                                throws Exception
Throws:
Exception

test_unitsql_ddl_udf_sql

public void test_unitsql_ddl_udf_sql()
                              throws Exception
Throws:
Exception

test_unitsql_ddl_udt_sql

public void test_unitsql_ddl_udt_sql()
                              throws Exception
Throws:
Exception

test_unitsql_ddl_view_sql

public void test_unitsql_ddl_view_sql()
                               throws Exception
Throws:
Exception

test_unitsql_expressions_constants_sql

public void test_unitsql_expressions_constants_sql()
                                            throws Exception
Throws:
Exception

test_unitsql_expressions_datatypes_sql

public void test_unitsql_expressions_datatypes_sql()
                                            throws Exception
Throws:
Exception

test_unitsql_expressions_datetime_sql

public void test_unitsql_expressions_datetime_sql()
                                           throws Exception
Throws:
Exception

test_unitsql_expressions_default_sql

public void test_unitsql_expressions_default_sql()
                                          throws Exception
Throws:
Exception

test_unitsql_expressions_identifiers_sql

public void test_unitsql_expressions_identifiers_sql()
                                              throws Exception
Throws:
Exception

test_unitsql_expressions_nullable_sql

public void test_unitsql_expressions_nullable_sql()
                                           throws Exception
Throws:
Exception

test_unitsql_expressions_orderby_sql

public void test_unitsql_expressions_orderby_sql()
                                          throws Exception
Throws:
Exception

test_unitsql_expressions_row_sql

public void test_unitsql_expressions_row_sql()
                                      throws Exception
Throws:
Exception

test_unitsql_expressions_strCasts_sql

public void test_unitsql_expressions_strCasts_sql()
                                           throws Exception
Throws:
Exception

test_unitsql_expressions_tablesample_sql

public void test_unitsql_expressions_tablesample_sql()
                                              throws Exception
Throws:
Exception

test_unitsql_expressions_udfInvocation_sql

public void test_unitsql_expressions_udfInvocation_sql()
                                                throws Exception
Throws:
Exception

test_unitsql_expressions_unicode_sql

public void test_unitsql_expressions_unicode_sql()
                                          throws Exception
Throws:
Exception

test_unitsql_expressions_values_sql

public void test_unitsql_expressions_values_sql()
                                         throws Exception
Throws:
Exception

test_unitsql_jdbc_medmetadata_sql

public void test_unitsql_jdbc_medmetadata_sql()
                                       throws Exception
Throws:
Exception

test_unitsql_jdbc_metadata_sql

public void test_unitsql_jdbc_metadata_sql()
                                    throws Exception
Throws:
Exception

test_unitsql_med_csv_sql

public void test_unitsql_med_csv_sql()
                              throws Exception
Throws:
Exception

test_unitsql_med_flatfile_sql

public void test_unitsql_med_flatfile_sql()
                                   throws Exception
Throws:
Exception

test_unitsql_med_loopback_sql

public void test_unitsql_med_loopback_sql()
                                   throws Exception
Throws:
Exception

test_unitsql_med_mock_sql

public void test_unitsql_med_mock_sql()
                               throws Exception
Throws:
Exception

test_unitsql_optimizer_agg_sql

public void test_unitsql_optimizer_agg_sql()
                                    throws Exception
Throws:
Exception

test_unitsql_optimizer_aggDistinct_sql

public void test_unitsql_optimizer_aggDistinct_sql()
                                            throws Exception
Throws:
Exception

test_unitsql_optimizer_calc_sql

public void test_unitsql_optimizer_calc_sql()
                                     throws Exception
Throws:
Exception

test_unitsql_optimizer_cartesian_sql

public void test_unitsql_optimizer_cartesian_sql()
                                          throws Exception
Throws:
Exception

test_unitsql_optimizer_commonRelSubExpr_sql

public void test_unitsql_optimizer_commonRelSubExpr_sql()
                                                 throws Exception
Throws:
Exception

test_unitsql_optimizer_distinct_sql

public void test_unitsql_optimizer_distinct_sql()
                                         throws Exception
Throws:
Exception

test_unitsql_optimizer_filter_sql

public void test_unitsql_optimizer_filter_sql()
                                       throws Exception
Throws:
Exception

test_unitsql_optimizer_hashexe_sql

public void test_unitsql_optimizer_hashexe_sql()
                                        throws Exception
Throws:
Exception

test_unitsql_optimizer_index_sql

public void test_unitsql_optimizer_index_sql()
                                      throws Exception
Throws:
Exception

test_unitsql_optimizer_iterator_sql

public void test_unitsql_optimizer_iterator_sql()
                                         throws Exception
Throws:
Exception

test_unitsql_optimizer_joinUsing_sql

public void test_unitsql_optimizer_joinUsing_sql()
                                          throws Exception
Throws:
Exception

test_unitsql_optimizer_joinorder_sql

public void test_unitsql_optimizer_joinorder_sql()
                                          throws Exception
Throws:
Exception

test_unitsql_optimizer_lbm_sql

public void test_unitsql_optimizer_lbm_sql()
                                    throws Exception
Throws:
Exception

test_unitsql_optimizer_lcs_sql

public void test_unitsql_optimizer_lcs_sql()
                                    throws Exception
Throws:
Exception

test_unitsql_optimizer_lcsdelete_sql

public void test_unitsql_optimizer_lcsdelete_sql()
                                          throws Exception
Throws:
Exception

test_unitsql_optimizer_lcsrid_sql

public void test_unitsql_optimizer_lcsrid_sql()
                                       throws Exception
Throws:
Exception

test_unitsql_optimizer_merge_sql

public void test_unitsql_optimizer_merge_sql()
                                      throws Exception
Throws:
Exception

test_unitsql_optimizer_mergeNoIndexes_sql

public void test_unitsql_optimizer_mergeNoIndexes_sql()
                                               throws Exception
Throws:
Exception

test_unitsql_optimizer_mergeOptimizations_sql

public void test_unitsql_optimizer_mergeOptimizations_sql()
                                                   throws Exception
Throws:
Exception

test_unitsql_optimizer_mergeUniqIndex_sql

public void test_unitsql_optimizer_mergeUniqIndex_sql()
                                               throws Exception
Throws:
Exception

test_unitsql_optimizer_multiset_sql

public void test_unitsql_optimizer_multiset_sql()
                                         throws Exception
Throws:
Exception

test_unitsql_optimizer_namespace_sql

public void test_unitsql_optimizer_namespace_sql()
                                          throws Exception
Throws:
Exception

test_unitsql_optimizer_nestedLoopJoin_sql

public void test_unitsql_optimizer_nestedLoopJoin_sql()
                                               throws Exception
Throws:
Exception

test_unitsql_optimizer_outerJoin_sql

public void test_unitsql_optimizer_outerJoin_sql()
                                          throws Exception
Throws:
Exception

test_unitsql_optimizer_pushProject_sql

public void test_unitsql_optimizer_pushProject_sql()
                                            throws Exception
Throws:
Exception

test_unitsql_optimizer_pushfilter_sql

public void test_unitsql_optimizer_pushfilter_sql()
                                           throws Exception
Throws:
Exception

test_unitsql_optimizer_removeSelfJoins_sql

public void test_unitsql_optimizer_removeSelfJoins_sql()
                                                throws Exception
Throws:
Exception

test_unitsql_optimizer_reshape_sql

public void test_unitsql_optimizer_reshape_sql()
                                        throws Exception
Throws:
Exception

test_unitsql_optimizer_residualfilter_sql

public void test_unitsql_optimizer_residualfilter_sql()
                                               throws Exception
Throws:
Exception

test_unitsql_optimizer_semijoin_sql

public void test_unitsql_optimizer_semijoin_sql()
                                         throws Exception
Throws:
Exception

test_unitsql_optimizer_setop_sql

public void test_unitsql_optimizer_setop_sql()
                                      throws Exception
Throws:
Exception

test_unitsql_optimizer_sort_sql

public void test_unitsql_optimizer_sort_sql()
                                     throws Exception
Throws:
Exception

test_unitsql_optimizer_stat_sql

public void test_unitsql_optimizer_stat_sql()
                                     throws Exception
Throws:
Exception

test_unitsql_optimizer_statHistograms_sql

public void test_unitsql_optimizer_statHistograms_sql()
                                               throws Exception
Throws:
Exception

test_unitsql_optimizer_subquery_sql

public void test_unitsql_optimizer_subquery_sql()
                                         throws Exception
Throws:
Exception

test_unitsql_optimizer_union_sql

public void test_unitsql_optimizer_union_sql()
                                      throws Exception
Throws:
Exception

test_unitsql_optimizer_unionEliminator_sql

public void test_unitsql_optimizer_unionEliminator_sql()
                                                throws Exception
Throws:
Exception

test_unitsql_optimizer_update_sql

public void test_unitsql_optimizer_update_sql()
                                       throws Exception
Throws:
Exception

test_unitsql_optimizer_view_sql

public void test_unitsql_optimizer_view_sql()
                                     throws Exception
Throws:
Exception

test_unitsql_sqlline_display_sql

public void test_unitsql_sqlline_display_sql()
                                      throws Exception
Throws:
Exception

test_unitsql_sqlline_incremental_sql

public void test_unitsql_sqlline_incremental_sql()
                                          throws Exception
Throws:
Exception

test_unitsql_syslib_cancel_sql

public void test_unitsql_syslib_cancel_sql()
                                    throws Exception
Throws:
Exception

test_unitsql_syslib_exportImport_sql

public void test_unitsql_syslib_exportImport_sql()
                                          throws Exception
Throws:
Exception

test_unitsql_syslib_mgmt_sql

public void test_unitsql_syslib_mgmt_sql()
                                  throws Exception
Throws:
Exception

test_unitsql_syslib_presort_sql

public void test_unitsql_syslib_presort_sql()
                                     throws Exception
Throws:
Exception