aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorcedricnjanga2017-11-22 10:20:03 +0100
committercedricnjanga2017-11-22 10:20:03 +0100
commiteec1d9e43509a1677d346584ee24cd3ee6f8c124 (patch)
tree5ea0ffc28a65f7178e5f11ae19cff353139d3159 /db
parent577204834de4dfcd1851fc9b5f85558eaa141a89 (diff)
parentf01e81604053e9cbdaf4b84534214e37fbfcae5e (diff)
downloadchouette-core-eec1d9e43509a1677d346584ee24cd3ee6f8c124.tar.bz2
Merge branch 'master' into 4941-refactoring_object_id
Diffstat (limited to 'db')
-rw-r--r--db/migrate/20150218175300_set_organisation_id_to_rps.rb13
-rw-r--r--db/migrate/20150219175300_insert_default_organisation.rb8
-rw-r--r--db/migrate/20171114102438_drop_table_rule_parameter_sets.rb5
-rw-r--r--db/schema.rb10
4 files changed, 7 insertions, 29 deletions
diff --git a/db/migrate/20150218175300_set_organisation_id_to_rps.rb b/db/migrate/20150218175300_set_organisation_id_to_rps.rb
deleted file mode 100644
index 024f5938e..000000000
--- a/db/migrate/20150218175300_set_organisation_id_to_rps.rb
+++ /dev/null
@@ -1,13 +0,0 @@
-class SetOrganisationIdToRps < ActiveRecord::Migration
- def up
- RuleParameterSet.where(organisation_id: nil).update_all "name = concat(name, ' ', id)"
-
- # RuleParameterSet.joins(...).update_all("organisation_id = referentials.organisation_id")
- # fails (see https://github.com/rails/arel/pull/294)
- execute "UPDATE rule_parameter_sets SET organisation_id = referentials.organisation_id FROM referentials WHERE referentials.id = rule_parameter_sets.referential_id;"
- end
-
- def down
- RuleParameterSet.update_all organisation_id: nil
- end
-end
diff --git a/db/migrate/20150219175300_insert_default_organisation.rb b/db/migrate/20150219175300_insert_default_organisation.rb
index c8e97b562..2734893f5 100644
--- a/db/migrate/20150219175300_insert_default_organisation.rb
+++ b/db/migrate/20150219175300_insert_default_organisation.rb
@@ -1,10 +1,8 @@
class InsertDefaultOrganisation < ActiveRecord::Migration
class Organisation < ActiveRecord::Base
attr_accessor :name
-
- has_many :rule_parameter_sets, :dependent => :destroy
end
-
+
def up
organisation = Organisation.find_or_create_by!(:name => "Chouette")
Referential.where( :organisation_id => nil).each do |r|
@@ -13,10 +11,6 @@ class InsertDefaultOrganisation < ActiveRecord::Migration
User.where( :organisation_id => nil).each do |r|
r.update_attributes :organisation_id => organisation.id
end
- Organisation.all.each do |organisation|
- RuleParameterSet.default_for_all_modes( organisation).save if organisation.rule_parameter_sets.empty?
- end
-
end
def down
diff --git a/db/migrate/20171114102438_drop_table_rule_parameter_sets.rb b/db/migrate/20171114102438_drop_table_rule_parameter_sets.rb
new file mode 100644
index 000000000..55dfd32df
--- /dev/null
+++ b/db/migrate/20171114102438_drop_table_rule_parameter_sets.rb
@@ -0,0 +1,5 @@
+class DropTableRuleParameterSets < ActiveRecord::Migration
+ def change
+ drop_table :rule_parameter_sets
+ end
+end
diff --git a/db/schema.rb b/db/schema.rb
index a992eb32b..21aa73cd8 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -11,7 +11,7 @@
#
# It's strongly recommended that you check this file into your version control system.
-ActiveRecord::Schema.define(version: 20171113101005) do
+ActiveRecord::Schema.define(version: 20171114102438) do
# These are extensions that must be enabled in order to support this database
enable_extension "plpgsql"
@@ -682,14 +682,6 @@ ActiveRecord::Schema.define(version: 20171113101005) do
t.integer "line_id", limit: 8
end
- create_table "rule_parameter_sets", id: :bigserial, force: :cascade do |t|
- t.text "parameters"
- t.string "name"
- t.datetime "created_at"
- t.datetime "updated_at"
- t.integer "organisation_id", limit: 8
- end
-
create_table "stop_area_referential_memberships", id: :bigserial, force: :cascade do |t|
t.integer "organisation_id", limit: 8
t.integer "stop_area_referential_id", limit: 8