public function createDB()
{
if (!$this->db->tableExists('migration')) {
$sql = "\r\n\t\t\tCREATE TABLE `migration`\r\n\t\t\t(\r\n\t\t\t\t`id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t`name` VARCHAR(255) NOT NULL,\r\n\t\t\t\t`date` DATETIME NOT NULL,\r\n\t\t\t\t`isUp` INT NOT NULL\r\n\t\t\t);\r\n\t\t";
$this->db->query($sql);
}
}
protected function validateFields($fields)
{
$messenges = [];
if (count($fields) > 0) {
foreach ($fields as $obj) {
$object = $field = null;
foreach ($obj as $ob => $fi) {
$object = $ob;
$field = $fi;
}
if (!$object || !$field) {
array_push($messenges, "Fatal error object or field empty!");
}
if (!$this->db->tableExists($object)) {
array_push($messenges, "Table `{$object}` in which you are going to insert a field `{$field}` does not exist in your database!");
} elseif ($this->db->tableColumnExists($object, $field)) {
array_push($messenges, "Field `{$field}` already exists in your table `{$object}`!");
}
}
}
return count($messenges) > 0 ? $messenges : true;
}
