Examples of org.apache.torque.util.Criteria.addSelectColumn()

org.apache.torque.util.Criteria.addSelectColumn()
Add select column. @param name A String with the name of the select column. @return A modified Criteria object.

     */
    public static boolean checkExists(User user)
        throws DataBackendException, Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(USER_ID);
        criteria.add(USERNAME, user.getName());
        List results = BasePeer.doSelect(criteria);
        if (results.size() > 1)
        {
            throw new DataBackendException("Multiple users named '"

View Full Code Here

    public static boolean checkExists(Permission permission)
        throws DataBackendException, Exception
    {
        Criteria criteria = new Criteria();


        criteria.addSelectColumn(getIdColumn());


        criteria.add(getNameColumn(), permission.getName());


        List results = BasePeer.doSelect(criteria);

View Full Code Here

    public static boolean checkExists(User user)
        throws DataBackendException, Exception
    {
        Criteria criteria = new Criteria();


        criteria.addSelectColumn(getIdColumn());


        criteria.add(getNameColumn(), user.getName());


        List results = BasePeer.doSelect(criteria);

View Full Code Here

    public static boolean checkExists(Role role)
        throws DataBackendException, Exception
    {
        Criteria criteria = new Criteria();


        criteria.addSelectColumn(getIdColumn());


        criteria.add(getNameColumn(), role.getName());


        List results = BasePeer.doSelect(criteria);

View Full Code Here

     */
    public static boolean checkExists(Permission permission)
        throws DataBackendException, Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(PERMISSION_ID);
        criteria.add(NAME, ((SecurityObject) permission).getName());
        List results = BasePeer.doSelect(criteria);
        if (results.size() > 1)
        {
            throw new DataBackendException("Multiple permissions named '"

View Full Code Here

     */
    public static boolean checkExists(Role role)
        throws DataBackendException, Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(ROLE_ID);
        criteria.add(NAME, role.getName());
        List results = BasePeer.doSelect(criteria);
        if (results.size() > 1)
        {
            throw new DataBackendException("Multiple roles named '"

View Full Code Here

     */
    public static boolean checkExists(Group group)
        throws DataBackendException, Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn(GROUP_ID);
        criteria.add(NAME, ((SecurityObject) group).getName());
        List results = BasePeer.doSelect(criteria);
        if (results.size() > 1)
        {
            throw new DataBackendException("Multiple groups named '"

View Full Code Here

    public static boolean checkExists(Group group)
        throws DataBackendException, Exception
    {
        Criteria criteria = new Criteria();


        criteria.addSelectColumn(getIdColumn());


        criteria.add(getNameColumn(), group.getName());


        List results = BasePeer.doSelect(criteria);

View Full Code Here

     */
    public void testSelectClause() throws Exception
    {
        // test double functions in select columns
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("count(distinct(" + BookPeer.BOOK_ID + "))");
        List result = BookPeer.doSelectVillageRecords(criteria);


        // test qualifiers in function in select columns
        criteria = new Criteria();
        criteria.addSelectColumn("count(distinct " + BookPeer.BOOK_ID + ")");

View Full Code Here

        criteria.addSelectColumn("count(distinct(" + BookPeer.BOOK_ID + "))");
        List result = BookPeer.doSelectVillageRecords(criteria);


        // test qualifiers in function in select columns
        criteria = new Criteria();
        criteria.addSelectColumn("count(distinct " + BookPeer.BOOK_ID + ")");
        result = BookPeer.doSelectVillageRecords(criteria);
    }


    /**
     * test the behaviour if a connection is supplied to access the database,

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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.