public static void Execute()
{
NpgsqlConnectionInfo info = new NpgsqlConnectionInfo
{
ServerName = _hostname,
ServerPort = _port,
DatabaseName = _database,
UserName = _username
};
info.FillStoredPassword(false);
using (IDbConnection conn = TryLogin(info))
{
if (conn == null)
{
Console.Error.WriteLine("ログインできませんでした。終了します。");
Environment.Exit(1);
}
}
ExportTable obj = new ExportTable
{
DataSet = new NpgsqlDataSet(info)
};
if (_exportDir == null)
{
_exportDir = Environment.CurrentDirectory;
}
Task t = null;
switch (_mode)
{
case ExportMode.Export:
t = obj.ExportAsync(obj.DataSet, _schemas, _excludeSchemas, _configFileName, _exportDir, _encoding);
break;
case ExportMode.GenerateConfig:
t = obj.ExportConfigAsync(obj.DataSet, _schemas, _excludeSchemas, _configFileName, _ruleFileName, _encoding);
break;
case ExportMode.GenerateRule:
File.WriteAllText(_ruleFileName, Properties.Resources.DBExpRule, _encoding);
break;
}
if (t == null)
{
return;
}
while (!t.IsCompleted)
{
Thread.Sleep(100);
}
if (t.IsFaulted)
{
Console.Error.WriteLine(t.ToString());
Console.Error.Flush();
Environment.Exit(1);
}
}
private void window_Loaded(object sender, RoutedEventArgs e)
{
gridLoading.Visibility = Visibility.Collapsed;
ConnectionInfo info = new NpgsqlConnectionInfo()
{
ServerName = App.Hostname,
ServerPort = App.Port,
DatabaseName = App.Database,
UserName = App.Username
};
if (App.HasConnectionInfo)
{
if (!info.FillStoredPassword(true))
{
if (TryConnect(info))
{
return;
}
}
}
else
{
info = NewConnectionInfoFromRegistry();
}
NewConnectionWindow win = new NewConnectionWindow();
win.Owner = this;
win.Target = info;
bool?ret = win.ShowDialog();
if (!ret.HasValue || !ret.Value)
{
return;
}
info = win.Target;
Connect(info);
App.Connections.Merge(info);
App.Connections.Save();
menuItemPsql.IsEnabled = !string.IsNullOrEmpty(GetExecutableFromPath(menuItemPsql.Tag.ToString()));
menuItemPgdump.IsEnabled = !string.IsNullOrEmpty(GetExecutableFromPath(menuItemPgdump.Tag.ToString()));
{
CommandBinding cb;
cb = new CommandBinding(DataGridCommands.CopyTable, CopyTableCommand_Executed, CopyTableCommand_CanExecute);
CommandBindings.Add(cb);
cb = new CommandBinding(DataGridCommands.CopyTableContent, CopyTableContentCommand_Executed, CopyTableCommand_CanExecute);
CommandBindings.Add(cb);
cb = new CommandBinding(DataGridCommands.CopyTableAsInsert, CopyTableAsInsertCommand_Executed, CopyTableCommand_CanExecute);
CommandBindings.Add(cb);
cb = new CommandBinding(DataGridCommands.CopyTableAsCopy, CopyTableAsCopyCommand_Executed, CopyTableCommand_CanExecute);
CommandBindings.Add(cb);
}
}
private ConnectionInfo NewConnectionInfoFromRegistry()
{
NpgsqlConnectionInfo info = new NpgsqlConnectionInfo()
{
ServerName = App.Registry.GetString("Connection", "ServerName", App.Hostname),
ServerPort = App.Registry.GetInt32("Connection", "ServerPort", App.Port),
DatabaseName = App.Registry.GetString("Connection", "DatabaseName", App.Database),
UserName = App.Registry.GetString("Connection", "UserName", App.Username),
SearchPath = App.Registry.GetString("Connection", "SearchPath", App.SearchPath),
};
info.FillStoredPassword(false);
info = App.Connections.Find(info) as NpgsqlConnectionInfo;
return(info);
}
public static void Execute()
{
NpgsqlConnectionInfo info = new NpgsqlConnectionInfo
{
ServerName = _hostname,
ServerPort = _port,
DatabaseName = _database,
UserName = _username
};
info.FillStoredPassword(false);
using (IDbConnection conn = TryLogin(info))
{
if (conn == null)
{
Console.Error.WriteLine("ログインできませんでした。終了します。");
Environment.Exit(1);
}
}
ExportSchema obj = new ExportSchema
{
DataSet = new NpgsqlDataSet(info)
{
NewLineRule = _newLine
}
};
if (_exportDir == null)
{
_exportDir = Environment.CurrentDirectory;
}
Task t = obj.ExportAsync(obj.DataSet, _schemas, _excludeSchemas, _exportDir, _encoding);
while (!t.IsCompleted)
{
Thread.Sleep(100);
}
if (t.IsFaulted)
{
Console.Error.WriteLine(t.ToString());
Console.Error.Flush();
Environment.Exit(1);
}
}
