function mdle_sql_fielddef($table, $col)
{
global $pdo;
$sql = mdle_field_type($table, $col);
$data = $table['fields'][$col];
if (!isset($data['null']) || !$data['null']) {
$sql .= ' NOT';
}
$sql .= ' NULL';
if ($data['type'] == 'auto_int') {
$sql .= ' AUTO_INCREMENT';
}
if (isset($data['default'])) {
$sql .= ' DEFAULT ' . $pdo->quote($data['default']);
} elseif ($data['type'] == 'file') {
$sql .= ' DEFAULT NULL';
}
return $sql;
}
$installed_tables = array();
$sql = $pdo->query('SHOW TABLES');
while ($t = $sql->fetch()) {
$installed_tables[] = $t[0];
}
$delete_tables = array_diff($installed_tables, $need_tables);
$install_tables = array_diff($need_tables, $installed_tables);
$verify_tables = array_intersect($need_tables, $installed_tables);
$modify_tables = array();
foreach ($verify_tables as $table) {
$sql = $pdo->query("SHOW COLUMNS FROM {$table}");
$fields = array();
$modify_fields = array();
while ($c = $sql->fetch()) {
$fields[] = $c['Field'];
if ($c['Type'] != mdle_field_type($define_tables[$table], $c['Field'])) {
$modify_fields[] = $c['Field'];
} elseif (isset($define_tables[$table]['fields'][$c['Field']]['null']) && $c['Null'] != 'YES') {
$modify_fields[] = $c['Field'];
}
}
$del_fields = array_diff($fields, array_keys($define_tables[$table]['fields']));
$add_fields = array_diff(array_keys($define_tables[$table]['fields']), $fields);
if (count($add_fields) + count($del_fields) + count($modify_fields) != 0) {
$modify_tables[] = array('table' => $table, 'add' => $add_fields, 'del' => $del_fields, 'modify' => $modify_fields);
}
}
$sql_queries = array();
foreach ($delete_tables as $table) {
$sql_queries[] = "DROP TABLE {$table}";
}
public function _updateModels()
{
global $pdo;
$moddir = $this->extdir . '/models';
$matchs = null;
$sqlTables = $pdo->query('show tables');
$inTables = array();
$defTables = array();
while ($line = $sqlTables->fetch()) {
$inTables[$line[0]] = array();
}
foreach (scandir($moddir) as $modfile) {
if (preg_match('`^(.*)\\.yml$`', $modfile, $matchs)) {
$def = spyc_load_file($moddir . '/' . $modfile);
$defTables[$def['name']] = $def;
}
}
//Ajout des tables
$addTables = array_diff_key($defTables, $inTables);
foreach ($addTables as $table) {
$pdo->execute(mdle_sql_create($table));
}
$checkTables = array_intersect_key($defTables, $inTables);
$modTables = array();
foreach ($checkTables as $table => $def) {
$sql = $pdo->query("SHOW COLUMNS FROM {$table}");
$fields = array();
$modify_fields = array();
while ($c = $sql->fetch()) {
$fields[] = $c['Field'];
if ($c['Type'] != mdle_field_type($defTables[$table], $c['Field'])) {
$modify_fields[] = $c['Field'];
} elseif (isset($defTables[$table]['fields'][$c['Field']]['null']) && $c['Null'] != 'YES') {
$modify_fields[] = $c['Field'];
}
}
$del_fields = array_diff($fields, array_keys($defTables[$table]['fields']));
$add_fields = array_diff(array_keys($defTables[$table]['fields']), $fields);
if (count($add_fields) + count($del_fields) + count($modify_fields) != 0) {
$modTables[] = array('table' => $table, 'add' => $add_fields, 'del' => $del_fields, 'modify' => $modify_fields);
}
}
foreach ($modTables as $tdef) {
$sql = 'ALTER TABLE `' . $tdef['table'] . "`";
$first = true;
foreach ($tdef['del'] as $col) {
if ($first) {
$first = false;
} else {
$sql .= ',';
}
$sql .= "\n DEL `{$col}`";
}
foreach ($tdef['add'] as $col) {
if ($first) {
$first = false;
} else {
$sql .= ',';
}
$sql .= "\n ADD `{$col}` ";
$sql .= mdle_sql_fielddef($defTables[$tdef['table']], $col);
}
foreach ($tdef['modify'] as $col) {
if ($first) {
$first = false;
} else {
$sql .= ',';
}
$sql .= "\n MODIFY `{$col}` ";
$sql .= mdle_sql_fielddef($defTables[$tdef['table']], $col);
}
$pdo->query($sql);
}
return true;
}
