public function createUpdateTable(Object\ClassDefinition $class)
{
$tableStore = $this->getTableName($class, false);
$tableQuery = $this->getTableName($class, true);
$this->db->query("CREATE TABLE IF NOT EXISTS `" . $tableStore . "` (\n\t\t `o_id` int(11) NOT NULL default '0',\n `fieldname` varchar(190) default '',\n PRIMARY KEY (`o_id`,`fieldname`),\n INDEX `o_id` (`o_id`),\n INDEX `fieldname` (`fieldname`)\n\t\t) DEFAULT CHARSET=utf8mb4;");
$this->db->query("CREATE TABLE IF NOT EXISTS `" . $tableQuery . "` (\n\t\t `o_id` int(11) NOT NULL default '0',\n `fieldname` varchar(190) default '',\n PRIMARY KEY (`o_id`,`fieldname`),\n INDEX `o_id` (`o_id`),\n INDEX `fieldname` (`fieldname`)\n\t\t) DEFAULT CHARSET=utf8mb4;");
$existingColumnsStore = $this->getValidTableColumns($tableStore, false);
// no caching of table definition
$columnsToRemoveStore = $existingColumnsStore;
$existingColumnsQuery = $this->getValidTableColumns($tableQuery, false);
// no caching of table definition
$columnsToRemoveQuery = $existingColumnsQuery;
$protectedColumnsStore = ["o_id", "fieldname"];
$protectedColumnsQuery = ["o_id", "fieldname"];
Object\ClassDefinition\Service::updateTableDefinitions($this->tableDefinitions, [$tableStore, $tableQuery]);
foreach ($this->model->getFieldDefinitions() as $value) {
$key = $value->getName();
// if a datafield requires more than one column in the query table
if (is_array($value->getQueryColumnType())) {
foreach ($value->getQueryColumnType() as $fkey => $fvalue) {
$this->addModifyColumn($tableQuery, $key . "__" . $fkey, $fvalue, "", "NULL");
$protectedColumnsQuery[] = $key . "__" . $fkey;
}
}
// if a datafield requires more than one column in the datastore table => only for non-relation types
if (!$value->isRelationType() && is_array($value->getColumnType())) {
foreach ($value->getColumnType() as $fkey => $fvalue) {
$this->addModifyColumn($tableStore, $key . "__" . $fkey, $fvalue, "", "NULL");
$protectedColumnsStore[] = $key . "__" . $fkey;
}
}
// everything else
if (!is_array($value->getQueryColumnType()) && !is_array($value->getColumnType())) {
if ($value->getQueryColumnType()) {
$this->addModifyColumn($tableQuery, $key, $value->getQueryColumnType(), "", "NULL");
$protectedColumnsQuery[] = $key;
}
if ($value->getColumnType() && !$value->isRelationType()) {
$this->addModifyColumn($tableStore, $key, $value->getColumnType(), "", "NULL");
$protectedColumnsStore[] = $key;
}
}
// add indices
$this->addIndexToField($value, $tableStore);
$this->addIndexToField($value, $tableQuery);
}
$this->removeUnusedColumns($tableStore, $columnsToRemoveStore, $protectedColumnsStore);
$this->removeUnusedColumns($tableQuery, $columnsToRemoveQuery, $protectedColumnsQuery);
}