net.sf.jkniv.whinstone.couchdb.dialect

Class CouchDbDialect2o0

java.lang.Object

net.sf.jkniv.sqlegance.dialect.AnsiDialect

net.sf.jkniv.whinstone.couchdb.dialect.CouchDbDialect2o0

All Implemented Interfaces:

SqlDialect

Direct Known Subclasses:

CouchDbDialect2o1

public class CouchDbDialect2o0
extends AnsiDialect

Dialect to CouchDB

Limit clause:

  {
    "selector": {
      "year": {"$gt": 2010}
    },
    "fields": ["_id", "_rev", "year", "title"],
    "sort": [{"year": "asc"}],
    "limit": 2,
    "skip": 0
  }
  

• Supports limits? true
• Supports limit off set? true
• Supports rownum? false

Since:

0.6.0

Author:

Alisson Gomes

See Also:

Find Pagination

Field Summary

Fields inherited from class net.sf.jkniv.sqlegance.dialect.AnsiDialect

name, patternORDER_BY

Constructor Summary

Constructors

Constructor and Description
CouchDbDialect2o0()

Method Summary

Modifier and Type	Method and Description
String	buildQueryCount(String sqlText) Build a paginate query to count the total of records from sqlText
String	buildQueryPaging(String sqlText, int offset, int max) Build a paginate query accordingly data base dialect
String	buildQueryPaging(String sqlText, int offset, int max, String bookmark) Build a paginate query accordingly data base dialect
boolean	supportsParmMark(ParamMarkType paramParse) verify if dialect supports a specific ParamMarkType

Methods inherited from class net.sf.jkniv.sqlegance.dialect.AnsiDialect

addFeature, countOccurrencesOf, getAccessId, getAccessRevision, getMaxOfParameters, getSqlPatternCount, getSqlPatternPaging, name, setMaxOfParameters, sqlEndsWithOrderBy, sqlEndWithForUpdate, sqlStartWithSelect, sqlStartWithSelectOrDistinct, supportsFeature

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

CouchDbDialect2o0

public CouchDbDialect2o0()

Method Detail

buildQueryPaging

public String buildQueryPaging(String sqlText,
                               int offset,
                               int max)

Description copied from interface: SqlDialect

Build a paginate query accordingly data base dialect

Specified by:

buildQueryPaging in interface SqlDialect

Overrides:

buildQueryPaging in class AnsiDialect

Parameters:

sqlText - final SQL with parameters to bind

offset - number from first row from query result

max - maximum number of rows from query result.

Returns:

paginate query for specific data base dialect

buildQueryPaging

public String buildQueryPaging(String sqlText,
                               int offset,
                               int max,
                               String bookmark)

Description copied from interface: SqlDialect

Build a paginate query accordingly data base dialect

Specified by:

buildQueryPaging in interface SqlDialect

Overrides:

buildQueryPaging in class AnsiDialect

Parameters:

sqlText - final SQL with parameters to bind

offset - number from first row from query result

max - maximum number of rows from query result.

bookmark - a page selected marked the reader's place

Returns:

paginate query for specific data base dialect

supportsParmMark

public boolean supportsParmMark(ParamMarkType paramParse)

Description copied from interface: SqlDialect

verify if dialect supports a specific ParamMarkType

Specified by:

supportsParmMark in interface SqlDialect

Overrides:

supportsParmMark in class AnsiDialect

Parameters:

paramParse - parameter mark type

Returns:

true when the parse type is supported, false otherwise

buildQueryCount

public String buildQueryCount(String sqlText)

Description copied from interface: SqlDialect

Build a paginate query to count the total of records from sqlText

Specified by:

buildQueryCount in interface SqlDialect

Overrides:

buildQueryCount in class AnsiDialect

Parameters:

sqlText - original SQL to discover the total of records

Returns:

query that count the total of records from sqlText