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 void testRightJoin()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table1.column1");
        criteria.addJoin("table1.column", "table2.column", Criteria.RIGHT_JOIN);
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT table1.column1"
                    + " FROM table1 RIGHT JOIN table2"

View Full Code Here


    public void testRightJoinWithExistingRightTable()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("table1.column1");
        criteria.addJoin("table2.column2", "table3.column3", Criteria.INNER_JOIN);
        criteria.addJoin("table1.column1", "table2.column2", Criteria.RIGHT_JOIN);
        Query query = SqlBuilder.buildQuery(criteria);
        // right join must be converted to left join to satisfy
        // first join condition

View Full Code Here


    public void testInnerJoinImplicitWithAlias()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("alias.column1");
        criteria.addAlias("alias", "table1");
        criteria.addJoin("alias.column", "table2.column");
        Query query = SqlBuilder.buildQuery(criteria);
        assertEquals(
                "SELECT alias.column1 FROM table1 alias, table2"

View Full Code Here


    public void testInnerJoinImplicitWithDefaultSchema()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("*");
        criteria.addJoin("table1.column", "table2.column");
        String oldSchema = database.getSchema();
        try
        {
            database.setSchema("schema1");

View Full Code Here


    public void testInnerJoinImplicitWithAliasAndDefaultSchema()
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("alias.column1");
        criteria.addAlias("alias", "table1");
        criteria.addJoin("alias.column", "table2.column");
        String oldSchema = database.getSchema();
        try
        {

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(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(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(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

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.