seeds.rb 1.01 KB
Newer Older
Zac Wood's avatar
Zac Wood committed
1
2
3
4
5
6
7
# This file should contain all the record creation needed to seed the database with its default values.
# The data can then be loaded with the rails db:seed command (or created alongside the database with db:setup).
#
# Examples:
#
#   movies = Movie.create([{ name: 'Star Wars' }, { name: 'Lord of the Rings' }])
#   Character.create(name: 'Luke', movie: movies.first)
Zac Wood's avatar
Zac Wood committed
8
require 'rubyXL'
9
10
require_relative 'excel_loader'

Zac Wood's avatar
Zac Wood committed
11
12
13
14
15
Semester.delete_all
Course.delete_all
Section.delete_all
Closure.delete_all

16
17
18
19
20
loader = if Rails.env.test?
           ExcelLoader.new 'db/data/testdata.xlsx'
         else
           ExcelLoader.new 'db/data/allsections.xlsx'
         end
21

Zac Wood's avatar
Zac Wood committed
22
23
24
25
26
27
28
semester = Semester.where(season: "Fall", year: "2018").first

Closure.create! date: Date.new(2018, 9, 3), semester: semester
Closure.create! date: Date.new(2018, 10, 8), semester: semester
(21..25).each { |n| Closure.create! date: Date.new(2018, 11, n), semester: semester }
(10..19).each { |n| Closure.create! date: Date.new(2018, 12, n), semester: semester }

29
loader.load_data