-
Notifications
You must be signed in to change notification settings - Fork 0
/
dump.js
93 lines (85 loc) · 2.49 KB
/
dump.js
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
const config = require("./config.json");
var exports = module.exports = {};
var mysql = require('mysql');
var pool = mysql.createPool({
connectionLimit : 10, //important
host : 'localhost',
user : 'root',
password : config.password,
database : 'ffcc',
debug : false
});
const challonge = require('challonge');
const tournament = challonge.createClient({
apiKey: config.challonge
});
//--------------------------
exports.clear=function(){
clear(function(bool){
if(bool) dump();
})
}
//--------------------------
function dump(){
tourneyURLs=["FCIT_TH9_S1","FCIT_TH9_S2","FCIT_TH10_S1","FCIT_TH10_S2","FCIT_TH11_S1","FCIT_TH11_S2"];
tourneyID=[91,92,101,102,111,112]
for(var j=0;j<tourneyURLs.length;j++){
tourneyURL=tourneyURLs[j];
//start of actual dumping progress
tournament.participants.index({
id: tourneyURL,
callback: (err, data) => {
if(err) console.log(err);
for(var i=0;data[i];i++){
console.log(i);
save(data[i].participant.id,tourneyID[j],data[i].participant.seed)
}
}
});
}
}
function clear(callback){
//Creates a database connection
pool.getConnection(function(err,connection){
if (err) {
callback("Error: "+err);
}
//Successfully connected
console.log('connected as id ' + connection.threadId);
connection.query('TRUNCATE seeds',function(err,rows){
connection.release();
if(!err) {
//parsing stuff
callback(true);
console.log("OK "+connection.threadId);
} else{
console.log(err);
}
});
connection.on('error', function(err) {
console.log("Error: "+err);
});
});
}
function save(tournamentID,tourneyID,seedNumber){
//Creates a database connection
pool.getConnection(function(err,connection){
if (err) {
callback("Error: "+err);
}
//Successfully connected
console.log('connected as id ' + connection.threadId);
connection.query('INSERT INTO `seeds` SET ?',{tournamentID: tournamentID, tourneyID: tourneyID, seedNumber:seedNumber},function(err,rows){
connection.release();
if(!err) {
//parsing stuff
console.log("OK "+connection.threadId);
} else{
console.log(err);
}
});
connection.on('error', function(err) {
console.log("Error: "+err);
});
});
}