codeclan_cinema_SQL/console.rb at master · mholwill/codeclan_cinema_SQL · GitHub

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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
require('pry-byebug')

require_relative('models/customers')
require_relative('models/films')
require_relative('models/tickets')

Ticket.delete_all()
Film.delete_all()
Customer.delete_all()

#Customers
  customer1 = Customer.new ({
    'name' => 'Graham',
    'funds' => 40
  })
  customer1.save()

customer2 = Customer.new ({
    'name' => 'Fraser',
    'funds' => 20
  })
customer2.save()

customer3 = Customer.new ({
    'name' => 'Sarah',
    'funds' => 30
  })
customer3.save()

customer4 = Customer.new ({
    'name' => 'Jess',
    'funds' => 15
  })
customer4.save()

#Films
film1 = Film.new ({
    'title' => 'Bad Boys',
    'price' => 12
  })
film1.save()

film2 = Film.new ({
    'title' => 'Stardust',
    'price' => 8
  })
film2.save()

film3 = Film.new ({
    'title' => 'Star Wars',
    'price' => 12
  })
film3.save()

#Tickets
ticket1 = Ticket.new ({
    'customer_id' => customer1.id,
    'film_id' => film1.id
  })
ticket1.save()

ticket2 = Ticket.new ({
    'customer_id' => customer2.id,
    'film_id' => film1.id
  })
ticket2.save()

ticket3 = Ticket.new ({
    'customer_id' => customer4.id,
    'film_id' => film1.id
  })
ticket3.save()

ticket4 = Ticket.new ({
    'customer_id' => customer3.id,
    'film_id' => film2.id
  })
ticket4.save()

ticket5 = Ticket.new ({
    'customer_id' => customer1.id,
    'film_id' => film3.id
  })
ticket5.save()

ticket6 = Ticket.new ({
    'customer_id' => customer3.id,
    'film_id' => film3.id
  })
ticket6.save()

ticket7 = Ticket.new ({
    'customer_id' => customer1.id,
    'film_id' => film2.id
  })
ticket7.save()

binding.pry
nil