src/applications/phlux/query/PhluxVariableQuery.php

   1 <?php
   2
   3 final class PhluxVariableQuery
   4   extends PhabricatorCursorPagedPolicyAwareQuery {
   5
   6   private $ids;
   7   private $keys;
   8   private $phids;
   9
  10   public function withIDs(array $ids) {
  11     $this->ids = $ids;
  12     return $this;
  13   }
  14
  15   public function withPHIDs(array $phids) {
  16     $this->phids = $phids;
  17     return $this;
  18   }
  19
  20   public function withKeys(array $keys) {
  21     $this->keys = $keys;
  22     return $this;
  23   }
  24
  25   protected function loadPage() {
  26     $table = new PhluxVariable();
  27     $conn_r = $table->establishConnection('r');
  28
  29     $rows = queryfx_all(
  30       $conn_r,
  31       'SELECT * FROM %T %Q %Q %Q',
  32       $table->getTableName(),
  33       $this->buildWhereClause($conn_r),
  34       $this->buildOrderClause($conn_r),
  35       $this->buildLimitClause($conn_r));
  36
  37     return $table->loadAllFromArray($rows);
  38   }
  39
  40   protected function buildWhereClause(AphrontDatabaseConnection $conn) {
  41     $where = array();
  42
  43     if ($this->ids !== null) {
  44       $where[] = qsprintf(
  45         $conn,
  46         'id IN (%Ld)',
  47         $this->ids);
  48     }
  49
  50     if ($this->keys !== null) {
  51       $where[] = qsprintf(
  52         $conn,
  53         'variableKey IN (%Ls)',
  54         $this->keys);
  55     }
  56
  57     if ($this->phids !== null) {
  58       $where[] = qsprintf(
  59         $conn,
  60         'phid IN (%Ls)',
  61         $this->phids);
  62     }
  63
  64     $where[] = $this->buildPagingClause($conn);
  65
  66     return $this->formatWhereClause($conn, $where);
  67   }
  68
  69   protected function getDefaultOrderVector() {
  70     return array('key');
  71   }
  72
  73   public function getOrderableColumns() {
  74     return array(
  75       'key' => array(
  76         'column' => 'variableKey',
  77         'type' => 'string',
  78         'reverse' => true,
  79         'unique' => true,
  80       ),
  81     );
  82   }
  83
  84   protected function newPagingMapFromPartialObject($object) {
  85     return array(
  86       'id' => (int)$object->getID(),
  87       'key' => $object->getVariableKey(),
  88     );
  89   }
  90
  91   public function getQueryApplicationClass() {
  92     return 'PhabricatorPhluxApplication';
  93   }
  94
  95 }