src/Slashworks/BackendBundle/Model/om/BaseUserRolePeer.php
public static function doSelectJoinAll(Criteria $criteria, $con = null, $join_behavior = Criteria::LEFT_JOIN)
    {
        $criteria = clone $criteria;

        // Set the correct dbName if it has not been overridden
        if ($criteria->getDbName() == Propel::getDefaultDB()) {
            $criteria->setDbName(UserRolePeer::DATABASE_NAME);
        }

        UserRolePeer::addSelectColumns($criteria);
        $startcol2 = UserRolePeer::NUM_HYDRATE_COLUMNS;

        UserPeer::addSelectColumns($criteria);
        $startcol3 = $startcol2 + UserPeer::NUM_HYDRATE_COLUMNS;

        RolePeer::addSelectColumns($criteria);
        $startcol4 = $startcol3 + RolePeer::NUM_HYDRATE_COLUMNS;

        $criteria->addJoin(UserRolePeer::USER_ID, UserPeer::ID, $join_behavior);

        $criteria->addJoin(UserRolePeer::ROLE_ID, RolePeer::ID, $join_behavior);

        $stmt = BasePeer::doSelect($criteria, $con);
        $results = array();

        while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
            $key1 = UserRolePeer::getPrimaryKeyHashFromRow($row, 0);
            if (null !== ($obj1 = UserRolePeer::getInstanceFromPool($key1))) {
                // We no longer rehydrate the object, since this can cause data loss.
                // See http://www.propelorm.org/ticket/509
                // $obj1->hydrate($row, 0, true); // rehydrate
            } else {
                $cls = UserRolePeer::getOMClass();

                $obj1 = new $cls();
                $obj1->hydrate($row);
                UserRolePeer::addInstanceToPool($obj1, $key1);
            } // if obj1 already loaded

            // Add objects for joined User rows

            $key2 = UserPeer::getPrimaryKeyHashFromRow($row, $startcol2);
            if ($key2 !== null) {
                $obj2 = UserPeer::getInstanceFromPool($key2);
                if (!$obj2) {

                    $cls = UserPeer::getOMClass();

                    $obj2 = new $cls();
                    $obj2->hydrate($row, $startcol2);
                    UserPeer::addInstanceToPool($obj2, $key2);
                } // if obj2 loaded

                // Add the $obj1 (UserRole) to the collection in $obj2 (User)
                $obj2->addUserRole($obj1);
            } // if joined row not null

            // Add objects for joined Role rows

            $key3 = RolePeer::getPrimaryKeyHashFromRow($row, $startcol3);
            if ($key3 !== null) {
                $obj3 = RolePeer::getInstanceFromPool($key3);
                if (!$obj3) {

                    $cls = RolePeer::getOMClass();

                    $obj3 = new $cls();
                    $obj3->hydrate($row, $startcol3);
                    RolePeer::addInstanceToPool($obj3, $key3);
                } // if obj3 loaded

                // Add the $obj1 (UserRole) to the collection in $obj3 (Role)
                $obj3->addUserRole($obj1);
            } // if joined row not null

            $results[] = $obj1;
        }
        $stmt->closeCursor();

        return $results;
    }
public static function doSelectJoinAll(Criteria $criteria, $con = null, $join_behavior = Criteria::LEFT_JOIN)
    {
        $criteria = clone $criteria;

        // Set the correct dbName if it has not been overridden
        if ($criteria->getDbName() == Propel::getDefaultDB()) {
            $criteria->setDbName(UserRolePeer::DATABASE_NAME);
        }

        UserRolePeer::addSelectColumns($criteria);
        $startcol2 = UserRolePeer::NUM_HYDRATE_COLUMNS;

        UserPeer::addSelectColumns($criteria);
        $startcol3 = $startcol2 + UserPeer::NUM_HYDRATE_COLUMNS;

        RolePeer::addSelectColumns($criteria);
        $startcol4 = $startcol3 + RolePeer::NUM_HYDRATE_COLUMNS;

        $criteria->addJoin(UserRolePeer::USER_ID, UserPeer::ID, $join_behavior);

        $criteria->addJoin(UserRolePeer::ROLE_ID, RolePeer::ID, $join_behavior);

        $stmt = BasePeer::doSelect($criteria, $con);
        $results = array();

        while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
            $key1 = UserRolePeer::getPrimaryKeyHashFromRow($row, 0);
            if (null !== ($obj1 = UserRolePeer::getInstanceFromPool($key1))) {
                // We no longer rehydrate the object, since this can cause data loss.
                // See http://www.propelorm.org/ticket/509
                // $obj1->hydrate($row, 0, true); // rehydrate
            } else {
                $cls = UserRolePeer::getOMClass();

                $obj1 = new $cls();
                $obj1->hydrate($row);
                UserRolePeer::addInstanceToPool($obj1, $key1);
            } // if obj1 already loaded

            // Add objects for joined User rows

            $key2 = UserPeer::getPrimaryKeyHashFromRow($row, $startcol2);
            if ($key2 !== null) {
                $obj2 = UserPeer::getInstanceFromPool($key2);
                if (!$obj2) {

                    $cls = UserPeer::getOMClass();

                    $obj2 = new $cls();
                    $obj2->hydrate($row, $startcol2);
                    UserPeer::addInstanceToPool($obj2, $key2);
                } // if obj2 loaded

                // Add the $obj1 (UserRole) to the collection in $obj2 (User)
                $obj2->addUserRole($obj1);
            } // if joined row not null

            // Add objects for joined Role rows

            $key3 = RolePeer::getPrimaryKeyHashFromRow($row, $startcol3);
            if ($key3 !== null) {
                $obj3 = RolePeer::getInstanceFromPool($key3);
                if (!$obj3) {

                    $cls = RolePeer::getOMClass();

                    $obj3 = new $cls();
                    $obj3->hydrate($row, $startcol3);
                    RolePeer::addInstanceToPool($obj3, $key3);
                } // if obj3 loaded

                // Add the $obj1 (UserRole) to the collection in $obj3 (Role)
                $obj3->addUserRole($obj1);
            } // if joined row not null

            $results[] = $obj1;
        }
        $stmt->closeCursor();

        return $results;
    }
public static function doSelectJoinAll ( Criteria $ criteria , $ con = null , $ join_behavior = Criteria :: LEFT_JOIN ) { $ criteria = clone $ criteria ; // Set the correct dbName if it has not been overridden if ( $ criteria -> getDbName ( ) == Propel :: getDefaultDB ( ) ) { $ criteria -> setDbName ( UserRolePeer :: DATABASE_NAME ) ; } UserRolePeer :: addSelectColumns ( $ criteria ) ; $ startcol2 = UserRolePeer :: NUM_HYDRATE_COLUMNS ; UserPeer :: addSelectColumns ( $ criteria ) ; $ startcol3 = $ startcol2 + UserPeer :: NUM_HYDRATE_COLUMNS ; RolePeer :: addSelectColumns ( $ criteria ) ; $ startcol4 = $ startcol3 + RolePeer :: NUM_HYDRATE_COLUMNS ; $ criteria -> addJoin ( UserRolePeer :: USER_ID , UserPeer :: ID , $ join_behavior ) ; $ criteria -> addJoin ( UserRolePeer :: ROLE_ID , RolePeer :: ID , $ join_behavior ) ; $ stmt = BasePeer :: doSelect ( $ criteria , $ con ) ; $ results = array ( ) ; while ( $ row = $ stmt -> fetch ( PDO :: FETCH_NUM ) ) { $ key1 = UserRolePeer :: getPrimaryKeyHashFromRow ( $ row , 0 ) ; if ( null !== ( $ obj1 = UserRolePeer :: getInstanceFromPool ( $ key1 ) ) ) { // We no longer rehydrate the object, since this can cause data loss. // See http://www.propelorm.org/ticket/509 // $obj1->hydrate($row, 0, true); // rehydrate } else { $ cls = UserRolePeer :: getOMClass ( ) ; $ obj1 = new $ cls ( ) ; $ obj1 -> hydrate ( $ row ) ; UserRolePeer :: addInstanceToPool ( $ obj1 , $ key1 ) ; } // if obj1 already loaded // Add objects for joined User rows $ key2 = UserPeer :: getPrimaryKeyHashFromRow ( $ row , $ startcol2 ) ; if ( $ key2 !== null ) { $ obj2 = UserPeer :: getInstanceFromPool ( $ key2 ) ; if ( ! $ obj2 ) { $ cls = UserPeer :: getOMClass ( ) ; $ obj2 = new $ cls ( ) ; $ obj2 -> hydrate ( $ row , $ startcol2 ) ; UserPeer :: addInstanceToPool ( $ obj2 , $ key2 ) ; } // if obj2 loaded // Add the $obj1 (UserRole) to the collection in $obj2 (User) $ obj2 -> addUserRole ( $ obj1 ) ; } // if joined row not null // Add objects for joined Role rows $ key3 = RolePeer :: getPrimaryKeyHashFromRow ( $ row , $ startcol3 ) ; if ( $ key3 !== null ) { $ obj3 = RolePeer :: getInstanceFromPool ( $ key3 ) ; if ( ! $ obj3 ) { $ cls = RolePeer :: getOMClass ( ) ; $ obj3 = new $ cls ( ) ; $ obj3 -> hydrate ( $ row , $ startcol3 ) ; RolePeer :: addInstanceToPool ( $ obj3 , $ key3 ) ; } // if obj3 loaded // Add the $obj1 (UserRole) to the collection in $obj3 (Role) $ obj3 -> addUserRole ( $ obj1 ) ; } // if joined row not null $ results [ ] = $ obj1 ; } $ stmt -> closeCursor ( ) ; return $ results ; }
Selects a collection of UserRole objects pre-filled with all related objects.

@param      Criteria  $criteria
@param      PropelPDO $con
@param      String    $join_behavior the type of joins to use, defaults to Criteria::LEFT_JOIN
@return array           Array of UserRole objects.
@throws PropelException Any exceptions caught during processing will be
rethrown wrapped into a PropelException.
Selects a collection of UserRole objects pre - filled with all related objects .