aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorVlatka Pavisic2017-01-04 14:00:39 +0100
committerVlatka Pavisic2017-01-04 14:00:39 +0100
commitaf34cb854255f2893a27e28b11a2601d6af8a725 (patch)
tree4da1c8de8b34069a2d816869c46576dc3d98e5a4 /db
parentd1e76469119acd0d92cdb65fa8e9a5b61803b3a3 (diff)
parentc11be6d012dd77101721900168b9acc64db66e49 (diff)
downloadchouette-core-af34cb854255f2893a27e28b11a2601d6af8a725.tar.bz2
Merge master
Diffstat (limited to 'db')
-rw-r--r--db/migrate/20150312104557_set_default_value_for_data_format_in_organisation.rb19
1 files changed, 2 insertions, 17 deletions
diff --git a/db/migrate/20150312104557_set_default_value_for_data_format_in_organisation.rb b/db/migrate/20150312104557_set_default_value_for_data_format_in_organisation.rb
index 9efd941c4..03d48e0bb 100644
--- a/db/migrate/20150312104557_set_default_value_for_data_format_in_organisation.rb
+++ b/db/migrate/20150312104557_set_default_value_for_data_format_in_organisation.rb
@@ -1,22 +1,7 @@
class SetDefaultValueForDataFormatInOrganisation < ActiveRecord::Migration
def change
- Organisation.all.each do |organisation|
- if organisation.data_format.neptune?
- organisation.update_attributes :data_format => "neptune"
- end
- end
- Referential.all.each do |referential|
- if referential.data_format.neptune?
- referential.update_attributes :data_format => "neptune"
- elsif referential.data_format.netex?
- referential.update_attributes :data_format => "netex"
- elsif referential.data_format.gtfs?
- referential.update_attributes :data_format => "gtfs"
- elsif referential.data_format.hub?
- referential.update_attributes :data_format => "hub"
- end
- end
-
+ Organisation.where(data_format: nil).update_all(data_format: "neptune")
+ execute "update referentials set data_format = organisations.data_format from organisations where referentials.data_format is null and referentials.organisation_id = organisations.id"
change_column :organisations, :data_format, :string, :default => "neptune"
end
end