Beispiel #1
0
    public override void EnterUpdate_elem(TSqlParser.Update_elemContext context)
    {
        if (IsStatementUpdate())
        {
            var statement = GetStatementAsUpdate();
            var element   = new UpdateStatementElement();
            element.RawString = context.GetText();
            element.RawStringWithWhitespace = GetWhiteSpaceFormat(context);
            statement.Elements.Add(element);
        }

        Debug.WriteLine(context.GetText());
    }
Beispiel #2
0
 private void SetupElement(UpdateStatementElement element)
 {
     if (element != null)
     {
         if (!string.IsNullOrEmpty(element.DatabaseName))
         {
             if (_process.HasDatabase(element.DatabaseName))
             {
                 var db = _process.GetDatabase(element.DatabaseName);
                 element.Database = db as Database;
                 if (db.HasTable(element.TableName))
                 {
                     element.Table = db.GetTable(element.TableName);
                     if (element.Table.HasColumn(element.ColumnName))
                     {
                         element.Column = element.Table.GetColumn(element.ColumnName);
                     }
                     else
                     {
                         IsValid      = false;
                         ErrorMessage = $"Column {element.ColumnName} not found";
                     }
                 }
                 else
                 {
                     IsValid      = false;
                     ErrorMessage = $"Table {element.TableName} not found";
                 }
             }
         }
         else
         {
             IsValid      = false;
             ErrorMessage = "Database Name not supplied";
         }
     }
 }