private void OkBtn_Click(object sender, EventArgs e) { string sql; try { sql = _session.GenerateSql(GetSelectedTables(), _methodLinkRad.Checked); } catch (Exception ex) { Ui.ShowError(this, "Error", ex); return; } var text = $"Importing from database..."; WaitForm.GoWithCancel(this, "Import", text, out var success, cancel => { SqlUtil.WithCancellableTransaction(_manager.Notebook, () => { _manager.ExecuteScript(sql); }, cancel); }); _manager.Rescan(); _manager.SetDirty(); if (!success) { return; } DialogResult = DialogResult.OK; Close(); }
private void Execute() { var sql = _inputText.SqlText.Trim(); if (string.IsNullOrWhiteSpace(sql)) { return; } using var output = WaitForm.GoWithCancel(TopLevelControl, "Console", "Executing...", out var success, cancel => { return(SqlUtil.WithCancellation(_manager.Notebook, () => { using var status = WaitStatus.StartRows("Script output"); return _manager.ExecuteScript(sql, onRow: status.IncrementRows); }, cancel)); }); _manager.SetDirty(); _manager.Rescan(); if (!success) { return; } _inputText.SqlText = ""; Log(sql, output); TakeFocus(); }
private async Task UpdateInputPreview() { var loadId = Guid.NewGuid(); _inputPreviewLoadId = loadId; _inputPreviewLoadControl.PushLoad(); try { var tempTableName = Guid.NewGuid().ToString(); var fileEncoding = _optionsControl.FileEncoding.Value; var text = await Task.Run(() => { try { var importSql = @"IMPORT TXT @filePath INTO @tableName (number, line) OPTIONS (TAKE_LINES: 1000, TEMPORARY_TABLE: 1, FILE_ENCODING: @encoding);"; _manager.ExecuteScriptNoOutput(importSql, new Dictionary <string, object> { ["@filePath"] = _filePath, ["@tableName"] = tempTableName, ["@encoding"] = fileEncoding }); using var dt = _manager.ExecuteScript($"SELECT line FROM {tempTableName.DoubleQuote()} ORDER BY number") .DataTables[0]; return(string.Join(Environment.NewLine, dt.Rows.Select(x => x[0].ToString()))); } finally { _manager.ExecuteScriptNoOutput($"DROP TABLE IF EXISTS {tempTableName.DoubleQuote()}"); } }); if (_inputPreviewLoadId == loadId) { _inputPreviewError.Value = null; _inputPreviewControl.PreviewText = text; } } catch (UncaughtErrorScriptException ex) { if (_inputPreviewLoadId == loadId) { _inputPreviewError.Value = $"Error loading the input file:\r\n{ex.ErrorMessage}"; _inputPreviewLoadControl.SetError(_inputPreviewError.Value); } } finally { _inputPreviewLoadControl.PopLoad(); } }