PageRenderTime 81ms CodeModel.GetById 25ms RepoModel.GetById 0ms app.codeStats 1ms

/libs/dibi/dibi.min.php

https://github.com/vrana/mvc-exception-demo
PHP | 1788 lines | 1765 code | 4 blank | 19 comment | 3 complexity | fdbfd30d5494967a62e2557b54c3fd73 MD5 | raw file
    

  1. <?php //netteloader=DibiVariable,IDataSource,IDibiProfiler,IDibiDriver,IDibiResultDriver,IDibiReflector,DibiObject,DibiLazyStorageBase,DibiLazyStorage,DibiException,DibiDriverException,DibiConnection,DibiResult,DibiResultIterator,DibiRow,DibiTranslator,DibiDataSource,DibiFluent,DibiDatabaseInfo,DibiTableInfo,DibiResultInfo,DibiColumnInfo,DibiForeignKeyInfo,DibiIndexInfo,DibiProfiler,dibi,DibiMySqlReflector,DibiMySqlDriver,DibiMySqliDriver,DibiOdbcDriver,DibiPdoDriver,DibiPostgreDriver,DibiSqliteReflector,DibiSqliteDriver,DibiSqlite3Driver
    2. 

  2. 

  3. /**
    4. 

  4.  * dibi - tiny'n'smart database abstraction layer
    5. 

  5.  * ----------------------------------------------
    6. 

  6.  *
    7. 

  7.  * Copyright (c) 2005, 2010 David Grudl (http://davidgrudl.com)
    8. 

  8.  *
    9. 

  9.  * This source file is subject to the "dibi license" that is bundled
    10. 

  10.  * with this package in the file license.txt, and/or GPL license.
    11. 

  11.  *
    12. 

  12.  * For more information please see http://dibiphp.com
    13. 

  13.  *
    14. 

  14.  * @copyright  Copyright (c) 2005, 2010 David Grudl
    15. 

  15.  * @license    http://dibiphp.com/license  dibi license
    16. 

  16.  * @link       http://dibiphp.com
    17. 

  17.  * @package    dibi
    18. 

  18.  */
    19. 

  19. 

  20. if(version_compare(PHP_VERSION,'5.2.0','<')){throw
    21. 

  21. new
    22. 

  22. Exception('dibi needs PHP 5.2.0 or newer.');}@set_magic_quotes_runtime(FALSE);if(!class_exists('NotImplementedException',FALSE)){class
    23. 

  23. NotImplementedException
    24. 

  24. extends
    25. 

  25. LogicException{}}if(!class_exists('NotSupportedException',FALSE)){class
    26. 

  26. NotSupportedException
    27. 

  27. extends
    28. 

  28. LogicException{}}if(!class_exists('MemberAccessException',FALSE)){class
    29. 

  29. MemberAccessException
    30. 

  30. extends
    31. 

  31. LogicException{}}if(!class_exists('InvalidStateException',FALSE)){class
    32. 

  32. InvalidStateException
    33. 

  33. extends
    34. 

  34. RuntimeException{}}if(!class_exists('IOException',FALSE)){class
    35. 

  35. IOException
    36. 

  36. extends
    37. 

  37. RuntimeException{}}if(!class_exists('FileNotFoundException',FALSE)){class
    38. 

  38. FileNotFoundException
    39. 

  39. extends
    40. 

  40. IOException{}}if(!class_exists('PcreException',FALSE)){class
    41. 

  41. PcreException
    42. 

  42. extends
    43. 

  43. Exception{public
    44. 

  44. function
    45. 

  45. __construct(){static$messages=array(PREG_INTERNAL_ERROR=>'Internal error.',PREG_BACKTRACK_LIMIT_ERROR=>'Backtrack limit was exhausted.',PREG_RECURSION_LIMIT_ERROR=>'Recursion limit was exhausted.',PREG_BAD_UTF8_ERROR=>'Malformed UTF-8 data.',5=>'Offset didn\'t correspond to the begin of a valid UTF-8 code point.');$code=preg_last_error();parent::__construct(isset($messages[$code])?$messages[$code]:'Unknown error.',$code);}}}if(!interface_exists('IDebugPanel',FALSE)){interface
    46. 

  46. IDebugPanel{function
    47. 

  47. getTab();function
    48. 

  48. getPanel();function
    49. 

  49. getId();}}if(!class_exists('DateTime53',FALSE)){class
    50. 

  50. DateTime53
    51. 

  51. extends
    52. 

  52. DateTime{public
    53. 

  53. function
    54. 

  54. __sleep(){$this->fix=array($this->format('Y-m-d H:i:s'),$this->getTimezone()->getName());return
    55. 

  55. array('fix');}public
    56. 

  56. function
    57. 

  57. __wakeup(){$this->__construct($this->fix[0],new
    58. 

  58. DateTimeZone($this->fix[1]));unset($this->fix);}public
    59. 

  59. function
    60. 

  60. getTimestamp(){return(int)$this->format('U');}public
    61. 

  61. function
    62. 

  62. setTimestamp($timestamp){return$this->__construct(date('Y-m-d H:i:s',$timestamp),new
    63. 

  63. DateTimeZone($this->getTimezone()->getName()));}}}class
    64. 

  64. DibiVariable
    65. 

  65. extends
    66. 

  66. DateTime53{function
    67. 

  67. __construct($val){parent::__construct($val);}}interface
    68. 

  68. IDataSource
    69. 

  69. extends
    70. 

  70. Countable,IteratorAggregate{}interface
    71. 

  71. IDibiProfiler{const
    72. 

  72. CONNECT=1;const
    73. 

  73. SELECT=4;const
    74. 

  74. INSERT=8;const
    75. 

  75. DELETE=16;const
    76. 

  76. UPDATE=32;const
    77. 

  77. QUERY=60;const
    78. 

  78. BEGIN=64;const
    79. 

  79. COMMIT=128;const
    80. 

  80. ROLLBACK=256;const
    81. 

  81. TRANSACTION=448;const
    82. 

  82. EXCEPTION=512;const
    83. 

  83. ALL=1023;function
    84. 

  84. before(DibiConnection$connection,$event,$sql=NULL);function
    85. 

  85. after($ticket,$result=NULL);function
    86. 

  86. exception(DibiDriverException$exception);}interface
    87. 

  87. IDibiDriver{function
    88. 

  88. connect(array&$config);function
    89. 

  89. disconnect();function
    90. 

  90. query($sql);function
    91. 

  91. getAffectedRows();function
    92. 

  92. getInsertId($sequence);function
    93. 

  93. begin($savepoint=NULL);function
    94. 

  94. commit($savepoint=NULL);function
    95. 

  95. rollback($savepoint=NULL);function
    96. 

  96. getResource();function
    97. 

  97. getReflector();function
    98. 

  98. escape($value,$type);function
    99. 

  99. applyLimit(&$sql,$limit,$offset);}interface
    100. 

  100. IDibiResultDriver{function
    101. 

  101. getRowCount();function
    102. 

  102. seek($row);function
    103. 

  103. fetch($type);function
    104. 

  104. free();function
    105. 

  105. getResultColumns();function
    106. 

  106. getResultResource();function
    107. 

  107. unescape($value,$type);}interface
    108. 

  108. IDibiReflector{function
    109. 

  109. getTables();function
    110. 

  110. getColumns($table);function
    111. 

  111. getIndexes($table);function
    112. 

  112. getForeignKeys($table);}abstract
    113. 

  113. class
    114. 

  114. DibiObject{private
    115. 

  115. static$extMethods;final
    116. 

  116. public
    117. 

  117. function
    118. 

  118. getClass(){return
    119. 

  119. get_class($this);}final
    120. 

  120. public
    121. 

  121. function
    122. 

  122. getReflection(){return
    123. 

  123. new
    124. 

  124. ReflectionObject($this);}public
    125. 

  125. function
    126. 

  126. __call($name,$args){$class=get_class($this);if($name===''){throw
    127. 

  127. new
    128. 

  128. MemberAccessException("Call to class '$class' method without name.");}if(preg_match('#^on[A-Z]#',$name)){$rp=new
    129. 

  129. ReflectionProperty($class,$name);if($rp->isPublic()&&!$rp->isStatic()){$list=$this->$name;if(is_array($list)||$list
    130. 

  130. instanceof
    131. 

  131. Traversable){foreach($list
    132. 

  132. as$handler){if(is_object($handler)){call_user_func_array(array($handler,'__invoke'),$args);}else{call_user_func_array($handler,$args);}}}return
    133. 

  133. NULL;}}if($cb=self::extensionMethod("$class::$name")){array_unshift($args,$this);return
    134. 

  134. call_user_func_array($cb,$args);}throw
    135. 

  135. new
    136. 

  136. MemberAccessException("Call to undefined method $class::$name().");}public
    137. 

  137. static
    138. 

  138. function
    139. 

  139. __callStatic($name,$args){$class=get_called_class();throw
    140. 

  140. new
    141. 

  141. MemberAccessException("Call to undefined static method $class::$name().");}public
    142. 

  142. static
    143. 

  143. function
    144. 

  144. extensionMethod($name,$callback=NULL){if(self::$extMethods===NULL||$name===NULL){$list=get_defined_functions();foreach($list['user']as$fce){$pair=explode('_prototype_',$fce);if(count($pair)===2){self::$extMethods[$pair[1]][$pair[0]]=$fce;self::$extMethods[$pair[1]]['']=NULL;}}if($name===NULL)return
    145. 

  145. NULL;}$name=strtolower($name);$a=strrpos($name,':');if($a===FALSE){$class=strtolower(get_called_class());$l=&self::$extMethods[$name];}else{$class=substr($name,0,$a-1);$l=&self::$extMethods[substr($name,$a+1)];}if($callback!==NULL){$l[$class]=$callback;$l['']=NULL;return
    146. 

  146. NULL;}if(empty($l)){return
    147. 

  147. FALSE;}elseif(isset($l[''][$class])){return$l[''][$class];}$cl=$class;do{$cl=strtolower($cl);if(isset($l[$cl])){return$l[''][$class]=$l[$cl];}}while(($cl=get_parent_class($cl))!==FALSE);foreach(class_implements($class)as$cl){$cl=strtolower($cl);if(isset($l[$cl])){return$l[''][$class]=$l[$cl];}}return$l[''][$class]=FALSE;}public
    148. 

  148. function&__get($name){$class=get_class($this);if($name===''){throw
    149. 

  149. new
    150. 

  150. MemberAccessException("Cannot read a class '$class' property without name.");}$name[0]=$name[0]&"\xDF";$m='get'.$name;if(self::hasAccessor($class,$m)){$val=$this->$m();return$val;}$m='is'.$name;if(self::hasAccessor($class,$m)){$val=$this->$m();return$val;}$name=func_get_arg(0);throw
    151. 

  151. new
    152. 

  152. MemberAccessException("Cannot read an undeclared property $class::\$$name.");}public
    153. 

  153. function
    154. 

  154. __set($name,$value){$class=get_class($this);if($name===''){throw
    155. 

  155. new
    156. 

  156. MemberAccessException("Cannot assign to a class '$class' property without name.");}$name[0]=$name[0]&"\xDF";if(self::hasAccessor($class,'get'.$name)||self::hasAccessor($class,'is'.$name)){$m='set'.$name;if(self::hasAccessor($class,$m)){$this->$m($value);return;}else{$name=func_get_arg(0);throw
    157. 

  157. new
    158. 

  158. MemberAccessException("Cannot assign to a read-only property $class::\$$name.");}}$name=func_get_arg(0);throw
    159. 

  159. new
    160. 

  160. MemberAccessException("Cannot assign to an undeclared property $class::\$$name.");}public
    161. 

  161. function
    162. 

  162. __isset($name){$name[0]=$name[0]&"\xDF";return$name!==''&&self::hasAccessor(get_class($this),'get'.$name);}public
    163. 

  163. function
    164. 

  164. __unset($name){$class=get_class($this);throw
    165. 

  165. new
    166. 

  166. MemberAccessException("Cannot unset the property $class::\$$name.");}private
    167. 

  167. static
    168. 

  168. function
    169. 

  169. hasAccessor($c,$m){static$cache;if(!isset($cache[$c])){$cache[$c]=array_flip(get_class_methods($c));}return
    170. 

  170. isset($cache[$c][$m]);}}abstract
    171. 

  171. class
    172. 

  172. DibiLazyStorageBase{private$callback;public
    173. 

  173. function
    174. 

  174. __construct($callback){$this->setCallback($callback);}public
    175. 

  175. function
    176. 

  176. setCallback($callback){if(!is_callable($callback)){$able=is_callable($callback,TRUE,$textual);throw
    177. 

  177. new
    178. 

  178. InvalidArgumentException("Handler '$textual' is not ".($able?'callable.':'valid PHP callback.'));}$this->callback=$callback;}public
    179. 

  179. function
    180. 

  180. getCallback(){return$this->callback;}}final
    181. 

  181. class
    182. 

  182. DibiLazyStorage
    183. 

  183. extends
    184. 

  184. DibiLazyStorageBase{public
    185. 

  185. function
    186. 

  186. __get($nm){if(is_array($nm)){$nm=$nm[1];}if($nm==''){throw
    187. 

  187. new
    188. 

  188. InvalidStateException('Missing identifier name.');}return$this->$nm=call_user_func($this->getCallback(),$nm);}}class
    189. 

  189. DibiException
    190. 

  190. extends
    191. 

  191. Exception
    192. 

  192. implements
    193. 

  193. IDebugPanel{private$sql;public
    194. 

  194. function
    195. 

  195. __construct($message=NULL,$code=0,$sql=NULL){parent::__construct($message,(int)$code);$this->sql=$sql;}final
    196. 

  196. public
    197. 

  197. function
    198. 

  198. getSql(){return$this->sql;}public
    199. 

  199. function
    200. 

  200. __toString(){return
    201. 

  201. parent::__toString().($this->sql?"\nSQL: ".$this->sql:'');}public
    202. 

  202. function
    203. 

  203. getTab(){return'SQL';}public
    204. 

  204. function
    205. 

  205. getPanel(){return$this->sql?dibi::dump($this->sql,TRUE):NULL;}public
    206. 

  206. function
    207. 

  207. getId(){return
    208. 

  208. __CLASS__;}}class
    209. 

  209. DibiDriverException
    210. 

  210. extends
    211. 

  211. DibiException{private
    212. 

  212. static$errorMsg;public
    213. 

  213. static
    214. 

  214. function
    215. 

  215. tryError(){set_error_handler(array(__CLASS__,'_errorHandler'),E_ALL);self::$errorMsg=NULL;}public
    216. 

  216. static
    217. 

  217. function
    218. 

  218. catchError(&$message){restore_error_handler();$message=self::$errorMsg;self::$errorMsg=NULL;return$message!==NULL;}public
    219. 

  219. static
    220. 

  220. function
    221. 

  221. _errorHandler($code,$message){restore_error_handler();if(ini_get('html_errors')){$message=strip_tags($message);$message=html_entity_decode($message);}self::$errorMsg=$message;}}class
    222. 

  222. DibiConnection
    223. 

  223. extends
    224. 

  224. DibiObject{private$config;private$driver;private$translator;private$profiler;private$connected=FALSE;public
    225. 

  225. function
    226. 

  226. __construct($config,$name=NULL){if(is_string($config)){parse_str($config,$config);}elseif($config
    227. 

  227. instanceof
    228. 

  228. Traversable){$tmp=array();foreach($config
    229. 

  229. as$key=>$val){$tmp[$key]=$val
    230. 

  230. instanceof
    231. 

  231. Traversable?iterator_to_array($val):$val;}$config=$tmp;}elseif(!is_array($config)){throw
    232. 

  232. new
    233. 

  233. InvalidArgumentException('Configuration must be array, string or object.');}self::alias($config,'username','user');self::alias($config,'password','pass');self::alias($config,'host','hostname');self::alias($config,'result|detectTypes','resultDetectTypes');self::alias($config,'result|formatDateTime','resultDateTime');if(!isset($config['driver'])){$config['driver']=dibi::$defaultDriver;}$driver=preg_replace('#[^a-z0-9_]#','_',strtolower($config['driver']));$class="Dibi".$driver."Driver";if(!class_exists($class,FALSE)){ include_once dirname(__FILE__)."/../drivers/$driver.php";if(!class_exists($class,FALSE)){throw
    234. 

  234. new
    235. 

  235. DibiException("Unable to create instance of dibi driver '$class'.");}}$config['name']=$name;$this->config=$config;$this->driver=new$class;$this->translator=new
    236. 

  236. DibiTranslator($this->driver);$profilerCfg=&$config['profiler'];if(is_scalar($profilerCfg)){$profilerCfg=array('run'=>(bool)$profilerCfg,'class'=>strlen($profilerCfg)>1?$profilerCfg:NULL);}if(!empty($profilerCfg['run'])){$class=isset($profilerCfg['class'])?$profilerCfg['class']:'DibiProfiler';if(!class_exists($class)){throw
    237. 

  237. new
    238. 

  238. DibiException("Unable to create instance of dibi profiler '$class'.");}$this->setProfiler(new$class($profilerCfg));}if(!empty($config['substitutes'])){foreach($config['substitutes']as$key=>$value){dibi::addSubst($key,$value);}}if(empty($config['lazy'])){$this->connect();}}public
    239. 

  239. function
    240. 

  240. __destruct(){$this->connected&&$this->disconnect();}final
    241. 

  241. public
    242. 

  242. function
    243. 

  243. connect(){if($this->profiler!==NULL){$ticket=$this->profiler->before($this,IDibiProfiler::CONNECT);}$this->driver->connect($this->config);$this->connected=TRUE;if(isset($ticket)){$this->profiler->after($ticket);}}final
    244. 

  244. public
    245. 

  245. function
    246. 

  246. disconnect(){$this->driver->disconnect();$this->connected=FALSE;}final
    247. 

  247. public
    248. 

  248. function
    249. 

  249. isConnected(){return$this->connected;}final
    250. 

  250. public
    251. 

  251. function
    252. 

  252. getConfig($key=NULL,$default=NULL){if($key===NULL){return$this->config;}elseif(isset($this->config[$key])){return$this->config[$key];}else{return$default;}}public
    253. 

  253. static
    254. 

  254. function
    255. 

  255. alias(&$config,$key,$alias){$foo=&$config;foreach(explode('|',$key)as$key)$foo=&$foo[$key];if(!isset($foo)&&isset($config[$alias])){$foo=$config[$alias];unset($config[$alias]);}}final
    256. 

  256. public
    257. 

  257. function
    258. 

  258. getDriver(){$this->connected||$this->connect();return$this->driver;}final
    259. 

  259. public
    260. 

  260. function
    261. 

  261. query($args){$this->connected||$this->connect();$args=func_get_args();return$this->nativeQuery($this->translator->translate($args));}final
    262. 

  262. public
    263. 

  263. function
    264. 

  264. translate($args){$this->connected||$this->connect();$args=func_get_args();return$this->translator->translate($args);}function
    265. 

  265. sql($args){trigger_error(__METHOD__.'() is deprecated; use translate() instead.',E_USER_NOTICE);$this->connected||$this->connect();$args=func_get_args();return$this->translator->translate($args);}final
    266. 

  266. public
    267. 

  267. function
    268. 

  268. test($args){$this->connected||$this->connect();$args=func_get_args();try{dibi::dump($this->translator->translate($args));return
    269. 

  269. TRUE;}catch(DibiException$e){dibi::dump($e->getSql());return
    270. 

  270. FALSE;}}final
    271. 

  271. public
    272. 

  272. function
    273. 

  273. dataSource($args){$this->connected||$this->connect();$args=func_get_args();return
    274. 

  274. new
    275. 

  275. DibiDataSource($this->translator->translate($args),$this);}final
    276. 

  276. public
    277. 

  277. function
    278. 

  278. nativeQuery($sql){$this->connected||$this->connect();if($this->profiler!==NULL){$event=IDibiProfiler::QUERY;if(preg_match('#\s*(SELECT|UPDATE|INSERT|DELETE)#i',$sql,$matches)){static$events=array('SELECT'=>IDibiProfiler::SELECT,'UPDATE'=>IDibiProfiler::UPDATE,'INSERT'=>IDibiProfiler::INSERT,'DELETE'=>IDibiProfiler::DELETE);$event=$events[strtoupper($matches[1])];}$ticket=$this->profiler->before($this,$event,$sql);}dibi::$sql=$sql;if($res=$this->driver->query($sql)){$res=new
    279. 

  279. DibiResult($res,$this->config['result']);}else{$res=$this->driver->getAffectedRows();}if(isset($ticket)){$this->profiler->after($ticket,$res);}return$res;}public
    280. 

  280. function
    281. 

  281. getAffectedRows(){$this->connected||$this->connect();$rows=$this->driver->getAffectedRows();if(!is_int($rows)||$rows<0)throw
    282. 

  282. new
    283. 

  283. DibiException('Cannot retrieve number of affected rows.');return$rows;}public
    284. 

  284. function
    285. 

  285. affectedRows(){return$this->getAffectedRows();}public
    286. 

  286. function
    287. 

  287. getInsertId($sequence=NULL){$this->connected||$this->connect();$id=$this->driver->getInsertId($sequence);if($id<1)throw
    288. 

  288. new
    289. 

  289. DibiException('Cannot retrieve last generated ID.');return(int)$id;}public
    290. 

  290. function
    291. 

  291. insertId($sequence=NULL){return$this->getInsertId($sequence);}public
    292. 

  292. function
    293. 

  293. begin($savepoint=NULL){$this->connected||$this->connect();if($this->profiler!==NULL){$ticket=$this->profiler->before($this,IDibiProfiler::BEGIN,$savepoint);}$this->driver->begin($savepoint);if(isset($ticket)){$this->profiler->after($ticket);}}public
    294. 

  294. function
    295. 

  295. commit($savepoint=NULL){$this->connected||$this->connect();if($this->profiler!==NULL){$ticket=$this->profiler->before($this,IDibiProfiler::COMMIT,$savepoint);}$this->driver->commit($savepoint);if(isset($ticket)){$this->profiler->after($ticket);}}public
    296. 

  296. function
    297. 

  297. rollback($savepoint=NULL){$this->connected||$this->connect();if($this->profiler!==NULL){$ticket=$this->profiler->before($this,IDibiProfiler::ROLLBACK,$savepoint);}$this->driver->rollback($savepoint);if(isset($ticket)){$this->profiler->after($ticket);}}public
    298. 

  298. function
    299. 

  299. command(){return
    300. 

  300. new
    301. 

  301. DibiFluent($this);}public
    302. 

  302. function
    303. 

  303. select($args){$args=func_get_args();return$this->command()->__call('select',$args);}public
    304. 

  304. function
    305. 

  305. update($table,$args){if(!(is_array($args)||$args
    306. 

  306. instanceof
    307. 

  307. Traversable)){throw
    308. 

  308. new
    309. 

  309. InvalidArgumentException('Arguments must be array or Traversable.');}return$this->command()->update('%n',$table)->set($args);}public
    310. 

  310. function
    311. 

  311. insert($table,$args){if($args
    312. 

  312. instanceof
    313. 

  313. Traversable){$args=iterator_to_array($args);}elseif(!is_array($args)){throw
    314. 

  314. new
    315. 

  315. InvalidArgumentException('Arguments must be array or Traversable.');}return$this->command()->insert()->into('%n',$table,'(%n)',array_keys($args))->values('%l',$args);}public
    316. 

  316. function
    317. 

  317. delete($table){return$this->command()->delete()->from('%n',$table);}public
    318. 

  318. function
    319. 

  319. setProfiler(IDibiProfiler$profiler=NULL){$this->profiler=$profiler;return$this;}public
    320. 

  320. function
    321. 

  321. getProfiler(){return$this->profiler;}public
    322. 

  322. function
    323. 

  323. fetch($args){$args=func_get_args();return$this->query($args)->fetch();}public
    324. 

  324. function
    325. 

  325. fetchAll($args){$args=func_get_args();return$this->query($args)->fetchAll();}public
    326. 

  326. function
    327. 

  327. fetchSingle($args){$args=func_get_args();return$this->query($args)->fetchSingle();}public
    328. 

  328. function
    329. 

  329. fetchPairs($args){$args=func_get_args();return$this->query($args)->fetchPairs();}public
    330. 

  330. function
    331. 

  331. loadFile($file){$this->connected||$this->connect();@set_time_limit(0);$handle=@fopen($file,'r');if(!$handle){throw
    332. 

  332. new
    333. 

  333. FileNotFoundException("Cannot open file '$file'.");}$count=0;$sql='';while(!feof($handle)){$s=fgets($handle);$sql.=$s;if(substr(rtrim($s),-1)===';'){$this->driver->query($sql);$sql='';$count++;}}fclose($handle);return$count;}public
    334. 

  334. function
    335. 

  335. getDatabaseInfo(){$this->connected||$this->connect();return
    336. 

  336. new
    337. 

  337. DibiDatabaseInfo($this->driver->getReflector(),isset($this->config['database'])?$this->config['database']:NULL);}public
    338. 

  338. function
    339. 

  339. __wakeup(){throw
    340. 

  340. new
    341. 

  341. NotSupportedException('You cannot serialize or unserialize '.$this->getClass().' instances.');}public
    342. 

  342. function
    343. 

  343. __sleep(){throw
    344. 

  344. new
    345. 

  345. NotSupportedException('You cannot serialize or unserialize '.$this->getClass().' instances.');}}class
    346. 

  346. DibiResult
    347. 

  347. extends
    348. 

  348. DibiObject
    349. 

  349. implements
    350. 

  350. IDataSource{private$driver;private$types;private$meta;private$fetched=FALSE;private$rowClass='DibiRow';private$dateFormat='';public
    351. 

  351. function
    352. 

  352. __construct($driver,$config){$this->driver=$driver;if(!empty($config['detectTypes'])){$this->detectTypes();}if(!empty($config['formatDateTime'])){$this->dateFormat=is_string($config['formatDateTime'])?$config['formatDateTime']:'';}}final
    353. 

  353. public
    354. 

  354. function
    355. 

  355. getResource(){return$this->getDriver()->getResultResource();}final
    356. 

  356. public
    357. 

  357. function
    358. 

  358. free(){if($this->driver!==NULL){$this->driver->free();$this->driver=$this->meta=NULL;}}private
    359. 

  359. function
    360. 

  360. getDriver(){if($this->driver===NULL){throw
    361. 

  361. new
    362. 

  362. InvalidStateException('Result-set was released from memory.');}return$this->driver;}final
    363. 

  363. public
    364. 

  364. function
    365. 

  365. seek($row){return($row!==0||$this->fetched)?(bool)$this->getDriver()->seek($row):TRUE;}final
    366. 

  366. public
    367. 

  367. function
    368. 

  368. count(){return$this->getDriver()->getRowCount();}final
    369. 

  369. public
    370. 

  370. function
    371. 

  371. getRowCount(){return$this->getDriver()->getRowCount();}final
    372. 

  372. public
    373. 

  373. function
    374. 

  374. rowCount(){return$this->getDriver()->getRowCount();}final
    375. 

  375. public
    376. 

  376. function
    377. 

  377. getIterator(){if(func_num_args()){trigger_error(__METHOD__.' arguments $offset & $limit have been dropped; use SQL clauses instead.',E_USER_WARNING);}return
    378. 

  378. new
    379. 

  379. DibiResultIterator($this);}public
    380. 

  380. function
    381. 

  381. setRowClass($class){$this->rowClass=$class;return$this;}public
    382. 

  382. function
    383. 

  383. getRowClass(){return$this->rowClass;}final
    384. 

  384. public
    385. 

  385. function
    386. 

  386. fetch(){$row=$this->getDriver()->fetch(TRUE);if(!is_array($row))return
    387. 

  387. FALSE;$this->fetched=TRUE;if($this->types!==NULL){foreach($this->types
    388. 

  388. as$col=>$type){if(isset($row[$col])){$row[$col]=$this->convert($row[$col],$type);}}}return
    389. 

  389. new$this->rowClass($row);}final
    390. 

  390. public
    391. 

  391. function
    392. 

  392. fetchSingle(){$row=$this->getDriver()->fetch(TRUE);if(!is_array($row))return
    393. 

  393. FALSE;$this->fetched=TRUE;$value=reset($row);$key=key($row);if(isset($this->types[$key])){return$this->convert($value,$this->types[$key]);}return$value;}final
    394. 

  394. public
    395. 

  395. function
    396. 

  396. fetchAll($offset=NULL,$limit=NULL){$limit=$limit===NULL?-1:(int)$limit;$this->seek((int)$offset);$row=$this->fetch();if(!$row)return
    397. 

  397. array();$data=array();do{if($limit===0)break;$limit--;$data[]=$row;}while($row=$this->fetch());return$data;}final
    398. 

  398. public
    399. 

  399. function
    400. 

  400. fetchAssoc($assoc){if(strpos($assoc,',')!==FALSE){return$this->oldFetchAssoc($assoc);}$this->seek(0);$row=$this->fetch();if(!$row)return
    401. 

  401. array();$data=NULL;$assoc=preg_split('#(\[\]|->|=|\|)#',$assoc,NULL,PREG_SPLIT_DELIM_CAPTURE|PREG_SPLIT_NO_EMPTY);foreach($assoc
    402. 

  402. as$as){if($as!=='[]'&&$as!=='='&&$as!=='->'&&$as!=='|'&&!property_exists($row,$as)){throw
    403. 

  403. new
    404. 

  404. InvalidArgumentException("Unknown column '$as' in associative descriptor.");}}if($as==='->'){array_pop($assoc);}if(empty($assoc)){$assoc[]='[]';}do{$x=&$data;foreach($assoc
    405. 

  405. as$i=>$as){if($as==='[]'){$x=&$x[];}elseif($as==='='){$x=$row->{$assoc[$i+1]};continue
    406. 

  406. 2;}elseif($as==='->'){if($x===NULL){$x=clone$row;$x=&$x->{$assoc[$i+1]};$x=NULL;}else{$x=&$x->{$assoc[$i+1]};}}elseif($as!=='|'){$x=&$x[$row->$as];}}if($x===NULL){$x=$row;}}while($row=$this->fetch());unset($x);return$data;}private
    407. 

  407. function
    408. 

  408. oldFetchAssoc($assoc){$this->seek(0);$row=$this->fetch();if(!$row)return
    409. 

  409. array();$data=NULL;$assoc=explode(',',$assoc);$leaf='@';$last=count($assoc)-1;while($assoc[$last]==='='||$assoc[$last]==='@'){$leaf=$assoc[$last];unset($assoc[$last]);$last--;if($last<0){$assoc[]='#';break;}}do{$x=&$data;foreach($assoc
    410. 

  410. as$i=>$as){if($as==='#'){$x=&$x[];}elseif($as==='='){if($x===NULL){$x=$row->toArray();$x=&$x[$assoc[$i+1]];$x=NULL;}else{$x=&$x[$assoc[$i+1]];}}elseif($as==='@'){if($x===NULL){$x=clone$row;$x=&$x->{$assoc[$i+1]};$x=NULL;}else{$x=&$x->{$assoc[$i+1]};}}else{$x=&$x[$row->$as];}}if($x===NULL){if($leaf==='='){$x=$row->toArray();}else{$x=$row;}}}while($row=$this->fetch());unset($x);return$data;}final
    411. 

  411. public
    412. 

  412. function
    413. 

  413. fetchPairs($key=NULL,$value=NULL){$this->seek(0);$row=$this->fetch();if(!$row)return
    414. 

  414. array();$data=array();if($value===NULL){if($key!==NULL){throw
    415. 

  415. new
    416. 

  416. InvalidArgumentException("Either none or both columns must be specified.");}$tmp=array_keys($row->toArray());$key=$tmp[0];if(count($row)<2){do{$data[]=$row[$key];}while($row=$this->fetch());return$data;}$value=$tmp[1];}else{if(!property_exists($row,$value)){throw
    417. 

  417. new
    418. 

  418. InvalidArgumentException("Unknown value column '$value'.");}if($key===NULL){do{$data[]=$row[$value];}while($row=$this->fetch());return$data;}if(!property_exists($row,$key)){throw
    419. 

  419. new
    420. 

  420. InvalidArgumentException("Unknown key column '$key'.");}}do{$data[$row[$key]]=$row[$value];}while($row=$this->fetch());return$data;}final
    421. 

  421. public
    422. 

  422. function
    423. 

  423. setType($col,$type){$this->types[$col]=$type;return$this;}final
    424. 

  424. public
    425. 

  425. function
    426. 

  426. detectTypes(){foreach($this->getInfo()->getColumns()as$col){$this->types[$col->getName()]=$col->getType();}}final
    427. 

  427. public
    428. 

  428. function
    429. 

  429. setTypes(array$types){$this->types=$types;return$this;}final
    430. 

  430. public
    431. 

  431. function
    432. 

  432. getType($col){return
    433. 

  433. isset($this->types[$col])?$this->types[$col]:NULL;}protected
    434. 

  434. function
    435. 

  435. convert($value,$type){if($value===NULL||$value===FALSE){return
    436. 

  436. NULL;}switch($type){case
    437. 

  437. dibi::TEXT:return(string)$value;case
    438. 

  438. dibi::BINARY:return$this->getDriver()->unescape($value,$type);case
    439. 

  439. dibi::INTEGER:return(int)$value;case
    440. 

  440. dibi::FLOAT:return(float)$value;case
    441. 

  441. dibi::DATE:case
    442. 

  442. dibi::DATETIME:if((int)$value===0){return
    443. 

  443. NULL;}elseif($this->dateFormat===''){return
    444. 

  444. new
    445. 

  445. DateTime53(is_numeric($value)?date('Y-m-d H:i:s',$value):$value);}elseif($this->dateFormat==='U'){return
    446. 

  446. is_numeric($value)?(int)$value:strtotime($value);}elseif(is_numeric($value)){return
    447. 

  447. date($this->dateFormat,$value);}else{$value=new
    448. 

  448. DateTime53($value);return$value->format($this->dateFormat);}case
    449. 

  449. dibi::BOOL:return((bool)$value)&&$value!=='f'&&$value!=='F';default:return$value;}}public
    450. 

  450. function
    451. 

  451. getInfo(){if($this->meta===NULL){$this->meta=new
    452. 

  452. DibiResultInfo($this->getDriver());}return$this->meta;}final
    453. 

  453. public
    454. 

  454. function
    455. 

  455. getColumns(){return$this->getInfo()->getColumns();}public
    456. 

  456. function
    457. 

  457. getColumnNames($fullNames=FALSE){return$this->getInfo()->getColumnNames($fullNames);}final
    458. 

  458. public
    459. 

  459. function
    460. 

  460. dump(){$i=0;$this->seek(0);while($row=$this->fetch()){if($i===0){echo"\n<table class=\"dump\">\n<thead>\n\t<tr>\n\t\t<th>#row</th>\n";foreach($row
    461. 

  461. as$col=>$foo){echo"\t\t<th>".htmlSpecialChars($col)."</th>\n";}echo"\t</tr>\n</thead>\n<tbody>\n";}echo"\t<tr>\n\t\t<th>",$i,"</th>\n";foreach($row
    462. 

  462. as$col){echo"\t\t<td>",htmlSpecialChars($col),"</td>\n";}echo"\t</tr>\n";$i++;}if($i===0){echo'<p><em>empty result set</em></p>';}else{echo"</tbody>\n</table>\n";}}}class
    463. 

  463. DibiResultIterator
    464. 

  464. implements
    465. 

  465. Iterator,Countable{private$result;private$row;private$pointer;public
    466. 

  466. function
    467. 

  467. __construct(DibiResult$result){$this->result=$result;}public
    468. 

  468. function
    469. 

  469. rewind(){$this->pointer=0;$this->result->seek(0);$this->row=$this->result->fetch();}public
    470. 

  470. function
    471. 

  471. key(){return$this->pointer;}public
    472. 

  472. function
    473. 

  473. current(){return$this->row;}public
    474. 

  474. function
    475. 

  475. next(){$this->row=$this->result->fetch();$this->pointer++;}public
    476. 

  476. function
    477. 

  477. valid(){return!empty($this->row);}public
    478. 

  478. function
    479. 

  479. count(){return$this->result->getRowCount();}}class
    480. 

  480. DibiRow
    481. 

  481. implements
    482. 

  482. ArrayAccess,IteratorAggregate,Countable{public
    483. 

  483. function
    484. 

  484. __construct($arr){foreach($arr
    485. 

  485. as$k=>$v)$this->$k=$v;}public
    486. 

  486. function
    487. 

  487. toArray(){return(array)$this;}public
    488. 

  488. function
    489. 

  489. asDateTime($key,$format=NULL){$time=$this[$key];if((int)$time===0){return
    490. 

  490. NULL;}$dt=new
    491. 

  491. DateTime53(is_numeric($time)?date('Y-m-d H:i:s',$time):$time);return$format===NULL?$dt:$dt->format($format);}public
    492. 

  492. function
    493. 

  493. asTimestamp($key){$time=$this[$key];return(int)$time===0?NULL:(is_numeric($time)?(int)$time:strtotime($time));}public
    494. 

  494. function
    495. 

  495. asBool($key){$value=$this[$key];if($value===NULL||$value===FALSE){return$value;}else{return((bool)$value)&&$value!=='f'&&$value!=='F';}}public
    496. 

  496. function
    497. 

  497. asDate($key,$format=NULL){if($format===NULL){return$this->asTimestamp($key);}else{return$this->asDateTime($key,$format===TRUE?NULL:$format);}}final
    498. 

  498. public
    499. 

  499. function
    500. 

  500. count(){return
    501. 

  501. count((array)$this);}final
    502. 

  502. public
    503. 

  503. function
    504. 

  504. getIterator(){return
    505. 

  505. new
    506. 

  506. ArrayIterator($this);}final
    507. 

  507. public
    508. 

  508. function
    509. 

  509. offsetSet($nm,$val){$this->$nm=$val;}final
    510. 

  510. public
    511. 

  511. function
    512. 

  512. offsetGet($nm){return$this->$nm;}final
    513. 

  513. public
    514. 

  514. function
    515. 

  515. offsetExists($nm){return
    516. 

  516. isset($this->$nm);}final
    517. 

  517. public
    518. 

  518. function
    519. 

  519. offsetUnset($nm){unset($this->$nm);}}final
    520. 

  520. class
    521. 

  521. DibiTranslator
    522. 

  522. extends
    523. 

  523. DibiObject{private$driver;private$cursor;private$args;private$hasError;private$comment;private$ifLevel;private$ifLevelStart;private$limit;private$offset;private$identifiers;public
    524. 

  524. function
    525. 

  525. __construct(IDibiDriver$driver){$this->driver=$driver;$this->identifiers=new
    526. 

  526. DibiLazyStorage(array($this,'delimite'));}public
    527. 

  527. function
    528. 

  528. translate(array$args){$args=array_values($args);while(count($args)===1&&is_array($args[0])){$args=array_values($args[0]);}$this->args=$args;$this->limit=-1;$this->offset=0;$this->hasError=FALSE;$commandIns=NULL;$lastArr=NULL;$cursor=&$this->cursor;$cursor=0;$this->ifLevel=$this->ifLevelStart=0;$comment=&$this->comment;$comment=FALSE;$sql=array();while($cursor<count($this->args)){$arg=$this->args[$cursor];$cursor++;if(is_string($arg)){$toSkip=strcspn($arg,'`[\'":%');if(strlen($arg)===$toSkip){$sql[]=$arg;}else{$sql[]=substr($arg,0,$toSkip).preg_replace_callback('/(?=[`[\'":%?])(?:`(.+?)`|\[(.+?)\]|(\')((?:\'\'|[^\'])*)\'|(")((?:""|[^"])*)"|(\'|")|:(\S*?:)([a-zA-Z0-9._]?)|%([a-zA-Z]{1,4})(?![a-zA-Z])|(\?))/s',array($this,'cb'),substr($arg,$toSkip));if(preg_last_error())throw
    529. 

  529. new
    530. 

  530. PcreException;}continue;}if($comment){$sql[]='...';continue;}if($arg
    531. 

  531. instanceof
    532. 

  532. Traversable){$arg=iterator_to_array($arg);}if(is_array($arg)){if(is_string(key($arg))){if($commandIns===NULL){$commandIns=strtoupper(substr(ltrim($this->args[0]),0,6));$commandIns=$commandIns==='INSERT'||$commandIns==='REPLAC';$sql[]=$this->formatValue($arg,$commandIns?'v':'a');}else{if($lastArr===$cursor-1)$sql[]=',';$sql[]=$this->formatValue($arg,$commandIns?'l':'a');}$lastArr=$cursor;continue;}}$sql[]=$this->formatValue($arg,FALSE);}if($comment)$sql[]="*/";$sql=implode(' ',$sql);if($this->hasError){throw
    533. 

  533. new
    534. 

  534. DibiException('SQL translate error',0,$sql);}if($this->limit>-1||$this->offset>0){$this->driver->applyLimit($sql,$this->limit,$this->offset);}return$sql;}public
    535. 

  535. function
    536. 

  536. formatValue($value,$modifier){if($value
    537. 

  537. instanceof
    538. 

  538. Traversable){$value=iterator_to_array($value);}if(is_array($value)){$vx=$kx=array();switch($modifier){case'and':case'or':if(empty($value)){return'1=1';}foreach($value
    539. 

  539. as$k=>$v){if(is_string($k)){$pair=explode('%',$k,2);$k=$this->identifiers->{$pair[0]}.' ';if(!isset($pair[1])){$v=$this->formatValue($v,FALSE);$vx[]=$k.($v==='NULL'?'IS ':'= ').$v;}elseif($pair[1]==='ex'){$vx[]=$k.$this->formatValue($v,'ex');}else{$v=$this->formatValue($v,$pair[1]);$vx[]=$k.($pair[1]==='l'||$pair[1]==='in'?'IN ':($v==='NULL'?'IS ':'= ')).$v;}}else{$vx[]=$this->formatValue($v,'ex');}}return'('.implode(') '.strtoupper($modifier).' (',$vx).')';case'n':foreach($value
    540. 

  540. as$k=>$v){if(is_string($k)){$vx[]=$this->identifiers->$k.(empty($v)?'':' AS '.$v);}else{$pair=explode('%',$v,2);$vx[]=$this->identifiers->{$pair[0]};}}return
    541. 

  541. implode(', ',$vx);case'a':foreach($value
    542. 

  542. as$k=>$v){$pair=explode('%',$k,2);$vx[]=$this->identifiers->{$pair[0]}.'='.$this->formatValue($v,isset($pair[1])?$pair[1]:(is_array($v)?'ex':FALSE));}return
    543. 

  543. implode(', ',$vx);case'in':case'l':foreach($value
    544. 

  544. as$k=>$v){$pair=explode('%',$k,2);$vx[]=$this->formatValue($v,isset($pair[1])?$pair[1]:(is_array($v)?'ex':FALSE));}return'('.(($vx||$modifier==='l')?implode(', ',$vx):'NULL').')';case'v':foreach($value
    545. 

  545. as$k=>$v){$pair=explode('%',$k,2);$kx[]=$this->identifiers->{$pair[0]};$vx[]=$this->formatValue($v,isset($pair[1])?$pair[1]:(is_array($v)?'ex':FALSE));}return'('.implode(', ',$kx).') VALUES ('.implode(', ',$vx).')';case'm':foreach($value
    546. 

  546. as$k=>$v){if(is_array($v)){if(isset($proto)){if($proto!==array_keys($v)){$this->hasError=TRUE;return'**Multi-insert array "'.$k.'" is different.**';}}else{$proto=array_keys($v);}}else{$this->hasError=TRUE;return'**Unexpected type '.gettype($v).'**';}$pair=explode('%',$k,2);$kx[]=$this->identifiers->{$pair[0]};foreach($v
    547. 

  547. as$k2=>$v2){$vx[$k2][]=$this->formatValue($v2,isset($pair[1])?$pair[1]:(is_array($v2)?'ex':FALSE));}}foreach($vx
    548. 

  548. as$k=>$v){$vx[$k]='('.implode(', ',$v).')';}return'('.implode(', ',$kx).') VALUES '.implode(', ',$vx);case'by':foreach($value
    549. 

  549. as$k=>$v){if(is_array($v)){$vx[]=$this->formatValue($v,'ex');}elseif(is_string($k)){$v=(is_string($v)&&strncasecmp($v,'d',1))||$v>0?'ASC':'DESC';$vx[]=$this->identifiers->$k.' '.$v;}else{$vx[]=$this->identifiers->$v;}}return
    550. 

  550. implode(', ',$vx);case'ex':case'sql':$translator=new
    551. 

  551. self($this->driver);return$translator->translate($value);default:foreach($value
    552. 

  552. as$v){$vx[]=$this->formatValue($v,$modifier);}return
    553. 

  553. implode(', ',$vx);}}if($modifier){if($value!==NULL&&!is_scalar($value)&&!($value
    554. 

  554. instanceof
    555. 

  555. DateTime)){$this->hasError=TRUE;return'**Unexpected type '.gettype($value).'**';}switch($modifier){case's':case'bin':case'b':return$value===NULL?'NULL':$this->driver->escape($value,$modifier);case'sN':case'sn':return$value==''?'NULL':$this->driver->escape($value,dibi::TEXT);case'iN':case'in':if($value=='')$value=NULL;case'i':case'u':if(is_string($value)&&preg_match('#[+-]?\d++(e\d+)?$#A',$value)){return$value;}else{return$value===NULL?'NULL':(string)(int)($value+0);}case'f':if(is_string($value)&&is_numeric($value)&&strpos($value,'x')===FALSE){return$value;}else{return$value===NULL?'NULL':rtrim(rtrim(number_format($value+0,5,'.',''),'0'),'.');}case'd':case't':if($value===NULL){return'NULL';}else{if(is_numeric($value)){$value=(int)$value;}elseif(is_string($value)){$value=new
    556. 

  556. DateTime($value);}return$this->driver->escape($value,$modifier);}case'by':case'n':return$this->identifiers->$value;case'ex':case'sql':$value=(string)$value;$toSkip=strcspn($value,'`[\'":');if(strlen($value)!==$toSkip){$value=substr($value,0,$toSkip).preg_replace_callback('/(?=[`[\'":])(?:`(.+?)`|\[(.+?)\]|(\')((?:\'\'|[^\'])*)\'|(")((?:""|[^"])*)"|(\'|")|:(\S*?:)([a-zA-Z0-9._]?))/s',array($this,'cb'),substr($value,$toSkip));if(preg_last_error())throw
    557. 

  557. new
    558. 

  558. PcreException;}return$value;case'SQL':return(string)$value;case'and':case'or':case'a':case'l':case'v':$this->hasError=TRUE;return'**Unexpected type '.gettype($value).'**';default:$this->hasError=TRUE;return"**Unknown or invalid modifier %$modifier**";}}if(is_string($value)){return$this->driver->escape($value,dibi::TEXT);}elseif(is_int($value)){return(string)$value;}elseif(is_float($value)){return
    559. 

  559. rtrim(rtrim(number_format($value,5,'.',''),'0'),'.');}elseif(is_bool($value)){return$this->driver->escape($value,dibi::BOOL);}elseif($value===NULL){return'NULL';}elseif($value
    560. 

  560. instanceof
    561. 

  561. DateTime){return$this->driver->escape($value,dibi::DATETIME);}else{$this->hasError=TRUE;return'**Unexpected '.gettype($value).'**';}}private
    562. 

  562. function
    563. 

  563. cb($matches){if(!empty($matches[11])){$cursor=&$this->cursor;if($cursor>=count($this->args)){$this->hasError=TRUE;return"**Extra placeholder**";}$cursor++;return$this->formatValue($this->args[$cursor-1],FALSE);}if(!empty($matches[10])){$mod=$matches[10];$cursor=&$this->cursor;if($cursor>=count($this->args)&&$mod!=='else'&&$mod!=='end'){$this->hasError=TRUE;return"**Extra modifier %$mod**";}if($mod==='if'){$this->ifLevel++;$cursor++;if(!$this->comment&&!$this->args[$cursor-1]){$this->ifLevelStart=$this->ifLevel;$this->comment=TRUE;return"/*";}return'';}elseif($mod==='else'){if($this->ifLevelStart===$this->ifLevel){$this->ifLevelStart=0;$this->comment=FALSE;return"*/";}elseif(!$this->comment){$this->ifLevelStart=$this->ifLevel;$this->comment=TRUE;return"/*";}}elseif($mod==='end'){$this->ifLevel--;if($this->ifLevelStart===$this->ifLevel+1){$this->ifLevelStart=0;$this->comment=FALSE;return"*/";}return'';}elseif($mod==='ex'){array_splice($this->args,$cursor,1,$this->args[$cursor]);return'';}elseif($mod==='lmt'){if($this->args[$cursor]!==NULL)$this->limit=(int)$this->args[$cursor];$cursor++;return'';}elseif($mod==='ofs'){if($this->args[$cursor]!==NULL)$this->offset=(int)$this->args[$cursor];$cursor++;return'';}else{$cursor++;return$this->formatValue($this->args[$cursor-1],$mod);}}if($this->comment)return'...';if($matches[1])return$this->identifiers->{$matches[1]};if($matches[2])return$this->identifiers->{$matches[2]};if($matches[3])return$this->driver->escape(str_replace("''","'",$matches[4]),dibi::TEXT);if($matches[5])return$this->driver->escape(str_replace('""','"',$matches[6]),dibi::TEXT);if($matches[7]){$this->hasError=TRUE;return'**Alone quote**';}if($matches[8]){$m=substr($matches[8],0,-1);$m=isset(dibi::$substs[$m])?dibi::$substs[$m]:call_user_func(dibi::$substFallBack,$m);return$matches[9]==''?$this->formatValue($m,FALSE):$m.$matches[9];}die('this should be never executed');}public
    564. 

  564. function
    565. 

  565. delimite($value){$value=self::substitute($value);$parts=explode('.',$value);foreach($parts
    566. 

  566. as&$v){if($v!=='*')$v=$this->driver->escape($v,dibi::IDENTIFIER);}return
    567. 

  567. implode('.',$parts);}public
    568. 

  568. static
    569. 

  569. function
    570. 

  570. substitute($value){if(strpos($value,':')!==FALSE){return
    571. 

  571. preg_replace_callback('#:([^:\s]*):#',array(__CLASS__,'subCb'),$value);}return$value;}private
    572. 

  572. static
    573. 

  573. function
    574. 

  574. subCb($m){$m=$m[1];return
    575. 

  575. isset(dibi::$substs[$m])?dibi::$substs[$m]:call_user_func(dibi::$substFallBack,$m);}}class
    576. 

  576. DibiDataSource
    577. 

  577. extends
    578. 

  578. DibiObject
    579. 

  579. implements
    580. 

  580. IDataSource{private$connection;private$sql;private$result;private$count;private$totalCount;private$cols=array();private$sorting=array();private$conds=array();private$offset;private$limit;public
    581. 

  581. function
    582. 

  582. __construct($sql,DibiConnection$connection){if(strpbrk($sql," \t\r\n")===FALSE){$this->sql=$connection->getDriver()->escape($sql,dibi::IDENTIFIER);}else{$this->sql='('.$sql.') t';}$this->connection=$connection;}public
    583. 

  583. function
    584. 

  584. select($col,$as=NULL){if(is_array($col)){$this->cols=$col;}else{$this->cols[$col]=$as;}$this->result=NULL;return$this;}public
    585. 

  585. function
    586. 

  586. where($cond){if(is_array($cond)){$this->conds[]=$cond;}else{$this->conds[]=func_get_args();}$this->result=$this->count=NULL;return$this;}public
    587. 

  587. function
    588. 

  588. orderBy($row,$sorting='ASC'){if(is_array($row)){$this->sorting=$row;}else{$this->sorting[$row]=$sorting;}$this->result=NULL;return$this;}public
    589. 

  589. function
    590. 

  590. applyLimit($limit,$offset=NULL){$this->limit=$limit;$this->offset=$offset;$this->result=$this->count=NULL;return$this;}final
    591. 

  591. public
    592. 

  592. function
    593. 

  593. getConnection(){return$this->connection;}public
    594. 

  594. function
    595. 

  595. getResult(){if($this->result===NULL){$this->result=$this->connection->nativeQuery($this->__toString());}return$this->result;}public
    596. 

  596. function
    597. 

  597. getIterator(){return$this->getResult()->getIterator();}public
    598. 

  598. function
    599. 

  599. fetch(){return$this->getResult()->fetch();}public
    600. 

  600. function
    601. 

  601. fetchSingle(){return$this->getResult()->fetchSingle();}public
    602. 

  602. function
    603. 

  603. fetchAll(){return$this->getResult()->fetchAll();}public
    604. 

  604. function
    605. 

  605. fetchAssoc($assoc){return$this->getResult()->fetchAssoc($assoc);}public
    606. 

  606. function
    607. 

  607. fetchPairs($key=NULL,$value=NULL){return$this->getResult()->fetchPairs($key,$value);}public
    608. 

  608. function
    609. 

  609. release(){$this->result=$this->count=$this->totalCount=NULL;}public
    610. 

  610. function
    611. 

  611. toFluent(){return$this->connection->select('*')->from('(%SQL) AS t',$this->__toString());}public
    612. 

  612. function
    613. 

  613. toDataSource(){return
    614. 

  614. new
    615. 

  615. self($this->__toString(),$this->connection);}public
    616. 

  616. function
    617. 

  617. __toString(){return$this->connection->translate('
    618. 

  618. 			SELECT %n',(empty($this->cols)?'*':$this->cols),'
    619. 

  619. 			FROM %SQL',$this->sql,'
    620. 

  620. 			%ex',$this->conds?array('WHERE %and',$this->conds):NULL,'
    621. 

  621. 			%ex',$this->sorting?array('ORDER BY %by',$this->sorting):NULL,'
    622. 

  622. 			%ofs %lmt',$this->offset,$this->limit);}public
    623. 

  623. function
    624. 

  624. count(){if($this->count===NULL){$this->count=$this->conds||$this->offset||$this->limit?(int)$this->connection->nativeQuery('SELECT COUNT(*) FROM ('.$this->__toString().') AS t')->fetchSingle():$this->getTotalCount();}return$this->count;}public
    625. 

  625. function
    626. 

  626. getTotalCount(){if($this->totalCount===NULL){$this->totalCount=(int)$this->connection->nativeQuery('SELECT COUNT(*) FROM '.$this->sql)->fetchSingle();}return$this->totalCount;}}class
    627. 

  627. DibiFluent
    628. 

  628. extends
    629. 

  629. DibiObject
    630. 

  630. implements
    631. 

  631. IDataSource{const
    632. 

  632. REMOVE=FALSE;public
    633. 

  633. static$masks=array('SELECT'=>array('SELECT','DISTINCT','FROM','WHERE','GROUP BY','HAVING','ORDER BY','LIMIT','OFFSET'),'UPDATE'=>array('UPDATE','SET','WHERE','ORDER BY','LIMIT'),'INSERT'=>array('INSERT','INTO','VALUES','SELECT'),'DELETE'=>array('DELETE','FROM','USING','WHERE','ORDER BY','LIMIT'));public
    634. 

  634. static$modifiers=array('SELECT'=>'%n','FROM'=>'%n','IN'=>'%in','VALUES'=>'%l','SET'=>'%a','WHERE'=>'%and','HAVING'=>'%and','ORDER BY'=>'%by','GROUP BY'=>'%by');public
    635. 

  635. static$separators=array('SELECT'=>',','FROM'=>',','WHERE'=>'AND','GROUP BY'=>',','HAVING'=>'AND','ORDER BY'=>',','LIMIT'=>FALSE,'OFFSET'=>FALSE,'SET'=>',','VALUES'=>',','INTO'=>FALSE);public
    636. 

  636. static$clauseSwitches=array('JOIN'=>'FROM','INNER JOIN'=>'FROM','LEFT JOIN'=>'FROM','RIGHT JOIN'=>'FROM');private$connection;private$command;private$clauses=array();private$flags=array();private$cursor;private
    637. 

  637. static$normalizer;public
    638. 

  638. function
    639. 

  639. __construct(DibiConnection$connection){$this->connection=$connection;if(self::$normalizer===NULL){self::$normalizer=new
    640. 

  640. DibiLazyStorage(array(__CLASS__,'_formatClause'));}}public
    641. 

  641. function
    642. 

  642. __call($clause,$args){$clause=self::$normalizer->$clause;if($this->command===NULL){if(isset(self::$masks[$clause])){$this->clauses=array_fill_keys(self::$masks[$clause],NULL);}$this->cursor=&$this->clauses[$clause];$this->cursor=array();$this->command=$clause;}if(isset(self::$clauseSwitches[$clause])){$this->cursor=&$this->clauses[self::$clauseSwitches[$clause]];}if(array_key_exists($clause,$this->clauses)){$this->cursor=&$this->clauses[$clause];if($args===array(self::REMOVE)){$this->cursor=NULL;return$this;}if(isset(self::$separators[$clause])){$sep=self::$separators[$clause];if($sep===FALSE){$this->cursor=array();}elseif(!empty($this->cursor)){$this->cursor[]=$sep;}}}else{if($args===array(self::REMOVE)){return$this;}$this->cursor[]=$clause;}if($this->cursor===NULL){$this->cursor=array();}if(count($args)===1){$arg=$args[0];if($arg===TRUE){return$this;}elseif(is_string($arg)&&preg_match('#^[a-z:_][a-z0-9_.:]*$#i',$arg)){$args=array('%n',$arg);}elseif($arg
    643. 

  643. instanceof
    644. 

  644. self){$args=array_merge(array('('),$arg->_export(),array(')'));}elseif(is_array($arg)||$arg
    645. 

  645. instanceof
    646. 

  646. Traversable){if(isset(self::$modifiers[$clause])){$args=array(self::$modifiers[$clause],$arg);}elseif(is_string(key($arg))){$args=array('%a',$arg);}}}foreach($args
    647. 

  647. as$arg)$this->cursor[]=$arg;return$this;}public
    648. 

  648. function
    649. 

  649. clause($clause,$remove=FALSE){$this->cursor=&$this->clauses[self::$normalizer->$clause];if($remove){trigger_error(__METHOD__.'(..., TRUE) is deprecated; use removeClause() instead.',E_USER_NOTICE);$this->cursor=NULL;}elseif($this->cursor===NULL){$this->cursor=array();}return$this;}public
    650. 

  650. function
    651. 

  651. removeClause($clause){$this->clauses[self::$normalizer->$clause]=NULL;return$this;}public
    652. 

  652. function
    653. 

  653. setFlag($flag,$value=TRUE){$flag=strtoupper($flag);if($value){$this->flags[$flag]=TRUE;}else{unset($this->flags[$flag]);}return$this;}final
    654. 

  654. public
    655. 

  655. function
    656. 

  656. getFlag($flag){return
    657. 

  657. isset($this->flags[strtoupper($flag)]);}final
    658. 

  658. public
    659. 

  659. function
    660. 

  660. getCommand(){return$this->command;}final
    661. 

  661. public
    662. 

  662. function
    663. 

  663. getConnection(){return$this->connection;}public
    664. 

  664. function
    665. 

  665. execute($return=NULL){$res=$this->connection->query($this->_export());return$return===dibi::IDENTIFIER?$this->connection->getInsertId():$res;}public
    666. 

  666. function
    667. 

  667. fetch(){if($this->command==='SELECT'){return$this->connection->query($this->_export(NULL,array('%lmt',1)))->fetch();}else{return$this->connection->query($this->_export())->fetch();}}public
    668. 

  668. function
    669. 

  669. fetchSingle(){if($this->command==='SELECT'){return$this->connection->query($this->_export(NULL,array('%lmt',1)))->fetchSingle();}else{return$this->connection->query($this->_export())->fetchSingle();}}public
    670. 

  670. function
    671. 

  671. fetchAll($offset=NULL,$limit=NULL){return$this->connection->query($this->_export(NULL,array('%ofs %lmt',$offset,$limit)))->fetchAll();}public
    672. 

  672. function
    673. 

  673. fetchAssoc($assoc){return$this->connection->query($this->_export())->fetchAssoc($assoc);}public
    674. 

  674. function
    675. 

  675. fetchPairs($key=NULL,$value=NULL){return$this->connection->query($this->_export())->fetchPairs($key,$value);}public
    676. 

  676. function
    677. 

  677. getIterator($offset=NULL,$limit=NULL){return$this->connection->query($this->_export(NULL,array('%ofs %lmt',$offset,$limit)))->getIterator();}public
    678. 

  678. function
    679. 

  679. test($clause=NULL){return$this->connection->test($this->_export($clause));}public
    680. 

  680. function
    681. 

  681. count(){return(int)$this->connection->query('SELECT COUNT(*) FROM (%ex',$this->_export(),') AS [data]')->fetchSingle();}public
    682. 

  682. function
    683. 

  683. toDataSource(){return
    684. 

  684. new
    685. 

  685. DibiDataSource($this->connection->translate($this->_export()),$this->connection);}final
    686. 

  686. public
    687. 

  687. function
    688. 

  688. __toString(){return$this->connection->translate($this->_export());}protected
    689. 

  689. function
    690. 

  690. _export($clause=NULL,$args=array()){if($clause===NULL){$data=$this->clauses;}else{$clause=self::$normalizer->$clause;if(array_key_exists($clause,$this->clauses)){$data=array($clause=>$this->clauses[$clause]);}else{return
    691. 

  691. array();}}foreach($data
    692. 

  692. as$clause=>$statement){if($statement!==NULL){$args[]=$clause;if($clause===$this->command&&$this->flags){$args[]=implode(' ',array_keys($this->flags));}foreach($statement
    693. 

  693. as$arg)$args[]=$arg;}}return$args;}public
    694. 

  694. static
    695. 

  695. function
    696. 

  696. _formatClause($s){if($s==='order'||$s==='group'){$s.='By';trigger_error("Did you mean '$s'?",E_USER_NOTICE);}return
    697. 

  697. strtoupper(preg_replace('#[a-z](?=[A-Z])#','$0 ',$s));}public
    698. 

  698. function
    699. 

  699. __clone(){foreach($this->clauses
    700. 

  700. as$clause=>$val){$this->clauses[$clause]=&$val;unset($val);}$this->cursor=&$foo;}}class
    701. 

  701. DibiDatabaseInfo
    702. 

  702. extends
    703. 

  703. DibiObject{private$reflector;private$name;private$tables;public
    704. 

  704. function
    705. 

  705. __construct(IDibiReflector$reflector,$name){$this->reflector=$reflector;$this->name=$name;}public
    706. 

  706. function
    707. 

  707. getName(){return$this->name;}public
    708. 

  708. function
    709. 

  709. getTables(){$this->init();return
    710. 

  710. array_values($this->tables);}public
    711. 

  711. function
    712. 

  712. getTableNames(){$this->init();$res=array();foreach($this->tables
    713. 

  713. as$table){$res[]=$table->getName();}return$res;}public
    714. 

  714. function
    715. 

  715. getTable($name){$name=DibiTranslator::substitute($name);$this->init();$l=strtolower($name);if(isset($this->tables[$l])){return$this->tables[$l];}else{throw
    716. 

  716. new
    717. 

  717. DibiException("Database '$this->name' has no table '$name'.");}}public
    718. 

  718. function
    719. 

  719. hasTable($name){$name=DibiTranslator::substitute($name);$this->init();return
    720. 

  720. isset($this->tables[strtolower($name)]);}protected
    721. 

  721. function
    722. 

  722. init(){if($this->tables===NULL){$this->tables=array();foreach($this->reflector->getTables()as$info){$this->tables[strtolower($info['name'])]=new
    723. 

  723. DibiTableInfo($this->reflector,$info);}}}}class
    724. 

  724. DibiTableInfo
    725. 

  725. extends
    726. 

  726. DibiObject{private$reflector;private$name;private$view;private$columns;private$foreignKeys;private$indexes;private$primaryKey;public
    727. 

  727. function
    728. 

  728. __construct(IDibiReflector$reflector,array$info){$this->reflector=$reflector;$this->name=$info['name'];$this->view=!empty($info['view']);}public
    729. 

  729. function
    730. 

  730. getName(){return$this->name;}public
    731. 

  731. function
    732. 

  732. isView(){return$this->view;}public
    733. 

  733. function
    734. 

  734. getColumns(){$this->initColumns();return
    735. 

  735. array_values($this->columns);}public
    736. 

  736. function
    737. 

  737. getColumnNames(){$this->initColumns();$res=array();foreach($this->columns
    738. 

  738. as$column){$res[]=$column->getName();}return$res;}public
    739. 

  739. function
    740. 

  740. getColumn($name){$name=DibiTranslator::substitute($name);$this->initColumns();$l=strtolower($name);if(isset($this->columns[$l])){return$this->columns[$l];}else{throw
    741. 

  741. new
    742. 

  742. DibiException("Table '$this->name' has no column '$name'.");}}public
    743. 

  743. function
    744. 

  744. hasColumn($name){$name=DibiTranslator::substitute($name);$this->initColumns();return
    745. 

  745. isset($this->columns[strtolower($name)]);}public
    746. 

  746. function
    747. 

  747. getForeignKeys(){$this->initForeignKeys();return$this->foreignKeys;}public
    748. 

  748. function
    749. 

  749. getIndexes(){$this->initIndexes();return$this->indexes;}public
    750. 

  750. function
    751. 

  751. getPrimaryKey(){$this->initIndexes();return$this->primaryKey;}protected
    752. 

  752. function
    753. 

  753. initColumns(){if($this->columns===NULL){$this->columns=array();foreach($this->reflector->getColumns($this->name)as$info){$this->columns[strtolower($info['name'])]=new
    754. 

  754. DibiColumnInfo($this->reflector,$info);}}}protected
    755. 

  755. function
    756. 

  756. initIndexes(){if($this->indexes===NULL){$this->initColumns();$this->indexes=array();foreach($this->reflector->getIndexes($this->name)as$info){foreach($info['columns']as$key=>$name){$info['columns'][$key]=$this->columns[strtolower($name)];}$this->indexes[strtolower($info['name'])]=new
    757. 

  757. DibiIndexInfo($info);if(!empty($info['primary'])){$this->primaryKey=$this->indexes[strtolower($info['name'])];}}}}protected
    758. 

  758. function
    759. 

  759. initForeignKeys(){throw
    760. 

  760. new
    761. 

  761. NotImplementedException;}}class
    762. 

  762. DibiResultInfo
    763. 

  763. extends
    764. 

  764. DibiObject{private$driver;private$columns;private$names;public
    765. 

  765. function
    766. 

  766. __construct(IDibiResultDriver$driver){$this->driver=$driver;}public
    767. 

  767. function
    768. 

  768. getColumns(){$this->initColumns();return
    769. 

  769. array_values($this->columns);}public
    770. 

  770. function
    771. 

  771. getColumnNames($fullNames=FALSE){$this->initColumns();$res=array();foreach($this->columns
    772. 

  772. as$column){$res[]=$fullNames?$column->getFullName():$column->getName();}return$res;}public
    773. 

  773. function
    774. 

  774. getColumn($name){$name=DibiTranslator::substitute($name);$this->initColumns();$l=strtolower($name);if(isset($this->names[$l])){return$this->names[$l];}else{throw
    775. 

  775. new
    776. 

  776. DibiException("Result set has no column '$name'.");}}public
    777. 

  777. function
    778. 

  778. hasColumn($name){$name=DibiTranslator::substitute($name);$this->initColumns();return
    779. 

  779. isset($this->names[strtolower($name)]);}protected
    780. 

  780. function
    781. 

  781. initColumns(){if($this->columns===NULL){$this->columns=array();$reflector=$this->driver
    782. 

  782. instanceof
    783. 

  783. IDibiReflector?$this->driver:NULL;foreach($this->driver->getResultColumns()as$info){$this->columns[]=$this->names[$info['name']]=new
    784. 

  784. DibiColumnInfo($reflector,$info);}}}}class
    785. 

  785. DibiColumnInfo
    786. 

  786. extends
    787. 

  787. DibiObject{private
    788. 

  788. static$types;private$reflector;private$info;public
    789. 

  789. function
    790. 

  790. __construct(IDibiReflector$reflector=NULL,array$info){$this->reflector=$reflector;$this->info=$info;}public
    791. 

  791. function
    792. 

  792. getName(){return$this->info['name'];}public
    793. 

  793. function
    794. 

  794. getFullName(){return
    795. 

  795. isset($this->info['fullname'])?$this->info['fullname']:NULL;}public
    796. 

  796. function
    797. 

  797. hasTable(){return!empty($this->info['table']);}public
    798. 

  798. function
    799. 

  799. getTable(){if(empty($this->info['table'])||!$this->reflector){throw
    800. 

  800. new
    801. 

  801. DibiException("Table is unknown or not available.");}return
    802. 

  802. new
    803. 

  803. DibiTableInfo($this->reflector,array('name'=>$this->info['table']));}public
    804. 

  804. function
    805. 

  805. getTableName(){return
    806. 

  806. isset($this->info['table'])?$this->info['table']:NULL;}public
    807. 

  807. function
    808. 

  808. getType(){if(self::$types===NULL){self::$types=new
    809. 

  809. DibiLazyStorage(array(__CLASS__,'detectType'));}return$this->info['nativetype']?self::$types->{$this->info['nativetype']}:dibi::TEXT;}public
    810. 

  810. function
    811. 

  811. getNativeType(){return$this->info['nativetype'];}public
    812. 

  812. function
    813. 

  813. getSize(){return
    814. 

  814. isset($this->info['size'])?(int)$this->info['size']:NULL;}public
    815. 

  815. function
    816. 

  816. isUnsigned(){return
    817. 

  817. isset($this->info['unsigned'])?(bool)$this->info['unsigned']:NULL;}public
    818. 

  818. function
    819. 

  819. isNullable(){return
    820. 

  820. isset($this->info['nullable'])?(bool)$this->info['nullable']:NULL;}public
    821. 

  821. function
    822. 

  822. isAutoIncrement(){return
    823. 

  823. isset($this->info['autoincrement'])?(bool)$this->info['autoincrement']:NULL;}public
    824. 

  824. function
    825. 

  825. getDefault(){return
    826. 

  826. isset($this->info['default'])?$this->info['default']:NULL;}public
    827. 

  827. function
    828. 

  828. getVendorInfo($key){return
    829. 

  829. isset($this->info['vendor'][$key])?$this->info['vendor'][$key]:NULL;}public
    830. 

  830. static
    831. 

  831. function
    832. 

  832. detectType($type){static$patterns=array('BYTEA|BLOB|BIN'=>dibi::BINARY,'TEXT|CHAR|BIGINT|LONGLONG'=>dibi::TEXT,'BYTE|COUNTER|SERIAL|INT|LONG'=>dibi::INTEGER,'CURRENCY|REAL|MONEY|FLOAT|DOUBLE|DECIMAL|NUMERIC|NUMBER'=>dibi::FLOAT,'^TIME$'=>dibi::TIME,'TIME'=>dibi::DATETIME,'YEAR|DATE'=>dibi::DATE,'BOOL|BIT'=>dibi::BOOL);foreach($patterns
    833. 

  833. as$s=>$val){if(preg_match("#$s#i",$type)){return$val;}}return
    834. 

  834. dibi::TEXT;}}class
    835. 

  835. DibiForeignKeyInfo
    836. 

  836. extends
    837. 

  837. DibiObject{private$name;private$references;public
    838. 

  838. function
    839. 

  839. __construct($name,array$references){$this->name=$name;$this->references=$references;}public
    840. 

  840. function
    841. 

  841. getName(){return$this->name;}public
    842. 

  842. function
    843. 

  843. getReferences(){return$this->references;}}class
    844. 

  844. DibiIndexInfo
    845. 

  845. extends
    846. 

  846. DibiObject{private$info;public
    847. 

  847. function
    848. 

  848. __construct(array$info){$this->info=$info;}public
    849. 

  849. function
    850. 

  850. getName(){return$this->info['name'];}public
    851. 

  851. function
    852. 

  852. getColumns(){return$this->info['columns'];}public
    853. 

  853. function
    854. 

  854. isUnique(){return!empty($this->info['unique']);}public
    855. 

  855. function
    856. 

  856. isPrimary(){return!empty($this->info['primary']);}}class
    857. 

  857. DibiProfiler
    858. 

  858. extends
    859. 

  859. DibiObject
    860. 

  860. implements
    861. 

  861. IDibiProfiler,IDebugPanel{static
    862. 

  862. public$maxQueries=30;static
    863. 

  863. public$maxLength=1000;private$file;public$useFirebug;public$explainQuery=TRUE;private$filter=self::ALL;public
    864. 

  864. static$tickets=array();public
    865. 

  865. static$fireTable=array(array('Time','SQL Statement','Rows','Connection'));public
    866. 

  866. function
    867. 

  867. __construct(array$config){if(class_exists('Debug',FALSE)&&is_callable('Debug::addPanel')){Debug::addPanel($this);}$this->useFirebug=isset($_SERVER['HTTP_USER_AGENT'])&&strpos($_SERVER['HTTP_USER_AGENT'],'FirePHP/');if(isset($config['filter'])){$this->setFilter($config['filter']);}if(isset($config['explain'])){$this->explainQuery=(bool)$config['explain'];}}public
    868. 

  868. function
    869. 

  869. setFile($file){$this->file=$file;return$this;}public
    870. 

  870. function
    871. 

  871. setFilter($filter){$this->filter=(int)$filter;return$this;}public
    872. 

  872. function
    873. 

  873. before(DibiConnection$connection,$event,$sql=NULL){if($event&self::QUERY)dibi::$numOfQueries++;dibi::$elapsedTime=FALSE;self::$tickets[]=array($connection,$event,trim($sql),-microtime(TRUE),NULL,NULL);end(self::$tickets);return
    874. 

  874. key(self::$tickets);}public
    875. 

  875. function
    876. 

  876. after($ticket,$res=NULL){if(!isset(self::$tickets[$ticket])){throw
    877. 

  877. new
    878. 

  878. InvalidArgumentException('Bad ticket number.');}$ticket=&self::$tickets[$ticket];$ticket[3]+=microtime(TRUE);list($connection,$event,$sql,$time)=$ticket;dibi::$elapsedTime=$time;dibi::$totalTime+=$time;if(($event&$this->filter)===0)return;if($event&self::QUERY){try{$ticket[4]=$count=$res
    879. 

  879. instanceof
    880. 

  880. DibiResult?count($res):'-';}catch(Exception$e){$count='?';}if(count(self::$fireTable)<self::$maxQueries){self::$fireTable[]=array(sprintf('%0.3f',$time*1000),strlen($sql)>self::$maxLength?substr($sql,0,self::$maxLength).'...':$sql,$count,$connection->getConfig('driver').'/'.$connection->getConfig('name'));if($this->explainQuery&&$event===self::SELECT){$tmpSql=dibi::$sql;try{$ticket[5]=dibi::dump($connection->setProfiler(NULL)->nativeQuery('EXPLAIN '.$sql),TRUE);}catch(DibiException$e){}$connection->setProfiler($this);dibi::$sql=$tmpSql;}if($this->useFirebug&&!headers_sent()){header('X-Wf-Protocol-dibi: http://meta.wildfirehq.org/Protocol/JsonStream/0.2');header('X-Wf-dibi-Plugin-1: http://meta.firephp.org/Wildfire/Plugin/FirePHP/Library-FirePHPCore/0.2.0');header('X-Wf-dibi-Structure-1: http://meta.firephp.org/Wildfire/Structure/FirePHP/FirebugConsole/0.1');$payload=json_encode(array(array('Type'=>'TABLE','Label'=>'dibi profiler ('.dibi::$numOfQueries.' SQL queries took '.sprintf('%0.3f',dibi::$totalTime*1000).' ms)'),self::$fireTable));foreach(str_split($payload,4990)as$num=>$s){$num++;header("X-Wf-dibi-1-1-d$num: |$s|\\");}header("X-Wf-dibi-1-1-d$num: |$s|");}}if($this->file){$this->writeFile("OK: ".$sql.($res
    881. 

  881. instanceof
    882. 

  882. DibiResult?";\n-- rows: ".$count:'')."\n-- takes: ".sprintf('%0.3f',$time*1000).' ms'."\n-- driver: ".$connection->getConfig('driver').'/'.$connection->getConfig('name')."\n-- ".date('Y-m-d H:i:s')."\n\n");}}}public
    883. 

  883. function
    884. 

  884. exception(DibiDriverException$exception){if((self::EXCEPTION&$this->filter)===0)return;if($this->useFirebug){}if($this->file){$message=$exception->getMessage();$code=$exception->getCode();if($code){$message="[$code] $message";}$this->writeFile("ERROR: $message"."\n-- SQL: ".dibi::$sql."\n-- driver: ".";\n-- ".date('Y-m-d H:i:s')."\n\n");}}private
    885. 

  885. function
    886. 

  886. writeFile($message){$handle=fopen($this->file,'a');if(!$handle)return;flock($handle,LOCK_EX);fwrite($handle,$message);fclose($handle);}public
    887. 

  887. function
    888. 

  888. getTab(){return'<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAQAAAC1+jfqAAAABGdBTUEAAK/INwWK6QAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAEYSURBVBgZBcHPio5hGAfg6/2+R980k6wmJgsJ5U/ZOAqbSc2GnXOwUg7BESgLUeIQ1GSjLFnMwsKGGg1qxJRmPM97/1zXFAAAAEADdlfZzr26miup2svnelq7d2aYgt3rebl585wN6+K3I1/9fJe7O/uIePP2SypJkiRJ0vMhr55FLCA3zgIAOK9uQ4MS361ZOSX+OrTvkgINSjS/HIvhjxNNFGgQsbSmabohKDNoUGLohsls6BaiQIMSs2FYmnXdUsygQYmumy3Nhi6igwalDEOJEjPKP7CA2aFNK8Bkyy3fdNCg7r9/fW3jgpVJbDmy5+PB2IYp4MXFelQ7izPrhkPHB+P5/PjhD5gCgCenx+VR/dODEwD+A3T7nqbxwf1HAAAAAElFTkSuQmCC">'.dibi::$numOfQueries.' queries';}public
    889. 

  889. function
    890. 

  890. getPanel(){if(!dibi::$numOfQueries)return;$content="
    891. 

  891. <h1>Queries: ".dibi::$numOfQueries.(dibi::$totalTime===NULL?'':', time: '.sprintf('%0.3f',dibi::$totalTime*1000).' ms')."</h1>
    892. 

  892. 

  893. <style>
    894. 

  894. 	#nette-debug-DibiProfiler td.dibi-sql { background: white }
    895. 

  895. 	#nette-debug-DibiProfiler .nette-alt td.dibi-sql { background: #F5F5F5 }
    896. 

  896. 	#nette-debug-DibiProfiler .dibi-sql div { display: none; margin-top: 10px; max-height: 150px; overflow:auto }
    897. 

  897. </style>
    898. 

  898. 

  899. <div class='nette-inner'>
    900. 

  900. <table>
    901. 

  901. <tr>
    902. 

  902. 	<th>Time</th><th>SQL Statement</th><th>Rows</th><th>Connection</th>
    903. 

  903. </tr>
    904. 

  904. ";$i=0;$classes=array('class="nette-alt"','');foreach(self::$tickets
    905. 

  905. as$ticket){list($connection,$event,$sql,$time,$count,$explain)=$ticket;if(!($event&self::QUERY))continue;$content.="
    906. 

  906. <tr {$classes[++$i%2]}>
    907. 

  907. 	<td>".sprintf('%0.3f',$time*1000).($explain?"
    908. 

  908. 	<br><a href='#' class='nette-toggler' rel='#nette-debug-DibiProfiler-row-$i'>explain&nbsp;&#x25ba;</a>":'')."</td>
    909. 

  909. 	<td class='dibi-sql'>".dibi::dump(strlen($sql)>self::$maxLength?substr($sql,0,self::$maxLength).'...':$sql,TRUE).($explain?"
    910. 

  910. 	<div id='nette-debug-DibiProfiler-row-$i'>{$explain}</div>":'')."</td>
    911. 

  911. 	<td>{$count}</td>
    912. 

  912. 	<td>".htmlSpecialChars($connection->getConfig('driver').'/'.$connection->getConfig('name'))."</td>
    913. 

  913. </tr>
    914. 

  914. ";}$content.='</table></div>';return$content;}public
    915. 

  915. function
    916. 

  916. getId(){return
    917. 

  917. get_class($this);}}class
    918. 

  918. dibi{const
    919. 

  919. TEXT='s';const
    920. 

  920. BINARY='bin';const
    921. 

  921. BOOL='b';const
    922. 

  922. INTEGER='i';const
    923. 

  923. FLOAT='f';const
    924. 

  924. DATE='d';const
    925. 

  925. DATETIME='t';const
    926. 

  926. TIME='t';const
    927. 

  927. IDENTIFIER='n';const
    928. 

  928. FIELD_TEXT=self::TEXT;const
    929. 

  929. FIELD_BINARY=self::BINARY;const
    930. 

  930. FIELD_BOOL=self::BOOL;const
    931. 

  931. FIELD_INTEGER=self::INTEGER;const
    932. 

  932. FIELD_FLOAT=self::FLOAT;const
    933. 

  933. FIELD_DATE=self::DATE;const
    934. 

  934. FIELD_DATETIME=self::DATETIME;const
    935. 

  935. FIELD_TIME=self::TIME;const
    936. 

  936. VERSION='1.3-dev';const
    937. 

  937. REVISION='8dc164d released on 2010-08-05';const
    938. 

  938. ASC='ASC',DESC='DESC';private
    939. 

  939. static$registry=array();private
    940. 

  940. static$connection;public
    941. 

  941. static$substs=array();public
    942. 

  942. static$substFallBack=array(__CLASS__,'defaultSubstFallback');private
    943. 

  943. static$handlers=array();public
    944. 

  944. static$sql;public
    945. 

  945. static$elapsedTime;public
    946. 

  946. static$totalTime;public
    947. 

  947. static$numOfQueries=0;public
    948. 

  948. static$defaultDriver='mysql';final
    949. 

  949. public
    950. 

  950. function
    951. 

  951. __construct(){throw
    952. 

  952. new
    953. 

  953. LogicException("Cannot instantiate static class ".get_class($this));}public
    954. 

  954. static
    955. 

  955. function
    956. 

  956. connect($config=array(),$name=0){return
    957. 

  957. self::$connection=self::$registry[$name]=new
    958. 

  958. DibiConnection($config,$name);}public
    959. 

  959. static
    960. 

  960. function
    961. 

  961. disconnect(){self::getConnection()->disconnect();}public
    962. 

  962. static
    963. 

  963. function
    964. 

  964. isConnected(){return(self::$connection!==NULL)&&self::$connection->isConnected();}public
    965. 

  965. static
    966. 

  966. function
    967. 

  967. getConnection($name=NULL){if($name===NULL){if(self::$connection===NULL){throw
    968. 

  968. new
    969. 

  969. DibiException('Dibi is not connected to database.');}return
    970. 

  970. self::$connection;}if(!isset(self::$registry[$name])){throw
    971. 

  971. new
    972. 

  972. DibiException("There is no connection named '$name'.");}return
    973. 

  973. self::$registry[$name];}public
    974. 

  974. static
    975. 

  975. function
    976. 

  976. activate($name){self::$connection=self::getConnection($name);}public
    977. 

  977. static
    978. 

  978. function
    979. 

  979. getProfiler(){return
    980. 

  980. self::getConnection()->getProfiler();}public
    981. 

  981. static
    982. 

  982. function
    983. 

  983. query($args){$args=func_get_args();return
    984. 

  984. self::getConnection()->query($args);}public
    985. 

  985. static
    986. 

  986. function
    987. 

  987. nativeQuery($sql){return
    988. 

  988. self::getConnection()->nativeQuery($sql);}public
    989. 

  989. static
    990. 

  990. function
    991. 

  991. test($args){$args=func_get_args();return
    992. 

  992. self::getConnection()->test($args);}public
    993. 

  993. static
    994. 

  994. function
    995. 

  995. dataSource($args){$args=func_get_args();return
    996. 

  996. self::getConnection()->dataSource($args);}public
    997. 

  997. static
    998. 

  998. function
    999. 

  999. fetch($args){$args=func_get_args();return
    1000. 

  1000. self::getConnection()->query($args)->fetch();}public
    1001. 

  1001. static
    1002. 

  1002. function
    1003. 

  1003. fetchAll($args){$args=func_get_args();return
    1004. 

  1004. self::getConnection()->query($args)->fetchAll();}public
    1005. 

  1005. static
    1006. 

  1006. function
    1007. 

  1007. fetchSingle($args){$args=func_get_args();return
    1008. 

  1008. self::getConnection()->query($args)->fetchSingle();}public
    1009. 

  1009. static
    1010. 

  1010. function
    1011. 

  1011. fetchPairs($args){$args=func_get_args();return
    1012. 

  1012. self::getConnection()->query($args)->fetchPairs();}public
    1013. 

  1013. static
    1014. 

  1014. function
    1015. 

  1015. getAffectedRows(){return
    1016. 

  1016. self::getConnection()->getAffectedRows();}public
    1017. 

  1017. static
    1018. 

  1018. function
    1019. 

  1019. affectedRows(){return
    1020. 

  1020. self::getConnection()->getAffectedRows();}public
    1021. 

  1021. static
    1022. 

  1022. function
    1023. 

  1023. getInsertId($sequence=NULL){return
    1024. 

  1024. self::getConnection()->getInsertId($sequence);}public
    1025. 

  1025. static
    1026. 

  1026. function
    1027. 

  1027. insertId($sequence=NULL){return
    1028. 

  1028. self::getConnection()->getInsertId($sequence);}public
    1029. 

  1029. static
    1030. 

  1030. function
    1031. 

  1031. begin($savepoint=NULL){self::getConnection()->begin($savepoint);}public
    1032. 

  1032. static
    1033. 

  1033. function
    1034. 

  1034. commit($savepoint=NULL){self::getConnection()->commit($savepoint);}public
    1035. 

  1035. static
    1036. 

  1036. function
    1037. 

  1037. rollback($savepoint=NULL){self::getConnection()->rollback($savepoint);}public
    1038. 

  1038. static
    1039. 

  1039. function
    1040. 

  1040. getDatabaseInfo(){return
    1041. 

  1041. self::getConnection()->getDatabaseInfo();}public
    1042. 

  1042. static
    1043. 

  1043. function
    1044. 

  1044. loadFile($file){return
    1045. 

  1045. self::getConnection()->loadFile($file);}public
    1046. 

  1046. static
    1047. 

  1047. function
    1048. 

  1048. __callStatic($name,$args){return
    1049. 

  1049. call_user_func_array(array(self::getConnection(),$name),$args);}public
    1050. 

  1050. static
    1051. 

  1051. function
    1052. 

  1052. command(){return
    1053. 

  1053. self::getConnection()->command();}public
    1054. 

  1054. static
    1055. 

  1055. function
    1056. 

  1056. select($args){$args=func_get_args();return
    1057. 

  1057. call_user_func_array(array(self::getConnection(),'select'),$args);}public
    1058. 

  1058. static
    1059. 

  1059. function
    1060. 

  1060. update($table,$args){return
    1061. 

  1061. self::getConnection()->update($table,$args);}public
    1062. 

  1062. static
    1063. 

  1063. function
    1064. 

  1064. insert($table,$args){return
    1065. 

  1065. self::getConnection()->insert($table,$args);}public
    1066. 

  1066. static
    1067. 

  1067. function
    1068. 

  1068. delete($table){return
    1069. 

  1069. self::getConnection()->delete($table);}public
    1070. 

  1070. static
    1071. 

  1071. function
    1072. 

  1072. datetime($time=NULL){return
    1073. 

  1073. new
    1074. 

  1074. DateTime53(is_numeric($time)?date('Y-m-d H:i:s',$time):$time);}public
    1075. 

  1075. static
    1076. 

  1076. function
    1077. 

  1077. date($date=NULL){return
    1078. 

  1078. new
    1079. 

  1079. DateTime53(is_numeric($date)?date('Y-m-d',$date):$date);}public
    1080. 

  1080. static
    1081. 

  1081. function
    1082. 

  1082. addSubst($expr,$subst){if($expr===''){trigger_error(__METHOD__.': empty substitutions will probably be deprecated.',E_USER_NOTICE);}self::$substs[$expr]=$subst;}public
    1083. 

  1083. static
    1084. 

  1084. function
    1085. 

  1085. removeSubst($expr){if($expr===TRUE){self::$substs=array();}else{unset(self::$substs[$expr]);}}public
    1086. 

  1086. static
    1087. 

  1087. function
    1088. 

  1088. setSubstFallback($callback){if(!is_callable($callback)){$able=is_callable($callback,TRUE,$textual);throw
    1089. 

  1089. new
    1090. 

  1090. InvalidArgumentException("Handler '$textual' is not ".($able?'callable.':'valid PHP callback.'));}self::$substFallBack=$callback;}public
    1091. 

  1091. static
    1092. 

  1092. function
    1093. 

  1093. defaultSubstFallback($expr){throw
    1094. 

  1094. new
    1095. 

  1095. InvalidStateException("Missing substitution for '$expr' expression.");}public
    1096. 

  1096. static
    1097. 

  1097. function
    1098. 

  1098. dump($sql=NULL,$return=FALSE){ob_start();if($sql
    1099. 

  1099. instanceof
    1100. 

  1100. DibiResult){$sql->dump();}else{if($sql===NULL)$sql=self::$sql;static$keywords1='SELECT|UPDATE|INSERT(?:\s+INTO)?|REPLACE(?:\s+INTO)?|DELETE|FROM|WHERE|HAVING|GROUP\s+BY|ORDER\s+BY|LIMIT|OFFSET|SET|VALUES|LEFT\s+JOIN|INNER\s+JOIN|TRUNCATE';static$keywords2='ALL|DISTINCT|DISTINCTROW|AS|USING|ON|AND|OR|IN|IS|NOT|NULL|LIKE|TRUE|FALSE';$sql=" $sql ";$sql=preg_replace("#(?<=[\\s,(])($keywords1)(?=[\\s,)])#i","\n\$1",$sql);$sql=preg_replace('#[ \t]{2,}#'," ",$sql);$sql=wordwrap($sql,100);$sql=htmlSpecialChars($sql);$sql=preg_replace("#([ \t]*\r?\n){2,}#","\n",$sql);if(PHP_SAPI==='cli'){echo
    1101. 

  1101. trim($sql)."\n\n";}else{$sql=preg_replace_callback("#(/\\*.+?\\*/)|(\\*\\*.+?\\*\\*)|(?<=[\\s,(])($keywords1)(?=[\\s,)])|(?<=[\\s,(=])($keywords2)(?=[\\s,)=])#is",array('dibi','highlightCallback'),$sql);echo'<pre class="dump">',trim($sql),"</pre>\n";}}if($return){return
    1102. 

  1102. ob_get_clean();}else{ob_end_flush();}}private
    1103. 

  1103. static
    1104. 

  1104. function
    1105. 

  1105. highlightCallback($matches){if(!empty($matches[1]))return'<em style="color:gray">'.$matches[1].'</em>';if(!empty($matches[2]))return'<strong style="color:red">'.$matches[2].'</strong>';if(!empty($matches[3]))return'<strong style="color:blue">'.$matches[3].'</strong>';if(!empty($matches[4]))return'<strong style="color:green">'.$matches[4].'</strong>';}}class
    1106. 

  1106. DibiMySqlReflector
    1107. 

  1107. extends
    1108. 

  1108. DibiObject
    1109. 

  1109. implements
    1110. 

  1110. IDibiReflector{private$driver;public
    1111. 

  1111. function
    1112. 

  1112. __construct(IDibiDriver$driver){$this->driver=$driver;}public
    1113. 

  1113. function
    1114. 

  1114. getTables(){$this->driver->query("SHOW FULL TABLES");$res=array();while($row=$this->driver->fetch(FALSE)){$res[]=array('name'=>$row[0],'view'=>isset($row[1])&&$row[1]==='VIEW');}$this->driver->free();return$res;}public
    1115. 

  1115. function
    1116. 

  1116. getColumns($table){$this->driver->query("SHOW FULL COLUMNS FROM `$table`");$res=array();while($row=$this->driver->fetch(TRUE)){$type=explode('(',$row['Type']);$res[]=array('name'=>$row['Field'],'table'=>$table,'nativetype'=>strtoupper($type[0]),'size'=>isset($type[1])?(int)$type[1]:NULL,'unsigned'=>(bool)strstr($row['Type'],'unsigned'),'nullable'=>$row['Null']==='YES','default'=>$row['Default'],'autoincrement'=>$row['Extra']==='auto_increment','vendor'=>$row);}$this->driver->free();return$res;}public
    1117. 

  1117. function
    1118. 

  1118. getIndexes($table){$this->driver->query("SHOW INDEX FROM `$table`");$res=array();while($row=$this->driver->fetch(TRUE)){$res[$row['Key_name']]['name']=$row['Key_name'];$res[$row['Key_name']]['unique']=!$row['Non_unique'];$res[$row['Key_name']]['primary']=$row['Key_name']==='PRIMARY';$res[$row['Key_name']]['columns'][$row['Seq_in_index']-1]=$row['Column_name'];}$this->driver->free();return
    1119. 

  1119. array_values($res);}public
    1120. 

  1120. function
    1121. 

  1121. getForeignKeys($table){throw
    1122. 

  1122. new
    1123. 

  1123. NotImplementedException;}}class
    1124. 

  1124. DibiMySqlDriver
    1125. 

  1125. extends
    1126. 

  1126. DibiObject
    1127. 

  1127. implements
    1128. 

  1128. IDibiDriver,IDibiResultDriver{const
    1129. 

  1129. ERROR_ACCESS_DENIED=1045;const
    1130. 

  1130. ERROR_DUPLICATE_ENTRY=1062;const
    1131. 

  1131. ERROR_DATA_TRUNCATED=1265;private$connection;private$resultSet;private$buffered;public
    1132. 

  1132. function
    1133. 

  1133. __construct(){if(!extension_loaded('mysql')){throw
    1134. 

  1134. new
    1135. 

  1135. DibiDriverException("PHP extension 'mysql' is not loaded.");}}public
    1136. 

  1136. function
    1137. 

  1137. connect(array&$config){if(isset($config['resource'])){$this->connection=$config['resource'];}else{DibiConnection::alias($config,'flags','options');if(!isset($config['charset']))$config['charset']='utf8';if(!isset($config['username']))$config['username']=ini_get('mysql.default_user');if(!isset($config['password']))$config['password']=ini_get('mysql.default_password');if(!isset($config['host'])){$host=ini_get('mysql.default_host');if($host){$config['host']=$host;$config['port']=ini_get('mysql.default_port');}else{if(!isset($config['socket']))$config['socket']=ini_get('mysql.default_socket');$config['host']=NULL;}}if(empty($config['socket'])){$host=$config['host'].(empty($config['port'])?'':':'.$config['port']);}else{$host=':'.$config['socket'];}if(empty($config['persistent'])){$this->connection=@mysql_connect($host,$config['username'],$config['password'],TRUE,$config['flags']);}else{$this->connection=@mysql_pconnect($host,$config['username'],$config['password'],$config['flags']);}}if(!is_resource($this->connection)){throw
    1138. 

  1138. new
    1139. 

  1139. DibiDriverException(mysql_error(),mysql_errno());}if(isset($config['charset'])){$ok=FALSE;if(function_exists('mysql_set_charset')){$ok=@mysql_set_charset($config['charset'],$this->connection);}if(!$ok){$this->query("SET NAMES '$config[charset]'");}}if(isset($config['database'])){if(!@mysql_select_db($config['database'],$this->connection)){throw
    1140. 

  1140. new
    1141. 

  1141. DibiDriverException(mysql_error($this->connection),mysql_errno($this->connection));}}if(isset($config['sqlmode'])){$this->query("SET sql_mode='$config[sqlmode]'");}$this->query("SET time_zone='".date('P')."'");$this->buffered=empty($config['unbuffered']);}public
    1142. 

  1142. function
    1143. 

  1143. disconnect(){mysql_close($this->connection);}public
    1144. 

  1144. function
    1145. 

  1145. query($sql){if($this->buffered){$this->resultSet=@mysql_query($sql,$this->connection);}else{$this->resultSet=@mysql_unbuffered_query($sql,$this->connection);}if(mysql_errno($this->connection)){throw
    1146. 

  1146. new
    1147. 

  1147. DibiDriverException(mysql_error($this->connection),mysql_errno($this->connection),$sql);}return
    1148. 

  1148. is_resource($this->resultSet)?clone$this:NULL;}public
    1149. 

  1149. function
    1150. 

  1150. getInfo(){$res=array();preg_match_all('#(.+?): +(\d+) *#',mysql_info($this->connection),$matches,PREG_SET_ORDER);if(preg_last_error())throw
    1151. 

  1151. new
    1152. 

  1152. PcreException;foreach($matches
    1153. 

  1153. as$m){$res[$m[1]]=(int)$m[2];}return$res;}public
    1154. 

  1154. function
    1155. 

  1155. getAffectedRows(){return
    1156. 

  1156. mysql_affected_rows($this->connection);}public
    1157. 

  1157. function
    1158. 

  1158. getInsertId($sequence){return
    1159. 

  1159. mysql_insert_id($this->connection);}public
    1160. 

  1160. function
    1161. 

  1161. begin($savepoint=NULL){$this->query($savepoint?"SAVEPOINT $savepoint":'START TRANSACTION');}public
    1162. 

  1162. function
    1163. 

  1163. commit($savepoint=NULL){$this->query($savepoint?"RELEASE SAVEPOINT $savepoint":'COMMIT');}public
    1164. 

  1164. function
    1165. 

  1165. rollback($savepoint=NULL){$this->query($savepoint?"ROLLBACK TO SAVEPOINT $savepoint":'ROLLBACK');}public
    1166. 

  1166. function
    1167. 

  1167. getResource(){return$this->connection;}public
    1168. 

  1168. function
    1169. 

  1169. getReflector(){return
    1170. 

  1170. new
    1171. 

  1171. DibiMySqlReflector($this);}public
    1172. 

  1172. function
    1173. 

  1173. escape($value,$type){switch($type){case
    1174. 

  1174. dibi::TEXT:return"'".mysql_real_escape_string($value,$this->connection)."'";case
    1175. 

  1175. dibi::BINARY:return"_binary'".mysql_real_escape_string($value,$this->connection)."'";case
    1176. 

  1176. dibi::IDENTIFIER:return'`'.str_replace('`','``',$value).'`';case
    1177. 

  1177. dibi::BOOL:return$value?1:0;case
    1178. 

  1178. dibi::DATE:return$value
    1179. 

  1179. instanceof
    1180. 

  1180. DateTime?$value->format("'Y-m-d'"):date("'Y-m-d'",$value);case
    1181. 

  1181. dibi::DATETIME:return$value
    1182. 

  1182. instanceof
    1183. 

  1183. DateTime?$value->format("'Y-m-d H:i:s'"):date("'Y-m-d H:i:s'",$value);default:throw
    1184. 

  1184. new
    1185. 

  1185. InvalidArgumentException('Unsupported type.');}}public
    1186. 

  1186. function
    1187. 

  1187. unescape($value,$type){if($type===dibi::BINARY){return$value;}throw
    1188. 

  1188. new
    1189. 

  1189. InvalidArgumentException('Unsupported type.');}public
    1190. 

  1190. function
    1191. 

  1191. applyLimit(&$sql,$limit,$offset){if($limit<0&&$offset<1)return;$sql.=' LIMIT '.($limit<0?'18446744073709551615':(int)$limit).($offset>0?' OFFSET '.(int)$offset:'');}public
    1192. 

  1192. function
    1193. 

  1193. getRowCount(){if(!$this->buffered){throw
    1194. 

  1194. new
    1195. 

  1195. DibiDriverException('Row count is not available for unbuffered queries.');}return
    1196. 

  1196. mysql_num_rows($this->resultSet);}public
    1197. 

  1197. function
    1198. 

  1198. fetch($assoc){return
    1199. 

  1199. mysql_fetch_array($this->resultSet,$assoc?MYSQL_ASSOC:MYSQL_NUM);}public
    1200. 

  1200. function
    1201. 

  1201. seek($row){if(!$this->buffered){throw
    1202. 

  1202. new
    1203. 

  1203. DibiDriverException('Cannot seek an unbuffered result set.');}return
    1204. 

  1204. mysql_data_seek($this->resultSet,$row);}public
    1205. 

  1205. function
    1206. 

  1206. free(){mysql_free_result($this->resultSet);$this->resultSet=NULL;}public
    1207. 

  1207. function
    1208. 

  1208. getResultColumns(){$count=mysql_num_fields($this->resultSet);$res=array();for($i=0;$i<$count;$i++){$row=(array)mysql_fetch_field($this->resultSet,$i);$res[]=array('name'=>$row['name'],'table'=>$row['table'],'fullname'=>$row['table']?$row['table'].'.'.$row['name']:$row['name'],'nativetype'=>strtoupper($row['type']),'vendor'=>$row);}return$res;}public
    1209. 

  1209. function
    1210. 

  1210. getResultResource(){return$this->resultSet;}}class
    1211. 

  1211. DibiMySqliDriver
    1212. 

  1212. extends
    1213. 

  1213. DibiObject
    1214. 

  1214. implements
    1215. 

  1215. IDibiDriver,IDibiResultDriver{const
    1216. 

  1216. ERROR_ACCESS_DENIED=1045;const
    1217. 

  1217. ERROR_DUPLICATE_ENTRY=1062;const
    1218. 

  1218. ERROR_DATA_TRUNCATED=1265;private$connection;private$resultSet;private$buffered;public
    1219. 

  1219. function
    1220. 

  1220. __construct(){if(!extension_loaded('mysqli')){throw
    1221. 

  1221. new
    1222. 

  1222. DibiDriverException("PHP extension 'mysqli' is not loaded.");}}public
    1223. 

  1223. function
    1224. 

  1224. connect(array&$config){mysqli_report(MYSQLI_REPORT_OFF);if(isset($config['resource'])){$this->connection=$config['resource'];}else{if(!isset($config['charset']))$config['charset']='utf8';if(!isset($config['username']))$config['username']=ini_get('mysqli.default_user');if(!isset($config['password']))$config['password']=ini_get('mysqli.default_pw');if(!isset($config['socket']))$config['socket']=ini_get('mysqli.default_socket');if(!isset($config['port']))$config['port']=NULL;if(!isset($config['host'])){$host=ini_get('mysqli.default_host');if($host){$config['host']=$host;$config['port']=ini_get('mysqli.default_port');}else{$config['host']=NULL;$config['port']=NULL;}}$foo=&$config['flags'];$foo=&$config['database'];$this->connection=mysqli_init();if(isset($config['options'])){if(is_scalar($config['options'])){$config['flags']=$config['options'];trigger_error(__CLASS__.": configuration item 'options' must be array; for constants MYSQLI_CLIENT_* use 'flags'.",E_USER_NOTICE);}else{foreach((array)$config['options']as$key=>$value){mysqli_options($this->connection,$key,$value);}}}@mysqli_real_connect($this->connection,$config['host'],$config['username'],$config['password'],$config['database'],$config['port'],$config['socket'],$config['flags']);if($errno=mysqli_connect_errno()){throw
    1225. 

  1225. new
    1226. 

  1226. DibiDriverException(mysqli_connect_error(),$errno);}}if(isset($config['charset'])){$ok=FALSE;if(version_compare(PHP_VERSION,'5.1.5','>=')){$ok=@mysqli_set_charset($this->connection,$config['charset']);}if(!$ok){$this->query("SET NAMES '$config[charset]'");}}if(isset($config['sqlmode'])){$this->query("SET sql_mode='$config[sqlmode]'");}$this->query("SET time_zone='".date('P')."'");$this->buffered=empty($config['unbuffered']);}public
    1227. 

  1227. function
    1228. 

  1228. disconnect(){mysqli_close($this->connection);}public
    1229. 

  1229. function
    1230. 

  1230. query($sql){$this->resultSet=@mysqli_query($this->connection,$sql,$this->buffered?MYSQLI_STORE_RESULT:MYSQLI_USE_RESULT);if(mysqli_errno($this->connection)){throw
    1231. 

  1231. new
    1232. 

  1232. DibiDriverException(mysqli_error($this->connection),mysqli_errno($this->connection),$sql);}return
    1233. 

  1233. is_object($this->resultSet)?clone$this:NULL;}public
    1234. 

  1234. function
    1235. 

  1235. getInfo(){$res=array();preg_match_all('#(.+?): +(\d+) *#',mysqli_info($this->connection),$matches,PREG_SET_ORDER);if(preg_last_error())throw
    1236. 

  1236. new
    1237. 

  1237. PcreException;foreach($matches
    1238. 

  1238. as$m){$res[$m[1]]=(int)$m[2];}return$res;}public
    1239. 

  1239. function
    1240. 

  1240. getAffectedRows(){return
    1241. 

  1241. mysqli_affected_rows($this->connection);}public
    1242. 

  1242. function
    1243. 

  1243. getInsertId($sequence){return
    1244. 

  1244. mysqli_insert_id($this->connection);}public
    1245. 

  1245. function
    1246. 

  1246. begin($savepoint=NULL){$this->query($savepoint?"SAVEPOINT $savepoint":'START TRANSACTION');}public
    1247. 

  1247. function
    1248. 

  1248. commit($savepoint=NULL){$this->query($savepoint?"RELEASE SAVEPOINT $savepoint":'COMMIT');}public
    1249. 

  1249. function
    1250. 

  1250. rollback($savepoint=NULL){$this->query($savepoint?"ROLLBACK TO SAVEPOINT $savepoint":'ROLLBACK');}public
    1251. 

  1251. function
    1252. 

  1252. getResource(){return$this->connection;}public
    1253. 

  1253. function
    1254. 

  1254. getReflector(){return
    1255. 

  1255. new
    1256. 

  1256. DibiMySqlReflector($this);}public
    1257. 

  1257. function
    1258. 

  1258. escape($value,$type){switch($type){case
    1259. 

  1259. dibi::TEXT:return"'".mysqli_real_escape_string($this->connection,$value)."'";case
    1260. 

  1260. dibi::BINARY:return"_binary'".mysqli_real_escape_string($this->connection,$value)."'";case
    1261. 

  1261. dibi::IDENTIFIER:return'`'.str_replace('`','``',$value).'`';case
    1262. 

  1262. dibi::BOOL:return$value?1:0;case
    1263. 

  1263. dibi::DATE:return$value
    1264. 

  1264. instanceof
    1265. 

  1265. DateTime?$value->format("'Y-m-d'"):date("'Y-m-d'",$value);case
    1266. 

  1266. dibi::DATETIME:return$value
    1267. 

  1267. instanceof
    1268. 

  1268. DateTime?$value->format("'Y-m-d H:i:s'"):date("'Y-m-d H:i:s'",$value);default:throw
    1269. 

  1269. new
    1270. 

  1270. InvalidArgumentException('Unsupported type.');}}public
    1271. 

  1271. function
    1272. 

  1272. unescape($value,$type){if($type===dibi::BINARY){return$value;}throw
    1273. 

  1273. new
    1274. 

  1274. InvalidArgumentException('Unsupported type.');}public
    1275. 

  1275. function
    1276. 

  1276. applyLimit(&$sql,$limit,$offset){if($limit<0&&$offset<1)return;$sql.=' LIMIT '.($limit<0?'18446744073709551615':(int)$limit).($offset>0?' OFFSET '.(int)$offset:'');}public
    1277. 

  1277. function
    1278. 

  1278. getRowCount(){if(!$this->buffered){throw
    1279. 

  1279. new
    1280. 

  1280. DibiDriverException('Row count is not available for unbuffered queries.');}return
    1281. 

  1281. mysqli_num_rows($this->resultSet);}public
    1282. 

  1282. function
    1283. 

  1283. fetch($assoc){return
    1284. 

  1284. mysqli_fetch_array($this->resultSet,$assoc?MYSQLI_ASSOC:MYSQLI_NUM);}public
    1285. 

  1285. function
    1286. 

  1286. seek($row){if(!$this->buffered){throw
    1287. 

  1287. new
    1288. 

  1288. DibiDriverException('Cannot seek an unbuffered result set.');}return
    1289. 

  1289. mysqli_data_seek($this->resultSet,$row);}public
    1290. 

  1290. function
    1291. 

  1291. free(){mysqli_free_result($this->resultSet);$this->resultSet=NULL;}public
    1292. 

  1292. function
    1293. 

  1293. getResultColumns(){static$types;if(empty($types)){$consts=get_defined_constants(TRUE);foreach($consts['mysqli']as$key=>$value){if(strncmp($key,'MYSQLI_TYPE_',12)===0){$types[$value]=substr($key,12);}}$types[MYSQLI_TYPE_TINY]=$types[MYSQLI_TYPE_SHORT]=$types[MYSQLI_TYPE_LONG]='INT';}$count=mysqli_num_fields($this->resultSet);$res=array();for($i=0;$i<$count;$i++){$row=(array)mysqli_fetch_field_direct($this->resultSet,$i);$res[]=array('name'=>$row['name'],'table'=>$row['orgtable'],'fullname'=>$row['table']?$row['table'].'.'.$row['name']:$row['name'],'nativetype'=>$types[$row['type']],'vendor'=>$row);}return$res;}public
    1294. 

  1294. function
    1295. 

  1295. getResultResource(){return$this->resultSet;}}class
    1296. 

  1296. DibiOdbcDriver
    1297. 

  1297. extends
    1298. 

  1298. DibiObject
    1299. 

  1299. implements
    1300. 

  1300. IDibiDriver,IDibiResultDriver,IDibiReflector{private$connection;private$resultSet;private$row=0;public
    1301. 

  1301. function
    1302. 

  1302. __construct(){if(!extension_loaded('odbc')){throw
    1303. 

  1303. new
    1304. 

  1304. DibiDriverException("PHP extension 'odbc' is not loaded.");}}public
    1305. 

  1305. function
    1306. 

  1306. connect(array&$config){if(isset($config['resource'])){$this->connection=$config['resource'];}else{if(!isset($config['username']))$config['username']=ini_get('odbc.default_user');if(!isset($config['password']))$config['password']=ini_get('odbc.default_pw');if(!isset($config['dsn']))$config['dsn']=ini_get('odbc.default_db');if(empty($config['persistent'])){$this->connection=@odbc_connect($config['dsn'],$config['username'],$config['password']);}else{$this->connection=@odbc_pconnect($config['dsn'],$config['username'],$config['password']);}}if(!is_resource($this->connection)){throw
    1307. 

  1307. new
    1308. 

  1308. DibiDriverException(odbc_errormsg().' '.odbc_error());}}public
    1309. 

  1309. function
    1310. 

  1310. disconnect(){odbc_close($this->connection);}public
    1311. 

  1311. function
    1312. 

  1312. query($sql){$this->resultSet=@odbc_exec($this->connection,$sql);if($this->resultSet===FALSE){throw
    1313. 

  1313. new
    1314. 

  1314. DibiDriverException(odbc_errormsg($this->connection).' '.odbc_error($this->connection),0,$sql);}return
    1315. 

  1315. is_resource($this->resultSet)?clone$this:NULL;}public
    1316. 

  1316. function
    1317. 

  1317. getAffectedRows(){return
    1318. 

  1318. odbc_num_rows($this->resultSet);}public
    1319. 

  1319. function
    1320. 

  1320. getInsertId($sequence){throw
    1321. 

  1321. new
    1322. 

  1322. NotSupportedException('ODBC does not support autoincrementing.');}public
    1323. 

  1323. function
    1324. 

  1324. begin($savepoint=NULL){if(!odbc_autocommit($this->connection,FALSE)){throw
    1325. 

  1325. new
    1326. 

  1326. DibiDriverException(odbc_errormsg($this->connection).' '.odbc_error($this->connection));}}public
    1327. 

  1327. function
    1328. 

  1328. commit($savepoint=NULL){if(!odbc_commit($this->connection)){throw
    1329. 

  1329. new
    1330. 

  1330. DibiDriverException(odbc_errormsg($this->connection).' '.odbc_error($this->connection));}odbc_autocommit($this->connection,TRUE);}public
    1331. 

  1331. function
    1332. 

  1332. rollback($savepoint=NULL){if(!odbc_rollback($this->connection)){throw
    1333. 

  1333. new
    1334. 

  1334. DibiDriverException(odbc_errormsg($this->connection).' '.odbc_error($this->connection));}odbc_autocommit($this->connection,TRUE);}public
    1335. 

  1335. function
    1336. 

  1336. inTransaction(){return!odbc_autocommit($this->connection);}public
    1337. 

  1337. function
    1338. 

  1338. getResource(){return$this->connection;}public
    1339. 

  1339. function
    1340. 

  1340. getReflector(){return$this;}public
    1341. 

  1341. function
    1342. 

  1342. escape($value,$type){switch($type){case
    1343. 

  1343. dibi::TEXT:case
    1344. 

  1344. dibi::BINARY:return"'".str_replace("'","''",$value)."'";case
    1345. 

  1345. dibi::IDENTIFIER:return'['.str_replace(array('[',']'),array('[[',']]'),$value).']';case
    1346. 

  1346. dibi::BOOL:return$value?1:0;case
    1347. 

  1347. dibi::DATE:return$value
    1348. 

  1348. instanceof
    1349. 

  1349. DateTime?$value->format("#m/d/Y#"):date("#m/d/Y#",$value);case
    1350. 

  1350. dibi::DATETIME:return$value
    1351. 

  1351. instanceof
    1352. 

  1352. DateTime?$value->format("#m/d/Y H:i:s#"):date("#m/d/Y H:i:s#",$value);default:throw
    1353. 

  1353. new
    1354. 

  1354. InvalidArgumentException('Unsupported type.');}}public
    1355. 

  1355. function
    1356. 

  1356. unescape($value,$type){if($type===dibi::BINARY){return$value;}throw
    1357. 

  1357. new
    1358. 

  1358. InvalidArgumentException('Unsupported type.');}public
    1359. 

  1359. function
    1360. 

  1360. applyLimit(&$sql,$limit,$offset){if($limit>=0){$sql='SELECT TOP '.(int)$limit.' * FROM ('.$sql.')';}if($offset)throw
    1361. 

  1361. new
    1362. 

  1362. InvalidArgumentException('Offset is not implemented in driver odbc.');}public
    1363. 

  1363. function
    1364. 

  1364. getRowCount(){return
    1365. 

  1365. odbc_num_rows($this->resultSet);}public
    1366. 

  1366. function
    1367. 

  1367. fetch($assoc){if($assoc){return
    1368. 

  1368. odbc_fetch_array($this->resultSet,++$this->row);}else{$set=$this->resultSet;if(!odbc_fetch_row($set,++$this->row))return
    1369. 

  1369. FALSE;$count=odbc_num_fields($set);$cols=array();for($i=1;$i<=$count;$i++)$cols[]=odbc_result($set,$i);return$cols;}}public
    1370. 

  1370. function
    1371. 

  1371. seek($row){$this->row=$row;return
    1372. 

  1372. TRUE;}public
    1373. 

  1373. function
    1374. 

  1374. free(){odbc_free_result($this->resultSet);$this->resultSet=NULL;}public
    1375. 

  1375. function
    1376. 

  1376. getResultColumns(){$count=odbc_num_fields($this->resultSet);$res=array();for($i=1;$i<=$count;$i++){$res[]=array('name'=>odbc_field_name($this->resultSet,$i),'table'=>NULL,'fullname'=>odbc_field_name($this->resultSet,$i),'nativetype'=>odbc_field_type($this->resultSet,$i));}return$res;}public
    1377. 

  1377. function
    1378. 

  1378. getResultResource(){return$this->resultSet;}public
    1379. 

  1379. function
    1380. 

  1380. getTables(){$result=odbc_tables($this->connection);$res=array();while($row=odbc_fetch_array($result)){if($row['TABLE_TYPE']==='TABLE'||$row['TABLE_TYPE']==='VIEW'){$res[]=array('name'=>$row['TABLE_NAME'],'view'=>$row['TABLE_TYPE']==='VIEW');}}odbc_free_result($result);return$res;}public
    1381. 

  1381. function
    1382. 

  1382. getColumns($table){$result=odbc_columns($this->connection);$res=array();while($row=odbc_fetch_array($result)){if($row['TABLE_NAME']===$table){$res[]=array('name'=>$row['COLUMN_NAME'],'table'=>$table,'nativetype'=>$row['TYPE_NAME'],'size'=>$row['COLUMN_SIZE'],'nullable'=>(bool)$row['NULLABLE'],'default'=>$row['COLUMN_DEF']);}}odbc_free_result($result);return$res;}public
    1383. 

  1383. function
    1384. 

  1384. getIndexes($table){throw
    1385. 

  1385. new
    1386. 

  1386. NotImplementedException;}public
    1387. 

  1387. function
    1388. 

  1388. getForeignKeys($table){throw
    1389. 

  1389. new
    1390. 

  1390. NotImplementedException;}}class
    1391. 

  1391. DibiPdoDriver
    1392. 

  1392. extends
    1393. 

  1393. DibiObject
    1394. 

  1394. implements
    1395. 

  1395. IDibiDriver,IDibiResultDriver{private$connection;private$resultSet;private$affectedRows=FALSE;private$driverName;public
    1396. 

  1396. function
    1397. 

  1397. __construct(){if(!extension_loaded('pdo')){throw
    1398. 

  1398. new
    1399. 

  1399. DibiDriverException("PHP extension 'pdo' is not loaded.");}}public
    1400. 

  1400. function
    1401. 

  1401. connect(array&$config){$foo=&$config['dsn'];$foo=&$config['options'];DibiConnection::alias($config,'resource','pdo');if($config['resource']instanceof
    1402. 

  1402. PDO){$this->connection=$config['resource'];}else
    1403. 

  1403. try{$this->connection=new
    1404. 

  1404. PDO($config['dsn'],$config['username'],$config['password'],$config['options']);}catch(PDOException$e){throw
    1405. 

  1405. new
    1406. 

  1406. DibiDriverException($e->getMessage(),$e->getCode());}if(!$this->connection){throw
    1407. 

  1407. new
    1408. 

  1408. DibiDriverException('Connecting error.');}$this->driverName=$this->connection->getAttribute(PDO::ATTR_DRIVER_NAME);}public
    1409. 

  1409. function
    1410. 

  1410. disconnect(){$this->connection=NULL;}public
    1411. 

  1411. function
    1412. 

  1412. query($sql){$cmd=strtoupper(substr(ltrim($sql),0,6));static$list=array('UPDATE'=>1,'DELETE'=>1,'INSERT'=>1,'REPLAC'=>1);if(isset($list[$cmd])){$this->resultSet=NULL;$this->affectedRows=$this->connection->exec($sql);if($this->affectedRows===FALSE){$err=$this->connection->errorInfo();throw
    1413. 

  1413. new
    1414. 

  1414. DibiDriverException("SQLSTATE[$err[0]]: $err[2]",$err[1],$sql);}return
    1415. 

  1415. NULL;}else{$this->resultSet=$this->connection->query($sql);$this->affectedRows=FALSE;if($this->resultSet===FALSE){$err=$this->connection->errorInfo();throw
    1416. 

  1416. new
    1417. 

  1417. DibiDriverException("SQLSTATE[$err[0]]: $err[2]",$err[1],$sql);}return
    1418. 

  1418. clone$this;}}public
    1419. 

  1419. function
    1420. 

  1420. getAffectedRows(){return$this->affectedRows;}public
    1421. 

  1421. function
    1422. 

  1422. getInsertId($sequence){return$this->connection->lastInsertId();}public
    1423. 

  1423. function
    1424. 

  1424. begin($savepoint=NULL){if(!$this->connection->beginTransaction()){$err=$this->connection->errorInfo();throw
    1425. 

  1425. new
    1426. 

  1426. DibiDriverException("SQLSTATE[$err[0]]: $err[2]",$err[1]);}}public
    1427. 

  1427. function
    1428. 

  1428. commit($savepoint=NULL){if(!$this->connection->commit()){$err=$this->connection->errorInfo();throw
    1429. 

  1429. new
    1430. 

  1430. DibiDriverException("SQLSTATE[$err[0]]: $err[2]",$err[1]);}}public
    1431. 

  1431. function
    1432. 

  1432. rollback($savepoint=NULL){if(!$this->connection->rollBack()){$err=$this->connection->errorInfo();throw
    1433. 

  1433. new
    1434. 

  1434. DibiDriverException("SQLSTATE[$err[0]]: $err[2]",$err[1]);}}public
    1435. 

  1435. function
    1436. 

  1436. getResource(){return$this->connection;}public
    1437. 

  1437. function
    1438. 

  1438. getReflector(){throw
    1439. 

  1439. new
    1440. 

  1440. NotSupportedException;}public
    1441. 

  1441. function
    1442. 

  1442. escape($value,$type){switch($type){case
    1443. 

  1443. dibi::TEXT:return$this->connection->quote($value,PDO::PARAM_STR);case
    1444. 

  1444. dibi::BINARY:return$this->connection->quote($value,PDO::PARAM_LOB);case
    1445. 

  1445. dibi::IDENTIFIER:switch($this->driverName){case'mysql':return'`'.str_replace('`','``',$value).'`';case'pgsql':return'"'.str_replace('"','""',$value).'"';case'sqlite':case'sqlite2':return'['.strtr($value,'[]','  ').']';case'odbc':case'oci':case'mssql':return'['.str_replace(array('[',']'),array('[[',']]'),$value).']';default:return$value;}case
    1446. 

  1446. dibi::BOOL:return$this->connection->quote($value,PDO::PARAM_BOOL);case
    1447. 

  1447. dibi::DATE:return$value
    1448. 

  1448. instanceof
    1449. 

  1449. DateTime?$value->format("'Y-m-d'"):date("'Y-m-d'",$value);case
    1450. 

  1450. dibi::DATETIME:return$value
    1451. 

  1451. instanceof
    1452. 

  1452. DateTime?$value->format("'Y-m-d H:i:s'"):date("'Y-m-d H:i:s'",$value);default:throw
    1453. 

  1453. new
    1454. 

  1454. InvalidArgumentException('Unsupported type.');}}public
    1455. 

  1455. function
    1456. 

  1456. unescape($value,$type){if($type===dibi::BINARY){return$value;}throw
    1457. 

  1457. new
    1458. 

  1458. InvalidArgumentException('Unsupported type.');}public
    1459. 

  1459. function
    1460. 

  1460. applyLimit(&$sql,$limit,$offset){if($limit<0&&$offset<1)return;switch($this->driverName){case'mysql':$sql.=' LIMIT '.($limit<0?'18446744073709551615':(int)$limit).($offset>0?' OFFSET '.(int)$offset:'');break;case'pgsql':if($limit>=0)$sql.=' LIMIT '.(int)$limit;if($offset>0)$sql.=' OFFSET '.(int)$offset;break;case'sqlite':case'sqlite2':$sql.=' LIMIT '.$limit.($offset>0?' OFFSET '.(int)$offset:'');break;case'oci':if($offset>0){$sql='SELECT * FROM (SELECT t.*, ROWNUM AS "__rnum" FROM ('.$sql.') t '.($limit>=0?'WHERE ROWNUM <= '.((int)$offset+(int)$limit):'').') WHERE "__rnum" > '.(int)$offset;}elseif($limit>=0){$sql='SELECT * FROM ('.$sql.') WHERE ROWNUM <= '.(int)$limit;}break;case'odbc':case'mssql':if($offset<1){$sql='SELECT TOP '.(int)$limit.' * FROM ('.$sql.')';break;}default:throw
    1461. 

  1461. new
    1462. 

  1462. NotSupportedException('PDO or driver does not support applying limit or offset.');}}public
    1463. 

  1463. function
    1464. 

  1464. getRowCount(){return$this->resultSet->rowCount();}public
    1465. 

  1465. function
    1466. 

  1466. fetch($assoc){return$this->resultSet->fetch($assoc?PDO::FETCH_ASSOC:PDO::FETCH_NUM);}public
    1467. 

  1467. function
    1468. 

  1468. seek($row){throw
    1469. 

  1469. new
    1470. 

  1470. NotSupportedException('Cannot seek an unbuffered result set.');}public
    1471. 

  1471. function
    1472. 

  1472. free(){$this->resultSet=NULL;}public
    1473. 

  1473. function
    1474. 

  1474. getResultColumns(){$count=$this->resultSet->columnCount();$res=array();for($i=0;$i<$count;$i++){$row=@$this->resultSet->getColumnMeta($i);if($row===FALSE){throw
    1475. 

  1475. new
    1476. 

  1476. DibiDriverException('Driver does not support meta data.');}$row['table']=isset($row['table'])?$row['table']:NULL;$res[]=array('name'=>$row['name'],'table'=>$row['table'],'nativetype'=>$row['native_type'],'fullname'=>$row['table']?$row['table'].'.'.$row['name']:$row['name'],'vendor'=>$row);}return$res;}public
    1477. 

  1477. function
    1478. 

  1478. getResultResource(){return$this->resultSet;}}class
    1479. 

  1479. DibiPostgreDriver
    1480. 

  1480. extends
    1481. 

  1481. DibiObject
    1482. 

  1482. implements
    1483. 

  1483. IDibiDriver,IDibiResultDriver,IDibiReflector{private$connection;private$resultSet;private$escMethod=FALSE;public
    1484. 

  1484. function
    1485. 

  1485. __construct(){if(!extension_loaded('pgsql')){throw
    1486. 

  1486. new
    1487. 

  1487. DibiDriverException("PHP extension 'pgsql' is not loaded.");}}public
    1488. 

  1488. function
    1489. 

  1489. connect(array&$config){if(isset($config['resource'])){$this->connection=$config['resource'];}else{if(!isset($config['charset']))$config['charset']='utf8';if(isset($config['string'])){$string=$config['string'];}else{$string='';DibiConnection::alias($config,'user','username');DibiConnection::alias($config,'dbname','database');foreach(array('host','hostaddr','port','dbname','user','password','connect_timeout','options','sslmode','service')as$key){if(isset($config[$key]))$string.=$key.'='.$config[$key].' ';}}DibiDriverException::tryError();if(empty($config['persistent'])){$this->connection=pg_connect($string,PGSQL_CONNECT_FORCE_NEW);}else{$this->connection=pg_pconnect($string,PGSQL_CONNECT_FORCE_NEW);}if(DibiDriverException::catchError($msg)){throw
    1490. 

  1490. new
    1491. 

  1491. DibiDriverException($msg,0);}}if(!is_resource($this->connection)){throw
    1492. 

  1492. new
    1493. 

  1493. DibiDriverException('Connecting error.');}if(isset($config['charset'])){DibiDriverException::tryError();pg_set_client_encoding($this->connection,$config['charset']);if(DibiDriverException::catchError($msg)){throw
    1494. 

  1494. new
    1495. 

  1495. DibiDriverException($msg,0);}}if(isset($config['schema'])){$this->query('SET search_path TO "'.$config['schema'].'"');}$this->escMethod=version_compare(PHP_VERSION,'5.2.0','>=');}public
    1496. 

  1496. function
    1497. 

  1497. disconnect(){pg_close($this->connection);}public
    1498. 

  1498. function
    1499. 

  1499. query($sql){$this->resultSet=@pg_query($this->connection,$sql);if($this->resultSet===FALSE){throw
    1500. 

  1500. new
    1501. 

  1501. DibiDriverException(pg_last_error($this->connection),0,$sql);}return
    1502. 

  1502. is_resource($this->resultSet)&&pg_num_fields($this->resultSet)?clone$this:NULL;}public
    1503. 

  1503. function
    1504. 

  1504. getAffectedRows(){return
    1505. 

  1505. pg_affected_rows($this->resultSet);}public
    1506. 

  1506. function
    1507. 

  1507. getInsertId($sequence){if($sequence===NULL){$has=$this->query("SELECT LASTVAL()");}else{$has=$this->query("SELECT CURRVAL('$sequence')");}if(!$has)return
    1508. 

  1508. FALSE;$row=$this->fetch(FALSE);$this->free();return
    1509. 

  1509. is_array($row)?$row[0]:FALSE;}public
    1510. 

  1510. function
    1511. 

  1511. begin($savepoint=NULL){$this->query($savepoint?"SAVEPOINT $savepoint":'START TRANSACTION');}public
    1512. 

  1512. function
    1513. 

  1513. commit($savepoint=NULL){$this->query($savepoint?"RELEASE SAVEPOINT $savepoint":'COMMIT');}public
    1514. 

  1514. function
    1515. 

  1515. rollback($savepoint=NULL){$this->query($savepoint?"ROLLBACK TO SAVEPOINT $savepoint":'ROLLBACK');}public
    1516. 

  1516. function
    1517. 

  1517. inTransaction(){return!in_array(pg_transaction_status($this->connection),array(PGSQL_TRANSACTION_UNKNOWN,PGSQL_TRANSACTION_IDLE),TRUE);}public
    1518. 

  1518. function
    1519. 

  1519. getResource(){return$this->connection;}public
    1520. 

  1520. function
    1521. 

  1521. getReflector(){return$this;}public
    1522. 

  1522. function
    1523. 

  1523. escape($value,$type){switch($type){case
    1524. 

  1524. dibi::TEXT:if($this->escMethod){return"'".pg_escape_string($this->connection,$value)."'";}else{return"'".pg_escape_string($value)."'";}case
    1525. 

  1525. dibi::BINARY:if($this->escMethod){return"'".pg_escape_bytea($this->connection,$value)."'";}else{return"'".pg_escape_bytea($value)."'";}case
    1526. 

  1526. dibi::IDENTIFIER:return'"'.str_replace('"','""',$value).'"';case
    1527. 

  1527. dibi::BOOL:return$value?'TRUE':'FALSE';case
    1528. 

  1528. dibi::DATE:return$value
    1529. 

  1529. instanceof
    1530. 

  1530. DateTime?$value->format("'Y-m-d'"):date("'Y-m-d'",$value);case
    1531. 

  1531. dibi::DATETIME:return$value
    1532. 

  1532. instanceof
    1533. 

  1533. DateTime?$value->format("'Y-m-d H:i:s'"):date("'Y-m-d H:i:s'",$value);default:throw
    1534. 

  1534. new
    1535. 

  1535. InvalidArgumentException('Unsupported type.');}}public
    1536. 

  1536. function
    1537. 

  1537. unescape($value,$type){if($type===dibi::BINARY){return
    1538. 

  1538. pg_unescape_bytea($value);}throw
    1539. 

  1539. new
    1540. 

  1540. InvalidArgumentException('Unsupported type.');}public
    1541. 

  1541. function
    1542. 

  1542. applyLimit(&$sql,$limit,$offset){if($limit>=0)$sql.=' LIMIT '.(int)$limit;if($offset>0)$sql.=' OFFSET '.(int)$offset;}public
    1543. 

  1543. function
    1544. 

  1544. getRowCount(){return
    1545. 

  1545. pg_num_rows($this->resultSet);}public
    1546. 

  1546. function
    1547. 

  1547. fetch($assoc){return
    1548. 

  1548. pg_fetch_array($this->resultSet,NULL,$assoc?PGSQL_ASSOC:PGSQL_NUM);}public
    1549. 

  1549. function
    1550. 

  1550. seek($row){return
    1551. 

  1551. pg_result_seek($this->resultSet,$row);}public
    1552. 

  1552. function
    1553. 

  1553. free(){pg_free_result($this->resultSet);$this->resultSet=NULL;}public
    1554. 

  1554. function
    1555. 

  1555. getResultColumns(){$hasTable=version_compare(PHP_VERSION,'5.2.0','>=');$count=pg_num_fields($this->resultSet);$res=array();for($i=0;$i<$count;$i++){$row=array('name'=>pg_field_name($this->resultSet,$i),'table'=>$hasTable?pg_field_table($this->resultSet,$i):NULL,'nativetype'=>pg_field_type($this->resultSet,$i));$row['fullname']=$row['table']?$row['table'].'.'.$row['name']:$row['name'];$res[]=$row;}return$res;}public
    1556. 

  1556. function
    1557. 

  1557. getResultResource(){return$this->resultSet;}public
    1558. 

  1558. function
    1559. 

  1559. getTables(){$version=pg_version($this->connection);if($version['server']<8){throw
    1560. 

  1560. new
    1561. 

  1561. DibiDriverException('Reflection requires PostgreSQL 8.');}$this->query("
    1562. 

  1562. 			SELECT table_name as name, CAST(table_type = 'VIEW' AS INTEGER) as view
    1563. 

  1563. 			FROM information_schema.tables
    1564. 

  1564. 			WHERE table_schema = current_schema()
    1565. 

  1565. 		");$res=pg_fetch_all($this->resultSet);$this->free();return$res?$res:array();}public
    1566. 

  1566. function
    1567. 

  1567. getColumns($table){$_table=$this->escape($table,dibi::TEXT);$this->query("
    1568. 

  1568. 			SELECT indkey
    1569. 

  1569. 			FROM pg_class
    1570. 

  1570. 			LEFT JOIN pg_index on pg_class.oid = pg_index.indrelid AND pg_index.indisprimary
    1571. 

  1571. 			WHERE pg_class.relname = $_table
    1572. 

  1572. 		");$primary=(int)pg_fetch_object($this->resultSet)->indkey;$this->query("
    1573. 

  1573. 			SELECT *
    1574. 

  1574. 			FROM information_schema.columns
    1575. 

  1575. 			WHERE table_name = $_table AND table_schema = current_schema()
    1576. 

  1576. 			ORDER BY ordinal_position
    1577. 

  1577. 		");$res=array();while($row=$this->fetch(TRUE)){$size=(int)max($row['character_maximum_length'],$row['numeric_precision']);$res[]=array('name'=>$row['column_name'],'table'=>$table,'nativetype'=>strtoupper($row['udt_name']),'size'=>$size?$size:NULL,'nullable'=>$row['is_nullable']==='YES','default'=>$row['column_default'],'autoincrement'=>(int)$row['ordinal_position']===$primary&&substr($row['column_default'],0,7)==='nextval','vendor'=>$row);}$this->free();return$res;}public
    1578. 

  1578. function
    1579. 

  1579. getIndexes($table){$_table=$this->escape($table,dibi::TEXT);$this->query("
    1580. 

  1580. 			SELECT ordinal_position, column_name
    1581. 

  1581. 			FROM information_schema.columns
    1582. 

  1582. 			WHERE table_name = $_table AND table_schema = current_schema()
    1583. 

  1583. 			ORDER BY ordinal_position
    1584. 

  1584. 		");$columns=array();while($row=$this->fetch(TRUE)){$columns[$row['ordinal_position']]=$row['column_name'];}$this->query("
    1585. 

  1585. 			SELECT pg_class2.relname, indisunique, indisprimary, indkey
    1586. 

  1586. 			FROM pg_class
    1587. 

  1587. 			LEFT JOIN pg_index on pg_class.oid = pg_index.indrelid
    1588. 

  1588. 			INNER JOIN pg_class as pg_class2 on pg_class2.oid = pg_index.indexrelid
    1589. 

  1589. 			WHERE pg_class.relname = $_table
    1590. 

  1590. 		");$res=array();while($row=$this->fetch(TRUE)){$res[$row['relname']]['name']=$row['relname'];$res[$row['relname']]['unique']=$row['indisunique']==='t';$res[$row['relname']]['primary']=$row['indisprimary']==='t';foreach(explode(' ',$row['indkey'])as$index){$res[$row['relname']]['columns'][]=$columns[$index];}}$this->free();return
    1591. 

  1591. array_values($res);}public
    1592. 

  1592. function
    1593. 

  1593. getForeignKeys($table){throw
    1594. 

  1594. new
    1595. 

  1595. NotImplementedException;}}class
    1596. 

  1596. DibiSqliteReflector
    1597. 

  1597. extends
    1598. 

  1598. DibiObject
    1599. 

  1599. implements
    1600. 

  1600. IDibiReflector{private$driver;public
    1601. 

  1601. function
    1602. 

  1602. __construct(IDibiDriver$driver){$this->driver=$driver;}public
    1603. 

  1603. function
    1604. 

  1604. getTables(){$this->driver->query("
    1605. 

  1605. 			SELECT name, type = 'view' as view FROM sqlite_master WHERE type IN ('table', 'view')
    1606. 

  1606. 			UNION ALL
    1607. 

  1607. 			SELECT name, type = 'view' as view FROM sqlite_temp_master WHERE type IN ('table', 'view')
    1608. 

  1608. 			ORDER BY name
    1609. 

  1609. 		");$res=array();while($row=$this->driver->fetch(TRUE)){$res[]=$row;}$this->driver->free();return$res;}public
    1610. 

  1610. function
    1611. 

  1611. getColumns($table){$this->driver->query("
    1612. 

  1612. 			SELECT sql FROM sqlite_master WHERE type = 'table' AND name = '$table'
    1613. 

  1613. 			UNION ALL
    1614. 

  1614. 			SELECT sql FROM sqlite_temp_master WHERE type = 'table' AND name = '$table'");$meta=$this->driver->fetch(TRUE);$this->driver->free();$this->driver->query("PRAGMA table_info([$table])");$res=array();while($row=$this->driver->fetch(TRUE)){$column=$row['name'];$pattern="/(\"$column\"|\[$column\]|$column)\s+[^,]+\s+PRIMARY\s+KEY\s+AUTOINCREMENT/Ui";$type=explode('(',$row['type']);$res[]=array('name'=>$column,'table'=>$table,'fullname'=>"$table.$column",'nativetype'=>strtoupper($type[0]),'size'=>isset($type[1])?(int)$type[1]:NULL,'nullable'=>$row['notnull']=='0','default'=>$row['dflt_value'],'autoincrement'=>(bool)preg_match($pattern,$meta['sql']),'vendor'=>$row);}$this->driver->free();return$res;}public
    1615. 

  1615. function
    1616. 

  1616. getIndexes($table){$this->driver->query("PRAGMA index_list([$table])");$res=array();while($row=$this->driver->fetch(TRUE)){$res[$row['name']]['name']=$row['name'];$res[$row['name']]['unique']=(bool)$row['unique'];}$this->driver->free();foreach($res
    1617. 

  1617. as$index=>$values){$this->driver->query("PRAGMA index_info([$index])");while($row=$this->driver->fetch(TRUE)){$res[$index]['columns'][$row['seqno']]=$row['name'];}}$this->driver->free();$columns=$this->driver->getColumns($table);foreach($res
    1618. 

  1618. as$index=>$values){$column=$res[$index]['columns'][0];$primary=FALSE;foreach($columns
    1619. 

  1619. as$info){if($column==$info['name']){$primary=$info['vendor']['pk'];break;}}$res[$index]['primary']=(bool)$primary;}if(!$res){foreach($columns
    1620. 

  1620. as$column){if($column['vendor']['pk']){$res[]=array('name'=>'ROWID','unique'=>TRUE,'primary'=>TRUE,'columns'=>array($column['name']));break;}}}return
    1621. 

  1621. array_values($res);}public
    1622. 

  1622. function
    1623. 

  1623. getForeignKeys($table){if(!($this->driver
    1624. 

  1624. instanceof
    1625. 

  1625. DibiSqlite3Driver)){}$this->driver->query("PRAGMA foreign_key_list([$table])");$res=array();while($row=$this->driver->fetch(TRUE)){$res[$row['id']]['name']=$row['id'];$res[$row['id']]['local'][$row['seq']]=$row['from'];$res[$row['id']]['table']=$row['table'];$res[$row['id']]['foreign'][$row['seq']]=$row['to'];$res[$row['id']]['onDelete']=$row['on_delete'];$res[$row['id']]['onUpdate']=$row['on_update'];if($res[$row['id']]['foreign'][0]==NULL){$res[$row['id']]['foreign']=NULL;}}$this->driver->free();return
    1626. 

  1626. array_values($res);}}class
    1627. 

  1627. DibiSqliteDriver
    1628. 

  1628. extends
    1629. 

  1629. DibiObject
    1630. 

  1630. implements
    1631. 

  1631. IDibiDriver,IDibiResultDriver{private$connection;private$resultSet;private$buffered;private$fmtDate,$fmtDateTime;private$dbcharset,$charset;public
    1632. 

  1632. function
    1633. 

  1633. __construct(){if(!extension_loaded('sqlite')){throw
    1634. 

  1634. new
    1635. 

  1635. DibiDriverException("PHP extension 'sqlite' is not loaded.");}}public
    1636. 

  1636. function
    1637. 

  1637. connect(array&$config){DibiConnection::alias($config,'database','file');$this->fmtDate=isset($config['formatDate'])?$config['formatDate']:'U';$this->fmtDateTime=isset($config['formatDateTime'])?$config['formatDateTime']:'U';$errorMsg='';if(isset($config['resource'])){$this->connection=$config['resource'];}elseif(empty($config['persistent'])){$this->connection=@sqlite_open($config['database'],0666,$errorMsg);}else{$this->connection=@sqlite_popen($config['database'],0666,$errorMsg);}if(!$this->connection){throw
    1638. 

  1638. new
    1639. 

  1639. DibiDriverException($errorMsg);}$this->buffered=empty($config['unbuffered']);$this->dbcharset=empty($config['dbcharset'])?'UTF-8':$config['dbcharset'];$this->charset=empty($config['charset'])?'UTF-8':$config['charset'];if(strcasecmp($this->dbcharset,$this->charset)===0){$this->dbcharset=$this->charset=NULL;}}public
    1640. 

  1640. function
    1641. 

  1641. disconnect(){sqlite_close($this->connection);}public
    1642. 

  1642. function
    1643. 

  1643. query($sql){if($this->dbcharset!==NULL){$sql=iconv($this->charset,$this->dbcharset.'//IGNORE',$sql);}DibiDriverException::tryError();if($this->buffered){$this->resultSet=sqlite_query($this->connection,$sql);}else{$this->resultSet=sqlite_unbuffered_query($this->connection,$sql);}if(DibiDriverException::catchError($msg)){throw
    1644. 

  1644. new
    1645. 

  1645. DibiDriverException($msg,sqlite_last_error($this->connection),$sql);}return
    1646. 

  1646. is_resource($this->resultSet)?clone$this:NULL;}public
    1647. 

  1647. function
    1648. 

  1648. getAffectedRows(){return
    1649. 

  1649. sqlite_changes($this->connection);}public
    1650. 

  1650. function
    1651. 

  1651. getInsertId($sequence){return
    1652. 

  1652. sqlite_last_insert_rowid($this->connection);}public
    1653. 

  1653. function
    1654. 

  1654. begin($savepoint=NULL){$this->query('BEGIN');}public
    1655. 

  1655. function
    1656. 

  1656. commit($savepoint=NULL){$this->query('COMMIT');}public
    1657. 

  1657. function
    1658. 

  1658. rollback($savepoint=NULL){$this->query('ROLLBACK');}public
    1659. 

  1659. function
    1660. 

  1660. getResource(){return$this->connection;}public
    1661. 

  1661. function
    1662. 

  1662. getReflector(){return
    1663. 

  1663. new
    1664. 

  1664. DibiSqliteReflector($this);}public
    1665. 

  1665. function
    1666. 

  1666. escape($value,$type){switch($type){case
    1667. 

  1667. dibi::TEXT:case
    1668. 

  1668. dibi::BINARY:return"'".sqlite_escape_string($value)."'";case
    1669. 

  1669. dibi::IDENTIFIER:return'['.strtr($value,'[]','  ').']';case
    1670. 

  1670. dibi::BOOL:return$value?1:0;case
    1671. 

  1671. dibi::DATE:return$value
    1672. 

  1672. instanceof
    1673. 

  1673. DateTime?$value->format($this->fmtDate):date($this->fmtDate,$value);case
    1674. 

  1674. dibi::DATETIME:return$value
    1675. 

  1675. instanceof
    1676. 

  1676. DateTime?$value->format($this->fmtDateTime):date($this->fmtDateTime,$value);default:throw
    1677. 

  1677. new
    1678. 

  1678. InvalidArgumentException('Unsupported type.');}}public
    1679. 

  1679. function
    1680. 

  1680. unescape($value,$type){if($type===dibi::BINARY){return$value;}throw
    1681. 

  1681. new
    1682. 

  1682. InvalidArgumentException('Unsupported type.');}public
    1683. 

  1683. function
    1684. 

  1684. applyLimit(&$sql,$limit,$offset){if($limit<0&&$offset<1)return;$sql.=' LIMIT '.$limit.($offset>0?' OFFSET '.(int)$offset:'');}public
    1685. 

  1685. function
    1686. 

  1686. getRowCount(){if(!$this->buffered){throw
    1687. 

  1687. new
    1688. 

  1688. DibiDriverException('Row count is not available for unbuffered queries.');}return
    1689. 

  1689. sqlite_num_rows($this->resultSet);}public
    1690. 

  1690. function
    1691. 

  1691. fetch($assoc){$row=sqlite_fetch_array($this->resultSet,$assoc?SQLITE_ASSOC:SQLITE_NUM);$charset=$this->charset===NULL?NULL:$this->charset.'//TRANSLIT';if($row&&($assoc||$charset)){$tmp=array();foreach($row
    1692. 

  1692. as$k=>$v){if($charset!==NULL&&is_string($v)){$v=iconv($this->dbcharset,$charset,$v);}$tmp[str_replace(array('[',']'),'',$k)]=$v;}return$tmp;}return$row;}public
    1693. 

  1693. function
    1694. 

  1694. seek($row){if(!$this->buffered){throw
    1695. 

  1695. new
    1696. 

  1696. DibiDriverException('Cannot seek an unbuffered result set.');}return
    1697. 

  1697. sqlite_seek($this->resultSet,$row);}public
    1698. 

  1698. function
    1699. 

  1699. free(){$this->resultSet=NULL;}public
    1700. 

  1700. function
    1701. 

  1701. getResultColumns(){$count=sqlite_num_fields($this->resultSet);$res=array();for($i=0;$i<$count;$i++){$name=str_replace(array('[',']'),'',sqlite_field_name($this->resultSet,$i));$pair=explode('.',$name);$res[]=array('name'=>isset($pair[1])?$pair[1]:$pair[0],'table'=>isset($pair[1])?$pair[0]:NULL,'fullname'=>$name,'nativetype'=>NULL);}return$res;}public
    1702. 

  1702. function
    1703. 

  1703. getResultResource(){return$this->resultSet;}public
    1704. 

  1704. function
    1705. 

  1705. registerFunction($name,$callback,$numArgs=-1){sqlite_create_function($this->connection,$name,$callback,$numArgs);}public
    1706. 

  1706. function
    1707. 

  1707. registerAggregateFunction($name,$rowCallback,$agrCallback,$numArgs=-1){sqlite_create_aggregate($this->connection,$name,$rowCallback,$agrCallback,$numArgs);}}class
    1708. 

  1708. DibiSqlite3Driver
    1709. 

  1709. extends
    1710. 

  1710. DibiObject
    1711. 

  1711. implements
    1712. 

  1712. IDibiDriver,IDibiResultDriver{private$connection;private$resultSet;private$fmtDate,$fmtDateTime;private$dbcharset,$charset;public
    1713. 

  1713. function
    1714. 

  1714. __construct(){if(!extension_loaded('sqlite3')){throw
    1715. 

  1715. new
    1716. 

  1716. DibiDriverException("PHP extension 'sqlite3' is not loaded.");}}public
    1717. 

  1717. function
    1718. 

  1718. connect(array&$config){DibiConnection::alias($config,'database','file');$this->fmtDate=isset($config['formatDate'])?$config['formatDate']:'U';$this->fmtDateTime=isset($config['formatDateTime'])?$config['formatDateTime']:'U';if(isset($config['resource'])&&$config['resource']instanceof
    1719. 

  1719. SQLite3){$this->connection=$config['resource'];}else
    1720. 

  1720. try{$this->connection=new
    1721. 

  1721. SQLite3($config['database']);}catch(Exception$e){throw
    1722. 

  1722. new
    1723. 

  1723. DibiDriverException($e->getMessage(),$e->getCode());}$this->dbcharset=empty($config['dbcharset'])?'UTF-8':$config['dbcharset'];$this->charset=empty($config['charset'])?'UTF-8':$config['charset'];if(strcasecmp($this->dbcharset,$this->charset)===0){$this->dbcharset=$this->charset=NULL;}$version=SQLite3::version();if($version['versionNumber']>='3006019'){$this->query("PRAGMA foreign_keys = ON");}}public
    1724. 

  1724. function
    1725. 

  1725. disconnect(){$this->connection->close();}public
    1726. 

  1726. function
    1727. 

  1727. query($sql){if($this->dbcharset!==NULL){$sql=iconv($this->charset,$this->dbcharset.'//IGNORE',$sql);}$this->resultSet=@$this->connection->query($sql);if($this->connection->lastErrorCode()){throw
    1728. 

  1728. new
    1729. 

  1729. DibiDriverException($this->connection->lastErrorMsg(),$this->connection->lastErrorCode(),$sql);}return$this->resultSet
    1730. 

  1730. instanceof
    1731. 

  1731. SQLite3Result?clone$this:NULL;}public
    1732. 

  1732. function
    1733. 

  1733. getAffectedRows(){return$this->connection->changes();}public
    1734. 

  1734. function
    1735. 

  1735. getInsertId($sequence){return$this->connection->lastInsertRowID();}public
    1736. 

  1736. function
    1737. 

  1737. begin($savepoint=NULL){$this->query($savepoint?"SAVEPOINT $savepoint":'BEGIN');}public
    1738. 

  1738. function
    1739. 

  1739. commit($savepoint=NULL){$this->query($savepoint?"RELEASE SAVEPOINT $savepoint":'COMMIT');}public
    1740. 

  1740. function
    1741. 

  1741. rollback($savepoint=NULL){$this->query($savepoint?"ROLLBACK TO SAVEPOINT $savepoint":'ROLLBACK');}public
    1742. 

  1742. function
    1743. 

  1743. getResource(){return$this->connection;}public
    1744. 

  1744. function
    1745. 

  1745. getReflector(){return
    1746. 

  1746. new
    1747. 

  1747. DibiSqliteReflector($this);}public
    1748. 

  1748. function
    1749. 

  1749. escape($value,$type){switch($type){case
    1750. 

  1750. dibi::TEXT:return"'".$this->connection->escapeString($value)."'";case
    1751. 

  1751. dibi::BINARY:return"X'".bin2hex((string)$value)."'";case
    1752. 

  1752. dibi::IDENTIFIER:return'['.strtr($value,'[]','  ').']';case
    1753. 

  1753. dibi::BOOL:return$value?1:0;case
    1754. 

  1754. dibi::DATE:return$value
    1755. 

  1755. instanceof
    1756. 

  1756. DateTime?$value->format($this->fmtDate):date($this->fmtDate,$value);case
    1757. 

  1757. dibi::DATETIME:return$value
    1758. 

  1758. instanceof
    1759. 

  1759. DateTime?$value->format($this->fmtDateTime):date($this->fmtDateTime,$value);default:throw
    1760. 

  1760. new
    1761. 

  1761. InvalidArgumentException('Unsupported type.');}}public
    1762. 

  1762. function
    1763. 

  1763. unescape($value,$type){if($type===dibi::BINARY){return$value;}throw
    1764. 

  1764. new
    1765. 

  1765. InvalidArgumentException('Unsupported type.');}public
    1766. 

  1766. function
    1767. 

  1767. applyLimit(&$sql,$limit,$offset){if($limit<0&&$offset<1)return;$sql.=' LIMIT '.$limit.($offset>0?' OFFSET '.(int)$offset:'');}public
    1768. 

  1768. function
    1769. 

  1769. getRowCount(){throw
    1770. 

  1770. new
    1771. 

  1771. NotSupportedException('Row count is not available for unbuffered queries.');}public
    1772. 

  1772. function
    1773. 

  1773. fetch($assoc){$row=$this->resultSet->fetchArray($assoc?SQLITE3_ASSOC:SQLITE3_NUM);$charset=$this->charset===NULL?NULL:$this->charset.'//TRANSLIT';if($row&&($assoc||$charset)){$tmp=array();foreach($row
    1774. 

  1774. as$k=>$v){if($charset!==NULL&&is_string($v)){$v=iconv($this->dbcharset,$charset,$v);}$tmp[str_replace(array('[',']'),'',$k)]=$v;}return$tmp;}return$row;}public
    1775. 

  1775. function
    1776. 

  1776. seek($row){throw
    1777. 

  1777. new
    1778. 

  1778. NotSupportedException('Cannot seek an unbuffered result set.');}public
    1779. 

  1779. function
    1780. 

  1780. free(){$this->resultSet=NULL;}public
    1781. 

  1781. function
    1782. 

  1782. getResultColumns(){$count=$this->resultSet->numColumns();$res=array();static$types=array(SQLITE3_INTEGER=>'int',SQLITE3_FLOAT=>'float',SQLITE3_TEXT=>'text',SQLITE3_BLOB=>'blob',SQLITE3_NULL=>'null');for($i=0;$i<$count;$i++){$res[]=array('name'=>$this->resultSet->columnName($i),'table'=>NULL,'fullname'=>$this->resultSet->columnName($i),'nativetype'=>$types[$this->resultSet->columnType($i)]);}return$res;}public
    1783. 

  1783. function
    1784. 

  1784. getResultResource(){return$this->resultSet;}public
    1785. 

  1785. function
    1786. 

  1786. registerFunction($name,$callback,$numArgs=-1){$this->connection->createFunction($name,$callback,$numArgs);}public
    1787. 

  1787. function
    1788. 

  1788. registerAggregateFunction($name,$rowCallback,$agrCallback,$numArgs=-1){$this->connection->createAggregate($name,$rowCallback,$agrCallback,$numArgs);}}
    1789.