PHP A_Sql_Delete::render Beispiele

Beispiel #1

Datei: DeleteTest.php Projekt: TheProjecter/skeleton

 function testSql_DeleteConstructorArgs()
 {
     $Sql_Delete = new A_Sql_Delete();
     $this->assertEqual($Sql_Delete->render(), '');
     $Sql_Delete = new A_Sql_Delete('foo');
     $this->assertEqual($Sql_Delete->render(), 'DELETE FROM foo');
     $Sql_Delete = new A_Sql_Delete('foo', array('bar' => 1));
     $this->assertEqual($Sql_Delete->render(), "DELETE FROM foo WHERE (bar = 1)");
     $Sql_Delete = new A_Sql_Delete('foo', array('bar' => 1, 'faz' => 'baz'));
     $this->assertEqual($Sql_Delete->render(), "DELETE FROM foo WHERE (bar = 1 AND faz = 'baz')");
 }

Beispiel #2

Datei: Activerecord.php Projekt: TheProjecter/skeleton

 public function delete()
 {
     if (isset($this->_data[$this->key]) && $this->is_loaded) {
         $delete = new A_Sql_Delete();
         $delete->table($this->table)->where($this->key, $this->_data[$this->key]);
         $this->sql = $delete->render();
         $this->db->query($this->sql);
     }
     return $this;
 }

Beispiel #3

Datei: example_delete.php Projekt: TheProjecter/skeleton

<?php

include 'config.php';
$delete = new A_Sql_Delete();
$delete->table('mytable')->where('id =', 1);
echo "A_Sql_Delete::render=" . $delete->render() . '<br/>';
dump($delete);