72 lines
1.9 KiB
JavaScript
72 lines
1.9 KiB
JavaScript
|
|
const Myt = require('./myt');
|
|
const Command = require('./lib/command');
|
|
const fs = require('fs-extra');
|
|
|
|
class Dump extends Command {
|
|
static usage = {
|
|
description: 'Dumps structure and fixtures from remote',
|
|
operand: 'remote'
|
|
};
|
|
|
|
static localOpts = {
|
|
default: {
|
|
remote: 'production'
|
|
}
|
|
};
|
|
|
|
async run(myt, opts) {
|
|
const dumpStream = await myt.initDump('.dump.sql');
|
|
|
|
console.log('Dumping structure.');
|
|
let dumpArgs = [
|
|
'--default-character-set=utf8',
|
|
'--no-data',
|
|
'--comments',
|
|
'--triggers',
|
|
'--routines',
|
|
'--events',
|
|
'--databases'
|
|
];
|
|
dumpArgs = dumpArgs.concat(opts.schemas);
|
|
await myt.runDump('docker-dump.sh', dumpArgs, dumpStream);
|
|
|
|
console.log('Dumping fixtures.');
|
|
await myt.dumpFixtures(dumpStream, opts.fixtures);
|
|
|
|
console.log('Dumping privileges.');
|
|
const privs = opts.privileges;
|
|
if (privs && Array.isArray(privs.tables)) {
|
|
let args = [
|
|
'--no-create-info',
|
|
'--skip-triggers',
|
|
'--insert-ignore',
|
|
'--complete-insert'
|
|
];
|
|
if (privs.where) args.push('--where', privs.where);
|
|
args = args.concat(['mysql'], privs.tables);
|
|
|
|
await dumpStream.write('USE `mysql`;\n', 'utf8');
|
|
await myt.runDump('mysqldump', args, dumpStream);
|
|
}
|
|
|
|
await dumpStream.end();
|
|
|
|
console.log('Saving version.');
|
|
await myt.dbConnect();
|
|
const version = await myt.fetchDbVersion();
|
|
if (version) {
|
|
await fs.writeFile(
|
|
`${opts.dumpDir}/.dump.json`,
|
|
JSON.stringify(version)
|
|
);
|
|
}
|
|
}
|
|
}
|
|
|
|
module.exports = Dump;
|
|
|
|
if (require.main === module)
|
|
new Myt().run(Dump);
|
|
|