<?php
namespace PHPFUI\ORM\Table;
class Migration extends \PHPFUI\ORM\Table
{
protected static string $className = '\\' . \PHPFUI\ORM\Record\Migration::class;
public function getHighest() : \PHPFUI\ORM\Record\Migration
{
$sql = 'select count(*) from migration';
$record = new \PHPFUI\ORM\Record\Migration(\PHPFUI\ORM::getValue($sql));
return $record;
}
public function paginate(int $page, int $perPage) : \PHPFUI\ORM\ArrayCursor
{
$offset = ($page - 1) * $perPage;
$sql = "select * from migration order by migrationId desc limit {$offset} {$perPage}";
return \PHPFUI\ORM::getArrayCursor($sql);
}
}