Join the 1-day Testing & QA Summit featuring 15+ Expert Speakers.Register for FREE! Join TestMu Conference

Automation Advisor
NBi
NBi.Testing
ConnectionStringReader

How to use ConnectionStringReader class of NBi.Testing package

Best NBi code snippet using NBi.Testing.ConnectionStringReader

ElasticsearchExecutionEngineTest.cs

Source:ElasticsearchExecutionEngineTest.cs

...38        #endregion39        [Test]40        public void Execute_Documents_DataSetFilled()41        {42            ElasticsearchClient client = new ElasticsearchClientFactory().Instantiate(ConnectionStringReader.GetElasticsearch()) as ElasticsearchClient;43            var statement = Mock.Of<IQuery>(44                x => x.Statement == 45                @"GET bank/_search" +46                @"{" +47                @"   ""query"": {""match_all"": { }}"+48                @"   , ""size"": 5" +49                @"   , ""_source"": [""gender"", ""age"", ""balance""]" +50                @"   , ""sort"" : [ { ""balance"" : {""order"" : ""desc""}}]" +51                @"}");52            ElasticsearchCommandOperation ElasticsearchQuery = new ElasticsearchCommandFactory().Instantiate(client, statement).Implementation as ElasticsearchCommandOperation;53            var engine = new ElasticsearchExecutionEngine((ElasticsearchClientOperation)(client.CreateNew()), ElasticsearchQuery);54            var ds = engine.Execute();55            Assert.That(ds.Tables, Has.Count.EqualTo(1));56            Assert.That(ds.Tables[0].Rows, Has.Count.EqualTo(5));57            Assert.That(ds.Tables[0].Columns, Has.Count.EqualTo(3));58            Assert.That(ds.Tables[0].Columns.Cast<DataColumn>().Select(x => x.ColumnName), Has.Member("gender"));59            Assert.That(ds.Tables[0].Columns.Cast<DataColumn>().Select(x => x.ColumnName), Has.Member("age"));60            Assert.That(ds.Tables[0].Columns.Cast<DataColumn>().Select(x => x.ColumnName), Has.Member("balance"));61            var genders = new List<object>();62            var ages = new List<object>();63            foreach (DataRow row in ds.Tables[0].Rows)64                for (int i = 0; i < ds.Tables[0].Columns.Count; i++)65                {66                    if (row.Table.Columns[i].ColumnName == "gender")67                        genders.Add(row.ItemArray[i]);68                    else if (row.Table.Columns[i].ColumnName == "age")69                        ages.Add(row.ItemArray[i]);70                }71            foreach (var expectedFirstName in new[] { "F", "M" })72                Assert.That(genders, Has.Member(expectedFirstName));73            foreach (var expectedAge in new object[] { 36, 25, 35, 40, 23 })74                Assert.That(ages, Has.Member(expectedAge));75            foreach (DataRow row in ds.Tables[0].Rows)76                Assert.That(row["balance"], Is.Not.Null.Or.Empty);77        }78        79        [Test]80        public void Execute_Aggregations_DataSetFilled()81        {82            ElasticsearchClient client = new ElasticsearchClientFactory().Instantiate(ConnectionStringReader.GetElasticsearch()) as ElasticsearchClient;83            var statement = Mock.Of<IQuery>(84                x => x.Statement ==85                @"GET /bank/_search" +86                @"{" +87                @"  ""size"": 5,"+88                @"  ""aggs"": {"+89                @"      ""group_by_state"": {"+90                @"          ""terms"": {"+91                @"            ""field"": ""state.keyword""," +92                @"            ""size"": 3," +93                @"            ""order"": {" +94                @"              ""average_balance"": ""desc""" +95                @"            }"+96                @"          },"+97                @"          ""aggs"": {"+98                @"              ""average_balance"": {"+99                @"                  ""avg"": {"+100                @"                      ""field"": ""balance"""+101                @"                  }" +102                @"              }" +103                @"          }" +104                @"      }" +105                @"  }" +106                @"}");107            ElasticsearchCommandOperation ElasticsearchQuery = new ElasticsearchCommandFactory().Instantiate(client, statement).Implementation as ElasticsearchCommandOperation;108            var engine = new ElasticsearchExecutionEngine((ElasticsearchClientOperation)(client.CreateNew()), ElasticsearchQuery);109            var ds = engine.Execute();110            Assert.That(ds.Tables, Has.Count.EqualTo(1));111            Assert.That(ds.Tables[0].Rows, Has.Count.EqualTo(3));112            Assert.That(ds.Tables[0].Columns, Has.Count.GreaterThanOrEqualTo(2));113            Assert.That(ds.Tables[0].Columns.Cast<DataColumn>().Select(x => x.ColumnName), Has.Member("key"));114            Assert.That(ds.Tables[0].Columns.Cast<DataColumn>().Select(x => x.ColumnName), Has.Member("average_balance"));115            var states = new List<object>();116            foreach (DataRow row in ds.Tables[0].Rows)117                for (int i = 0; i < ds.Tables[0].Columns.Count; i++)118                {119                    if (row.Table.Columns[i].ColumnName == "key")120                        states.Add(row.ItemArray[i]);121                }122            foreach (var expectedState in new[] { "WA", "AL", "RI" })123                Assert.That(states, Has.Member(expectedState));124            foreach (DataRow row in ds.Tables[0].Rows)125                Assert.That(row["average_balance"], Is.Positive);126        }127        //[Test]128        //public void Execute_Integer_ScalarReturned()129        //{130        //    ElasticsearchClient client = new ElasticsearchClientFactory().Instantiate(ConnectionStringReader.GetElasticsearch()) as ElasticsearchClient;131        //    var statement = Mock.Of<IQuery>(x => x.Statement == "g.V().count()");132        //    ElasticsearchCommandOperation ElasticsearchQuery = new ElasticsearchCommandFactory().Instantiate(client, statement).Implementation as ElasticsearchCommandOperation;133        //    var engine = new ElasticsearchExecutionEngine((ElasticsearchClientOperation)(client.CreateNew()), ElasticsearchQuery);134        //    var count = engine.ExecuteScalar();135        //    Assert.That(count, Is.EqualTo(4));136        //}137        //[Test]138        //public void Execute_String_ScalarReturned()139        //{140        //    ElasticsearchClient client = new ElasticsearchClientFactory().Instantiate(ConnectionStringReader.GetElasticsearch()) as ElasticsearchClient;141        //    var statement = Mock.Of<IQuery>(x => x.Statement == "g.V().has('firstName','Mary').values('lastName')");142        //    ElasticsearchCommandOperation ElasticsearchQuery = new ElasticsearchCommandFactory().Instantiate(client, statement).Implementation as ElasticsearchCommandOperation;143        //    var engine = new ElasticsearchExecutionEngine((ElasticsearchClientOperation)(client.CreateNew()), ElasticsearchQuery);144        //    var count = engine.ExecuteScalar();145        //    Assert.That(count, Is.EqualTo("Andersen"));146        //}147        //[Test]148        //public void Execute_NullString_ScalarReturned()149        //{150        //    ElasticsearchClient client = new ElasticsearchClientFactory().Instantiate(ConnectionStringReader.GetElasticsearch()) as ElasticsearchClient;151        //    var statement = Mock.Of<IQuery>(x => x.Statement == "g.V().has('firstName','Thomas').values('lastName')");152        //    ElasticsearchCommandOperation commandOperation = new ElasticsearchCommandFactory().Instantiate(client, statement).Implementation as ElasticsearchCommandOperation;153        //    var engine = new ElasticsearchExecutionEngine((ElasticsearchClientOperation)(client.CreateNew()), commandOperation);154        //    var count = engine.ExecuteScalar();155        //    Assert.That(count, Is.Null);156        //}157        //[Test]158        //public void Execute_ListOfString_ListReturned()159        //{160        //    ElasticsearchClient client = new ElasticsearchClientFactory().Instantiate(ConnectionStringReader.GetElasticsearch()) as ElasticsearchClient;161        //    var statement = Mock.Of<IQuery>(x => x.Statement == "g.V().values('lastName')");162        //    ElasticsearchCommandOperation ElasticsearchQuery = new ElasticsearchCommandFactory().Instantiate(client, statement).Implementation as ElasticsearchCommandOperation;163        //    var engine = new ElasticsearchExecutionEngine((ElasticsearchClientOperation)(client.CreateNew()), ElasticsearchQuery);164        //    var count = engine.ExecuteList<string>();165        //    Assert.That(count, Has.Member("Andersen"));166        //    Assert.That(count, Has.Member("Miller"));167        //    Assert.That(count, Has.Member("Wakefield"));168        //}169    }170}...

BulkLoadCommandTest.cs

Source:BulkLoadCommandTest.cs

...63        [Test]64		public void Execute_LoadTemporaryTableBasedOnCSV_TableHasMoreData()65		{66            //Create table67            CreateTemporaryTable("Temporary", ConnectionStringReader.GetLocalSqlClient());6869            //Check how many elements are available in the table70            var before = CountElementsInTable("Temporary", ConnectionStringReader.GetLocalSqlClient());7172             //Mock the commandXml73            var info = Mock.Of<ILoadCommand>(74                command => command.ConnectionString== ConnectionStringReader.GetLocalSqlClient()75			        && command.TableName=="Temporary"76                    && command.FileName == FileName77                );7879            //Apply the test80			var cmd = new BulkLoadCommand(info);81            cmd.Execute();8283            //Execute Query on temporary table to knwo the new count of elements84            var after = CountElementsInTable("Temporary", ConnectionStringReader.GetLocalSqlClient());8586            Assert.That(after, Is.GreaterThan(before));87		}8889	}90}
...

BatchRunnerSmoTest.cs

Source:BatchRunnerSmoTest.cs

...30        [SetUp]31        public void EnsureLocalSqlServerRunning()32        {33            var startTag = @"(local)\";34            var start = ConnectionStringReader.GetLocalSqlClient().IndexOf(startTag) + startTag.Length;35            var end = ConnectionStringReader.GetLocalSqlClient().IndexOf(';', start);36            var serviceName = "MSSQL$" + ConnectionStringReader.GetLocalSqlClient().Substring(start, end - start);37            using (var service = new ServiceController(serviceName))38            {39                if (service.Status != ServiceControllerStatus.Running)40                    Assert.Ignore("Local SQL Server not started.");41            }42        }43        [Test]44        public void Execute_Batch_TablesAreCreated()45        {46            //Create table47            CleanTemporaryTable("TablexxxOne", ConnectionStringReader.GetLocalSqlClient());48            CleanTemporaryTable("TablexxxTwo", ConnectionStringReader.GetLocalSqlClient());49            //Build the fullpath for the file to read50            var fileName = FileOnDisk.CreatePhysicalFile(BATCH_FILE, $"{GetType().Namespace}.Resources.{BATCH_FILE}");51            //Apply the test52            var runner = new BatchRunnerSmo(fileName, ConnectionStringReader.GetLocalSqlClient());53            runner.Execute();54            var countTable = 0;55            using (var conn = new SqlConnection(ConnectionStringReader.GetLocalSqlClient()))56            {57                using (var cmd = new SqlCommand())58                {59                    cmd.Connection = conn;60                    conn.Open();61                    cmd.CommandText = "select count(*) from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = 'dbo' and TABLE_NAME like 'Tablexxx%'";62                    countTable = (int)cmd.ExecuteScalar();63                }64            }65            Assert.That(countTable, Is.EqualTo(2));66        }67    }68}...

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.