-
Notifications
You must be signed in to change notification settings - Fork 0
/
phase3_SQL.txt
48 lines (46 loc) · 2.67 KB
/
phase3_SQL.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
44
45
46
'SELECT * FROM User WHERE Email = "%s"'
'SELECT * FROM User WHERE Username = "%s"'
'INSERT INTO Visitor VALUES (%s)'
'SELECT * FROM User WHERE Email = "%s"'
'SELECT * FROM User WHERE Username = "%s"'
'INSERT INTO User (Username, Email, Password) VALUES (%s, %s, %s)'
'INSERT INTO Staff VALUES (%s)'
'SELECT * FROM User WHERE Email = "%s"'
'SELECT Username FROM Staff'
'SELECT * FROM Visitor WHERE Username = "%s"'
'SELECT * FROM Staff WHERE Username = "%s"'
'SELECT * FROM Animal WHERE Name = "%s" AND Species = "%s"'
'SELECT * FROM Exhibit WHERE Name = "%s"'
'SELECT * FROM Animal WHERE Place = "%s" ORDER BY %s %s'
'SELECT * FROM Animal WHERE Place = "%s"'
'SELECT Exhibit.Name, Exhibit.Size, COUNT(*) as count, Exhibit.WaterFeature FROM Exhibit, Animal WHERE Exhibit.WaterFeature = "%s"'
'SELECT Exhibit.Name, Exhibit.Size, COUNT(*) as count, Exhibit.WaterFeature FROM Exhibit, Animal WHERE Exhibit.WaterFeature = "%s"'
'SELECT * FROM Animal WHERE Type = "%s" AND Place = "%s"'
'SELECT * FROM Animal WHERE Type = "%s" AND Place = "%s"'
'SELECT * FROM Shows WHERE LocateAt = "%s"'
'SELECT * FROM Shows WHERE LocateAt = "%s"'
'SELECT VisitExhibit.Exhibitname, VisitExhibit.Datetime, COUNT(*) as count FROM VisitExhibit WHERE Datetime = "%s"'
'SELECT VisitExhibit.Exhibitname, VisitExhibit.Datetime, COUNT(*) as count FROM VisitExhibit WHERE Datetime = "%s"'
'SELECT VisitShow.Showname, VisitShow.Showdate, Shows.LocateAt FROM VisitShow, Shows WHERE VisitShow.Showname = "%s"'
'SELECT VisitShow.Showname, VisitShow.Showdate, Shows.LocateAt FROM VisitShow, Shows WHERE VisitShow.Showname = "%s"'
'SELECT * FROM Shows WHERE Hostby = "%s"'
'SELECT * FROM Shows WHERE Hostby = "%s"'
'SELECT * FROM Animal WHERE Type = "%s" AND Place = "%s"'
'SELECT * FROM Animal WHERE Type = "%s" AND Place = "%s"'
'SELECT * FROM Animal WHERE Name = %s AND Species = %s'
'SELECT * FROM Note WHERE AnimalName = "%s" AND AnimalSpecies = "%s"'
'SELECT * FROM Animal WHERE Name = %s AND Species = %s'
'SELECT * FROM Note WHERE AnimalName = %s AND AnimalSpecies = %s'
'SELECT * FROM User WHERE Username in (select * from Staff)'
'SELECT * FROM User WHERE Username in (select * from Visitor)'
'SELECT Name, DateAndTime, LocateAt FROM Shows WHERE LocateAt = "%s"'
'SELECT Name, DateAndTime, LocateAt FROM Shows WHERE LocateAt = "%s"'
'SELECT * FROM Animal WHERE Type = "%s" AND Place = "%s"'
'SELECT * FROM Animal WHERE Type = "%s" AND Place = "%s"'
'INSERT INTO Animal VALUES(%s, %s, %s, %s, %s)'
'INSERT INTO Shows VALUES(%s, %s, %s, %s)'
'Delete FROM Shows where Name=%s and DateAndTime=%s'
'Delete FROM Animal where Name=%s and Species=%s'
'Delete FROM Visitor where Username=%s'
'Delete FROM User where Username=%s'
'Delete FROM Staff where Username=%s'