src/main/resources/data.sql - finance_tracker - caleb412/course_work

src/main/resources/data.sql
23 строки2 KB
Caleb Chanda
Added full finance tracker project code
01 июн 2025, 20:39
01 июн 2025, 20:396705ea8
insert into users (username, email) values ('helterSkelter', 'test@example.com');
insert into income (amount, date, source, description, user_id) values (10000, '2025-01-01', 'Job Salary','Monthly salary from ExampleCo', 1);
insert into expense (amount, date, title, description, category, user_id) values (350, '2025-01-01','Bought groceries','Bread, milk and meat', 'Groceries', 1);

insert into income (amount, date, source, description, user_id) values (4000, '2025-01-15', 'Passive Income','Profit from side-gig', 1);
insert into expense (amount, date, title, description, category, user_id) values (1000, '2025-01-10','Bought watch','Bought a fitness watch', 'Clothes', 1);

insert into income (amount, date, source, description, user_id) values (14000, '2025-01-21', 'Investment Payout','Crypto dividends from ExampleCo', 1);
insert into expense (amount, date, title, description, category, user_id) values (200, '2025-01-01','Transport','Travelled to the countryside', 'Transport', 1);

insert into income (amount, date, source, description, user_id) values (10000, '2025-02-01', 'Job Salary','Monthly salary from ExampleCo', 1);
insert into expense (amount, date, title, description, category, user_id) values (3500, '2025-02-01','Bought groceries','Bulked groceries', 'Groceries', 1);

insert into income (amount, date, source, description, user_id) values (10000, '2025-02-05', 'Birthday money','Money for birthday gift', 1);
insert into expense (amount, date, title, description, category, user_id) values (4000, '2025-02-12','Bought concert tickets','Went to see TwentyOnePilots', 'Leisure', 1);

insert into users (username, email) values ('maxVerstappen1', 'tutututut@redbull.com');

insert into income (amount, date, source, description, user_id) values (15000, '2025-02-01', 'Monthly salary','Salary from Red Bull Racing', 2);
insert into expense (amount, date, title, description, category, user_id) values (4000, '2025-02-12','Car repairs','Took car to the garage to fix steering', 'Car Fees', 2);

insert into income (amount, date, source, description, user_id) values (11000, '2025-02-15', 'Business profit','Quarterly profits from AuraCo', 2);
insert into expense (amount, date, title, description, category, user_id) values (1000, '2025-02-16','School Fees','Paid for the kids fees', 'School fees', 2);