org.openi.jdbc.impl
Class SqlProviderPostgreSQL

java.lang.Object
  extended by org.openi.jdbc.impl.SqlProviderPostgreSQL
All Implemented Interfaces:
SqlProvider

public class SqlProviderPostgreSQL
extends java.lang.Object
implements SqlProvider


Constructor Summary
SqlProviderPostgreSQL()
           
 
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 )
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

SqlProviderPostgreSQL

public SqlProviderPostgreSQL()
Method Detail

generateFetchMinMaxSql

public java.lang.String generateFetchMinMaxSql(java.lang.String targetTable,
                                               java.lang.String targetColumn)
Description copied from interface: SqlProvider
select min(targetColumn), max(targetColumn) from targetTable

Specified by:
generateFetchMinMaxSql in interface SqlProvider
Returns:

generateFetchRowCountSql

public java.lang.String generateFetchRowCountSql(java.lang.String targetTable)
Description copied from interface: SqlProvider
select count(*) from targetTable

Specified by:
generateFetchRowCountSql in interface SqlProvider
Returns:

generateSegmentSql

public java.lang.String generateSegmentSql(java.util.List bucketList,
                                           java.lang.String targetTable,
                                           java.lang.String targetColumn)
Description copied from interface: SqlProvider
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 )

Specified by:
generateSegmentSql in interface SqlProvider
Returns:

generateFetchColumnDataSql

public java.lang.String generateFetchColumnDataSql(java.lang.String targetTable,
                                                   java.lang.String targetColumn,
                                                   int sampleSize)
Description copied from interface: SqlProvider
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

Specified by:
generateFetchColumnDataSql in interface SqlProvider
Returns: