Class: MilkMaid::SpreadsheetWriter

Inherits:
Object
  • Object
show all
Defined in:
lib/milk_maid/spreadsheet_writer.rb

Class Method Summary collapse

Class Method Details



19
20
21
22
23
24
25
26
27
28
29
30
31
32
 
# File 'lib/milk_maid/spreadsheet_writer.rb', line 19

def self.print_footer(ws, row, record)
  ws[row, 1] = "Batch Name"
  ws[row, 2] = record.name
  row += 1
  ws[row, 1] = "Duration"
  ws[row, 2] = record.duration
  row += 1
  ws[row, 1] = "Base Temperature"
  ws[row, 2] = record.base_temperature
  row += 1
  ws[row, 1] = "Status"
  ws[row, 2] = record.status
  ws.save
end

.print_record(sheet, record) ⇒ Object 



34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
 
# File 'lib/milk_maid/spreadsheet_writer.rb', line 34

def self.print_record(sheet, record)
  worksheet_name = "#{record.name}: #{record.status}"
  puts "Creating worksheet for #{worksheet_name}"
  ws = sheet.add_worksheet(worksheet_name)

  ws[1,TIMESTAMP_COL] = "Timestamp"
  ws[1,READING_COL] = "Reading"
  ws[1,DATA_COL] = "Value"

  row = 2

  record.events.each do |event|
    ws[row, TIMESTAMP_COL] = event.timestamp
    ws[row, READING_COL] = event.name
    ws[row, DATA_COL] = event.data unless event.data == 0
    row += 1
  end

  print_footer(ws, row + 1, record)
end

.write_spreadsheet(session_file, spreadsheet_name, record) ⇒ Object 



10
11
12
13
14
15
16
17
 
# File 'lib/milk_maid/spreadsheet_writer.rb', line 10

def self.write_spreadsheet(session_file, spreadsheet_name, record)
  session = GoogleDrive.saved_session(session_file)

  puts "Creating Spreadsheet #{spreadsheet_name}"
  sheet = session.create_spreadsheet(spreadsheet_name)

  print_record(sheet, record)
end