Financial-Tracking-API/data.sql at main · emirokttrn/Financial-Tracking-API · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
-- Sample data for Financial Tracking API

-- Insert Users
INSERT INTO user (name, email, password) VALUES ('Ahmet Yılmaz', 'ahmet@example.com', 'password123');
INSERT INTO user (name, email, password) VALUES ('Ayşe Kaya', 'ayse@example.com', 'password456');
INSERT INTO user (name, email, password) VALUES ('Mehmet Demir', 'mehmet@example.com', 'password789');

-- Insert Categories
INSERT INTO category (name, type) VALUES ('Yiyecek', 'GIDER');
INSERT INTO category (name, type) VALUES ('Ulaşım', 'GIDER');
INSERT INTO category (name, type) VALUES ('Maaş', 'GELIR');
INSERT INTO category (name, type) VALUES ('Fatura', 'GIDER');

-- Insert Transactions
INSERT INTO transaction (amount, type, description, date, user_id, category_id) VALUES (50.00, 'EXPENSE', 'Market alışverişi', '2023-05-01 10:00:00', 1, 1);
INSERT INTO transaction (amount, type, description, date, user_id, category_id) VALUES (20.00, 'EXPENSE', 'Otobüs bileti', '2023-05-02 08:30:00', 1, 2);
INSERT INTO transaction (amount, type, description, date, user_id, category_id) VALUES (5000.00, 'INCOME', 'Aylık maaş', '2023-05-01 09:00:00', 2, 3);
INSERT INTO transaction (amount, type, description, date, user_id, category_id) VALUES (100.00, 'EXPENSE', 'Elektrik faturası', '2023-05-03 12:00:00', 2, 4);
INSERT INTO transaction (amount, type, description, date, user_id, category_id) VALUES (30.00, 'EXPENSE', 'Kahve', '2023-05-04 15:00:00', 3, 1);