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')"); }
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; }
<?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);