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
122
123
124
125
126
127
128
|
/* eslint-disable eqeqeq */
/* eslint-disable no-await-in-loop */
/* eslint-disable no-console */
const nodePath = require('path');
const moment = require('moment');
const oldDb = require('knex')({
client: 'sqlite3',
connection: {
filename: nodePath.join(__dirname, '..', '..', 'db'),
},
useNullAsDefault: true,
});
const newDb = require('knex')({
client: 'sqlite3',
connection: {
filename: nodePath.join(__dirname, '..', '..', 'database.sqlite'),
},
postProcessResponse: (result) => {
const booleanFields = [
'enabled',
'enableDownload',
'isAdmin',
];
const processResponse = (row) => {
Object.keys(row).forEach((key) => {
if (booleanFields.includes(key)) {
if (row[key] === 0) row[key] = false;
else if (row[key] === 1) row[key] = true;
}
});
return row;
};
if (Array.isArray(result)) return result.map((row) => processResponse(row));
if (typeof result === 'object') return processResponse(result);
return result;
},
useNullAsDefault: true,
});
const start = async () => {
console.log('Starting migration, this may take a few minutes...'); // Because I half assed it
console.log('Please do NOT kill the process. Wait for it to finish.');
const users = await oldDb.table('users').where('username', '<>', 'root');
for (const user of users) {
const now = moment.utc().toDate();
const userToInsert = {
id: user.id,
username: user.username,
password: user.password,
enabled: user.enabled == 1,
isAdmin: false,
apiKey: user.token,
passwordEditedAt: now,
apiKeyEditedAt: now,
createdAt: now,
editedAt: now,
};
await newDb.table('users').insert(userToInsert);
}
console.log('Finished migrating users...');
const albums = await oldDb.table('albums');
for (const album of albums) {
if (!album.enabled || album.enabled == 0) continue;
const now = moment.utc().toDate();
const albumToInsert = {
id: album.id,
userId: album.userid,
name: album.name,
zippedAt: album.zipGeneratedAt ? moment.unix(album.zipGeneratedAt).toDate() : null,
createdAt: moment.unix(album.timestamp).toDate(),
editedAt: moment.unix(album.editedAt).toDate(),
};
const linkToInsert = {
userId: album.userid,
albumId: album.id,
identifier: album.identifier,
views: 0,
enabled: true,
enableDownload: true,
createdAt: now,
editedAt: now,
};
await newDb.table('albums').insert(albumToInsert);
const insertedId = await newDb.table('links').insert(linkToInsert);
await newDb.table('albumsLinks').insert({
albumId: album.id,
linkId: insertedId[0],
});
}
console.log('Finished migrating albums...');
const files = await oldDb.table('files');
const filesToInsert = [];
const albumsFilesToInsert = [];
for (const file of files) {
const fileToInsert = {
id: file.id,
userId: file.userid,
name: file.name,
original: file.original,
type: file.type,
size: file.size,
hash: file.hash,
ip: file.ip,
createdAt: moment.unix(file.timestamp).toDate(),
editedAt: moment.unix(file.timestamp).toDate(),
};
filesToInsert.push(fileToInsert);
albumsFilesToInsert.push({
albumId: file.albumid,
fileId: file.id,
});
}
await newDb.batchInsert('files', filesToInsert, 20);
await newDb.batchInsert('albumsFiles', albumsFilesToInsert, 20);
console.log('Finished migrating files...');
console.log('Finished migrating everything. ');
process.exit(0);
};
start();
|