Exemple #1
0
 public SqlStatement Parse(SqlQueryParser parser)
 {
     return(new SqlDelete()
     {
         FromSource = parser.ParseQuery(Parent),
     });
 }
Exemple #2
0
 public SqlStatement Parse(SqlQueryParser parser)
 {
     return(new SqlSelect()
     {
         FromSource = parser.ParseQuery(SelectQuery),
     });
 }
Exemple #3
0
        public SqlStatement Parse(SqlQueryParser parser)
        {
            var queryResult = parser.ParseQuery(Parent);
            var parameters  = new Dictionary <string, SqlSubQueryResult>();

            parameters[InsertExpression.Parameters[0].Name] = queryResult.SelectResult; // item
            // parameters[stmt.InsertExpression.Parameters[1].Name] = ; // builder

            var inserts = parser.ParseInsertBuilder(FromQuery, InsertExpression, parameters);

            return(new SqlUpdate()
            {
                FromSource = queryResult,
                Inserts = inserts,
            });
        }
Exemple #4
0
        public SqlStatement Parse(SqlQueryParser parser)
        {
            var parentQueryResult = parser.ParseQuery(SelectQuery);

            var parameters = new Dictionary <string, SqlSubQueryResult>();

            parameters[InsertExpression.Parameters[0].Name] = parentQueryResult.SelectResult;

            var inserts = parser.ParseInsertBuilder(FromQuery, InsertExpression, parameters);

            var primaryKey = FromQuery.Columns.Where(c => c.PrimaryKeyAutoIncrement).FirstOrDefault();

            return(new SqlInsertSelect()
            {
                FromSource = parentQueryResult,
                Inserts = inserts,
                TableName = FromQuery.TableName,
                AutoIncrementPrimaryKeyName = primaryKey?.SqlName,
            });
        }