PHP LiftKit\Database\Schema\Table Table::getRows Examples

Example #1

File: TableTest.php Project: liftkit/database

 public function testAssignChildrenOneToMany()
 {
     $originalChildIds = $this->parentsTable->getChildren('children', 2)->fetchColumn('child_id');
     $assignedChildIds = array(4, 5);
     $this->parentsTable->assignChildren('children', 2, $assignedChildIds);
     $newChildIds = $this->parentsTable->getChildren('children', 2)->fetchColumn('child_id');
     $this->assertEquals($assignedChildIds, $newChildIds);
     $unsetIds = array_diff($originalChildIds, $assignedChildIds);
     $nullIds = $this->childrenTable->getRows($this->connection->createQuery()->whereIn('child_id', $unsetIds)->whereIs('children.parent_id', null))->fetchColumn('child_id');
     $this->assertEquals($unsetIds, $nullIds);
 }