PHP Zend\Db\Sql Delete::getSqlString Beispiele

Beispiel #1

Datei: DeleteTest.php Projekt: razvansividra/pnlzf2-1

 /**
  * @covers Zend\Db\Sql\Delete::getSqlString
  */
 public function testGetSqlString()
 {
     $this->delete->from('foo')->where('x = y');
     $this->assertEquals('DELETE FROM "foo" WHERE x = y', $this->delete->getSqlString());
     // with TableIdentifier
     $this->delete = new Delete();
     $this->delete->from(new TableIdentifier('foo', 'sch'))->where('x = y');
     $this->assertEquals('DELETE FROM "sch"."foo" WHERE x = y', $this->delete->getSqlString());
 }

Beispiel #2

Datei: TableGatewayTestCase.php Projekt: Sam-Burns/table-data-gateway

 /**
  * @param string $expectedSql
  */
 protected function assertTableGatewayLastSqlDelete($expectedSql)
 {
     $actualSql = $this->delete->getSqlString($this->mysqlPlatform);
     $this->assertSqlEquals($expectedSql, $actualSql);
 }