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 . ';');
}
