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); }