public void Execute(IMenuCommand command)
{
IDiagram diagram = this.DiagramContext.CurrentDiagram;
IModelStore modelStore = diagram.ModelStore;
string SqlFile = @"C:\MyLoStore\MyLoStorePostgres.sql";
string PythonFile = @"C:\MyLoStore\MyLoStore.py";
FolderBrowserDialog openFolderDialog1 = new FolderBrowserDialog();
openFolderDialog1.RootFolder = Environment.SpecialFolder.MyComputer;
openFolderDialog1.Description =
"Select the directory that you want to use for generated output";
if (openFolderDialog1.ShowDialog() == DialogResult.OK)
{
string folderName = openFolderDialog1.SelectedPath;
SqlFile = folderName + @"\MyLoStorePostgres.sql";
PythonFile = folderName + @"\MyLoStore.py";
using (StreamWriter fsSql = new StreamWriter(SqlFile, false))
{
using (StreamWriter fsPy = new StreamWriter(PythonFile, false))
{
SQLWriter mySql = new SQLWriter(SQLGenerateRun.Postgres);
PythonClassWriter py = new PythonClassWriter();
SQLGenerator sqlGen = new SQLGenerator(fsSql, mySql, fsPy, py, modelStore);
sqlGen.GenerateMySQL();
}
}
}
}
public void Execute(IMenuCommand command)
{
IDiagram diagram = this.DiagramContext.CurrentDiagram;
IModelStore modelStore = diagram.ModelStore;
const string newPath = @"C:\PLDB";
System.IO.Directory.CreateDirectory(newPath);
string SqlFile = Path.Combine(newPath, @"PLDBmysql.sql");
string PythonFile = Path.Combine(newPath, @"PLDB.py");
using (StreamWriter fsSql = new StreamWriter(SqlFile))
{
using (StreamWriter fsPy = new StreamWriter(PythonFile))
{
SQLWriter mySql = new SQLWriter(SQLGenerateRun.INNODB);
//DjangoWriter py = new DjangoWriter();
PythonClassWriter py = new PythonClassWriter();
SQLGenerator sqlGen = new SQLGenerator(fsSql, mySql, fsPy, py, modelStore);
sqlGen.GenerateMySQL();
}
}
// TODO debug this code: seems like I'm missing an assembly reference!
//var outWindow = Package.GetService(typeof(SVsOutputWindow)) as IVsOutputWindow;
//Guid generalPaneGuid = VSConstants.GUID_OutWindowGeneralPane;
//IVsOutputWindowPane generalPane;
//outWindow.GetPane(ref generalPaneGuid, out generalPane);
//generalPane.OutputString("============= SQL Generation Successful =================");
//generalPane.Activate(); // Brings this pane into view
}
public void Execute(IMenuCommand command)
{
IDiagram diagram = this.DiagramContext.CurrentDiagram;
IModelStore modelStore = diagram.ModelStore;
const string SqlFile = @"C:\PLDB\PLDBmysql.sql";
const string PythonFile = @"C:\PLDB\PLDB.py";
using (StreamWriter fsSql = new StreamWriter(SqlFile))
{
using (StreamWriter fsPy = new StreamWriter(PythonFile))
{
SQLWriter mySql = new SQLWriter(SQLGenerateRun.MyISAM);
PythonClassWriter py = new PythonClassWriter();
SQLGenerator sqlGen = new SQLGenerator(fsSql, mySql, fsPy, py, modelStore);
sqlGen.GenerateMySQL();
}
}
}