public static function make($table, $value, $type = 'insert', $conditions = "") { magic::proc($value); switch (strtolower($type)) { case "insert": $keys = ""; $vals = ""; foreach ($value as $key => $val) { if (!isset($donekey)) { $keys .= "("; } $vals .= "("; foreach ($val as $k => $v) { if (!isset($donekey)) { $keys .= "`{$k}`,"; } $vals .= "'{$v}',"; } if (!isset($donekey)) { $keys = substr($keys, 0, -1); $keys .= ") "; $donekey = true; } $vals = substr($vals, 0, -1); $vals .= "),"; } $vals = substr($vals, 0, -1); $qry = "insert into {$table}{$keys} values{$vals};"; break; case "update": $keys = ""; foreach ($value as $key => $val) { $keys .= Tools::arrtostr($val, ", ", "'", "`") . ", "; } $keys = substr($keys, 0, -2); $qry = "update {$table} set {$keys}"; if ($conditions) { $qry .= " where {$conditions};"; } break; case "delete": $keys = ""; foreach ($value as $key => $val) { $keys .= "("; $keys .= Tools::arrtostr($val, " and ", "'", "`") . ") or "; } $keys = substr($keys, 0, -4); $qry = "delete from {$table} where {$keys};"; break; default: $qry = false; } return $qry; }
public function doload($ref) { $qry = query::make("{$ref}", $arr, "select"); switch ($ref) { case "wal": // Dbqry magic::proc($ret, false); break; default: // Dbqry } return false; }
public static function load($ref = null) { $ref = $ref ? $ref : config::$walfile; /*$s = __class__; $engine = config::$storageengine.$s; $s = new $s; aggregate($s,$engine); $ret = $s->doload($ref);*/ $loc = Tools::makepath(array("wal", "{$ref}")); $ret = unserialize(gio::readfile($loc)); if ($ref == config::$walfile) { magic::proc($ret, false); } return $ret; }