Market/remplirBase at master · Zelfrost/Market · GitHub

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
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
#!/usr/bin/perl

open(U, ">remplirUser.sql");
foreach $i (5..10000) {
	print U 'INSERT INTO users VALUES('.$i.', \'aaa\', \'bbb\', \'aaa'.$i.'\', \'aaa\', \'aa@aa.aa\', 10000, 0, \'User\');'."\n";
}
close(U);


open(M, ">remplirMarket.sql");
foreach $i (5..10000) {
	print M 'INSERT INTO markets VALUES('.$i.', \'aaa\', \'bbb\', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '.$i.', 2);'."\n";
}
foreach $i (100005..20000) {
	print M 'INSERT INTO markets VALUES('.$i.', \'aaa\', \'bbb\', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '.( $i - 10000 ).', 2);'."\n";
}
foreach $i (200005..30000) {
	print M 'INSERT INTO markets VALUES('.$i.', \'aaa\', \'bbb\', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '.( $i - 20000 ).', 2);'."\n";
}
foreach $i (300005..40000) {
	print M 'INSERT INTO markets VALUES('.$i.', \'aaa\', \'bbb\', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '.( $i - 30000 ).', 2);'."\n";
}
close(M);

open(T, ">remplirTrans.sql");
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('.$i.', '.$i.', '.$i.', 10, 10, 0, 30, 0, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 10000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 0, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 20000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 0, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 30000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 0, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 40000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 0, 0, CURRENT_TIMESTAMP);'."\n";
}

foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 50000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 0, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 60000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 0, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 70000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 0, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 80000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 0, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 90000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 0, 0, CURRENT_TIMESTAMP);'."\n";
}

foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 100000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 0, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 110000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 0, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 120000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 0, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 130000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 0, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 140000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 0, 0, CURRENT_TIMESTAMP);'."\n";
}

foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 150000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 1, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 160000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 1, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 170000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 1, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 180000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 1, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 190000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 1, 0, CURRENT_TIMESTAMP);'."\n";
}

foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 200000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 1, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 210000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 1, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 220000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 1, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 230000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 1, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 240000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 1, 0, CURRENT_TIMESTAMP);'."\n";
}

foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 250000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 1, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 260000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 1, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 270000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 1, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 280000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 1, 0, CURRENT_TIMESTAMP);'."\n";
}
foreach $i (5..10000) {
	print T 'INSERT INTO transactions VALUES('. ( $i + 290000 ) .', '.$i.', '.$i.', 10, 10, 0, 30, 1, 0, CURRENT_TIMESTAMP);'."\n";
}
close(T);