PHP Database::order_by Examples

Example #1

File: pgsql.php Project: jawngee/HeavyMetal

 /**
  * Generates the null ordering for an order by in a select.  
  * 
  * Some databases don't support this, some do it differently.
  * 
  * @param $column the column being ordered on
  * @param $nulls The null ordering, 'first' or 'last'
  */
 function order_by($order)
 {
     $result = parent::order_by($order);
     if ($order->nulls) {
         $result .= " nulls {$order->nulls}";
     }
     return $result;
 }

Example #2

File: sqlite3.php Project: jawngee/HeavyMetal

 /**
  * Generates the null ordering for an order by in a select.  
  * 
  * Some databases don't support this, some do it differently.
  * 
  * @param $column the column being ordered on
  * @param $nulls The null ordering, 'first' or 'last'
  */
 function order_by($order)
 {
     $result = parent::order_by($order);
     if ($order->nulls) {
         $result = " case when {$order->filter->table_alias}.{$order->field} is null then 1 else 0 end, {$result}";
     }
     return $result;
 }