/** * Drop removed types * Add new types * Apply type definition differences, updating the type's tables along the way * * @param $ofs output file segmenter * @param $old_schema original schema * @param $new_schema new schema */ public static function apply_changes($ofs, $old_schema, $new_schema) { // drop any types that are no longer defined self::drop_types($ofs, $old_schema, $new_schema); // create any types that are new in the new definition self::create_types($ofs, $old_schema, $new_schema); // there is no alter for types // find types that still exist that are different // placehold type data in table columns, and recreate the type foreach (dbx::get_types($new_schema) as $new_type) { // does type exist in old definition ? if ($old_schema == NULL || !mssql10_schema::contains_type($old_schema, $new_type['name'])) { continue; } $old_type = dbx::get_type($old_schema, $new_type['name']); // is there a difference between the old and new type definitions? if (mssql10_type::equals($old_schema, $old_type, $new_schema, $new_type)) { continue; } $columns = array(); $ofs->write("-- type " . $new_type['name'] . " definition migration (1/4): dependant tables column constraint drop\n"); $ofs->write(mssql10_type::column_constraint_temporary_drop($columns, $old_schema, $old_type) . "\n"); $ofs->write("-- type " . $new_type['name'] . " definition migration (2/4): delete type list values\n"); $ofs->write(mssql10_type::get_enum_value_delete($old_schema, $old_type) . "\n"); $ofs->write("-- type " . $new_type['name'] . " definition migration (3/4): recreate type list values\n"); $ofs->write(mssql10_type::get_enum_value_insert($new_schema, $new_type) . "\n"); $ofs->write("-- type " . $new_type['name'] . " definition migration (4/4): restore dependant tables column constraint add\n"); $ofs->write(mssql10_type::column_constraint_restore($columns, $new_schema, $new_type) . "\n"); } }