Module: ListenSql

Defined in:
lib/listen_sql.rb,
lib/listen_sql/version.rb

Constant Summary collapse

VERSION = 
'0.1.2'

Class Method Summary collapse

Class Method Details

.exec_sql(db_name, file, color: true) ⇒ Object 



9
10
11
12
13
14
15
16
17
18
19
20
21
 
# File 'lib/listen_sql.rb', line 9

def exec_sql(db_name, file, color: true)
  puts "File: #{file}"
  puts "Time: #{Time.now}"

  # Show original SQL
  puts "SQL: "
  sql = File.read(file)
  puts(color ? CodeRay.scan(sql, :sql).terminal : sql)

  # Show Resultset
  puts "Rows: "
  puts `psql #{db_name} < #{Shellwords.escape file}`
end