org.openi.jdbc
Interface SqlProvider

All Known Implementing Classes:
SqlProviderMicrosoft, SqlProviderMySQL, SqlProviderPostgreSQL

public interface SqlProvider

Interface that generates sql queries specific to the database provider/version


Method Summary
 java.lang.String generateFetchColumnDataSql(java.lang.String targetTable, java.lang.String targetColumn, int sampleSize)
          if sampleSize >0, then fetch sample of data: select top 10 targetColumn from targetTable order by newid() if samplesize < 0, then just fetch all rows for column: select targetColumn from targetTable
 java.lang.String generateFetchMinMaxSql(java.lang.String targetTable, java.lang.String targetColumn)
          select min(targetColumn), max(targetColumn) from targetTable
 java.lang.String generateFetchRowCountSql(java.lang.String targetTable)
          select count(*) from targetTable
 java.lang.String generateSegmentSql(java.util.List bucketList, java.lang.String targetTable, java.lang.String targetColumn)
          Generates entire segment sql, in the case of microsoft sql server result looks like this: select count(warehouse_sales) as frequency, CASE WHEN warehouse_sales between 0.0 AND 56.0 THEN 0 WHEN warehouse_sales between 56.0 AND 112.0 THEN 1 WHEN warehouse_sales between 112.0 AND 168.0 THEN 2 WHEN warehouse_sales between 168.0 AND 224.0 THEN 3 ELSE -1 END AS warehouse_sales_bucket FROM [inventory_fact_1997] group by ( CASE WHEN warehouse_sales between 0.0 AND 56.0 THEN 0 WHEN warehouse_sales between 56.0 AND 112.0 THEN 1 WHEN warehouse_sales between 112.0 AND 168.0 THEN 2 WHEN warehouse_sales between 168.0 AND 224.0 THEN 3 ELSE -1 END )
 

Method Detail

generateFetchMinMaxSql

java.lang.String generateFetchMinMaxSql(java.lang.String targetTable,
                                        java.lang.String targetColumn)
select min(targetColumn), max(targetColumn) from targetTable

Parameters:
targetTable -
targetColumn -
Returns:

generateFetchRowCountSql

java.lang.String generateFetchRowCountSql(java.lang.String targetTable)
select count(*) from targetTable

Parameters:
targetTable -
Returns:

generateSegmentSql

java.lang.String generateSegmentSql(java.util.List bucketList,
                                    java.lang.String targetTable,
                                    java.lang.String targetColumn)
Generates entire segment sql, in the case of microsoft sql server result looks like this: select count(warehouse_sales) as frequency, CASE WHEN warehouse_sales between 0.0 AND 56.0 THEN 0 WHEN warehouse_sales between 56.0 AND 112.0 THEN 1 WHEN warehouse_sales between 112.0 AND 168.0 THEN 2 WHEN warehouse_sales between 168.0 AND 224.0 THEN 3 ELSE -1 END AS warehouse_sales_bucket FROM [inventory_fact_1997] group by ( CASE WHEN warehouse_sales between 0.0 AND 56.0 THEN 0 WHEN warehouse_sales between 56.0 AND 112.0 THEN 1 WHEN warehouse_sales between 112.0 AND 168.0 THEN 2 WHEN warehouse_sales between 168.0 AND 224.0 THEN 3 ELSE -1 END )

Parameters:
bucketList -
targetTable -
targetColumn -
Returns:

generateFetchColumnDataSql

java.lang.String generateFetchColumnDataSql(java.lang.String targetTable,
                                            java.lang.String targetColumn,
                                            int sampleSize)
if sampleSize >0, then fetch sample of data: select top 10 targetColumn from targetTable order by newid() if samplesize < 0, then just fetch all rows for column: select targetColumn from targetTable

Parameters:
targetTable -
targetColumn -
sampleSize -
Returns: