Package org.hibernate.sql

Examples of org.hibernate.sql.ConditionFragment

226
227
228
229
230
231
232
233
234
235
236
237
238
239
      }
      select.appendRestrictions( in.toFragmentString() );
    }
    else {
      // A COMPOSITE KEY...
      final ConditionFragment keyRestrictionBuilder = new ConditionFragment()
          .setTableAlias( alias )
          .setCondition( keyColumnNames, "?" );
      final String keyRestrictionFragment = keyRestrictionBuilder.toFragmentString();

      StringBuilder restrictions = new StringBuilder();
      if ( batchSize==1 ) {
        // for no batching, use "foo = ? and bar = ?"
        restrictions.append( keyRestrictionFragment );
View Full Code Here
68
69
70
71
72
73
74
75
76
77
78
    final String[] collectionKeys = collectionPersister.getKeyColumnNames();
    final String[] ownerKeys = ( (Loadable) factory.getEntityPersister( entityName ) ).getIdentifierColumnNames();

    final String innerSelect = "(select 1 from " + collectionPersister.getTableName() + " where "
        + new ConditionFragment().setTableAlias( sqlAlias ).setCondition( ownerKeys, collectionKeys ).toFragmentString()
        + ")";

    return excludeEmpty()
        ? "exists " + innerSelect
        : "not exists " + innerSelect;
View Full Code Here
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
      for ( int i=0; i<batchSize; i++ ) in.addValue("?");
      return new StringBuilder( in.toFragmentString() );
    }
    else {
      //a composite key
      ConditionFragment byId = new ConditionFragment()
          .setTableAlias(alias)
          .setCondition( columnNames, "?" );
 
      StringBuilder whereString = new StringBuilder();
      if ( batchSize==1 ) {
        // if no batch, use "foo = ? and bar = ?"
        whereString.append( byId.toFragmentString() );
      }
      else {
        // if a composite key, use "( (foo = ? and bar = ?) or (foo = ? and bar = ?) )" for batching
        whereString.append('('); //TODO: unnecessary for databases with ANSI-style joins
        DisjunctionFragment df = new DisjunctionFragment();
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
    final QueryableCollection cp = (QueryableCollection) criteriaQuery.getFactory().getCollectionPersister( role );

    final String[] fk = cp.getKeyColumnNames();
    final String[] pk = ( (Loadable) cp.getOwnerEntityPersister() ).getIdentifierColumnNames();

    final ConditionFragment subQueryRestriction = new ConditionFragment()
        .setTableAlias( criteriaQuery.getSQLAlias( criteria, propertyName ) )
        .setCondition( pk, fk );

    return String.format(
        "? %s (select count(*) from %s where %s)",
        op,
        cp.getTableName(),
        subQueryRestriction.toFragmentString()
    );
  }
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
        op +
        " (select count(*) from " +
        cp.getTableName() +
        //" collection_ where " +
        " where " +
        new ConditionFragment()
            .setTableAlias( criteriaQuery.getSQLAlias(criteria, propertyName) )
            .setCondition(pk, fk)
            .toFragmentString() +
        ")";
  }
View Full Code Here
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
      for ( int i=0; i<batchSize; i++ ) in.addValue("?");
      return new StringBuffer( in.toFragmentString() );
    }
    else {
      //a composite key
      ConditionFragment byId = new ConditionFragment()
          .setTableAlias(alias)
          .setCondition( columnNames, "?" );
 
      StringBuffer whereString = new StringBuffer();
      if ( batchSize==1 ) {
        // if no batch, use "foo = ? and bar = ?"
        whereString.append( byId.toFragmentString() );
      }
      else {
        // if a composite key, use "( (foo = ? and bar = ?) or (foo = ? and bar = ?) )" for batching
        whereString.append('('); //TODO: unnecessary for databases with ANSI-style joins
        DisjunctionFragment df = new DisjunctionFragment();
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
        op +
        " (select count(*) from " +
        cp.getTableName() +
        //" collection_ where " +
        " where " +
        new ConditionFragment()
            .setTableAlias( criteriaQuery.getSQLAlias(criteria, propertyName) )
            .setCondition(pk, fk)
            .toFragmentString() +
        ")";
  }
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
    String[] collectionKeys = collectionPersister.getKeyColumnNames();
    String[] ownerKeys = ( ( Loadable ) factory.getEntityPersister( entityName ) ).getIdentifierColumnNames();

    String innerSelect = "(select 1 from " + collectionPersister.getTableName()
            + " where "
            + new ConditionFragment().setTableAlias( sqlAlias ).setCondition( ownerKeys, collectionKeys ).toFragmentString()
            + ")";

    return excludeEmpty()
            ? "exists " + innerSelect
            : "not exists " + innerSelect;
View Full Code Here
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
      for ( int i=0; i<batchSize; i++ ) in.addValue("?");
      return new StringBuffer( in.toFragmentString() );
    }
    else {
      //a composite key
      ConditionFragment byId = new ConditionFragment()
          .setTableAlias(alias)
          .setCondition( columnNames, "?" );
 
      StringBuffer whereString = new StringBuffer();
      if ( batchSize==1 ) {
        // if no batch, use "foo = ? and bar = ?"
        whereString.append( byId.toFragmentString() );
      }
      else {
        // if a composite key, use "( (foo = ? and bar = ?) or (foo = ? and bar = ?) )" for batching
        whereString.append('('); //TODO: unnecessary for databases with ANSI-style joins
        DisjunctionFragment df = new DisjunctionFragment();
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
    String[] collectionKeys = collectionPersister.getKeyColumnNames();
    String[] ownerKeys = ( ( Loadable ) factory.getEntityPersister( entityName ) ).getIdentifierColumnNames();

    String innerSelect = "(select 1 from " + collectionPersister.getTableName()
            + " where "
            + new ConditionFragment().setTableAlias( sqlAlias ).setCondition( ownerKeys, collectionKeys ).toFragmentString()
            + ")";

    return excludeEmpty()
            ? "exists " + innerSelect
            : "not exists " + innerSelect;
View Full Code Here
TOP

Related Classes of org.hibernate.sql.ConditionFragment

  • org.hibernate.criterion.AbstractEmptinessExpression
  • org.hibernate.criterion.SizeExpression
  • org.hibernate.loader.internal.AbstractLoadQueryImpl
  • org.hibernate.loader.JoinWalker
  • org.hibernate.loader.plan.exec.internal.AbstractLoadQueryDetails
  • org.hibernate.loader.plan.exec.query.internal.EntityLoadQueryBuilderImpl
  • org.hibernate.loader.plan.exec.spi.AbstractLoadQueryDetails
  • org.hibernate.loader.plan.exec.spi.EntityLoadQueryDetails
  • org.hibernate.loader.plan2.exec.spi.EntityLoadQueryDetails
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.