Module: Reportme::Sql::ClassMethods

Defined in:
lib/reportme/sql.rb

Instance Method Summary collapse

Instance Method Details

#columns(table_name) ⇒ Object 



14
15
16
17
18
19
20
21
22
23
24
25
26
 
# File 'lib/reportme/sql.rb', line 14

def columns(table_name)
  sql = <<-SQL
  select
    column_name
  from
    information_schema.columns
  where
    table_schema = '#{schema_name}'
    and table_name = '#{table_name}'
  ;
  SQL
  select_values(sql)
end

#exec(sql) ⇒ Object 



56
57
58
59
60
61
 
# File 'lib/reportme/sql.rb', line 56

def exec(sql)
  puts "// ------------------------"
  puts "exec: #{sql}"
  puts "------------------------ //"
  ActiveRecord::Base.connection.execute(sql)
end

#select_all(sql) ⇒ Object 



42
43
44
45
46
47
 
# File 'lib/reportme/sql.rb', line 42

def select_all(sql)
  puts "// ------------------------"
  puts "select_all: #{sql}"
  puts "------------------------ //"
  ActiveRecord::Base.connection.select_all(sql)
end

#select_one(sql) ⇒ Object 



49
50
51
52
53
54
 
# File 'lib/reportme/sql.rb', line 49

def select_one(sql)
  puts "// ------------------------"
  puts "select_one: #{sql}"
  puts "------------------------ //"
  ActiveRecord::Base.connection.select_one(sql)
end

#select_rows(sql) ⇒ Object 



35
36
37
38
39
40
 
# File 'lib/reportme/sql.rb', line 35

def select_rows(sql)
  puts "// ------------------------"
  puts "select_rows: #{sql}"
  puts "------------------------ //"
  ActiveRecord::Base.connection.select_rows(sql)
end

#select_value(sql) ⇒ Object 



63
64
65
66
67
68
 
# File 'lib/reportme/sql.rb', line 63

def select_value(sql)
  puts "// ------------------------"
  puts "select_value: #{sql}"
  puts "------------------------ //"
  ActiveRecord::Base.connection.select_value(sql)
end

#select_values(sql) ⇒ Object 



28
29
30
31
32
33
 
# File 'lib/reportme/sql.rb', line 28

def select_values(sql)
  puts "// ------------------------"
  puts "select_values: #{sql}"
  puts "------------------------ //"
  ActiveRecord::Base.connection.select_values(sql)
end

#table_exist?(table_name) ⇒ Boolean

Returns:

  • (Boolean) 


10
11
12
 
# File 'lib/reportme/sql.rb', line 10

def table_exist?(table_name)
  ActiveRecord::Base.connection.select_value("show tables like '#{table_name}'") != nil
end