congrats Icon
New! Announcing our next generation AI code completions
Read here
Tabnine Logo
AbstractWhereBuilder.getOrderBy
Code IndexAdd Tabnine to your IDE (free)

How to use
getOrderBy
method
in
org.deegree.sqldialect.filter.AbstractWhereBuilder

Best Java code snippets using org.deegree.sqldialect.filter.AbstractWhereBuilder.getOrderBy (Showing top 5 results out of 315)

origin: deegree/deegree3

protected StringBuilder getPreparedStatementDatasetIDs( AbstractWhereBuilder builder ) {
  StringBuilder getDatasetIDs = new StringBuilder( 300 );
  String rootTableAlias = builder.getAliasManager().getRootTableAlias();
  getDatasetIDs.append( "SELECT DISTINCT " );
  getDatasetIDs.append( rootTableAlias );
  getDatasetIDs.append( '.' );
  getDatasetIDs.append( idColumn );
  // for SELECT DISTINCT, all ORDER BY columns have to be SELECTed as well
  if ( builder.getOrderBy() != null ) {
    // hack to transform the ORDER BY column list in select list
    String orderColList = builder.getOrderBy().getSQL().toString();
    int i = 1;
    while ( orderColList.contains( " ASC" ) || orderColList.contains( "DESC" ) ) {
      orderColList = orderColList.replaceFirst( " ASC| DESC", " AS crit" + ( i++ ) );
    }
    getDatasetIDs.append( ',' );
    getDatasetIDs.append( orderColList );
  }
  return getDatasetIDs;
}
origin: deegree/deegree3

if ( builder.getOrderBy() != null ) {
  for ( SQLArgument o : builder.getOrderBy().getArguments() ) {
    o.setArgument( stmt, i++ );
origin: deegree/deegree3

  idSelect.append( " WHERE " ).append( wb.getWhere().getSQL() );
if ( wb.getOrderBy() != null ) {
  idSelect.append( " ORDER BY " );
  idSelect.append( wb.getOrderBy().getSQL() );
if ( wb.getOrderBy() != null ) {
  for ( SQLArgument argument : wb.getOrderBy().getArguments() ) {
    argument.setArgument( stmt, i++ );
origin: deegree/deegree3

if ( builder.getOrderBy() != null ) {
  idSelect.append( " ORDER BY " );
  idSelect.append( builder.getOrderBy().getSQL() );
if ( builder.getOrderBy() != null ) {
  outerSelect.append( " ORDER BY " );
  String sortCols = builder.getOrderBy().getSQL().toString();
  String rootTableQualifier = builder.getAliasManager().getRootTableAlias() + ".";
  int columnCount = StringUtils.count( sortCols, "," ) + 1;
if ( builder.getOrderBy() != null ) {
  for ( SQLArgument o : builder.getOrderBy().getArguments() ) {
    o.setArgument( preparedStatement, i++ );
    arguments.add( o.getValue() );
origin: deegree/deegree3

String ftTableAlias = wb.getAliasManager().getRootTableAlias();
LOG.debug( "WHERE clause: " + wb.getWhere() );
LOG.debug( "ORDER BY clause: " + wb.getOrderBy() );
if ( wb.getOrderBy() != null ) {
  sql.append( " ORDER BY " );
  sql.append( wb.getOrderBy().getSQL() );
if ( wb.getOrderBy() != null ) {
  for ( SQLArgument o : wb.getOrderBy().getArguments() ) {
    o.setArgument( stmt, i++ );
org.deegree.sqldialect.filterAbstractWhereBuildergetOrderBy

Javadoc

Returns the expression for the SQL-ORDER-BY clause.

Popular methods of AbstractWhereBuilder

  • getWhere
    Returns the expression for the SQL-WHERE clause.
  • getAliasManager
    Returns the TableAliasManager that keeps track of the used table aliases. The returned manager may a
  • getMappedPropertyNames
    Returns the mappings of all ValueReferences from the filter / sort criteria that have been mapped to
  • addExpression
  • appendParamsFromFunction
  • assertNotMultiValued
    Ensures that the given SQLExpression is not an SQLExpression that is multi-valued.
  • buildIsLike
  • evaluateFunction
  • getPostFilter
    Returns a Filter that contains all constraints from the input filter that could not be expressed in
  • getPostSortCriteria
    Returns the sort criteria that contains all parts from the input sort criteria that could not be exp
  • inferType
  • toProtoSQL
    Translates the given SortProperty array into an SQLExpression.
  • inferType,
  • toProtoSQL

Popular in Java

  • Reading from database using SQL prepared statement
  • getApplicationContext (Context)
  • getExternalFilesDir (Context)
  • addToBackStack (FragmentTransaction)
  • FileInputStream (java.io)
    An input stream that reads bytes from a file. File file = ...finally if (in != null) in.clos
  • Socket (java.net)
    Provides a client-side TCP socket.
  • SQLException (java.sql)
    An exception that indicates a failed JDBC operation. It provides the following information about pro
  • DateFormat (java.text)
    Formats or parses dates and times.This class provides factories for obtaining instances configured f
  • TreeMap (java.util)
    Walk the nodes of the tree left-to-right or right-to-left. Note that in descending iterations, next
  • JTextField (javax.swing)
  • Sublime Text for Python
Tabnine Logo
  • Products

    Search for Java codeSearch for JavaScript code
  • IDE Plugins

    IntelliJ IDEAWebStormVisual StudioAndroid StudioEclipseVisual Studio CodePyCharmSublime TextPhpStormVimAtomGoLandRubyMineEmacsJupyter NotebookJupyter LabRiderDataGripAppCode
  • Company

    About UsContact UsCareers
  • Resources

    FAQBlogTabnine AcademyStudentsTerms of usePrivacy policyJava Code IndexJavascript Code Index
Get Tabnine for your IDE now