Class: TGaugex::DBConnection

Inherits:
Object
  • Object
show all
Defined in:
lib/db/db_connection.rb

Class Method Summary collapse

Class Method Details

.app_name ⇒ Object 



10
11
12
 
# File 'lib/db/db_connection.rb', line 10

def self.app_name
  YAML.load_file(Dir.pwd + '/config/database.yml')['database']
end

.execute(*args) ⇒ Object 



49
50
51
52
53
54
55
56
57
 
# File 'lib/db/db_connection.rb', line 49

def self.execute(*args)
  args.flatten!

  print_query(*args)
  query = self.number_placeholders(args.unshift[0])
  params = args[1..-1]
  params.flatten!
  instance.exec(query, params)
end

.instance ⇒ Object 



43
44
45
46
47
 
# File 'lib/db/db_connection.rb', line 43

def self.instance
  open if @postgres.nil?

  @postgres
end

.migrate ⇒ Object 



25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
 
# File 'lib/db/db_connection.rb', line 25

def self.migrate
  ensure_migrations_table

  MIGRATION_FILES.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 



14
15
16
17
18
19
 
# File 'lib/db/db_connection.rb', line 14

def self.open
  @postgres = PG::Connection.new(
    dbname: app_name,
    port: 5432
  )
end

.reset ⇒ Object 



21
22
23
 
# File 'lib/db/db_connection.rb', line 21

def self.reset
  self.instance
end