forked from javascript-tutorial/server
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathmigratePlay.js
More file actions
executable file
·108 lines (85 loc) · 2.76 KB
/
migratePlay.js
File metadata and controls
executable file
·108 lines (85 loc) · 2.76 KB
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
var fs = require('fs');
var fse = require('fs-extra');
var co = require('co');
var path = require('path');
var gutil = require('gulp-util');
var dataUtil = require('lib/dataUtil');
var mongoose = require('lib/mongoose');
var projectRoot = require('config').projectRoot;
var mysql = require('mysql');
var zip = require('node-zip');
module.exports = function() {
return function() {
return co(function*() {
var connection = mysql.createConnection({
host: 'localhost',
user: 'root',
database: 'js'
});
connection.connect();
var plays = yield function(callback) {
connection.query('SELECT * FROM play_save', function(err, rows, fields) {
callback(err, rows);
});
};
plays = plays.map(function(play) {
try {
play.content = JSON.parse(play.content);
} catch(e) {
console.log("BAD CONTENT", play.name, e.message);
// probably content over 64K
return null;
}
return {
id: play.id,
name: play.name,
url: 'http://learn.javascript.ru/play/' + play.name,
content: play.content
};
}).filter(Boolean);
for (var i = 0; i < plays.length; i++) {
var play = plays[i];
var file;
try {
file = yield* exportPlay(connection, play);
} catch(e) {
if (e.code == 'ENOENT') {
console.log("ENOENT", play.name);
// no such file
continue;
} else {
throw e;
}
}
console.log("done", play.name);
var dir = `/js/play/${play.name.slice(0,2).toLowerCase()}/${play.name.slice(2,4).toLowerCase()}`;
fse.ensureDirSync(dir);
fs.writeFileSync(`${dir}/${play.name}.zip`, file, 'binary');
}
connection.end();
});
};
};
function* exportPlay(db, play) {
var resources = yield function(callback) {
db.query(`
SELECT play_id,resource_id,name,fs_name,created
FROM play_save_resources psr, play_resources pr
WHERE psr.resource_id=pr.id AND play_id=?
ORDER BY created desc`, [play.id], function(err, rows, fields) {
callback(err, rows);
});
};
play.content.files = resources;
var archive = new zip();
for (var i = 0; i < play.content.tabs.length; i++) {
var tab = play.content.tabs[i];
archive.file(tab.name, tab.content);
}
for (var i = 0; i < play.content.files.length; i++) {
var file = play.content.files[i];
var filepath = `/var/site/js/www/files/play/${file.fs_name.slice(0, 2)}/${file.fs_name.slice(2, 4)}/${file.fs_name}`;
archive.file(file.name, fs.readFileSync(filepath));
}
return archive.generate({base64: false, compression: 'DEFLATE'});
}