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

Example #1

File: TableTest.php Project: liftkit/database

 public function testGetRowByValue()
 {
     $row = $this->childrenTable->getRowByValue('child_name', 'child1');
     $sql = "SELECT parents.*, children.*\n\t\t\t\t\tFROM children\n\t\t\t\t\tLEFT JOIN parents ON children.parent_id = parents.parent_id\n\t\t\t\t\tWHERE child_name = 'child1'";
     $result = self::$pdo->query($sql);
     $this->assertEquals($row->toArray(), $result->fetch(PDO::FETCH_ASSOC));
 }