@Override public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException { final String[] columns = criteriaQuery.getColumnsUsingProjection( criteria, this.propertyName ); final StringBuilder sql = new StringBuilder( "SDO_RELATE(" ); sql.append( columns[0] ).append( "," ).append( "?" ); if ( param != null && !param.isEmpty() ) { sql.append( "," ).append( param.toQuotedString() ); } sql.append( ") = 'TRUE'" ); return sql.toString(); } };
@Override public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException { final String[] columns = criteriaQuery.getColumnsUsingProjection( criteria, this.propertyName ); final StringBuilder sql = new StringBuilder( "SDO_FILTER(" ); sql.append( columns[0] ).append( "," ).append( "?" ); if ( param != null && !param.isEmpty() ) { sql.append( "," ).append( param.toQuotedString() ); } sql.append( ") = 'TRUE'" ); return sql.toString(); } };
@Override public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException { final String[] columns = criteriaQuery.getColumnsUsingProjection( criteria, this.propertyName ); final StringBuilder sql = new StringBuilder( "SDO_NN(" ); sql.append( columns[0] ).append( "," ).append( "?" ); if ( param != null && !param.isEmpty() ) { sql.append( "," ).append( param.toQuotedString() ); } sql.append( ") = 'TRUE'" ); return sql.toString(); } };
@Override public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException { final String[] columns = criteriaQuery.getColumnsUsingProjection( criteria, this.propertyName ); final StringBuilder sql = new StringBuilder( "SDO_WITHIN_DISTANCE(" ); sql.append( columns[0] ).append( "," ).append( "?" ); if ( param != null && !param.isEmpty() ) { sql.append( "," ).append( param.toQuotedString() ); } sql.append( ") = 'TRUE'" ); return sql.toString(); } };
public String toSqlString(Criteria criteria, int position, CriteriaQuery criteriaQuery) throws HibernateException { final StringBuilder stbuf = new StringBuilder(); final SessionFactoryImplementor factory = criteriaQuery.getFactory(); final String[] columns = criteriaQuery.getColumnsUsingProjection( criteria, propertyName ); final Dialect dialect = factory.getDialect(); if ( dialect instanceof SpatialDialect ) { final SpatialDialect seDialect = (SpatialDialect) dialect; stbuf.append( seDialect.getSpatialAggregateSQL( columns[0], SpatialAggregate.EXTENT ) ); stbuf.append( " as y" ).append( position ).append( '_' ); return stbuf.toString(); } return null; }
@Override public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException { final SessionFactoryImplementor factory = criteriaQuery.getFactory(); final String[] columns = criteriaQuery.getColumnsUsingProjection( criteria, this.propertyName ); final Dialect dialect = factory.getDialect(); if ( dialect instanceof SpatialDialect ) { final SpatialDialect seDialect = (SpatialDialect) dialect; return seDialect.getSpatialRelateSQL( columns[0], spatialRelation ); } else { throw new IllegalStateException( "Dialect must be spatially enabled dialect" ); } }
@Override public String toSqlString(Criteria criteria, int position, CriteriaQuery criteriaQuery) throws HibernateException { final SessionFactoryImplementor factory = criteriaQuery.getFactory(); final String[] columns = criteriaQuery.getColumnsUsingProjection( criteria, this.propertyName ); final Dialect dialect = factory.getDialect(); if ( dialect instanceof SpatialDialect ) { final SpatialDialect seDialect = (SpatialDialect) dialect; return new StringBuffer( seDialect.getSpatialAggregateSQL( columns[0], this.aggregate ) ).append( " y" ).append( position ) .append( "_" ).toString(); } else { throw new IllegalStateException( "Dialect must be spatially enabled dialect" ); } }
@Override public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException { final SessionFactoryImplementor factory = criteriaQuery.getFactory(); final String[] columns = criteriaQuery.getColumnsUsingProjection( criteria, this.propertyName ); final Dialect dialect = factory.getDialect(); if ( dialect instanceof SpatialDialect ) { final SpatialDialect seDialect = (SpatialDialect) dialect; return seDialect.getSpatialFilterExpression( columns[0] ); } else { throw new IllegalStateException( "Dialect must be spatially enabled dialect" ); } }
final String[] columns = criteriaQuery.getColumnsUsingProjection( criteria, propertyName ); final Type type = criteriaQuery.getTypeUsingProjection( criteria, propertyName ); final SessionFactoryImplementor factory = criteriaQuery.getFactory();
return outerQueryTranslator.getColumnsUsingProjection( subcriteria, propertyName );
public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException { String[] xcols = criteriaQuery.getColumnsUsingProjection(criteria, propertyName); String[] ycols = criteriaQuery.getColumnsUsingProjection(criteria, otherPropertyName); String result = StringHelper.join( " and ", StringHelper.add(xcols, getOp(), ycols) ); if (xcols.length>1) result = '(' + result + ')'; return result; //TODO: get SQL rendering out of this package! }
public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException { String[] xcols = criteriaQuery.getColumnsUsingProjection(criteria, propertyName); String[] ycols = criteriaQuery.getColumnsUsingProjection(criteria, otherPropertyName); String result = StringHelper.join( " and ", StringHelper.add(xcols, getOp(), ycols) ); if (xcols.length>1) result = '(' + result + ')'; return result; //TODO: get SQL rendering out of this package! }
public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException { String[] columns = criteriaQuery.getColumnsUsingProjection(criteria, propertyName); String result = StringHelper.join( " or ", StringHelper.suffix( columns, " is not null" ) ); if (columns.length>1) result = '(' + result + ')'; return result; //TODO: get SQL rendering out of this package! }
public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException { return StringHelper.join( " and ", StringHelper.suffix( criteriaQuery.getColumnsUsingProjection(criteria, propertyName), " between ? and ?" ) ); //TODO: get SQL rendering out of this package! }
public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException { String[] columns = criteriaQuery.getColumnsUsingProjection(criteria, propertyName); String result = StringHelper.join( " and ", StringHelper.suffix( columns, " is null" ) ); if (columns.length>1) result = '(' + result + ')'; return result; //TODO: get SQL rendering out of this package! }
public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException { String[] columns = criteriaQuery.getColumnsUsingProjection(criteria, propertyName); String result = StringHelper.join( " or ", StringHelper.suffix( columns, " is not null" ) ); if (columns.length>1) result = '(' + result + ')'; return result; //TODO: get SQL rendering out of this package! }
public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException { String[] columns = criteriaQuery.getColumnsUsingProjection(criteria, propertyName); String result = StringHelper.join( " and ", StringHelper.suffix( columns, " is null" ) ); if (columns.length>1) result = '(' + result + ')'; return result; //TODO: get SQL rendering out of this package! }
public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException { return StringHelper.join( " and ", StringHelper.suffix( criteriaQuery.getColumnsUsingProjection(criteria, propertyName), " between ? and ?" ) ); //TODO: get SQL rendering out of this package! }
public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException { SessionFactoryImplementor factory = criteriaQuery.getFactory(); String[] columns = criteriaQuery.getColumnsUsingProjection(criteria, this.propertyName); Dialect dialect = factory.getDialect(); if (dialect instanceof SpatialDialect) { SpatialDialect seDialect = (SpatialDialect) dialect; return seDialect.getSpatialFilterExpression(columns[0]); } else throw new IllegalStateException( "Dialect must be spatially enabled dialect"); }
public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException { String[] columns = criteriaQuery.getColumnsUsingProjection(criteria, propertyName); String singleValueParam = StringHelper.repeat( "?, ", columns.length-1 ) + "?"; if ( columns.length>1 ) singleValueParam = '(' + singleValueParam + ')'; String params = values.length>0 ? StringHelper.repeat( singleValueParam + ", ", values.length-1 ) + singleValueParam : ""; String cols = StringHelper.join(", ", columns); if ( columns.length>1 ) cols = '(' + cols + ')'; return cols + " in (" + params + ')'; }