private void SaveInFile() { // Save the query text to file if (QBuilder.ActiveUnionSubQuery == null) { return; } var saveFileDialog1 = new SaveFileDialog() { DefaultExt = "sql", FileName = "query", Filter = "SQL query files (*.sql)|*.sql|All files|*.*" }; if (saveFileDialog1.ShowDialog() != true) { return; } using (var sw = new StreamWriter(saveFileDialog1.FileName)) { sw.Write(FormattedSQLBuilder.GetSQL(QBuilder.ActiveUnionSubQuery.QueryRoot, QBuilder.SQLFormattingOptions)); } }
private void ApplyText() { var sqlFormattingOptions = queryBuilder1.SQLFormattingOptions; switch (_mode) { case ModeEditor.Entire: textBox1.Text = queryBuilder1.FormattedSQL; break; case ModeEditor.SubQuery: if (queryBuilder1.ActiveUnionSubQuery == null) { break; } var subQuery = queryBuilder1.ActiveUnionSubQuery.ParentSubQuery; textBox1.Text = FormattedSQLBuilder.GetSQL(subQuery, sqlFormattingOptions); break; case ModeEditor.Expression: if (queryBuilder1.ActiveUnionSubQuery == null) { break; } var unionSubQuery = queryBuilder1.ActiveUnionSubQuery; textBox1.Text = FormattedSQLBuilder.GetSQL(unionSubQuery, sqlFormattingOptions); break; default: throw new ArgumentOutOfRangeException(); } }
private void sqlQuery_SQLUpdated(object sender, EventArgs e) { // Handle the event raised by SQL Builder object that the text of SQL query is changed // Hide error banner if any errorBox1.Show(null, sqlContext1.SyntaxProvider); // update the text box with formatted query text created with default formatting options _lastValidSql = sqlTextEditor1.Text = FormattedSQLBuilder.GetSQL(sqlQuery1.QueryRoot, new SQLFormattingOptions()); }
private void _query_SQLUpdated(object sender, EventArgs e) { // at this stage you can get simple unformatted query text... //SqlBox.Text = _query.SQL; // ... or format the query text with SQL formatter SQLFormattingOptions formattingOptions = new SQLFormattingOptions { KeywordFormat = KeywordFormat.UpperCase }; var sql = FormattedSQLBuilder.GetSQL(_query.QueryRoot, formattingOptions); // put the result SQL query text to the text box SqlBox.Text = sql; }
private void ApplyText() { var sqlFormattingOptions = Builder.SQLFormattingOptions; if (TextEditor == null) { return; } switch (_mode) { case ModeEditor.Entire: _lastValidSql = TextEditor.Text = Builder.FormattedSQL; break; case ModeEditor.SubQuery: if (Builder.ActiveUnionSubQuery == null) { break; } var subQuery = Builder.ActiveUnionSubQuery.ParentSubQuery; _lastValidSql = TextEditor.Text = FormattedSQLBuilder.GetSQL(subQuery, sqlFormattingOptions); break; case ModeEditor.Expression: if (Builder.ActiveUnionSubQuery == null) { break; } var unionSubQuery = Builder.ActiveUnionSubQuery; _lastValidSql = TextEditor.Text = FormattedSQLBuilder.GetSQL(unionSubQuery, sqlFormattingOptions); break; default: throw new ArgumentOutOfRangeException(); } }
public void OnSQLUpdated(object sender, EventArgs e) { var qb = QueryBuilderStore.Get("AlternateNames"); var opts = new SQLFormattingOptions(); opts.Assign(qb.SQLFormattingOptions); opts.KeywordFormat = KeywordFormat.UpperCase; // get SQL query with real object names opts.UseAltNames = false; var plainSql = FormattedSQLBuilder.GetSQL(qb.SQLQuery.QueryRoot, opts); // get SQL query with alternate names opts.UseAltNames = true; var sqlWithAltNames = FormattedSQLBuilder.GetSQL(qb.SQLQuery.QueryRoot, opts); // prepare additional data to be sent to the client qb.ExchangeData = new { SQL = plainSql, AlternateSQL = sqlWithAltNames }; }
public void OnSQLUpdated(object sender, EventArgs e) { var qb = QueryBuilderStore.Get(InstanceId); var opts = new SQLFormattingOptions(); opts.Assign(qb.SQLFormattingOptions); opts.KeywordFormat = KeywordFormat.UpperCase; // get query with virtual objects and fields opts.ExpandVirtualObjects = false; var sqlWithVirtObjects = FormattedSQLBuilder.GetSQL(qb.SQLQuery.QueryRoot, opts); // get SQL query with real object names opts.ExpandVirtualObjects = true; var plainSql = FormattedSQLBuilder.GetSQL(qb.SQLQuery.QueryRoot, opts); // prepare additional data to be sent to the client qb.ExchangeData = new { SQL = plainSql, VirtualObjectsSQL = sqlWithVirtObjects }; }
private void sqlQuery_SQLUpdated(object sender, EventArgs e) { // Text of SQL query has been updated. // To get the query text, ready for execution on SQL server with real object names just use SQL property. _lastValidSql = sqlTextEditor.Text = FormattedSQLBuilder.GetSQL(_sqlQuery.QueryRoot, new SQLFormattingOptions()); }
private void sqlQuery1_SQLUpdated(object sender, EventArgs e) { sqlTextEditor1.Text = _builder.GetSQL(sqlQuery1.QueryRoot); }