Example #1
0
        public void ShouldGetObjectDependencies()
        {
            var token   = new CancellationTokenSource().Token;
            var service = new ObjectDependencyService();
            var meta    = ObjectMetadata.FromQualifiedString("ETL.fillCountry");

            var result = service.GetDependencies(meta, GetLocalConnection(), token);
        }
Example #2
0
        public void ShouldMockAllObjectDependencies()
        {
            var token   = new CancellationTokenSource().Token;
            var service = new ObjectDependencyService();
            var options = new PeterHenell.SSMS.Plugins.Utils.TsqltManager.MockOptionsDictionary();

            options.EachColumnInSelectOnNewRow = false;
            options.EachColumnInValuesOnNewRow = false;


            var meta = ObjectMetadata.FromQualifiedString("ETL.fillCountry");
            var deps = service.GetDependencies(meta, GetLocalConnection(), token);

            var res = TsqltManager.MockAllDependencies(token, options, GetLocalConnection(), deps);

            Console.WriteLine(res.ToString());
        }
Example #3
0
        public void ShouldMockHierarchialIDValues()
        {
            // Due to bug
            var token   = new CancellationTokenSource().Token;
            var service = new ObjectDependencyService();
            var options = new PeterHenell.SSMS.Plugins.Utils.TsqltManager.MockOptionsDictionary();

            options.EachColumnInSelectOnNewRow = false;
            options.EachColumnInValuesOnNewRow = false;


            var meta = ObjectMetadata.FromQualifiedString("REPORT.70_getShortRiskDetailed_IRT");
            var deps = service.GetDependencies(meta, GetLocalConnection(), token);

            var res = TsqltManager.MockAllDependencies(token, options, GetLocalConnection(), deps);

            Console.WriteLine(res.ToString());
        }
Example #4
0
        public override void ExecuteCommand(System.Threading.CancellationToken token)
        {
            var selectedText = ShellManager.GetSelectedText();

            var options = new PeterHenell.SSMS.Plugins.Utils.TsqltManager.MockOptionsDictionary();

            options.EachColumnInSelectOnNewRow = false;
            options.EachColumnInValuesOnNewRow = false;
            var connectionString = ConnectionManager.GetConnectionStringForCurrentWindow();

            var meta = ObjectMetadata.FromQualifiedString(selectedText);

            var service      = new ObjectDependencyService();
            var dependencies = service.GetDependencies(meta, connectionString, token);

            var superMockingString = TsqltManager.MockAllDependencies(token, options, connectionString, dependencies);

            ShellManager.AppendToEndOfSelection(superMockingString);
        }