function __construct()
 {
     $IP = Session::IP();
     \Radical\DB::Q('INSERT INTO session (session_ip,session_time) VALUES(' . \Radical\DB::E($IP) . ',' . time() . ') ON DUPLICATE KEY UPDATE session_time=' . time());
     $this->id = \Radical\DB::insertId();
     parent::__construct();
 }
Ejemplo n.º 2
0
 function search($text, TableReferenceInstance $table)
 {
     $orm = $table->getORM();
     $sql = new SelectStatement($table->getTable(), $orm->id);
     $this->_Filter($text, $sql);
     $res = \Radical\DB::Q($sql);
     $rows = $res->FetchAll();
     return $rows;
 }
Ejemplo n.º 3
0
 static function fromTable($table)
 {
     $query = new ShowCreateTable($table);
     try {
         $res = \Radical\DB::Q($query->toSQL());
         $data = $res->Fetch(DBAL\Fetch::NUM);
     } catch (\Exception $ex) {
         throw new \Exception('Couldnt get Create Table (' . $ex->getMessage() . ') for ' . $table, null, $ex);
     }
     return new static($data[1]);
 }
Ejemplo n.º 4
0
 private function _triggerCreate($myisam, $innodb, $fields)
 {
     $sql = 'create trigger ' . $myisam . ' after insert on ' . $innodb;
     $sql .= ' FOR EACH ROW insert into ' . $myisam . ' VALUES(';
     foreach ($fields as $f) {
         $sql .= 'new.' . $f . ',';
     }
     $sql = substr($sql, 0, -1);
     $sql .= ')';
     \Radical\DB::Q($sql);
 }
Ejemplo n.º 5
0
 static function init()
 {
     self::$pool = \Radical\Cache\PooledCache::get('radical_orm', 'Memory');
     global $_SQL;
     $cfile = '/tmp/' . $_SQL->getDb();
     if (file_exists($cfile) && filemtime($cfile) >= time() - 30) {
         self::$key = file_get_contents($cfile);
     } else {
         touch($cfile);
         $sql = 'SELECT MAX(UNIX_TIMESTAMP( CREATE_TIME )) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = "' . $_SQL->getDb() . '"';
         self::$key = \Radical\DB::Q($sql)->Fetch(Fetch::FIRST);
         file_put_contents($cfile, self::$key);
     }
     if (Server::isProduction()) {
         self::$data = self::$pool->get($_SQL->getDb() . '_' . self::$key);
         register_shutdown_function(function () {
             Cache::save();
         });
     }
     if (!is_array(self::$data)) {
         self::$data = array();
     }
 }
Ejemplo n.º 6
0
 function ensureExists($drop = false)
 {
     //Check if we need to do anything
     if ($this->Exists()) {
         if ($this->ValidateFields()) {
             return true;
         } else {
             if ($drop) {
                 \Radical\DB::Q('DROP TABLE ' . $this->_tableName);
             }
         }
     }
     //Create
     $this->Create();
     return false;
 }
Ejemplo n.º 7
0
 function execute()
 {
     $sql = $this->toSQL();
     return \Radical\DB::Q($sql);
 }
Ejemplo n.º 8
0
 function exists()
 {
     $sql = 'show tables like ' . \Radical\DB::E($this->getTable());
     $res = \Radical\DB::Q($sql);
     if ($res->Fetch()) {
         return true;
     }
     return false;
 }