Exemplos de Xiag\Rql\Parser\Query::setLimit em PHP

Exemplo n.º 1

Arquivo: TickerStaticMethodCallbackTest.php Projeto: avz-cmf/zaboy-scheduler

 protected static function callbackCommon($options)
 {
     /** @var \Zend\ServiceManager\ServiceManager $container */
     $container = (include './config/container.php');
     if (!$container->has(self::$logServiceName)) {
         throw new \Exception("The service \"" . self::$logServiceName . "\" must be specified in config/datastore");
     }
     $log = $container->get(self::$logServiceName);
     // Writes to log
     $itemData = array_flip(self::$logItemDataColumns);
     array_walk($itemData, function (&$item, $key) use($options) {
         if (!isset($options[$key])) {
             throw new \Exception("Expected necessary parameter \"{$key}\"");
         }
         $item = $options[$key];
     });
     $log->create($itemData);
     // Clears old records in the log
     if (isset($options['max_log_rows'])) {
         $maxLogRows = $options['max_log_rows'];
     } else {
         $config = $container->get('config')['test_ticker_staticmethod_callback'][self::$callbackType]['callbackParams'];
         $maxLogRows = $config['max_log_rows'];
     }
     $query = new \Xiag\Rql\Parser\Query();
     $query->setSelect(new SelectNode(['id']));
     $query->setLimit(new LimitNode($maxLogRows, $maxLogRows));
     $query->setSort(new SortNode(['id' => '-1']));
     $rowsForDeleting = $log->query($query);
     foreach ($rowsForDeleting as $row) {
         $log->delete($row['id']);
     }
 }

Exemplo n.º 2

Arquivo: ticker_common.php Projeto: avz-cmf/zaboy-scheduler

$options = $commandLineWorker->getCallOptions($_SERVER['argv']);
/** @var Zend\ServiceManager\ServiceManager $container */
$container = (include './config/container.php');
if (!$container->has($serviceName)) {
    throw new Exception("The service \"{$serviceName}\" must be specified in config/datastore");
}
$log = $container->get($serviceName);
// Writes to log
$itemData = array_flip($columns);
array_walk($itemData, function (&$item, $key) use($options) {
    if (!isset($options[$key])) {
        throw new Exception("Expected necessary parameter \"{$key}\"");
    }
    $item = $options[$key];
});
$log->create($itemData);
// Clears old records in the log
if (isset($options['max_log_rows'])) {
    $maxLogRows = $options['max_log_rows'];
} else {
    $config = $container->get('config')['ticker'][$scriptType]['callbackParams'];
    $maxLogRows = $config['max_log_rows'];
}
$query = new \Xiag\Rql\Parser\Query();
$query->setSelect(new SelectNode(['id']));
$query->setLimit(new LimitNode($maxLogRows, $maxLogRows));
$query->setSort(new SortNode(['id' => '-1']));
$rowsForDeleting = $log->query($query);
foreach ($rowsForDeleting as $row) {
    $log->delete($row['id']);
}