blob: 0cea58a48cfec94605a95c907f89246c028eb52d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
#!/usr/bin/env ruby
require 'bundler/inline'
gemfile do
source 'https://rubygems.org'
gem 'pg'
end
connection = PG.connect(
dbname: ENV.fetch('PGDBNAME', 'postgres'),
host: ENV.fetch('PGHOST', Pathname.pwd.join('tmp/sockets'))
)
print "Patient Number: "
sql = <<~SQL
SELECT p.name AS p_name, c.name as c_name, n.name as n_name
FROM Patients p
INNER JOIN Care_centres c ON c.cid = p.care_centre_id
INNER JOIN Nurses n ON n.nid = c.nurse_charge_id
WHERE pid = $1;
SQL
patient_id = gets.to_i
connection.exec_params(sql, [patient_id]) do |result|
result.each do |row|
puts "Patient Name: #{row['p_name']}"
puts "Care Centre Name: #{row['c_name']}"
puts "Name of Nurse-in-Charge: #{row['n_name']}"
end
end
puts "Treatment ID | Treatment Name | Physician ID | Date"
connection.exec_params("SELECT * FROM Treatments WHERE patient_id = $1;", [patient_id]) do |treatments|
treatments.each do |x|
puts [x['tid'].ljust(12), x['treatment_name'].ljust(14), x['physician_id'].ljust(12), x['date']].join(' | ')
end
end
|
