public WizardStep() { InitializeComponent(); CreateViewContext = new CreateViewContext(); CreateViewContext.PropertyChanged += CreateViewContext_PropertyChanged; }
public static IQsiDefinitionNode VisitCreateViewStatement(CreateViewContext context) { if (!context.TryGetTokenIndex(VIEW_SYMBOL, out var index)) { throw new QsiException(QsiError.Syntax); } var viewName = (ViewNameContext)context.children[index + 1]; var viewTail = (ViewTailContext)context.children[index + 2]; var columnInternalRefList = viewTail.columnInternalRefList(); var node = new MySqlViewDefinitionNode { Identifier = IdentifierVisitor.VisitViewName(viewName), }; if (context.viewReplaceOrAlgorithm() != null) { var replaceOrAlgorithm = context.viewReplaceOrAlgorithm(); node.Replace = replaceOrAlgorithm.HasToken(REPLACE_SYMBOL); if (replaceOrAlgorithm.viewAlgorithm() != null) { node.ViewAlgorithm.SetValue(TreeHelper.Fragment(replaceOrAlgorithm.viewAlgorithm().GetInputText())); } } if (context.definerClause() != null) { node.Definer = context.definerClause().user().GetInputText(); } if (context.viewSuid() != null) { node.ViewSuid.SetValue(TreeHelper.Fragment(context.viewSuid().GetInputText())); } node.Columns.SetValue(columnInternalRefList == null ? TreeHelper.CreateAllColumnsDeclaration() : TableVisitor.CreateSequentialColumns(columnInternalRefList)); node.Source.SetValue(TableVisitor.VisitViewSelect(viewTail.viewSelect())); return(node); }
public override AnalyseResult AnalyseView(string content) { SqlSyntaxError error = null; DdlStatementContext ddlStatement = this.GetDdlStatementContext(content, out error); AnalyseResult result = new AnalyseResult() { Error = error }; if (!result.HasError && ddlStatement != null) { ViewScript script = new ViewScript(); CreateViewContext view = ddlStatement.createView(); if (view != null) { #region Name this.SetScriptName(script, view.fullId()); #endregion #region Statement foreach (var child in view.children) { if (child is SimpleSelectContext select) { script.Statements.Add(this.ParseSelectStatement(select)); } } #endregion } this.ExtractFunctions(script, ddlStatement); result.Script = script; } return(result); }
public virtual void SetDataObject(CreateViewContext data) { }