public function testDelete()
{
$user = new User();
$user->name = 'John';
$user->save();
$sql = 'SELECT COUNT(*) FROM user';
$this->assertEquals('1', $this->orm->execute($sql)->fetchColumn());
$user->delete();
$this->assertEquals('0', $this->orm->execute($sql)->fetchColumn());
}
protected function setUp()
{
$this->orm = new ORM();
$this->orm->connect('sqlite::memory:');
$sql = <<<'TAG'
CREATE TABLE user (
identifier INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT
)
TAG;
$this->orm->execute($sql);
}
public function testUpdate()
{
$user = new User();
$user->name = 'John';
$user->save();
$user->id = null;
$user->name = 'Jane';
$user->save();
$user->id = null;
$user->name = 'Mark';
$user->save();
$fluentUser = new FluentUser();
$fluentUser->name = 'oops';
$fluentUser->updateAll();
$names = $this->orm->execute('SELECT name FROM user')->fetchAll(\PDO::FETCH_COLUMN);
foreach ($names as $name) {
$this->assertEquals('oops', $name);
}
}
/**
* Creates, executes and returns a statement based on this instance.
*
* @return false|\PDOStatement
*/
public function getStatement()
{
return $this->orm->execute($this->getSql(), $this->parameters);
}
