public function countRows() { $cloned = clone $this; $cloned instanceof Query; $cloned->select = 'COUNT(*)'; $cloned->offset = null; $cloned->group = null; return Db::query($cloned->select())->fetchColumn(); }
public static function execute($migrationsInstance) { $executed = Db::query('SELECT alias FROM db_migrations')->fetchAll(\PDO::FETCH_COLUMN); $rc = new \ReflectionClass($migrationsInstance); foreach ($rc->getMethods() as $method) { $method instanceof \ReflectionMethod; // if migration method not executed, run if (!in_array($method->name, $executed)) { // invoke the method try { $method->invoke($migrationsInstance); $failed = false; } catch (\Exception $e) { // when sql error ... $failed = true; } // save flag to migrations table Db::save('db_migrations', array('alias' => $method->name, 'failed' => $failed)); } } }
public static function getGroupPages($groupId) { return Db::query("SELECT page FROM group_pages WHERE group_id = ?", array($groupId))->fetchAll(\PDO::FETCH_COLUMN); }