Class: Avm::EacPostgresqlBase0::Instance::Assert

Inherits:
Object
  • Object
show all
Defined in:
lib/avm/eac_postgresql_base0/instance/assert.rb

Instance Method Summary collapse

Instance Method Details

#change_owner ⇒ Object 



17
18
19
 
# File 'lib/avm/eac_postgresql_base0/instance/assert.rb', line 17

def change_owner
  root_execute("ALTER DaTABASE \"#{name}\" OWNER TO \"#{user}\"")
end

#change_password ⇒ Object 



21
22
23
 
# File 'lib/avm/eac_postgresql_base0/instance/assert.rb', line 21

def change_password
  root_execute("ALTER USER \"#{user}\" WITH PASSWORD '#{password}'")
end

#create_database ⇒ Object 



55
56
57
 
# File 'lib/avm/eac_postgresql_base0/instance/assert.rb', line 55

def create_database
  root_execute("CREATE DATABASE \"#{name}\" WITH OWNER \"#{user}\"")
end

#create_user ⇒ Object 



25
26
27
 
# File 'lib/avm/eac_postgresql_base0/instance/assert.rb', line 25

def create_user
  root_execute("CREATE USER \"#{user}\" WITH PASSWORD '#{password}'")
end

#current_owner ⇒ Object 



29
30
31
32
33
34
35
36
 
# File 'lib/avm/eac_postgresql_base0/instance/assert.rb', line 29

def current_owner
  root_query(<<~SQL.squish
    SELECT pg_catalog.pg_get_userbyid(datdba)
    FROM pg_catalog.pg_database
    WHERE datname = '#{name}'
  SQL
            )
end

#database_exist? ⇒ Boolean

Returns:

  • (Boolean) 


38
39
40
 
# File 'lib/avm/eac_postgresql_base0/instance/assert.rb', line 38

def database_exist?
  root_boolean_query("FROM pg_database WHERE datname='#{name}'")
end

#password_ok? ⇒ Boolean

Returns:

  • (Boolean) 


42
43
44
45
 
# File 'lib/avm/eac_postgresql_base0/instance/assert.rb', line 42

def password_ok?
  instance.psql_command_command('SELECT 1', false)
    .execute!(exit_outputs: { 512 => 'login_failed' }).strip == '1'
end

#perform ⇒ Object 



10
11
12
13
14
15
 
# File 'lib/avm/eac_postgresql_base0/instance/assert.rb', line 10

def perform
  create_user unless user_exist?
  change_password unless password_ok?
  create_database unless database_exist?
  change_owner unless user_owner?
end

#user_exist? ⇒ Boolean

Returns:

  • (Boolean) 


47
48
49
 
# File 'lib/avm/eac_postgresql_base0/instance/assert.rb', line 47

def user_exist?
  root_boolean_query("FROM pg_roles WHERE rolname='#{user}'")
end

#user_owner? ⇒ Boolean

Returns:

  • (Boolean) 


51
52
53
 
# File 'lib/avm/eac_postgresql_base0/instance/assert.rb', line 51

def user_owner?
  user == current_owner
end