-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy path02-seed.sql
34 lines (26 loc) · 2.12 KB
/
02-seed.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
\c parkingmeter_db;
-- INSERT INTO tb_vehicles
INSERT INTO tb_vehicles(manufacturer, model, plate) VALUES ('Ferrari', 'Ferrari 288GTO', 'ABC1D23');
INSERT INTO tb_vehicles(manufacturer, model, plate) VALUES ('Ferrari', 'Ferrari 289GTO', 'ABC1D24');
-- INSERT INTO tb_price
INSERT INTO tb_price(hour_price) VALUES (7.00);
-- INSERT INTO tb_users
INSERT INTO tb_users(name, email, telephone) VALUES ('jonh1', '[email protected]', '999129912');
INSERT INTO tb_users(name, email, telephone) VALUES ('jonh2', '[email protected]', '999229922');
INSERT INTO tb_users(name, email, telephone) VALUES ('jonh3', '[email protected]', '999329932');
INSERT INTO tb_users(name, email, telephone) VALUES ('jonh4', '[email protected]', '999429942');
INSERT INTO tb_users(name, email, telephone) VALUES ('jonh5', '[email protected]', '999529952');
INSERT INTO tb_users(name, email, telephone) VALUES ('jonh6', '[email protected]', '999629962');
-- INSERT INTO user_vehicle
INSERT INTO user_vehicle(user_id, vehicle_id) VALUES (1, 1);
INSERT INTO user_vehicle(user_id, vehicle_id) VALUES (2, 1);
INSERT INTO user_vehicle(user_id, vehicle_id) VALUES (3, 1);
INSERT INTO user_vehicle(user_id, vehicle_id) VALUES (4, 1);
INSERT INTO user_vehicle(user_id, vehicle_id) VALUES (5, 1);
INSERT INTO user_vehicle(user_id, vehicle_id) VALUES (6, 1);
-- INSERT INTO tb_payment_method
INSERT INTO tb_payment_method(user_id, type, card_number, card_holder, cvv, card_expiration_date) VALUES (1, 'Crédito', '1234567890123456', 'teste', '123', '09/24');
-- INSERT INTO tb_tickets
INSERT INTO tb_tickets(vehicle_id, user_id, check_in, check_out, payment_type, card_id, status, price) VALUES (1, 1, '2023-09-24T10:10:01.176581600Z', '2023-09-24T23:10:01.176581600Z', 0, 1, 'closed', 91.00);
INSERT INTO tb_tickets(vehicle_id, user_id, check_in, check_out, payment_type, card_id, status, price) VALUES (1, 1, '2023-09-24T10:10:01.176581600Z', '2023-09-24T12:10:01.176581600Z', 0, 1, 'closed', 1.00);
INSERT INTO tb_tickets(vehicle_id, user_id, check_in, check_out, payment_type, card_id, status, price) VALUES (1, 1, '2023-09-24T17:17:01.176581600Z', '2023-09-24T23:10:01.176581600Z', 0, 1, 'closed', 42.00);