lib/code.php

   1 <?php
   2
   3         require_once "persistance.php";
   4         require_once "database.php";
   5
   6         class SqlCode implements sql, persistance
   7         {
   8                 static $db;
   9                 var $id;
  10                 var $code;
  11                 var $date;
  12
  13                 function __construct($code)
  14                 {
  15                         $this->code = $code;
  16                         $this->date = date('c');
  17                         $this->id = 'md5:'. md5($this->code);
  18                 }
  19
  20                 public static function get_table_name()
  21                 {
  22                         return "sql";
  23                 }
  24
  25                 public static function sql_select($options = NULL)
  26                 {
  27                         $table = self::get_table_name();
  28                         $query = "select id, code, date from $table $options";
  29                         return $query;
  30                 }
  31
  32                 function toSQLselect()
  33                 {
  34                         $table = $this->get_table_name();
  35                         $id    = $this->id;
  36                         $query = "select id, code, date from $table where id='$id'";
  37                         return $query;
  38                 }
  39
  40                 function toSQLinsert()
  41                 {
  42                         $table = $this->get_table_name();
  43                         $id    = $this->id;
  44                         $code  = str_replace("'", "''",$this->code);
  45                         $date  = $this->date;
  46                         $query = "insert into $table (id, code, date) values ('$id', '$code', '$date')";
  47                         return $query;
  48                 }
  49
  50                 static function set_db($db)
  51                 {
  52                         if ($db instanceof PDO) {
  53                                 self::$db =& $db;
  54                         } else {
  55                                 if (empty($user)) {
  56                                         self::$db =& new PDO($db);
  57                                 } else {
  58                                         self::$db =& new PDO($db, $user, $password);
  59                                 }
  60                         }
  61                         self::$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  62
  63                         return self::$db;
  64                 }
  65
  66                 static function select($options = NULL, $db = NULL)
  67                 {
  68                         if (!$db) $db =& self::$db;
  69                         $query = self::sql_select($options);
  70                         $result = $db->query($query);
  71                         $scripts = array();
  72                         foreach ($result as $r) {
  73                                 $s       = new SqlCode($r['code']);
  74                                 $s->id   = $r['id'];
  75                                 $s->date = $r['date'];
  76                                 $scripts []= $s;
  77                         }
  78                         return $scripts;
  79                 }
  80
  81                 function save($db = NULL)
  82                 {
  83                         if (!$db) $db =& self::$db;
  84                         $query = $this->toSQLinsert();
  85                         $id = $this->id;
  86                         $table = self::get_table_name();
  87                         try {
  88                                 $db->exec($query);
  89                         } catch (PDOException $e) {
  90                                 if ($db->errorCode() == "23000") { // l'id existe dans la table
  91                                         $db->exec("delete from $table where id='$id'");
  92                                         $db->exec($query);
  93                                 } else {
  94                                         die($e->getMessage());
  95                                 }
  96                         }
  97                         return $this;
  98                 }
  99
 100                 static function search($string, $options = NULL)
 101                 {
 102                         $options = str_replace("where", "and", $options);
 103                         $scripts = self::select("where code like '%$string%' $options");
 104                         return $scripts;
 105                 }
 106
 107                 function exec($db)
 108                 {
 109                         $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
 110                         $result = $db->query($this->code);
 111                         return $result;
 112                 }
 113
 114                 function extractColumns()
 115                 {
 116                         eregi('create +table +[^(]+\(([^)]+)', $this->code, $strings);
 117                         $columns = split(',', $strings[1]);
 118                         for ($i=0; $i < count($columns); $i++) {
 119                                 $c = new Column(firstWord($columns[$i]));
 120                                 $columns[$i] = $c;
 121                         }
 122                         return $columns;
 123                 }
 124
 125                 function toHTML()
 126                 {
 127                         $html = $this->code;
 128                         $html = preg_replace("/\'(.*?)(\')/", '<s>\'$1$2</s>', $html);
 129                         $html = preg_replace("/\b(add|after|aggregate|alias|all|and|as|authorization|between|by|cascade|cache|cache|called|case|check|column|comment|constraint|createdb|createuser|cycle|database|default|deferrable|deferred|diagnostics|distinct|domain|each|else|elseif|elsif|encrypted|except|exception|for|foreign|from|from|full|function|get|group|having|if|immediate|immutable|in|increment|initially|increment|index|inherits|inner|input|intersect|into|invoker|is|join|key|language|left|like|limit|local|loop|match|maxvalue|minvalue|natural|nextval|no|nocreatedb|nocreateuser|not|null|of|offset|oids|on|only|operator|or|order|outer|owner|partial|password|perform|plpgsql|primary|record|references|replace|restrict|return|returns|right|row|rule|schema|security|sequence|session|sql|stable|statistics|table|temp|temporary|then|time|to|transaction|trigger|type|unencrypted|union|unique|user|using|valid|value|values|view|volatile|when|where|with|without|zone)\b/i", '<b>$1</b>', $html);
 130                         $html = preg_replace("/\b(bigint|bigserial|bit|boolean|box|bytea|char|character|cidr|circle|date|decimal|double|float4|float8|inet|int2|int4|int8|integer|interval|line|lseg|macaddr|money|numeric|oid|path|point|polygon|precision|real|refcursor|serial|serial4|serial8|smallint|text|timestamp|varbit|varchar)\b/i", '<u>$1</u>', $html);
 131                         $html = preg_replace("/\b(abort|alter|analyze|begin|checkpoint|close|cluster|comment|commit|copy|create|deallocate|declare|delete|drop|end|execute|explain|fetch|grant|insert|listen|load|lock|move|notify|prepare|reindex|reset|restart|revoke|rollback|select|set|show|start|truncate|unlisten|update)\b/", '<a>$1</a>', $html);
 132                         $html = preg_replace('/\-\-([^\n]*\n)/', '<i>--$1</i>', $html);
 133                         return $html;
 134                 }
 135         }