public function edit() { $sql = "update " . $this->DBtable . " set "; // $data = $this->getData(); // $i = 0; // foreach ($data as $key => $value) { if ($i == 0) { $sql .= "{$key}='{$value}'"; } else { $sql .= ",{$key}='{$value}'"; } $i++; } if ($this->isMaj) { if ($i == 0) { $sql .= "edited_at='" . Time::now() . "'"; } else { $sql .= ",edited_at='" . Time::now() . "'"; } } // $key = $this->getPKvalue(); $sql .= " where " . $this->primaryKey . "='" . $key . "'"; // return Database::exec($sql); }
public static function rollback() { $Root = "../"; $r = glob("../app/schemas/*.php"); // $pieces = array(); $pieces1 = array(); $pieces2 = array(); $full_names = array(); // $time = ""; $name = ""; // $f = array(); foreach ($r as $key) { //echo $key."\n"; $pieces = explode("app/schemas/", $key); $pieces1 = explode("_", $pieces[1]); $time = $pieces1[0]; $p = explode(".", $pieces1[1]); $name = $p[0]; $f[] = $pieces1[0]; $pieces2[] = $pieces[1]; // $full_names = $pieces1[0] . "_" . $name; } $mx = max($f); // $ind = 0; $i = 0; // foreach ($pieces2 as $value) { if (strpos($value, $mx) !== false) { $ind = $i; } $i++; } $link = $r[$ind]; // try { include_once $link; if (down()) { if (Schema::existe(Config::get('database.migration'))) { Database::exec("update " . Config::get('database.migration') . " set status_schema='rolledback' where name_schema='" . $name . "' and date_schema='" . $time . "'"); } $full_names = $time . "_" . $name; Migration::updateRegister($full_names, "rollback", $Root); echo "Schéma annulé"; } else { echo "Schema n'est pas annulé" . Database::execErr(); } } catch (Exception $e) { echo $e->getMessage(); } }
protected function forget($key) { //$sql="delete from fiestacache where name='".$key."'"; $key = $this->hash($key); return Database::exec("delete from " . $this->DatabaseTableName() . " where name='" . $key . "'"); }
public static function remove($nom, $colmuns) { $name = self::tableName($nom); // self::$main_sql = "alter table " . $name . " "; // if (is_array($colmuns)) { // foreach ($colmuns as $value) { for ($i = 0; $i < count($colmuns); $i++) { if ($i == count($colmuns) - 1) { self::$main_sql .= " drop " . $colmuns[$i]; } else { self::$main_sql .= " drop " . $colmuns[$i] . ","; } } } else { self::$main_sql .= " drop " . $colmuns; } // return Database::exec(self::$main_sql); }
public function clear() { Database::exec('TRUNCATE TABLE ' . $this->name . ';'); }