public UpdateStatement (IdentifierExpression identifier, IEnumerable<IdentifierExpression> columns, IEnumerable<IExpression> values) { Identifier = identifier; this.columns = new List<IdentifierExpression> (); this.values = new List<IExpression> (); this.columns.AddRange (columns); this.values.AddRange (values); }
public InsertStatement (IdentifierExpression identifier, IEnumerable<IdentifierExpression> columns, IEnumerable<IEnumerable<IExpression>> values) { Identifier = identifier; this.columns = new List<IdentifierExpression> (); this.values = new List<List<IExpression>> (); this.columns.AddRange (columns); foreach (IEnumerable<IExpression> row in values) { List<IExpression> expr = new List<IExpression> (); expr.AddRange (row); this.Values.Add (expr); } }
protected void OnEmptyTable () { TableNode node = (TableNode)CurrentNode.DataItem; if (Services.MessageService.AskQuestion ( GettextCatalog.GetString ("Are you sure you want to empty table '{0}'", node.Table.Name), GettextCatalog.GetString ("Empty Table") )) { IdentifierExpression tableId = new IdentifierExpression (node.Table.Name); DeleteStatement del = new DeleteStatement (new FromTableClause (tableId)); IPooledDbConnection conn = node.ConnectionContext.ConnectionPool.Request (); IDbCommand command = conn.CreateCommand (del); conn.ExecuteNonQueryAsync (command, new ExecuteCallback<int> (OnEmptyTableCallback), null); } }
protected void OnSelectAllCommand () { TableNode node = (TableNode)CurrentNode.DataItem; IdentifierExpression tableId = new IdentifierExpression (node.Table.Name); SelectStatement sel = new SelectStatement (new FromTableClause (tableId)); IPooledDbConnection conn = node.ConnectionContext.ConnectionPool.Request (); IDbCommand command = conn.CreateCommand (sel); conn.ExecuteTableAsync (command, new ExecuteCallback<DataTable> (OnSelectCommandThreaded), null); }
private void OnSelectColumnsCommandGetColumns (object state) { TableNode node = (TableNode)state; ColumnSchemaCollection columns = node.Table.Columns; //this can invoke the schema provider, so it must be in bg thread DispatchService.GuiDispatch (delegate () { SelectColumnDialog dlg = new SelectColumnDialog (true, columns); if (dlg.Run () == (int)Gtk.ResponseType.Ok) { IdentifierExpression tableId = new IdentifierExpression (node.Table.Name); List<IdentifierExpression> cols = new List<IdentifierExpression> (); foreach (ColumnSchema schema in dlg.CheckedColumns) cols.Add (new IdentifierExpression (schema.Name)); SelectStatement sel = new SelectStatement (new FromTableClause (tableId), cols); IPooledDbConnection conn = node.ConnectionContext.ConnectionPool.Request (); IDbCommand command = conn.CreateCommand (sel); conn.ExecuteTableAsync (command, new ExecuteCallback<DataTable> (OnSelectCommandThreaded), null); } dlg.Destroy (); }); }
protected void OnQueryCommand () { TableNode node = (TableNode)CurrentNode.DataItem; IdentifierExpression tableId = new IdentifierExpression (node.Table.Name); SelectStatement sel = new SelectStatement (new FromTableClause (tableId)); SqlQueryView view = new SqlQueryView (); view.SelectedConnectionContext = node.ConnectionContext; IDbFactory fac = DbFactoryService.GetDbFactory (node.ConnectionContext.ConnectionSettings); view.Text = fac.Dialect.GetSql (sel); IdeApp.Workbench.OpenDocument (view, true); }
protected virtual string GetExpressionSql (IdentifierExpression expr) { return GetIdentifierName (expr.Name); }
public DropStatement (IdentifierExpression identifier, DropStatementType dropType) { Identifier = identifier; DropType = dropType; }
public FromTableClause (IdentifierExpression source) { Source = source; }
public DropStatement(IdentifierExpression identifier, DropStatementType dropType) { Identifier = identifier; DropType = dropType; }
public TruncateStatement (IdentifierExpression identifier) { Identifier = identifier; }
public virtual string GetUpdateQuery (TableSchema table) { ISqlDialect dialect = this.ConnectionPool.DbFactory.Dialect; IdentifierExpression tableId = new IdentifierExpression (table.Name); List<IdentifierExpression> columns = new List<IdentifierExpression>(); List<IExpression> values = new List<IExpression>(); foreach (ColumnSchema col in table.Columns) { columns.Add(new IdentifierExpression(col.Name)); values.Add(new IdentifierExpression(col.DataTypeName)); } UpdateStatement upd = new UpdateStatement (tableId, columns, values); return dialect.GetSql(upd); }
public virtual string GetSelectQuery (TableSchema table) { ISqlDialect dialect = this.ConnectionPool.DbFactory.Dialect; IdentifierExpression tableId = new IdentifierExpression (table.Name); List<IdentifierExpression> columns = new List<IdentifierExpression>(); foreach (ColumnSchema col in table.Columns) { columns.Add(new IdentifierExpression(col.Name)); } SelectStatement sel = new SelectStatement (new FromTableClause (tableId),columns); return dialect.GetSql(sel); }
protected virtual string GetExpressionSql(IdentifierExpression expr) { return(GetIdentifierName(expr.Name)); }
public TruncateStatement(IdentifierExpression identifier) { Identifier = identifier; }