private void hsRunAllCommands_Click(object sender, EventArgs e)
{
pbProgress.Maximum = _sql.CommandsCount;
pbProgress.Minimum = 0;
pbProgress.Value = 0;
_sql.ScriptNotify.Register4Info(ScriptInfoRaised);
_sql.ScriptNotify.Register4Error(ScriptErrorRaised);
_sql.RunPreparedCommands();
}
private void ExecuteCommandsFromFile(string filename)
{
var fi = new FileInfo(filename);
if (!fi.Exists)
{
return;
}
var content = new StringBuilder();
_notifies?.AddToINFO($@"{StaticFunctionsClass.DateTimeNowStr()} Prepare executing script in file {filename}");
Application.DoEvents();
string _connstr = ConnectionStrings.Instance.MakeConnectionString(_actScriptingDbReg);
_sql = new DBBasicClassLibrary.SQLScriptingClass(_connstr, AppSettingsClass.Instance.SQLVariables.GetNewLine(), AppSettingsClass.Instance.SQLVariables.CommentStart, AppSettingsClass.Instance.SQLVariables.CommentEnd, AppSettingsClass.Instance.SQLVariables.SingleLineComment, "SCRIPT");
_sql.ScriptNotify.Register4Info(EventMeldungRaised);
_sql.Commands.Clear();
int lineCount = 0;
int clearAfter = StaticFunctionsClass.ToIntDef(txtClear.Text, 1000);
fcbCommands.Clear();
fcbCommands.BeginUpdate();
content.Clear();
long mx = fi.Length / 20;
pbProgress.Maximum = (int)mx;
pbProgress.Minimum = 0;
pbProgress.Value = 0;
using (var sr = new StreamReader(fi.FullName, Encoding.Default))
{
if (pbProgress.Maximum >= pbProgress.Minimum)
{
pbProgress.Value = 0;
}
var startDt = DateTime.Now;
while (!sr.EndOfStream)
{
string str = sr.ReadLine();
bool cmdeady = _sql.AddCommandLine($@"{str}{Environment.NewLine}");
if (!cmdeady)
{
continue;
}
lineCount++;
var returnList = _sql.RunPreparedCommands();
_sql.Commands.Clear();
}
fcbCommands.EndUpdate();
Cursor = Cursors.Default;
_notifies?.AddToINFO($@"{StaticFunctionsClass.DateTimeNowStr()} Preparing done {lineCount.ToString()} commands");
Application.DoEvents();
}
}