Examples of QuerySelect

org.apache.click.extras.cayenne.QuerySelect
Provides a Cayenne Query Select control: <select></select>.

Query Select

The QuerySelect provides a Select control with the options automatically populated from a Cayenne query. This control supports both named queries, which are configured in the Cayenne Modeler, and SelectQuery and NamedQuery objects which can be defined in code.
All Cayenne queries are executed using the thread local {@link DataContext}obtained via DataContext.getThreadDataContext(), and are executed as required by the onProcess() and toString() methods.
QuerySelect has no dependency on {@link CayenneForm} and can be usedseparately in other forms or controls.
QuerySelect Examples
The QuerySelect below executes a Cayenne Modeler defined named query called "system.titles". This pre configured query returns a list of {@link DataRow}objects containing "VALUE" and "LABEL" values, which are rendered as the option values and labels.
```
 QuerySelect title = new QuerySelect("title"); title.setQueryValueLabel("system.titles", "VALUE", "LABEL"); form.add(title); 
```
The example below uses a {@link SelectQuery} defined in code and rendersthe Delivery object type and description properties and the option values and labels.
```
 QuerySelect delivery = new QuerySelect("delivery", true); delivery.setSelectQuery(new SelectQuery(Delivery.class)); delivery.setOptionValue("type"); delivery.setOptionLabel("description"); form.add(delivery); 
```
The last example uses a {@link Decorator} to render the select options label.
```
 QuerySelect userSelect = new QuerySelect("user", true); userSelect.setSelectQuery(new SelectQuery(User.class)); userSelect.setOptionValue("username"); userSelect.setDecorator(new Decorator() { public String render(Object object, Context context) { User user = (User) object; return user.getFirstName() + " " + user.getLastName(); } }); form.add(userSelect); 
```
@see CayenneForm @see PropertySelect
org.hibernate.sql.QuerySelect
A translated HQL query @author Gavin King

Examples of org.apache.click.extras.cayenne.QuerySelect

     * @param page the wizard page
     */
    public Step1(String name, String label, String description, WizardPage page) {
        super(name, label, description, page);


        QuerySelect querySelect = new QuerySelect("title", true);
        querySelect.setQueryValueLabel("titles", "value", "label");
        getForm().add(querySelect);


        getForm().add(new TextField("firstName"));
        getForm().add(new TextField("lastName"));
        getForm().add(new DateField("dateJoined"));

View Full Code Here

Examples of org.apache.click.extras.cayenne.QuerySelect


        getForm().add(new TextField("address.line1", "Line One"));
        getForm().add(new TextField("address.line2", "Line Two"));
        getForm().add(new TextField("address.suburb", "Suburb"));


        stateSelect = new QuerySelect("address.state", "State", true);


        stateSelect.setQueryValueLabel("states", "value", "label");
        getForm().add(stateSelect);
        postCodeField = new CayenneIntegerField("address.postCode", "Post Code");
        postCodeField.setMaxLength(5);

View Full Code Here

Examples of org.apache.click.extras.cayenne.QuerySelect

     */
    public CayenneFormPage() {
        FieldSet clientFieldSet = new FieldSet("Client");
        form.add(clientFieldSet);


        QuerySelect querySelect = new QuerySelect("title", true);
        querySelect.setQueryValueLabel("titles", "value", "label");
        clientFieldSet.add(querySelect);


        clientFieldSet.add(new TextField("firstName"));
        clientFieldSet.add(new TextField("lastName"));
        clientFieldSet.add(new DateField("dateJoined"));
        clientFieldSet.add(new EmailField("email"));


        FieldSet addressFieldSet = new FieldSet("Address");
        form.add(addressFieldSet);


        addressFieldSet.add(new TextField("address.line1", "Line One"));
        addressFieldSet.add(new TextField("address.line2", "Line Two"));
        addressFieldSet.add(new TextField("address.suburb", "Suburb"));


        querySelect = new QuerySelect("address.state", "State", true);
        querySelect.setQueryValueLabel("states", "value", "label");
        addressFieldSet.add(querySelect);


        IntegerField postCodeField = new IntegerField("address.postCode", "Post Code");
        postCodeField.setMaxLength(5);
        postCodeField.setSize(5);

View Full Code Here

Examples of org.hibernate.sql.QuerySelect

    returnTypes = new Type[scalarSize];
    for ( int i = 0; i < scalarSize; i++ ) {
      returnTypes[i] = ( Type ) scalarTypes.get( i );
    }


    QuerySelect sql = new QuerySelect( getFactory().getDialect() );
    sql.setDistinct( distinct );


    if ( !shallowQuery ) {
      renderIdentifierSelect( sql );
      renderPropertiesSelect( sql );
    }


    if ( collectionPersister != null ) {
      sql.addSelectFragmentString( collectionPersister.selectFragment( fetchName, "__" ) );
    }


    if ( hasScalars || shallowQuery ) sql.addSelectFragmentString( scalarSelect );


    //TODO: for some dialects it would be appropriate to add the renderOrderByPropertiesSelect() to other select strings
    mergeJoins( sql.getJoinFragment() );


    sql.setWhereTokens( whereTokens.iterator() );


    sql.setGroupByTokens( groupByTokens.iterator() );
    sql.setHavingTokens( havingTokens.iterator() );
    sql.setOrderByTokens( orderByTokens.iterator() );


    if ( collectionPersister != null && collectionPersister.hasOrdering() ) {
      sql.addOrderBy( collectionPersister.getSQLOrderByString( fetchName ) );
    }


    scalarColumnNames = NameGenerator.generateColumnNames( returnTypes, getFactory() );


    // initialize the Set of queried identifier spaces (ie. tables)
    Iterator iter = collections.values().iterator();
    while ( iter.hasNext() ) {
      CollectionPersister p = getCollectionPersister( ( String ) iter.next() );
      addQuerySpaces( p.getCollectionSpaces() );
    }
    iter = typeMap.keySet().iterator();
    while ( iter.hasNext() ) {
      Queryable p = getEntityPersisterForName( ( String ) iter.next() );
      addQuerySpaces( p.getQuerySpaces() );
    }


    sqlString = sql.toQueryString();


    if ( holderClass != null ) holderConstructor = ReflectHelper.getConstructor( holderClass, returnTypes );


    if ( hasScalars ) {
      actualReturnTypes = returnTypes;

View Full Code Here

Examples of org.hibernate.sql.QuerySelect

    returnTypes = new Type[scalarSize];
    for ( int i = 0; i < scalarSize; i++ ) {
      returnTypes[i] = ( Type ) scalarTypes.get( i );
    }


    QuerySelect sql = new QuerySelect( getFactory().getDialect() );
    sql.setDistinct( distinct );


    if ( !shallowQuery ) {
      renderIdentifierSelect( sql );
      renderPropertiesSelect( sql );
    }


    if ( collectionPersister != null ) {
      sql.addSelectFragmentString( collectionPersister.selectFragment( fetchName, "__" ) );
    }


    if ( hasScalars || shallowQuery ) sql.addSelectFragmentString( scalarSelect );


    //TODO: for some dialects it would be appropriate to add the renderOrderByPropertiesSelect() to other select strings
    mergeJoins( sql.getJoinFragment() );


    sql.setWhereTokens( whereTokens.iterator() );


    sql.setGroupByTokens( groupByTokens.iterator() );
    sql.setHavingTokens( havingTokens.iterator() );
    sql.setOrderByTokens( orderByTokens.iterator() );


    if ( collectionPersister != null && collectionPersister.hasOrdering() ) {
      sql.addOrderBy( collectionPersister.getSQLOrderByString( fetchName ) );
    }


    scalarColumnNames = NameGenerator.generateColumnNames( returnTypes, getFactory() );


    // initialize the Set of queried identifier spaces (ie. tables)
    Iterator iter = collections.values().iterator();
    while ( iter.hasNext() ) {
      CollectionPersister p = getCollectionPersister( ( String ) iter.next() );
      addQuerySpaces( p.getCollectionSpaces() );
    }
    iter = typeMap.keySet().iterator();
    while ( iter.hasNext() ) {
      Queryable p = getEntityPersisterForName( ( String ) iter.next() );
      addQuerySpaces( p.getQuerySpaces() );
    }


    sqlString = sql.toQueryString();


    if ( holderClass != null ) holderConstructor = ReflectHelper.getConstructor( holderClass, returnTypes );


    if ( hasScalars ) {
      actualReturnTypes = returnTypes;

View Full Code Here

Examples of org.hibernate.sql.QuerySelect

    returnTypes = new Type[scalarSize];
    for ( int i = 0; i < scalarSize; i++ ) {
      returnTypes[i] = ( Type ) scalarTypes.get( i );
    }


    QuerySelect sql = new QuerySelect( getFactory().getDialect() );
    sql.setDistinct( distinct );


    if ( !shallowQuery ) {
      renderIdentifierSelect( sql );
      renderPropertiesSelect( sql );
    }


    if ( collectionPersister != null ) {
      sql.addSelectFragmentString( collectionPersister.selectFragment( fetchName, "__" ) );
    }


    if ( hasScalars || shallowQuery ) sql.addSelectFragmentString( scalarSelect );


    //TODO: for some dialects it would be appropriate to add the renderOrderByPropertiesSelect() to other select strings
    mergeJoins( sql.getJoinFragment() );


    sql.setWhereTokens( whereTokens.iterator() );


    sql.setGroupByTokens( groupByTokens.iterator() );
    sql.setHavingTokens( havingTokens.iterator() );
    sql.setOrderByTokens( orderByTokens.iterator() );


    if ( collectionPersister != null && collectionPersister.hasOrdering() ) {
      sql.addOrderBy( collectionPersister.getSQLOrderByString( fetchName ) );
    }


    scalarColumnNames = NameGenerator.generateColumnNames( returnTypes, getFactory() );


    // initialize the Set of queried identifier spaces (ie. tables)
    Iterator iter = collections.values().iterator();
    while ( iter.hasNext() ) {
      CollectionPersister p = getCollectionPersister( ( String ) iter.next() );
      addQuerySpaces( p.getCollectionSpaces() );
    }
    iter = typeMap.keySet().iterator();
    while ( iter.hasNext() ) {
      Queryable p = getEntityPersisterForName( ( String ) iter.next() );
      addQuerySpaces( p.getQuerySpaces() );
    }


    sqlString = sql.toQueryString();


    if ( holderClass != null ) holderConstructor = ReflectHelper.getConstructor( holderClass, returnTypes );


    if ( hasScalars ) {
      actualReturnTypes = returnTypes;

View Full Code Here

Examples of org.hibernate.sql.QuerySelect

    returnTypes = new Type[scalarSize];
    for ( int i = 0; i < scalarSize; i++ ) {
      returnTypes[i] = ( Type ) scalarTypes.get( i );
    }


    QuerySelect sql = new QuerySelect( getFactory().getDialect() );
    sql.setDistinct( distinct );


    if ( !shallowQuery ) {
      renderIdentifierSelect( sql );
      renderPropertiesSelect( sql );
    }


    if ( collectionPersister != null ) {
      sql.addSelectFragmentString( collectionPersister.selectFragment( fetchName, "__" ) );
    }


    if ( hasScalars || shallowQuery ) sql.addSelectFragmentString( scalarSelect );


    //TODO: for some dialects it would be appropriate to add the renderOrderByPropertiesSelect() to other select strings
    mergeJoins( sql.getJoinFragment() );


    sql.setWhereTokens( whereTokens.iterator() );


    sql.setGroupByTokens( groupByTokens.iterator() );
    sql.setHavingTokens( havingTokens.iterator() );
    sql.setOrderByTokens( orderByTokens.iterator() );


    if ( collectionPersister != null && collectionPersister.hasOrdering() ) {
      sql.addOrderBy( collectionPersister.getSQLOrderByString( fetchName ) );
    }


    scalarColumnNames = NameGenerator.generateColumnNames( returnTypes, getFactory() );


    // initialize the Set of queried identifier spaces (ie. tables)
    Iterator iter = collections.values().iterator();
    while ( iter.hasNext() ) {
      CollectionPersister p = getCollectionPersister( ( String ) iter.next() );
      addQuerySpaces( p.getCollectionSpaces() );
    }
    iter = typeMap.keySet().iterator();
    while ( iter.hasNext() ) {
      Queryable p = getEntityPersisterForName( ( String ) iter.next() );
      addQuerySpaces( p.getQuerySpaces() );
    }


    sqlString = sql.toQueryString();


    if ( holderClass != null ) holderConstructor = ReflectHelper.getConstructor( holderClass, returnTypes );


    if ( hasScalars ) {
      actualReturnTypes = returnTypes;

View Full Code Here

Examples of org.hibernate.sql.QuerySelect

    returnTypes = new Type[scalarSize];
    for ( int i = 0; i < scalarSize; i++ ) {
      returnTypes[i] = ( Type ) scalarTypes.get( i );
    }


    QuerySelect sql = new QuerySelect( getFactory().getDialect() );
    sql.setDistinct( distinct );


    if ( !shallowQuery ) {
      renderIdentifierSelect( sql );
      renderPropertiesSelect( sql );
    }


    if ( collectionPersister != null ) {
      sql.addSelectFragmentString( collectionPersister.selectFragment( fetchName, "__" ) );
    }


    if ( hasScalars || shallowQuery ) sql.addSelectFragmentString( scalarSelect );


    //TODO: for some dialects it would be appropriate to add the renderOrderByPropertiesSelect() to other select strings
    mergeJoins( sql.getJoinFragment() );


    sql.setWhereTokens( whereTokens.iterator() );


    sql.setGroupByTokens( groupByTokens.iterator() );
    sql.setHavingTokens( havingTokens.iterator() );
    sql.setOrderByTokens( orderByTokens.iterator() );


    if ( collectionPersister != null && collectionPersister.hasOrdering() ) {
      sql.addOrderBy( collectionPersister.getSQLOrderByString( fetchName ) );
    }


    scalarColumnNames = NameGenerator.generateColumnNames( returnTypes, getFactory() );


    // initialize the Set of queried identifier spaces (ie. tables)
    Iterator iter = collections.values().iterator();
    while ( iter.hasNext() ) {
      CollectionPersister p = getCollectionPersister( ( String ) iter.next() );
      addQuerySpaces( p.getCollectionSpaces() );
    }
    iter = typeMap.keySet().iterator();
    while ( iter.hasNext() ) {
      Queryable p = getEntityPersisterForName( ( String ) iter.next() );
      addQuerySpaces( p.getQuerySpaces() );
    }


    sqlString = sql.toQueryString();


    if ( holderClass != null ) holderConstructor = ReflectHelper.getConstructor( holderClass, returnTypes );


    if ( hasScalars ) {
      actualReturnTypes = returnTypes;

View Full Code Here

Examples of org.hibernate.sql.QuerySelect

    returnTypes = new Type[scalarSize];
    for ( int i = 0; i < scalarSize; i++ ) {
      returnTypes[i] = ( Type ) scalarTypes.get( i );
    }


    QuerySelect sql = new QuerySelect( getFactory().getDialect() );
    sql.setDistinct( distinct );


    if ( !shallowQuery ) {
      renderIdentifierSelect( sql );
      renderPropertiesSelect( sql );
    }


    if ( collectionPersister != null ) {
      sql.addSelectFragmentString( collectionPersister.selectFragment( fetchName, "__" ) );
    }


    if ( hasScalars || shallowQuery ) sql.addSelectFragmentString( scalarSelect );


    //TODO: for some dialects it would be appropriate to add the renderOrderByPropertiesSelect() to other select strings
    mergeJoins( sql.getJoinFragment() );


    sql.setWhereTokens( whereTokens.iterator() );


    sql.setGroupByTokens( groupByTokens.iterator() );
    sql.setHavingTokens( havingTokens.iterator() );
    sql.setOrderByTokens( orderByTokens.iterator() );


    if ( collectionPersister != null && collectionPersister.hasOrdering() ) {
      sql.addOrderBy( collectionPersister.getSQLOrderByString( fetchName ) );
    }


    scalarColumnNames = NameGenerator.generateColumnNames( returnTypes, getFactory() );


    // initialize the Set of queried identifier spaces (ie. tables)
    Iterator iter = collections.values().iterator();
    while ( iter.hasNext() ) {
      CollectionPersister p = getCollectionPersister( ( String ) iter.next() );
      addQuerySpaces( p.getCollectionSpaces() );
    }
    iter = typeMap.keySet().iterator();
    while ( iter.hasNext() ) {
      Queryable p = getEntityPersisterForName( ( String ) iter.next() );
      addQuerySpaces( p.getQuerySpaces() );
    }


    sqlString = sql.toQueryString();


    if ( holderClass != null ) holderConstructor = ReflectHelper.getConstructor( holderClass, returnTypes );


    if ( hasScalars ) {
      actualReturnTypes = returnTypes;

View Full Code Here

Examples of org.hibernate.sql.QuerySelect

    returnTypes = new Type[scalarSize];
    for ( int i = 0; i < scalarSize; i++ ) {
      returnTypes[i] = ( Type ) scalarTypes.get( i );
    }


    QuerySelect sql = new QuerySelect( getFactory().getDialect() );
    sql.setDistinct( distinct );


    if ( !shallowQuery ) {
      renderIdentifierSelect( sql );
      renderPropertiesSelect( sql );
    }


    if ( collectionPersister != null ) {
      sql.addSelectFragmentString( collectionPersister.selectFragment( fetchName, "__" ) );
    }


    if ( hasScalars || shallowQuery ) sql.addSelectFragmentString( scalarSelect );


    //TODO: for some dialects it would be appropriate to add the renderOrderByPropertiesSelect() to other select strings
    mergeJoins( sql.getJoinFragment() );


    sql.setWhereTokens( whereTokens.iterator() );


    sql.setGroupByTokens( groupByTokens.iterator() );
    sql.setHavingTokens( havingTokens.iterator() );
    sql.setOrderByTokens( orderByTokens.iterator() );


    if ( collectionPersister != null && collectionPersister.hasOrdering() ) {
      sql.addOrderBy( collectionPersister.getSQLOrderByString( fetchName ) );
    }


    scalarColumnNames = NameGenerator.generateColumnNames( returnTypes, getFactory() );


    // initialize the Set of queried identifier spaces (ie. tables)
    Iterator iter = collections.values().iterator();
    while ( iter.hasNext() ) {
      CollectionPersister p = getCollectionPersister( ( String ) iter.next() );
      addQuerySpaces( p.getCollectionSpaces() );
    }
    iter = typeMap.keySet().iterator();
    while ( iter.hasNext() ) {
      Queryable p = getEntityPersisterForName( ( String ) iter.next() );
      addQuerySpaces( p.getQuerySpaces() );
    }


    sqlString = sql.toQueryString();


    if ( holderClass != null ) holderConstructor = ReflectHelper.getConstructor( holderClass, returnTypes );


    if ( hasScalars ) {
      actualReturnTypes = returnTypes;

View Full Code Here

0 1 2 3

TOP

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.