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; }