Example usage for org.hibernate.criterion Projections property

Introduction

In this page you can find the example usage for org.hibernate.criterion Projections property.

Prototype

public static PropertyProjection property(String propertyName)

Source Link

Document

A property value projection

Usage

From source file:com.amalto.core.storage.hibernate.StandardQueryHandler.java

License:Open Source License

@Override
public StorageResults visit(TaskId taskId) {
    String taskIdField = mappings.getMappingFromDatabase(mainType).getDatabaseTaskId();
    if (taskIdField != null) {
        projectionList.add(Projections.property(taskIdField));
    } else {/*from ww w  .  ja v  a  2 s. co  m*/
        EMPTY_STRING_CONSTANT.accept(this);
    }
    return null;
}

From source file:com.amalto.core.storage.hibernate.StandardQueryHandler.java

License:Open Source License

@Override
public StorageResults visit(StagingStatus stagingStatus) {
    projectionList.add(Projections.property(Storage.METADATA_STAGING_STATUS));
    return null;
}

From source file:com.amalto.core.storage.hibernate.StandardQueryHandler.java

License:Open Source License

@Override
public StorageResults visit(StagingError stagingError) {
    projectionList.add(Projections.property(Storage.METADATA_STAGING_ERROR));
    return null;
}

From source file:com.amalto.core.storage.hibernate.StandardQueryHandler.java

License:Open Source License

@Override
public StorageResults visit(StagingSource stagingSource) {
    projectionList.add(Projections.property(Storage.METADATA_STAGING_SOURCE));
    return null;
}

From source file:com.amalto.core.storage.hibernate.StandardQueryHandler.java

License:Open Source License

@Override
public StorageResults visit(StagingBlockKey stagingBlockKey) {
    projectionList.add(Projections.property(Storage.METADATA_STAGING_BLOCK_KEY));
    return null;
}

From source file:com.amalto.core.storage.hibernate.StandardQueryHandler.java

License:Open Source License

@Override
public StorageResults visit(final Field field) {
    final FieldMetadata userFieldMetadata = field.getFieldMetadata();
    ComplexTypeMetadata containingType = getContainingType(userFieldMetadata);
    final Set<String> aliases = getAliases(containingType, field);
    userFieldMetadata.accept(new DefaultMetadataVisitor<Void>() {

        @Override//from  w  w w .  ja  va  2  s . c o  m
        public Void visit(ReferenceFieldMetadata referenceField) {
            // Automatically selects referenced ID in case of FK.
            if (userFieldMetadata instanceof ReferenceFieldMetadata) {
                referenceField.getReferencedField().accept(this);
            }
            return null;
        }

        @Override
        public Void visit(SimpleTypeFieldMetadata simpleField) {
            if (!simpleField.isMany()) {
                for (String alias : aliases) {
                    projectionList.add(Projections.property(alias + '.' + simpleField.getName()));
                }
            } else {
                projectionList.add(new ManyFieldProjection(aliases, simpleField, resolver,
                        (RDBMSDataSource) storage.getDataSource()));
            }
            return null;
        }

        @Override
        public Void visit(EnumerationFieldMetadata enumField) {
            if (!enumField.isMany()) {
                for (String alias : aliases) {
                    projectionList.add(Projections.property(alias + '.' + enumField.getName()));
                }
            } else {
                projectionList.add(new ManyFieldProjection(aliases, enumField, resolver,
                        (RDBMSDataSource) storage.getDataSource()));
            }
            return null;
        }
    });
    return null;
}

From source file:com.ar.dev.tierra.api.dao.impl.ProductoDAOImpl.java

@SuppressWarnings("unchecked")
@Override/* ww w  .  ja v  a  2 s .c  o m*/
public List<Producto> getAll() {
    Criteria criteria = getSession().createCriteria(Producto.class);
    ProjectionList projList = Projections.projectionList();
    projList.add(Projections.property("idProducto"), "idProducto");
    projList.add(Projections.property("marcas"), "marcas");
    projList.add(Projections.property("descripcion"), "descripcion");
    projList.add(Projections.property("colorProducto"), "colorProducto");
    projList.add(Projections.property("cantidadTotal"), "cantidadTotal");
    projList.add(Projections.property("talla"), "talla");
    criteria.add(Restrictions.eq("estadoProducto", true));
    criteria.addOrder(Order.desc("idProducto"));
    criteria.setProjection(Projections.distinct(projList));
    criteria.setResultTransformer(Transformers.aliasToBean(Producto.class));
    List<Producto> list = criteria.list();
    return list;
}

From source file:com.ar.dev.tierra.api.dao.impl.UsuariosDAOImpl.java

@SuppressWarnings("unchecked")
@Override//  w ww .ja va 2 s  .co m
public List<Usuarios> allUsuarios() {
    Criteria criteria = getSession().createCriteria(Usuarios.class);
    criteria.addOrder(Order.asc("idUsuario"));
    ProjectionList projList = Projections.projectionList();
    projList.add(Projections.property("idUsuario"), "idUsuario");
    projList.add(Projections.property("roles"), "roles");
    projList.add(Projections.property("nombre"), "nombre");
    projList.add(Projections.property("apellido"), "apellido");
    projList.add(Projections.property("dni"), "dni");
    projList.add(Projections.property("telefono"), "telefono");
    projList.add(Projections.property("email"), "email");
    projList.add(Projections.property("fechaNacimiento"), "fechaNacimiento");
    projList.add(Projections.property("domicilio"), "domicilio");
    projList.add(Projections.property("estado"), "estado");
    projList.add(Projections.property("ultimaConexion"), "ultimaConexion");
    projList.add(Projections.property("usuarioSucursal"), "usuarioSucursal");
    criteria.setProjection(Projections.distinct(projList));
    criteria.setResultTransformer(Transformers.aliasToBean(Usuarios.class));
    List<Usuarios> us = criteria.list();
    return us;
}

From source file:com.ateam.hibernate.HibernateDAOImpl.java

public List<UserAttr> listUsers() throws DataAccessException, java.sql.SQLException {
    UserAttr obj = null;//from  w  w  w . j  a va 2  s. co  m
    DetachedCriteria critfour = DetachedCriteria.forClass(UserAttr.class);
    critfour.setProjection(Projections.property("userName"));
    List objs = getHibernateTemplate().findByCriteria(critfour);

    return objs;
}

From source file:com.ateam.hibernate.HibernateDAOImpl.java

public List<Questions> listSkills() throws DataAccessException, java.sql.SQLException {
    Questions obj = null;//from  w  w  w.j a  v  a  2  s .com
    DetachedCriteria critfive = DetachedCriteria.forClass(Questions.class);
    critfive.setProjection(Projections.distinct(Projections.property("skillId")));
    List objs = getHibernateTemplate().findByCriteria(critfive);

    return objs;
}