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
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
# File 'lib/alchemy/upgrader/eight_one.rb', line 6
def migrate_page_metadata
desc "Migrating page metadata to page versions"
connection = ActiveRecord::Base.connection
pages_table = Alchemy::Page.table_name
versions_table = Alchemy::PageVersion.table_name
unmigrated_count = connection.select_value(" SELECT COUNT(*) FROM \#{versions_table}\n WHERE title IS NULL\n AND meta_description IS NULL\n AND meta_keywords IS NULL\n SQL\n\n if unmigrated_count == 0\n log \"All page versions have meta data.\", :skip\n return\n end\n\n sql = if connection.adapter_name.downcase.match?(/mysql|trilogy/)\n <<-SQL.strip_heredoc\n UPDATE \#{versions_table} pv\n INNER JOIN \#{pages_table} p ON pv.page_id = p.id\n SET pv.title = p.title,\n pv.meta_description = p.meta_description,\n pv.meta_keywords = p.meta_keywords\n WHERE pv.title IS NULL\n AND pv.meta_description IS NULL\n AND pv.meta_keywords IS NULL\n SQL\n else\n <<-SQL.strip_heredoc\n UPDATE \#{versions_table}\n SET title = p.title,\n meta_description = p.meta_description,\n meta_keywords = p.meta_keywords\n FROM \#{pages_table} p\n WHERE \#{versions_table}.page_id = p.id\n AND \#{versions_table}.title IS NULL\n AND \#{versions_table}.meta_description IS NULL\n AND \#{versions_table}.meta_keywords IS NULL\n SQL\n end\n\n migrated_count = connection.update(sql)\n\n log \"Migrated metadata for \#{migrated_count} page versions.\"\nend\n".strip_heredoc).to_i
|