|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
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 |
|---|
java.lang.String generateFetchMinMaxSql(java.lang.String targetTable,
java.lang.String targetColumn)
targetTable - targetColumn -
java.lang.String generateFetchRowCountSql(java.lang.String targetTable)
targetTable -
java.lang.String generateSegmentSql(java.util.List bucketList,
java.lang.String targetTable,
java.lang.String targetColumn)
bucketList - targetTable - targetColumn -
java.lang.String generateFetchColumnDataSql(java.lang.String targetTable,
java.lang.String targetColumn,
int sampleSize)
targetTable - targetColumn - sampleSize -
|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||