-
Notifications
You must be signed in to change notification settings - Fork 1
/
dummy_data.sql
82 lines (64 loc) · 2.92 KB
/
dummy_data.sql
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
INSERT INTO conf_admin.location(
name, short_desc, full_desc, parking_info, create_dttm, last_update_dttm)
VALUES ('Sample Location', 'short', 'full', 'no parking', CURRENT_DATE, CURRENT_DATE);
INSERT INTO conf_admin.conference(
name, short_desc, full_desc, start_date, end_date, location_id,
create_dttm, last_update_dttm)
select 'Sample Conference', 'short desc', 'full desc', CURRENT_DATE - 1, CURRENT_DATE, location.id,
CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
from conf_admin.location where location.name = 'Sample Location';
INSERT INTO conf_admin.room(
short_desc, full_desc, conference_id)
select 'Short Description', 'Full Description', conference.id
from conf_admin.conference where conference.name = 'Sample Conference';
insert into conf_admin.company
(name, short_desc, full_desc, logo_path) values ('GFS', 'Gordon Food Service', 'Food distribution', 'http://logo_path/gfs.png');
INSERT INTO conf_admin.presenter(
user_id, short_bio, job_title, company_affiliation_id)
VALUES (null, 'short bio', 'sample title', 1);
INSERT INTO conf_admin.conference_session(
name, short_desc, full_desc, conference_id, conference_session_type_id,
room_id, start_dttm, duration, create_dttm, last_update_dttm,
conference_session_presenter_id)
SELECT 'Session name', 'short desc', 'full desc', conference.id, null,
room.id, CURRENT_DATE, 30, CURRENT_DATE, CURRENT_DATE,
null
from conf_admin.conference,conf_admin.room where conference.name = 'Sample Conference' and room.short_desc = 'Short Description';
INSERT INTO conf_admin.conference_session_presenter(
conference_session_id, presenter_id)
select conference_session.id, presenter.id
from conf_admin.presenter, conf_admin.conference_session
where presenter.job_title = 'sample title' and conference_session.name = 'Session name';
select * from conf_admin.company;
/*
select * from conf_admin.conference;
select * from conf_admin.location;
select * from conf_admin.presenter;
select * from conf_admin.room;
select * from conf_admin.conference_session;
select * from conf_admin.conference_session_presenter;
select * from conf_admin.conference;
SELECT *
FROM conf_admin.location;
SELECT *
FROM conf_admin.company;
SELECT *
FROM conf_admin.conference_session_type;
SELECT *
FROM conf_admin.location_address;
SELECT *
FROM conf_admin.room;
SELECT *
FROM conf_admin.sponsor_level;
*/
/* Trying to delete stuff in the right order */
/*
delete from conf_admin.conference_session_presenter cascade;
delete from conf_admin.conference_session cascade;
delete from conf_admin.room cascade;
delete from conf_admin.conference cascade;
delete from conf_admin.location_address cascade;
delete from conf_admin.location cascade;
delete from conf_admin.presenter cascade;
delete from conf_admin.conference cascade;
*/