xire28/redbean-traversing

Add traversing through associations with scopes for redbeans

Redbean traversing

Add traversing through associations with scopes for redbeans, _(*1)

Requirements

• PHP >= 5.4.0

Install

Using Composer

composer require xire28/redbean-traversing

Note

This package is composed of two parts: - MulticallProxy to use a collection like an object and apply the operation on all the items simultaneously - SQLConditionBuilder to progressively construct the SQL query filter, _(*2)

Examples

Seeds

• United States of America
  • Alabama
    • Lionel Richie (1949-06-20)
    • Felicia Day (1979-06-28)
  • Alaska
    • Anna Graceman (1999-08-01)
  • Arizona
    • Emma Stone (1988-11-06)
  • Arkansas
• China
  • Gensu
    • Wong Lee (1978-02-01)

Retrieve all persons in the usa

multi()->ownState->ownPerson;
  }
}

$usa = R::load('country', 1);

echo '

'; foreach($usa->people() as $person){ echo "
• {$person->fullName}
"; } echo '

SQL statements generated

SELECT `country`.* FROM `country` WHERE (`id` IN ( 1 ))
SELECT `state`.* FROM `state` WHERE country_id = '1'
SELECT `person`.* FROM `person` WHERE state_id = '1'
SELECT `person`.* FROM `person` WHERE state_id = '2'
SELECT `person`.* FROM `person` WHERE state_id = '3'
SELECT `person`.* FROM `person` WHERE state_id = '4'

Output

- Lionel Richie
- Felicia Day
- Anna Graceman
- Emma Stone

Retrieve all adult persons in the usa

multi()->ownState->isAdult()->ownPerson;
    }
}

class Model_State extends BaseModel
{
    use PersonScope;
}

trait PersonScope {
    public function isAdult(){
        return $this->personOlderThan(17);
    }
    public function personOlderThan($age){
        return $this->where('TIMESTAMPDIFF(YEAR, born_at, CURDATE()) > ?', $age);
    }
}

$usa = R::load('country', 1);
echo '

'; foreach($usa->adultPersons() as $person){ echo "
• {$person->fullName}
"; } echo '

SQL statements generated

SELECT `country`.* FROM `country` WHERE (`id` IN ( 1 ))
SELECT `state`.* FROM `state` WHERE country_id = '1'
SELECT `person`.* FROM `person` WHERE state_id = '1' AND TIMESTAMPDIFF(YEAR, born_at, CURDATE()) > 17
SELECT `person`.* FROM `person` WHERE state_id = '2' AND TIMESTAMPDIFF(YEAR, born_at, CURDATE()) > 17
SELECT `person`.* FROM `person` WHERE state_id = '3' AND TIMESTAMPDIFF(YEAR, born_at, CURDATE()) > 17
SELECT `person`.* FROM `person` WHERE state_id = '4' AND TIMESTAMPDIFF(YEAR, born_at, CURDATE()) > 17

Output

- Lionel Richie
- Felicia Day
- Emma Stone

Build complex queries

';
foreach($usa->multi()->group(function($q){ return $q->where('name LIKE "Ar%"')->_or()->where('name = ?', 'Alabama'); })->ownState->ownPerson as $person){
    echo "

SQL statements generated

SELECT `country`.* FROM `country` WHERE (`id` IN ( 1 ))
SELECT `state`.* FROM `state` WHERE country_id = '1' AND ( name LIKE "Ar%" OR name = 'Alabama' )
SELECT `person`.* FROM `person` WHERE state_id = '1'
SELECT `person`.* FROM `person` WHERE state_id = '3'

Output

- Lionel Richie
- Felicia Day
- Emma Stone