PHP JoinBook::belongs_to Exemples

Exemple #1

Fichier : ActiveRecordFindTest.php Projet : scorplev/php-activerecord

 public function test_joins_on_model_with_association_and_explicit_joins()
 {
     JoinBook::$belongs_to = array(array('author'));
     JoinBook::first(array('joins' => array('author', 'LEFT JOIN authors a ON(books.secondary_author_id=a.author_id)')));
     $this->assert_true(strpos(JoinBook::table()->last_sql, 'INNER JOIN `authors` ON(`books`.author_id = `authors`.author_id)') !== false);
     $this->assert_true(strpos(JoinBook::table()->last_sql, 'LEFT JOIN authors a ON(books.secondary_author_id=a.author_id)') !== false);
 }

Exemple #2

Fichier : ActiveRecordFindTest.php Projet : J1Duran/ph-web

 public function test_joins_on_model_with_association_and_explicit_joins()
 {
     JoinBook::$belongs_to = array(array('author'));
     JoinBook::first(array('joins' => array('author', 'LEFT JOIN authors a ON(books.secondary_author_id=a.author_id)')));
     $this->assert_sql_has('INNER JOIN authors ON(books.author_id = authors.author_id)', JoinBook::table()->last_sql);
     $this->assert_sql_has('LEFT JOIN authors a ON(books.secondary_author_id=a.author_id)', JoinBook::table()->last_sql);
 }