-
Notifications
You must be signed in to change notification settings - Fork 1
/
dummy_data.txt
98 lines (89 loc) · 4.78 KB
/
dummy_data.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
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
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
CREATE (p1:Person {name: 'John Doe', birth_date: '1980-01-01'})
CREATE (p2:Person {name: 'Jane Smith', birth_date: '1990-05-15'})
CREATE (p3:Person {name: 'Bob Johnson', birth_date: '1975-12-12'})
CREATE (a1:Account {account_number: 12345678, sort_code: 112233, account_type: 'Current'})
CREATE (a2:Account {account_number: 87654321, sort_code: 445566, account_type: 'Savings'})
CREATE (a3:Account {account_number: 24681357, sort_code: 778899, account_type: 'Credit Card'})
CREATE (m1:Shop {merchant_name: 'Aldi', account_number: 98765432, sort_code: 332211})
CREATE (m2:Shop {merchant_name: 'Tesco', account_number: 13579246, sort_code: 665544})
CREATE (m3:Shop {merchant_name: 'Sainsburys', account_number: 24681357, sort_code: 998877})
CREATE (c1:Category {transaction_category: 'online shopping'})
CREATE (c2:Category {transaction_category: 'in-store'})
CREATE (t1:Transaction {transaction_id: 1, transaction_date: '2024-05-01', narrative: 'Rent', type: 'Debit', amount: 100, balance: 900})
CREATE (t2:Transaction {transaction_id: 2, transaction_date: '2024-01-02', narrative: 'Groceries', type: 'Debit', amount: 50, balance: 850})
CREATE (t3:Transaction {transaction_id: 3, transaction_date: '2024-02-03', narrative: 'Bills', type: 'Debit', amount: 150, balance: 700})
CREATE (t4:Transaction {transaction_id: 4, transaction_date: '2024-02-04', narrative: 'Entertainment', type: 'Debit', amount: 75, balance: 625})
CREATE (t5:Transaction {transaction_id: 5, transaction_date: '2024-04-05', narrative: 'Groceries', type: 'Debit', amount: 125, balance: 500})
CREATE (t6:Transaction {transaction_id: 6, transaction_date: '2023-07-06', narrative: 'Shopping', type: 'Debit', amount: 200, balance: 300})
CREATE (t7:Transaction {transaction_id: 7, transaction_date: '2024-03-07', narrative: 'Entertainment', type: 'Debit', amount: 10, balance: 290})
CREATE (t8:Transaction {transaction_id: 8, transaction_date: '2023-08-08', narrative: 'Rent', type: 'Debit', amount: 1500, balance: -1210})
CREATE (t9:Transaction {transaction_id: 9, transaction_date: '2024-01-09', narrative: 'Groceries', type: 'Debit', amount: 200, balance: -1410})
CREATE (t10:Transaction {transaction_id: 10, transaction_date: '2024-02-10', narrative: 'Bills', type: 'Debit', amount: 800, balance: -2210})
CREATE (t11:Transaction {transaction_id: 11, transaction_date: '2024-02-11', narrative: 'Bills', type: 'Debit', amount: 2500, balance: -4710})
CREATE (t12:Transaction {transaction_id: 12, transaction_date: '2024-01-12', narrative: 'Entertainment', type: 'Debit', amount: 20, balance: -4730})
CREATE (t13:Transaction {transaction_id: 13, transaction_date: '2024-01-13', narrative: 'Shopping', type: 'Debit', amount: 600, balance: -5330})
CREATE (t14:Transaction {transaction_id: 14, transaction_date: '2024-01-14', narrative: 'Groceries', type: 'Debit', amount: 50, balance: -5380})
CREATE (t15:Transaction {transaction_id: 15, transaction_date: '2024-01-15', narrative: 'Entertainment', type: 'Debit', amount: 15, balance: -5395})
CREATE (p1)-[:HAS]->(a1)
CREATE (p2)-[:HAS]->(a2)
CREATE (p3)-[:HAS]->(a3)
CREATE (p1)-[:MADE]->(t1)
CREATE (p1)-[:MADE]->(t2)
CREATE (p2)-[:MADE]->(t3)
CREATE (p3)-[:MADE]->(t4)
CREATE (p1)-[:MADE]->(t5)
CREATE (p1)-[:MADE]->(t6)
CREATE (p1)-[:MADE]->(t7)
CREATE (p1)-[:MADE]->(t8)
CREATE (p2)-[:MADE]->(t9)
CREATE (p2)-[:MADE]->(t10)
CREATE (p3)-[:MADE]->(t11)
CREATE (p1)-[:MADE]->(t12)
CREATE (p2)-[:MADE]->(t13)
CREATE (p3)-[:MADE]->(t14)
CREATE (p1)-[:MADE]->(t15)
CREATE (t1)-[:PAID_TO]->(m1)
CREATE (t2)-[:PAID_TO]->(m2)
CREATE (t3)-[:PAID_TO]->(m2)
CREATE (t4)-[:PAID_TO]->(m3)
CREATE (t5)-[:PAID_TO]->(m1)
CREATE (t6)-[:PAID_TO]->(m2)
CREATE (t7)-[:PAID_TO]->(m3)
CREATE (t8)-[:PAID_TO]->(m2)
CREATE (t9)-[:PAID_TO]->(m1)
CREATE (t10)-[:PAID_TO]->(m3)
CREATE (t11)-[:PAID_TO]->(m2)
CREATE (t12)-[:PAID_TO]->(m3)
CREATE (t13)-[:PAID_TO]->(m1)
CREATE (t14)-[:PAID_TO]->(m2)
CREATE (t15)-[:PAID_TO]->(m3)
CREATE (t1)-[:CLASSIFIED_AS]->(c1)
CREATE (t2)-[:CLASSIFIED_AS]->(c2)
CREATE (t3)-[:CLASSIFIED_AS]->(c2)
CREATE (t4)-[:CLASSIFIED_AS]->(c2)
CREATE (t5)-[:CLASSIFIED_AS]->(c1)
CREATE (t6)-[:CLASSIFIED_AS]->(c2)
CREATE (t7)-[:CLASSIFIED_AS]->(c2)
CREATE (t8)-[:CLASSIFIED_AS]->(c2)
CREATE (t9)-[:CLASSIFIED_AS]->(c1)
CREATE (t10)-[:CLASSIFIED_AS]->(c2)
CREATE (t11)-[:CLASSIFIED_AS]->(c2)
CREATE (t12)-[:CLASSIFIED_AS]->(c2)
CREATE (t13)-[:CLASSIFIED_AS]->(c1)
CREATE (t14)-[:CLASSIFIED_AS]->(c2)
CREATE (t15)-[:CLASSIFIED_AS]->(c2)
CREATE (a1)<-[:PAID_BY]-(t1)
CREATE (a1)<-[:PAID_BY]-(t2)
CREATE (a2)<-[:PAID_BY]-(t3)
CREATE (a3)<-[:PAID_BY]-(t4)
CREATE (a1)<-[:PAID_BY]-(t5)
CREATE (a1)<-[:PAID_BY]-(t6)
CREATE (a1)<-[:PAID_BY]-(t7)
CREATE (a1)<-[:PAID_BY]-(t8)
CREATE (a2)<-[:PAID_BY]-(t9)
CREATE (a2)<-[:PAID_BY]-(t10)
CREATE (a3)<-[:PAID_BY]-(t11)
CREATE (a1)<-[:PAID_BY]-(t12)
CREATE (a2)<-[:PAID_BY]-(t13)
CREATE (a3)<-[:PAID_BY]-(t14)
CREATE (a1)<-[:PAID_BY]-(t15)