Class: DBConnection

Inherits:
Object show all
Defined in:
lib/laris/larisrecord/db_connection.rb

Class Method Summary collapse

Class Method Details

.columns(table_name) ⇒ Object 



39
40
41
42
43
44
45
46
47
48
49
50
51
52
 
# File 'lib/laris/larisrecord/db_connection.rb', line 39

def self.columns(table_name)
  cols = instance.exec("    SELECT\n      attname\n    FROM\n      pg_attribute\n    WHERE\n      attrelid = '\#{table_name}'::regclass AND\n      attnum > 0 AND\n      NOT attisdropped\n  SQL\n\n  cols.map { |col| col['attname'].to_sym }\nend\n")

.execute(query, params = []) ⇒ Object 



33
34
35
36
37
 
# File 'lib/laris/larisrecord/db_connection.rb', line 33

def self.execute(query, params=[])
  query = number_placeholders(query)
  print_query(query, params)
  res = instance.exec(query, params)
end

.migrate ⇒ Object 



14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
# File 'lib/laris/larisrecord/db_connection.rb', line 14

def self.migrate
  ensure_migrations_table

  migrations = Dir[File.join(Laris::ROOT, "/db/migrations/*.sql")]
  migrations.each do |file|
    filename = file.match(/([\w|-]*)\.sql$/)[1]

    unless migrated_files.include?(filename)
      instance.exec(File.read(file))
      instance.exec("        INSERT INTO\n          migrations (filename)\n        VALUES\n          ('\#{filename}')\n        SQL\n    end\n  end\nend\n")

.open ⇒ Object 



2
3
4
5
6
7
8
9
10
11
12
 
# File 'lib/laris/larisrecord/db_connection.rb', line 2

def self.open
  uri = URI.parse(ENV['DATABASE_URL'])

  @conn = PG::Connection.new(
    user: uri.user,
    password: uri.password,
    host: uri.host,
    port: uri.port,
    dbname: uri.path[1..-1],
  )
end