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

How to use Configuration class of DBTestCompareGenerator package

Best DBTestCompareGenerator code snippet using DBTestCompareGenerator.Configuration

Configuration.cs

Source:Configuration.cs

1ï»¿// <copyright file="Configuration.cs" company="Objectivity Bespoke Software Specialists">2// Copyright (c) Objectivity Bespoke Software Specialists. All rights reserved.3// </copyright>4namespace DBTestCompareGenerator5{6    using System;7    using System.Collections.Generic;8    using System.Globalization;9    using Microsoft.Extensions.Configuration;10    /// <summary>11    /// Configuration that consume settings file file.12    /// </summary>13    public static class Configuration14    {15        /// <summary>16        /// Getting appsettings.json file.17        /// </summary>18        public static readonly IConfigurationRoot Builder = new ConfigurationBuilder()19            .AddJsonFile("appsettings.json", true, true)20            .Build();21        /// <summary>22        /// NLog logger handle.23        /// </summary>24        private static readonly NLog.Logger Logger = NLog.Web.NLogBuilder.ConfigureNLog("nlog.config").GetCurrentClassLogger();25        /// <summary>26        /// Gets Connection String.27        /// </summary>28        public static string ConnectionString29        {30            get { return Configuration.Builder["appSettings:ConnectionStrings:DB"]; }31        }32        public static List<string> ColumnTypesToGroupBy33        {34            get35            {36                var columns = Configuration.Builder["appSettings:ColumnTypesToGroupBy"];37                List<string> columnTypes = new List<string>();38                foreach (var column in columns.Split(","))39                {40                    columnTypes.Add(column);41                }42                return columnTypes;43            }44        }45        public static string DBNameLiveMinusTests46        {47            get { return Configuration.Builder["appSettings:DBNameLiveMinusTests"]; }48        }49        public static string DBNameBranchMinusTests50        {51            get { return Configuration.Builder["appSettings:DBNameBranchMinusTests"]; }52        }53        public static bool ReadExcelFile54        {55            get56            {57                var setting = Configuration.Builder["appSettings:ReadExcelFile"];58                Logger.Trace(CultureInfo.CurrentCulture, "Read Excel File '{0}'", setting);59                if (string.IsNullOrEmpty(setting))60                {61                    return false;62                }63                if (setting.ToLower(CultureInfo.CurrentCulture).Equals("true"))64                {65                    return true;66                }67                return false;68            }69        }70        public static bool GenerateCountSmokeTests71        {72            get73            {74                var setting = Configuration.Builder["appSettings:GenerateCountSmokeTests"];75                Logger.Trace(CultureInfo.CurrentCulture, "Generate count smoke tests '{0}'", setting);76                if (string.IsNullOrEmpty(setting))77                {78                    return false;79                }80                if (setting.ToLower(CultureInfo.CurrentCulture).Equals("true"))81                {82                    return true;83                }84                return false;85            }86        }87        public static bool GenerateCompareFetchTests88        {89            get90            {91                var setting = Configuration.Builder["appSettings:GenerateCompareFetchTests"];92                Logger.Trace(CultureInfo.CurrentCulture, "Generate compare fetch tests '{0}'", setting);93                if (string.IsNullOrEmpty(setting))94                {95                    return false;96                }97                if (setting.ToLower(CultureInfo.CurrentCulture).Equals("true"))98                {99                    return true;100                }101                return false;102            }103        }104        public static bool GenerateCompareMinusTests105        {106            get107            {108                var setting = Configuration.Builder["appSettings:GenerateCompareMinusTests"];109                Logger.Trace(CultureInfo.CurrentCulture, "Generate compare minusT tests '{0}'", setting);110                if (string.IsNullOrEmpty(setting))111                {112                    return false;113                }114                if (setting.ToLower(CultureInfo.CurrentCulture).Equals("true"))115                {116                    return true;117                }118                return false;119            }120        }121    }122}...

CountQuerySqlServer.cs

Source:CountQuerySqlServer.cs

...8    {9        private static readonly NLog.Logger Logger = NLog.Web.NLogBuilder.ConfigureNLog("nlog.config").GetCurrentClassLogger();10        public static void CreateCountQuery(List<Dictionary<string, string>> configList)11        {12            if (Configuration.GenerateCountSmokeTests)13            {14                var data = TablesDefinitions.GetTablesDefinitions();15                for (int i = 0; i < data.Rows.Count; i++)16                {17                    var tableSchemaIteration = CompareQuerySqlServer.TableSchemaIteration(data, i, out var tableNameIteration);18                    var (createTest, domain, comment, whereClause, orderByCluse, aggregateByClause) = ReadConfigurationFromXlsx.CheckIfTableInExcel(configList, tableSchemaIteration, tableNameIteration);19                    if (createTest)20                    {21                        Logger.Debug("Skip iteration");22                        continue;23                    }24                    if (i + 1 < data.Rows.Count && tableNameIteration == data.Rows[i + 1]["TABLE_NAME"].ToString() &&25                        tableSchemaIteration == data.Rows[i + 1]["TABLE_SCHEMA"].ToString())26                    {27                        Logger.Debug("Skip iteration");28                        continue;29                    }30                    var folder = CopyConfigFiles.CreateFolderForTest(tableSchemaIteration, tableNameIteration, "1.Count");31                    var countQuery = TablesDefinitions.CreateSmokeCountQuery(tableSchemaIteration, tableNameIteration);32                    CopyConfigFiles.CreateTestDefinitions(folder, countQuery, tableSchemaIteration, tableNameIteration, "Smoke_", "ActualTable.sql", "from_file_sql.xml");...

Program.cs

Source:Program.cs

...7    {8        private static void Main(string[] args)9        {10            CopyConfigFiles.CopyConfigFile();11            var configFromExcel = ReadConfigurationFromXlsx.ReadExcelFile();12            CountQuerySqlServer.CreateCountQuery(configFromExcel);13            CompareQuerySqlServer.CreateCompareQuery(configFromExcel);14        }15    }16}...

Configuration

Using AI Code Generation

1using DBTestCompareGenerator;2using System;3using System.Collections.Generic;4using System.Linq;5using System.Text;6using System.Threading.Tasks;7{8    {9        static void Main(string[] args)10        {11            Configuration config = new Configuration();12            config.GenerateDBTestCompare();13        }14    }15}16using DBTestCompareGenerator;17using System;18using System.Collections.Generic;19using System.Linq;20using System.Text;21using System.Threading.Tasks;22{23    {24        static void Main(string[] args)25        {26            Configuration config = new Configuration();27            config.GenerateDBTestCompare();28        }29    }30}31using DBTestCompareGenerator;32using System;33using System.Collections.Generic;34using System.Linq;35using System.Text;36using System.Threading.Tasks;37{38    {39        static void Main(string[] args)40        {41            Configuration config = new Configuration();42            config.GenerateDBTestCompare();43        }44    }45}46using DBTestCompareGenerator;47using System;48using System.Collections.Generic;49using System.Linq;50using System.Text;51using System.Threading.Tasks;52{53    {54        static void Main(string[] args)55        {56            Configuration config = new Configuration();57            config.GenerateDBTestCompare();58        }59    }60}61using DBTestCompareGenerator;62using System;63using System.Collections.Generic;64using System.Linq;65using System.Text;66using System.Threading.Tasks;67{68    {69        static void Main(string[] args)70        {71            Configuration config = new Configuration();

Configuration

Using AI Code Generation

1using DBTestCompareGenerator;2using System;3using System.Collections.Generic;4using System.Linq;5using System.Text;6using System.Threading.Tasks;7{8    {9        static void Main(string[] args)10        {11            Configuration config = new Configuration();12            config.DatabaseName = "DBTestCompareGenerator";13            config.ConnectionString = "Data Source=.;Initial Catalog=DBTestCompareGenerator;Integrated Security=True";14            config.SchemaName = "dbo";15            config.OutputPath = @"C:\Users\Shah\Documents\Visual Studio 2013\Projects\DBTestCompareGenerator\DBTestCompareGenerator";16            config.Namespace = "DBTestCompareGenerator";17            config.Generate();18            Console.WriteLine("Done");19            Console.ReadKey();20        }21    }22}23using DBTestCompareGenerator;24using System;25using System.Collections.Generic;26using System.Linq;27using System.Text;28using System.Threading.Tasks;29{30    {31        static void Main(string[] args)32        {33            Configuration config = new Configuration();34            config.DatabaseName = "DBTestCompareGenerator";35            config.ConnectionString = "Data Source=.;Initial Catalog=DBTestCompareGenerator;Integrated Security=True";36            config.SchemaName = "dbo";37            config.OutputPath = @"C:\Users\Shah\Documents\Visual Studio 2013\Projects\DBTestCompareGenerator\DBTestCompareGenerator";38            config.Namespace = "DBTestCompareGenerator";39            config.Generate();40            Console.WriteLine("Done");41            Console.ReadKey();42        }43    }44}45using DBTestCompareGenerator;46using System;47using System.Collections.Generic;48using System.Linq;49using System.Text;50using System.Threading.Tasks;51{52    {53        static void Main(string[] args)54        {55            Configuration config = new Configuration();56            config.DatabaseName = "DBTestCompareGenerator";

Configuration

Using AI Code Generation

1using DBTestCompareGenerator;2using System;3using System.Collections.Generic;4using System.Linq;5using System.Text;6using System.Threading.Tasks;7{8    {9        public string ConnectionString { get; set; }10        public string Database { get; set; }11        public string Schema { get; set; }12        public string Table { get; set; }13        public string Table1 { get; set; }14        public string Table2 { get; set; }15        public string PrimaryKey { get; set; }16        public string PrimaryKey1 { get; set; }17        public string PrimaryKey2 { get; set; }18        public string CompareResult { get; set; }19        public string CompareResult1 { get; set; }20        public string CompareResult2 { get; set; }21    }22}23using DBTestCompareGenerator;24using System;25using System.Collections.Generic;26using System.Linq;27using System.Text;28using System.Threading.Tasks;29{30    {31        public string ConnectionString { get; set; }32        public string Database { get; set; }33        public string Schema { get; set; }34        public string Table { get; set; }35        public string Table1 { get; set; }36        public string Table2 { get; set; }37        public string PrimaryKey { get; set; }38        public string PrimaryKey1 { get; set; }39        public string PrimaryKey2 { get; set; }40        public string CompareResult { get; set; }41        public string CompareResult1 { get; set; }42        public string CompareResult2 { get; set; }43    }44}45using DBTestCompareGenerator;46using System;47using System.Collections.Generic;48using System.Linq;49using System.Text;50using System.Threading.Tasks;51{52    {53        public string ConnectionString { get; set; }54        public string Database { get; set; }55        public string Schema { get; set; }56        public string Table { get; set; }57        public string Table1 { get; set; }58        public string Table2 { get; set; }

Configuration

Using AI Code Generation

1using DBTestCompareGenerator;2{3    static void Main(string[] args)4    {5        Configuration config = new Configuration();6        config.ConnectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=True";7        config.PackagePath = @"C:\Test\AdventureWorks.dtsx";8        config.PackageName = "AdventureWorks";9        config.DestinationPath = @"C:\Test\";10        config.DestinationFileName = "AdventureWorks.dtsx";11        config.DestinationFilePath = @"C:\Test\AdventureWorks.dtsx";12        config.GeneratePackage();13    }14}15using DBTestCompareGenerator;16{17    static void Main(string[] args)18    {19        Configuration config = new Configuration();20        config.ConnectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=True";21        config.PackagePath = @"C:\Test\AdventureWorks.dtsx";22        config.PackageName = "AdventureWorks";23        config.DestinationPath = @"C:\Test\";24        config.DestinationFileName = "AdventureWorks.dtsx";25        config.DestinationFilePath = @"C:\Test\AdventureWorks.dtsx";26        config.GeneratePackage();27    }28}29using DBTestCompareGenerator;30{31    static void Main(string[] args)32    {33        Configuration config = new Configuration();34        config.ConnectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=True";35        config.PackagePath = @"C:\Test\AdventureWorks.dtsx";36        config.PackageName = "AdventureWorks";37        config.DestinationPath = @"C:\Test\";38        config.DestinationFileName = "AdventureWorks.dtsx";39        config.DestinationFilePath = @"C:\Test\AdventureWorks.dtsx";40        config.GeneratePackage();41    }42}

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.