Permissions table not found during testing

[mkanoor]

Intermittently during running specs the Permissions table goes missing. The Permissions table is implemented in this migration as sql enum

catalog-api/db/migrate/20200114164456_normalize_ace_table.rb

Line 5 in f45a57e

execute <<-SQL

This table is not exported in the db/schema.rb and during tests when the db is cleared its possible that this table would be missing.

Failure/Error: access_control_permissions { [create(:access_control_permission, :has_read_permission)] }
      
      ActiveRecord::StatementInvalid:
        PG::UndefinedTable: ERROR:  relation "permissions" does not exist
        LINE 8:                WHERE a.attrelid = '"permissions"'::regclass
                                                  ^
        :               SELECT a.attname, format_type(a.atttypid, a.atttypmod),
                             pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,
                             c.collname, col_description(a.attrelid, a.attnum) AS comment
                        FROM pg_attribute a
                        LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
                        LEFT JOIN pg_type t ON a.atttypid = t.oid
                        LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation
                       WHERE a.attrelid = '"permissions"'::regclass
                         AND a.attnum > 0 AND NOT a.attisdropped
                       ORDER BY a.attnum
      # ./spec/factories/access_control_entry.rb:16:in `block (4 levels) in <top (required)>'
      # ./spec/models/access_control_entry_spec.rb:8:in `block (3 levels) in <top (required)>'
      # ./spec/models/access_control_entry_spec.rb:12:in `block (4 levels) in <top (required)>'
      # ------------------
      # --- Caused by: ---
      # PG::UndefinedTable:
      #   ERROR:  relation "permissions" does not exist
      #   LINE 8:                WHERE a.attrelid = '"permissions"'::regclass
      #                                             ^
      #   ./spec/factories/access_control_entry.rb:16:in `block (4 levels) in <top (required)>'

[hsong-rh]

bin/rails db:drop db:create db:migrate RAILS_ENV=test should resolve this issue