PHP Pop\Db Sql::delete Examples

delete() public method

Create a delete statement

public delete ( ) : Update
return	Pop\Db\Sql\Update

Example #1

File: SqlTest.php Project: nicksagona/PopPHP

 public function testDelete()
 {
     $s = new Sql(Db::factory('Sqlite', array('database' => __DIR__ . '/../tmp/test.sqlite')), 'users');
     $s->delete()->orderBy('id')->limit(1);
     $this->assertEquals('DELETE FROM "users" ORDER BY "id" ASC LIMIT 1', $s->render(true));
 }

Example #2

File: Sqlite.php Project: nicksagona/PopPHP

 /**
  * Method to delete a value in cache.
  *
  * @param  string $id
  * @return void
  */
 public function remove($id)
 {
     $this->sqlite->delete()->where()->equalTo('id', $this->sqlite->adapter()->escape(sha1($id)));
     $this->sqlite->adapter()->query($this->sqlite->render(true));
 }