Module: PgRls::Database::Prepared

Defined in:
lib/pg_rls/database/prepared.rb

Overview

Prepare database for test unit

Class Method Summary collapse

Class Method Details

.grant_user_credentials(name: PgRls::SECURE_USERNAME, password: 'password') ⇒ Object 



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
 
# File 'lib/pg_rls/database/prepared.rb', line 8

def grant_user_credentials(name: PgRls::SECURE_USERNAME, password: 'password')
  return unless Rails.env.test? || PgRls.default_connection?

  PgRls.admin_execute <<-SQL
    DO
    $do$
    BEGIN
      IF NOT EXISTS (
        SELECT FROM pg_catalog.pg_roles AS r
        WHERE r.rolname = '#{name}') THEN

          CREATE USER #{name} WITH PASSWORD '#{password}';
      END IF;
    END
    $do$;
    GRANT USAGE ON SCHEMA public TO #{name};
    ALTER DEFAULT PRIVILEGES IN SCHEMA public
      GRANT SELECT, INSERT, UPDATE, DELETE
      ON TABLES TO #{name};
    GRANT SELECT, INSERT, UPDATE, DELETE
      ON ALL TABLES IN SCHEMA public
      TO #{name};
    GRANT USAGE, SELECT
      ON ALL SEQUENCES IN SCHEMA public
      TO #{name};
  SQL
end