diff options
Diffstat (limited to 'spec/support/helpers/database_helpers.rb')
-rw-r--r-- | spec/support/helpers/database_helpers.rb | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/spec/support/helpers/database_helpers.rb b/spec/support/helpers/database_helpers.rb new file mode 100644 index 00000000000..e9f0a74a8d1 --- /dev/null +++ b/spec/support/helpers/database_helpers.rb @@ -0,0 +1,13 @@ +# frozen_string_literal: true + +module DatabaseHelpers + # In order to directly work with views using factories, + # we can swapout the view for a table of identical structure. + def swapout_view_for_table(view) + ActiveRecord::Base.connection.execute(<<~SQL) + CREATE TABLE #{view}_copy (LIKE #{view}); + DROP VIEW #{view}; + ALTER TABLE #{view}_copy RENAME TO #{view}; + SQL + end +end |