如何使用命令行从MySQL Workbench生成SQL脚本? [英] How to generate SQL Script from MySQL Workbench using Command Line?

问题描述

我目前正在使用FinalBuilder创建一键式建筑并生成安装，但是我面对MySQL Workbench缺乏从命令行生成SQL脚本的能力.

I'm currently using FinalBuilder to create a one-click building n’ generate install, but I faced with MySQL Workbench lack of capacity to generate SQL script from a command line.

推荐答案

您实际上可以使用Python(或Lua)脚本自动执行此任务-MySQL Workbench在Scripting菜单下已经具有解释器.创建一个新脚本并使用存根:

You can actually automate this task with Python (or Lua) script - MySQL Workbench already has an interpreter under Scripting menu. Create a new script and use the stub:

# -*- coding: utf-8 -*-

import os
import grt
from grt.modules import DbMySQLFE

c = grt.root.wb.doc.physicalModels[0].catalog
DbMySQLFE.generateSQLCreateStatements(c, c.version, {
    'GenerateDrops' : 1,
    'GenerateSchemaDrops' : 1,
    'OmitSchemata' : 1,
    'GenerateUse' : 1
})
DbMySQLFE.generateSQLCreateStatements(c, c.version, {
DbMySQLFE.createScriptForCatalogObjects(os.path.dirname(grt.root.wb.docPath) + 'ddl.sql', c, {})

它不能从命令行强制运行，但是我相信您可以使用--run-script选项运行它.

It does not actully run from command line, but I beleive you can run it with --run-script option.

这篇关于如何使用命令行从MySQL Workbench生成SQL脚本?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！