_res/_libs/interfacesql.class.php

   1 <?php
   2 /**
   3  * Pseudo interface to be implemented (ehm, inherited) by the rest
   4  * of the DB classes.
   5  */
   6 abstract class interfaceSql {
   7         public          $conn,
   8                                 $error,
   9                                 $link;
  10
  11         /**
  12          * just a function to trigger an error in the eventuality of using
  13          * an unsupported DB_TYPE connection (usually because of a config error)
  14          *
  15          * TODO: this can be done more elegantly using an exception in the
  16          *               sqlFactory class
  17          *
  18          * @param string $dbHost
  19          * @param string $dbUser
  20          * @param string $dbPass
  21          */
  22         public function __construct( $dbHost = null, $dbUser = null, $dbPass = null ) {}
  23
  24         public function __destruct() {}
  25
  26         private function connect() {}
  27
  28         public function selectDatabase($incData) {}
  29
  30         public function escape ($incData) {}
  31
  32         public function query($query) {}
  33
  34         public function getRow () {}
  35
  36         public function getAssoc () {}
  37
  38         public function getArray () {}
  39
  40         public function getFirst () {}
  41
  42         public function close () {}
  43
  44         abstract public function _SELECT($incObj);
  45
  46         abstract public function _CREATE();
  47
  48         abstract public function _SET();
  49
  50         abstract public function _INSERT($incOb);
  51
  52         abstract public function _UPDATE($incOb);
  53
  54         abstract public function _FROM($incData);
  55
  56         abstract public function _AND();
  57
  58         abstract public function _OR();
  59
  60         abstract public function _JOIN ($type);
  61
  62         abstract public function _AS($str);
  63
  64         abstract public function _LIMIT($start = 0, $end = 0);
  65
  66         abstract public function _GROUP($incObj = null);
  67
  68         abstract public function _ORDER($orderBys = null);
  69
  70         abstract public function _WHERE ($clause);
  71 }
  72
  73 abstract class interfaceSqlField {
  74         static public $validTypes = array ('INT');
  75         public $name;
  76         private $type;
  77
  78         public function __construct () {}
  79         public function __destruct () {}
  80 }
  81
  82 abstract class interfaceSqlJoin {
  83         private $type,
  84                         $state,
  85                         $leftTable,
  86                         $leftField,
  87                         $rightTable,
  88                         $rightField;
  89
  90         public function __construct () {}
  91         public function __destruct () {}
  92 }
  93
  94 abstract class interfaceSqlResource {
  95         public  $instance;
  96
  97         public function __construct () {}
  98         public function __destruct () {}
  99 }
 100
 101 class interfaceSqlOrder {
 102         public function __construct () {}
 103         public function __destruct () {}
 104 }