private void NameConstraintsCalled(object sender, EventArgs e) { var dte = (DTE)GetService(typeof(DTE)); if (null == dte || dte.ActiveDocument == null) { return; } var doc = dte.ActiveDocument.Object("TextDocument") as TextDocument; if (null == doc) { return; } var ep = doc.StartPoint.CreateEditPoint(); ep.EndOfDocument(); var length = ep.AbsoluteCharOffset; ep.StartOfDocument(); var originalText = ep.GetText(length); var namer = new ConstraintNamer(originalText); var modifiedText = namer.Go(); if (originalText != modifiedText) { ep.Delete(length); ep.Insert(modifiedText); } }
private void NameConstraintsCalled(object sender, EventArgs e) { try { CallWrapper(); var dte = (DTE)GetService(typeof(DTE)); if (null == dte || dte.ActiveDocument == null) { return; } var doc = dte.ActiveDocument.Object("TextDocument") as TextDocument; if (null == doc) { return; } var ep = doc.StartPoint.CreateEditPoint(); ep.EndOfDocument(); var length = ep.AbsoluteCharOffset; ep.StartOfDocument(); var originalText = ep.GetText(length); var namer = new ConstraintNamer(originalText); var modifiedText = namer.Go(); if (originalText != modifiedText) { ep.Delete(length); ep.Insert(modifiedText); } } catch (Exception ex) { OutputPane.WriteMessage("Exception naming constraints, error: {0}", ex.Message); } }
public void PrimaryKey() { var scriptPath = ".\\tableOne.sql"; if (File.Exists(scriptPath)) { File.Delete(scriptPath); } File.Copy("..\\..\\..\\ProjectWithConstraints\\TableOne.sql", scriptPath); //var namer = new ConstraintNamer(scriptPath, // "..\\..\\..\\ProjectWithConstraints\\bin\\Release\\ProjectWithConstraints.dacpac"); var namer = new ConstraintNamer(File.ReadAllText(scriptPath)); var changedText = namer.Go(); Assert.LessOrEqual(-1, changedText.IndexOf("[Id] INT NOT NULL PRIMARY KEY"), changedText); Assert.Greater(changedText.IndexOf("CONSTRAINT [PK_TableOne] PRIMARY KEY ([Id])", StringComparison.OrdinalIgnoreCase), -1, changedText); }