Module: PGSpecHelper::Extensions

Included in:
PGSpecHelper
Defined in:
lib/pg_spec_helper/extensions.rb

Instance Method Summary collapse

Instance Method Details

#create_extension(extension_name) ⇒ Object

Create an extension



6
7
8
9
10
 
# File 'lib/pg_spec_helper/extensions.rb', line 6

def create_extension extension_name
  connection.exec("    CREATE EXTENSION \"\#{extension_name}\"\n  SQL\nend\n")

#drop_extension(extension_name) ⇒ Object

Drop an extension



13
14
15
16
17
 
# File 'lib/pg_spec_helper/extensions.rb', line 13

def drop_extension extension_name
  connection.exec("    DROP EXTENSION \"\#{extension_name}\"\n  SQL\nend\n")

#get_extension_names ⇒ Object

get a list of extension names for the provided table



20
21
22
23
24
25
26
27
 
# File 'lib/pg_spec_helper/extensions.rb', line 20

def get_extension_names
  rows = connection.exec_params("    SELECT\n      extname AS name\n    FROM pg_extension\n  SQL\n  rows.map { |row| row[\"name\"].to_sym }\nend\n")