blob: 25f36336ff539ad0a9dd636de8f1ebd60366c5eb (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
# The PublicBody model class had a bug that meant the
# translations for first_letter and publication_scheme
# were not being correctly populated.
#
# This migration fixes up the data to correct this.
#
# Note that the "update ... from" syntax is a Postgres
# extension to SQL.
class FixPublicBodyTranslations < ActiveRecord::Migration
def self.up
execute <<-SQL
update public_body_translations
set first_letter = upper(substr(name, 1, 1))
where first_letter is null
;
SQL
execute <<-SQL
update public_body_translations
set publication_scheme = (SELECT public_bodies.publication_scheme FROM public_bodies WHERE
public_body_translations.public_body_id = public_bodies.id )
where public_body_translations.publication_scheme is null
;
SQL
end
def self.down
# This is a bug-fix migration, that does not involve a schema change.
# It doesn't make sense to reverse it.
end
end
|
