/
commented_code.txt
43 lines (20 loc) · 1.05 KB
/
commented_code.txt
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
38
39
40
41
42
43
# --------- Upload CSV---------------
# require 'FasterCSV'
# require 'pp'
# csv = FasterCSV.read("deliverables230311.csv", :headers => true)
# pp csv
# csv.each {|row| Deliverable.create(:number => row['number'], :title => row['title'], :discipline_list => row ['tag1'], :document_type_list => row['tag2'], :tag_list => "#{row['tag3']}, #{row['tag4']}")}
# csv.each {|row| Deliverable.create(:number => row['number'], :title => row['title'], :discipline_list => row ['tag1'], :document_type_list => row['tag2'], :tag_list => row['tag3'])}
# require 'pp'
# csv = FasterCSV.read("AB3_Act.csv", :headers => true)
# pp csv
# csv.each {|row| Delivery.create(:deliverable_id => row['ID'], :planned_date => row['AB3_Actual'], :status_id => "2")}
# csv.each {|row| Delivery.update_all(["actual_date=?", row['AB3_Actual']], :id => row['ID'])}
# ------------------------------------------
# List deliveries for tag in deliverables controller
# def list_deliveries_for_tag
#
# all_deliveries
# end
# this is for uploading and parsing csv file
# ------------------