API tools faq
paste
Guest User

Untitled

a guest
Oct 18th, 2017
54
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.79 KB | None | 0 0
raw download clone embed print report
  1. class RenameClientCompanyToAccount < ActiveRecord::Migration
  2. def change
  3. safety_assured do
  4. reversible do |dir|
  5. dir.down { update_view :lease_connections, version: 6, revert_to_version: 7 }
  6. end
  7. #if table_exists?(:admin_add_user_to_property_requests) && column_exists?(:admin_add_user_to_property_requests, :client_company_id)
  8. rename_column :admin_add_user_to_property_requests, :client_company_id, :account_id
  9. #end
  10.  
  11. #if table_exists?(:admin_move_to_another_client_company_request_office_parks) && column_exists?(:admin_move_to_another_client_company_request_office_parks, :move_to_another_client_company_request_id)
  12. rename_column :admin_move_to_another_client_company_request_office_parks, :move_to_another_client_company_request_id, :move_to_another_account_request_id
  13. #end
  14.  
  15. #if table_exists?(:admin_move_to_another_client_company_request_office_parks)
  16. rename_table :admin_move_to_another_client_company_request_office_parks, :admin_move_to_another_account_request_office_parks
  17. #end
  18.  
  19. #if table_exists?(:admin_move_to_another_client_company_request_properties) && column_exists?(:admin_move_to_another_client_company_request_properties, :move_to_another_client_company_request_id)
  20. rename_column :admin_move_to_another_client_company_request_properties, :move_to_another_client_company_request_id, :move_to_another_account_request_id
  21. #end
  22.  
  23. #if table_exists?(:admin_move_to_another_client_company_request_properties)
  24. rename_table :admin_move_to_another_client_company_request_properties, :admin_move_to_another_account_request_properties
  25. #end
  26.  
  27. #if table_exists?(:admin_move_to_another_client_company_requests) && column_exists?(:admin_move_to_another_client_company_requests, :old_client_company_id)
  28. rename_column :admin_move_to_another_client_company_requests, :old_client_company_id, :old_account_id
  29. #end
  30.  
  31. #if table_exists?(:admin_move_to_another_client_company_requests) && column_exists?(:admin_move_to_another_client_company_requests, :new_client_company_id)
  32. rename_column :admin_move_to_another_client_company_requests, :new_client_company_id, :new_account_id
  33. #end
  34.  
  35. #if table_exists?(:admin_move_to_another_client_company_requests) && column_exists?(:admin_move_to_another_client_company_requests, :skip_users_on_destination_client_company_validation)
  36. rename_column :admin_move_to_another_client_company_requests, :skip_users_on_destination_client_company_validation, :skip_users_on_destination_account_validation
  37. #end
  38.  
  39. #if table_exists?(:admin_move_to_another_client_company_requests)
  40. rename_table :admin_move_to_another_client_company_requests, :admin_move_to_another_account_requests
  41. #end
  42.  
  43. #if table_exists?(:audit_events) && column_exists?(:audit_events, :client_company_id)
  44. rename_column :audit_events, :client_company_id, :account_id
  45. #end
  46.  
  47. #if table_exists?(:city_markets) && column_exists?(:city_markets, :client_company_id)
  48. rename_column :city_markets, :client_company_id, :account_id
  49. #end
  50.  
  51. #if table_exists?(:deal_api_requests) && column_exists?(:deal_api_requests, :client_company_id)
  52. rename_column :deal_api_requests, :client_company_id, :account_id
  53. #end
  54.  
  55. #if table_exists?(:ilevel_entities) && column_exists?(:ilevel_entities, :client_company_id)
  56. rename_column :ilevel_entities, :client_company_id, :account_id
  57. #end
  58.  
  59. #if table_exists?(:ilevel_investments) && column_exists?(:ilevel_investments, :client_company_id)
  60. rename_column :ilevel_investments, :client_company_id, :account_id
  61. #end
  62.  
  63. #if table_exists?(:internal_roles) && column_exists?(:internal_roles, :client_company_create)
  64. rename_column :internal_roles, :client_company_create, :account_create
  65. #end
  66.  
  67. #if table_exists?(:internal_roles) && column_exists?(:internal_roles, :client_company_edit)
  68. rename_column :internal_roles, :client_company_edit, :account_edit
  69. #end
  70.  
  71. #if table_exists?(:internal_roles) && column_exists?(:internal_roles, :client_company_read)
  72. rename_column :internal_roles, :client_company_read, :account_read
  73. #end
  74.  
  75. #if table_exists?(:internal_roles) && column_exists?(:internal_roles, :client_company_update)
  76. rename_column :internal_roles, :client_company_update, :account_update
  77. #end
  78.  
  79. #if table_exists?(:internal_roles) && column_exists?(:internal_roles, :client_company_delete)
  80. rename_column :internal_roles, :client_company_delete, :account_delete
  81. #end
  82.  
  83. #if table_exists?(:internal_roles) && column_exists?(:internal_roles, :client_company_user_read)
  84. rename_column :internal_roles, :client_company_user_read, :account_user_read
  85. #end
  86.  
  87. #if table_exists?(:internal_roles) && column_exists?(:internal_roles, :client_company_user_edit)
  88. rename_column :internal_roles, :client_company_user_edit, :account_user_edit
  89. #end
  90.  
  91. #if table_exists?(:internal_roles) && column_exists?(:internal_roles, :can_move_to_another_client_company_create)
  92. rename_column :internal_roles, :can_move_to_another_client_company_create, :can_move_to_another_account_create
  93. #end
  94.  
  95. #if table_exists?(:internal_roles) && column_exists?(:internal_roles, :can_move_to_another_client_company_read)
  96. rename_column :internal_roles, :can_move_to_another_client_company_read, :can_move_to_another_account_read
  97. #end
  98.  
  99. #if table_exists?(:internal_roles) && column_exists?(:internal_roles, :can_edit_client_company_onboarding_in_progress)
  100. rename_column :internal_roles, :can_edit_client_company_onboarding_in_progress, :can_edit_account_onboarding_in_progress
  101. #end
  102.  
  103. #if table_exists?(:portfolio_exports) && column_exists?(:portfolio_exports, :client_company_id)
  104. rename_column :portfolio_exports, :client_company_id, :account_id
  105. #end
  106.  
  107. #if table_exists?(:portfolio_imports) && column_exists?(:portfolio_imports, :client_company_id)
  108. rename_column :portfolio_imports, :client_company_id, :account_id
  109. #end
  110.  
  111. #if table_exists?(:query_audits) && column_exists?(:query_audits, :client_company_id)
  112. rename_column :query_audits, :client_company_id, :account_id
  113. #end
  114.  
  115. #if table_exists?(:trm_tenant_possible_dupes) && column_exists?(:trm_tenant_possible_dupes, :client_company_id)
  116. rename_column :trm_tenant_possible_dupes, :client_company_id, :account_id
  117. #end
  118.  
  119. #if table_exists?(:trm_tenant_dedupe_audits) && column_exists?(:trm_tenant_dedupe_audits, :client_company_id)
  120. rename_column :trm_tenant_dedupe_audits, :client_company_id, :account_id
  121. #end
  122.  
  123. #if table_exists?(:activity_log_iterations) && column_exists?(:activity_log_iterations, :client_company_id)
  124. rename_column :activity_log_iterations, :client_company_id, :account_id
  125. #end
  126.  
  127. #if table_exists?(:client_company_users) && column_exists?(:client_company_users, :client_company_id)
  128. rename_column :client_company_users, :client_company_id, :account_id
  129. #end
  130.  
  131. #if table_exists?(:client_company_users)
  132. rename_table :client_company_users, :account_users
  133. #end
  134.  
  135. #if table_exists?(:approval_settings) && column_exists?(:approval_settings, :client_company_id)
  136. rename_column :approval_settings, :client_company_id, :account_id
  137. #end
  138.  
  139. #if table_exists?(:approval_property_groups) && column_exists?(:approval_property_groups, :client_company_id)
  140. rename_column :approval_property_groups, :client_company_id, :account_id
  141. #end
  142.  
  143. #if table_exists?(:tenant_programs) && column_exists?(:tenant_programs, :client_company_id)
  144. rename_column :tenant_programs, :client_company_id, :account_id
  145. #end
  146.  
  147. #if table_exists?(:submarkets) && column_exists?(:submarkets, :client_company_id)
  148. rename_column :submarkets, :client_company_id, :account_id
  149. #end
  150.  
  151. #if table_exists?(:asset_roles) && column_exists?(:asset_roles, :client_company_id)
  152. rename_column :asset_roles, :client_company_id, :account_id
  153. #end
  154.  
  155. #if table_exists?(:groups) && column_exists?(:groups, :client_company_id)
  156. rename_column :groups, :client_company_id, :account_id
  157. #end
  158.  
  159. #if table_exists?(:properties) && column_exists?(:properties, :client_company_id)
  160. rename_column :properties, :client_company_id, :account_id
  161. #end
  162.  
  163. #if table_exists?(:leases) && column_exists?(:leases, :client_company_id)
  164. rename_column :leases, :client_company_id, :account_id
  165. #end
  166.  
  167. #if table_exists?(:office_parks) && column_exists?(:office_parks, :client_company_id)
  168. rename_column :office_parks, :client_company_id, :account_id
  169. #end
  170.  
  171. #if table_exists?(:activity_logs) && column_exists?(:activity_logs, :client_company_id)
  172. rename_column :activity_logs, :client_company_id, :account_id
  173. #end
  174.  
  175. #if table_exists?(:client_companies)
  176. rename_table :client_companies, :accounts
  177. #end
  178.  
  179. #if table_exists?(:tenants) && column_exists?(:tenants, :client_company_id)
  180. rename_column :tenants, :client_company_id, :account_id
  181. #end
  182.  
  183. #if table_exists?(:portfolio_import_configurations) && column_exists?(:portfolio_import_configurations, :client_company_id)
  184. rename_column :portfolio_import_configurations, :client_company_id, :account_id
  185. #end
  186.  
  187. #if table_exists?(:task_settings) && column_exists?(:task_settings, :client_company_id)
  188. rename_column :task_settings, :client_company_id, :account_id
  189. #end
  190.  
  191. #if table_exists?(:api_clients) && column_exists?(:api_clients, :client_company_id)
  192. rename_column :api_clients, :client_company_id, :account_id
  193. #end
  194.  
  195. reversible do |dir|
  196. dir.up { update_view :lease_connections, version: 7, revert_to_version: 6 }
  197. end
  198. end
  199.  
  200. end
  201. end
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!