How to use ExecutionEngineFactory method of NBi.Core.Query.Execution.ExecutionEngineFactory class

Best NBi code snippet using NBi.Core.Query.Execution.ExecutionEngineFactory.ExecutionEngineFactory

QuerySequenceResolverTest.cs

Source:QuerySequenceResolverTest.cs

...27                    , new TimeSpan(0, 0, 30)28            );29            var args = new QuerySequenceResolverArgs(queryArgs);30            var executionEngine = Mock.Of<IExecutionEngine>(x => x.ExecuteList<string>() == new List<string>() { "foo", "bar" });31            var executionEngineFactory = Mock.Of<ExecutionEngineFactory>(x => x.Instantiate(It.IsAny<IQuery>()) == executionEngine);32            var queryResolverFactory = new ServiceLocator().GetQueryResolverFactory();33            var serviceLocator = Mock.Of<ServiceLocator>(34                x => x.GetExecutionEngineFactory() == executionEngineFactory35                && x.GetQueryResolverFactory() == queryResolverFactory36            );37            var resolver = new QuerySequenceResolver<string>(args, serviceLocator);38            var elements = resolver.Execute();39            Assert.That(elements.Count(), Is.EqualTo(2));40            Assert.That(elements, Has.Member("foo"));41            Assert.That(elements, Has.Member("bar"));42        }43        [Test]44        public void Execute_QueryEmbedded_CorrectCallsToServiceLocatorMethods()45        {46            var queryArgs = new EmbeddedQueryResolverArgs(47                    "select * from table"48                    , "server=.;initiatl catalog=db;integrated security=true"49                    , null50                    , null51                    , new TimeSpan(0, 0, 30)52            );53            var args = new QuerySequenceResolverArgs(queryArgs);54            var executionEngine = Mock.Of<IExecutionEngine>(x => x.ExecuteList<string>() == new List<string>() { "foo", "bar" });55            var executionEngineFactory = Mock.Of<ExecutionEngineFactory>(x => x.Instantiate(It.IsAny<IQuery>()) == executionEngine);56            var queryResolverFactory = new ServiceLocator().GetQueryResolverFactory();57            var serviceLocator = Mock.Of<ServiceLocator>(58                x => x.GetExecutionEngineFactory() == executionEngineFactory59                && x.GetQueryResolverFactory() == queryResolverFactory60            );61            var resolver = new QuerySequenceResolver<string>(args, serviceLocator);62            var elements = resolver.Execute();63            Mock.Get(executionEngine).Verify(x => x.ExecuteList<string>(), Times.Once);64            Mock.Get(executionEngineFactory).Verify(x => x.Instantiate(It.IsAny<IQuery>()), Times.Once);65        }66    }67}...

ExecutionEngineFactoryTest.cs

Source:ExecutionEngineFactoryTest.cs

...14using System.Threading.Tasks;15using NBi.Extensibility.Query;16namespace NBi.Testing.Core.Elasticsearch.Unit.Query.Execution17{18    public class ExecutionEngineFactoryTest19    {20        private string base64AuthKey = Convert.ToBase64String(Encoding.UTF8.GetBytes("@uthK3y"));21        private class ElasticsearchConfig : IExtensionsConfiguration22        {23            public IReadOnlyCollection<Type> Extensions => new List<Type>()24            {25                typeof(ElasticsearchClientFactory),26                typeof(ElasticsearchCommandFactory),27                typeof(ElasticsearchExecutionEngine),28            };29        }30        [Test]31        public void Instantiate_ElasticsearchConnectionString_ElasticsearchExecutionEngine()32        {33            var config = new ElasticsearchConfig();34            var clientProvider = new ClientProvider(config);35            var commandProvider = new CommandProvider(config);36            var factory = new ExecutionEngineFactory(clientProvider, commandProvider, config);37            var query = Mock.Of<IQuery>38                (39                    x => x.ConnectionString == $@"Hostname=localhost;port=9200;Username=admin;password=p@ssw0rd;api=Elasticsearch"40                    && x.Statement == @"GET index/type/_search { ""query"": {""match_all"": { }} }"41            42                );43            var engine = factory.Instantiate(query);44            Assert.That(engine, Is.Not.Null);45            Assert.That(engine, Is.TypeOf<ElasticsearchExecutionEngine>());46        }47    }48}...

ExecutionEngineFactory.cs

Source:ExecutionEngineFactory.cs

...9{10    /// <summary>11    /// Class to retrieve an adequate query engine on base of the connectionString12    /// </summary>13    public class ExecutionEngineFactory: EngineFactory<IExecutionEngine>14    {15        private Type[] classics = new[] 16        {17            typeof(AdomdExecutionEngine),18            typeof(OdbcExecutionEngine),19            typeof(OleDbExecutionEngine),20            typeof(SqlExecutionEngine)21        };22        public ExecutionEngineFactory() 23            : base()24        {25            RegisterEngines(classics);26        }27        public ExecutionEngineFactory(ClientProvider clientProvider, CommandProvider commandProvider)28            : base(clientProvider, commandProvider)29        {30            RegisterEngines(classics);31        }32        public ExecutionEngineFactory(ClientProvider clientProvider, CommandProvider commandProvider, IExtensionsConfiguration config)33            : base(clientProvider, commandProvider)34        {35            var extensions = config?.Extensions?.Where(x => typeof(IExecutionEngine).IsAssignableFrom(x.Key))?.Select(x => x.Key) ?? new Type[0];36            RegisterEngines(classics.Union(extensions).ToArray());37        }38        internal int ExtensionCount { get => engines.Count() - classics.Count(); }39    }40}

ExecutionEngineFactory

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core.Query.Execution;7using NBi.Core.Query;8using NBi.Core.Query.Resolver;9using NBi.Core.Query.Resolver.Csv;10{11    {12        static void Main(string[] args)13        {14            var connectionString = @"C:\Users\Public\Documents\NBi\Sample\Sample.csv";15            var query = "select * from Sample.csv";16            var resolver = new CsvQueryResolver(connectionString);17            var engine = ExecutionEngineFactory.Get(resolver, query);18            var result = engine.Execute();19            foreach (var row in result.Rows)20            {21                foreach (var cell in row)22                {23                    Console.WriteLine(cell);24                }25            }26            Console.ReadLine();27        }28    }29}30using System;31using System.Collections.Generic;32using System.Linq;33using System.Text;34using System.Threading.Tasks;35using NBi.Core.Query.Execution;36using NBi.Core.Query;37using NBi.Core.Query.Resolver;38using NBi.Core.Query.Resolver.Csv;39{40    {41        static void Main(string[] args)42        {43            var connectionString = @"C:\Users\Public\Documents\NBi\Sample\Sample.csv";44            var query = "select * from Sample.csv";45            var resolver = new CsvQueryResolver(connectionString);46            var engine = ExecutionEngineFactory.Get(resolver, query);47            var result = engine.Execute();48            foreach (var row in result.Rows)49            {50                foreach (var cell in row)51                {52                    Console.WriteLine(cell);53                }54            }55            Console.ReadLine();56        }57    }58}59using System;60using System.Collections.Generic;61using System.Linq;62using System.Text;63using System.Threading.Tasks;64using NBi.Core.Query.Execution;65using NBi.Core.Query;66using NBi.Core.Query.Resolver;67using NBi.Core.Query.Resolver.Csv;68{69    {70        static void Main(string[] args)71        {72            var connectionString = @"C:\Users\Public\Documents\NBi\Sample\Sample.csv";

ExecutionEngineFactory

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core.Query.Execution;7using NBi.Core.Query;8using NBi.Core.Query.Client;9using NBi.Core.Query.Resolver;10using NBi.Core.Query.Resolver.Csv;11using NBi.Core.Query.Resolver.Command;12using NBi.Core.Query.Resolver.File;13using NBi.Core.Query.Resolver.Variables;14using NBi.Core.Query.Resolver.Variables.Csv;15using NBi.Core.Query.Resolver.Variables.File;16using NBi.Core.Query.Resolver.Variables.Xml;17using NBi.Core.Query.Resolver.Xml;18using NBi.Core.Query.Resolver.Factory;19using NBi.Core.Query.Resolver.Factory.Csv;20using NBi.Core.Query.Resolver.Factory.File;21using NBi.Core.Query.Resolver.Factory.Xml;22using NBi.Core.Query.Resolver.Verb;23using NBi.Core.Query.Resolver.Verb.Csv;24using NBi.Core.Query.Resolver.Verb.File;25using NBi.Core.Query.Resolver.Verb.Xml;26using NBi.Core.Query.Resolver.Adapter;27using NBi.Core.Query.Resolver.Adapter.Csv;28using NBi.Core.Query.Resolver.Adapter.File;29using NBi.Core.Query.Resolver.Adapter.Xml;30using NBi.Core.Query.Resolver.CommandBuilder;31using NBi.Core.Query.Resolver.CommandBuilder.Csv;32using NBi.Core.Query.Resolver.CommandBuilder.File;33using NBi.Core.Query.Resolver.CommandBuilder.Xml;34using System.Data;35using System.Data.OleDb;36using NBi.Core.Query.Execution;37{38    {39        static void Main(string[] args)40        {41            var csv = new CsvQueryResolverArgs("D:\\Test\\Test.csv", "SELECT * FROM [Test$]", null, null, null, null, null, null, null, null);42            var csvFactory = new CsvQueryResolverFactory();43            var csvResolver = csvFactory.Instantiate(csv);44            var csvAdapter = csvResolver.Instantiate();

ExecutionEngineFactory

Using AI Code Generation

1using NBi.Core.Query.Execution;2using NBi.Core.Query;3using NBi.Core.Query.Resolver;4using NBi.Core.Query.Command;5using NBi.Core.Query.Client;6using NBi.Core.Query.Client.SqlClient;7using NBi.Core.Query.Client.Odbc;8using NBi.Core.Query.Client.OleDb;9using System.Data.Odbc;10using System.Data.OleDb;11using System.Data.SqlClient;12using System.Data;13using System;14using System.Collections.Generic;15using System.Linq;16using System.Text;17using System.Threading.Tasks;18{19    {20        static void Main(string[] args)21        {22            var connectionString = "Server=.;Database=AdventureWorks2014;Trusted_Connection=True;";23            var query = "SELECT TOP 10 * FROM Person.Person";24            var client = ClientType.SqlClient;25            var engine = ExecutionEngineFactory.Instantiate(client, connectionString);26            var result = engine.Execute(query);27        }28    }29}30using NBi.Core.Query.Execution;31using NBi.Core.Query;32using NBi.Core.Query.Resolver;33using NBi.Core.Query.Command;34using NBi.Core.Query.Client;35using NBi.Core.Query.Client.SqlClient;36using NBi.Core.Query.Client.Odbc;37using NBi.Core.Query.Client.OleDb;38using System.Data.Odbc;39using System.Data.OleDb;40using System.Data.SqlClient;41using System.Data;42using System;43using System.Collections.Generic;44using System.Linq;45using System.Text;46using System.Threading.Tasks;47{48    {49        static void Main(string[] args)50        {51            var connectionString = "Server=.;Database=AdventureWorks2014;Trusted_Connection=True;";52            var query = "SELECT TOP 10 * FROM Person.Person";53            var engine = ExecutionEngineFactory.Instantiate(connectionString);54            var result = engine.Execute(query);55        }56    }57}

ExecutionEngineFactory

Using AI Code Generation

1using NBi.Core.Query;2using NBi.Core.Query.Execution;3using NBi.Core.Query.Resolver;4using System;5using System.Collections.Generic;6using System.Linq;7using System.Text;8using System.Threading.Tasks;9{10    {11        public static void Main(string[] args)12        {13            var connectionStringSettings = new System.Configuration.ConnectionStringSettings("Default", "Data Source=(local);Initial Catalog=AdventureWorks2012;Integrated Security=SSPI;", "System.Data.SqlClient");14            var connectionStringResolver = new ConnectionStringResolver(connectionStringSettings);15            var connectionString = connectionStringResolver.Execute();16            var executionEngineFactory = new ExecutionEngineFactory();17            var executionEngine = executionEngineFactory.Instantiate(connectionString);18            executionEngine.Execute("select * from Production.Product");19        }20    }21}

ExecutionEngineFactory

Using AI Code Generation

1using NBi.Core.Query.Execution;2using NBi.Core.Query;3using NBi.Core.Query.Resolver;4using NBi.Core.Query.Client;5using NBi.Core.Query.Command;6using System.Data;7using System;8{9    {10        static void Main(string[] args)11        {12            var connectionString = new ConnectionString("data source=.;initial catalog=AdventureWorks2017;integrated security=True");13            var query = new Query("select * from [Person].[Person]", CommandType.Text);14            var queryResolver = new QueryResolver(query);15            var queryCommand = new QueryCommand(queryResolver);16            var queryClient = new AdomdClient();17            var executionEngine = ExecutionEngineFactory.Get(queryClient, connectionString, queryCommand);18            var result = executionEngine.Execute();19            Console.WriteLine(result);20            Console.ReadLine();21        }22    }23}

ExecutionEngineFactory

Using AI Code Generation

1using NBi.Core.Query.Execution;2var factory = new ExecutionEngineFactory();3var engine = factory.Instantiate("SqlServer");4var query = new NBi.Core.Query.ClientQuery("select * from table");5var result = engine.Execute(query);6foreach (var row in result)7{8    Console.WriteLine(row[0]);9}10using NBi.Core.Query.Execution;11var factory = new ExecutionEngineFactory();12var engine = factory.Instantiate("OleDb");13var query = new NBi.Core.Query.ClientQuery("select * from table");14var result = engine.Execute(query);15foreach (var row in result)16{17    Console.WriteLine(row[0]);18}19using NBi.Core.Query.Execution;20var factory = new ExecutionEngineFactory();21var engine = factory.Instantiate("Odbc");22var query = new NBi.Core.Query.ClientQuery("select * from table");23var result = engine.Execute(query);24foreach (var row in result)25{26    Console.WriteLine(row[0]);27}28using NBi.Core.Query.Execution;29var factory = new ExecutionEngineFactory();30var engine = factory.Instantiate("MySql");31var query = new NBi.Core.Query.ClientQuery("select * from table");32var result = engine.Execute(query);33foreach (var row in result)34{35    Console.WriteLine(row[0]);36}37using NBi.Core.Query.Execution;38var factory = new ExecutionEngineFactory();39var engine = factory.Instantiate("Postgres");40var query = new NBi.Core.Query.ClientQuery("select * from table");41var result = engine.Execute(query);42foreach (var row in result)43{44    Console.WriteLine(row[0]);45}46using NBi.Core.Query.Execution;47var factory = new ExecutionEngineFactory();48var engine = factory.Instantiate("SQLite");49var query = new NBi.Core.Query.ClientQuery("select * from table");

ExecutionEngineFactory

Using AI Code Generation

1var factory = new ExecutionEngineFactory();2var engine = factory.Instantiate(new EngineCommand() { ConnectionString = "Data Source=.;Initial Catalog=AdventureWorks2014;Integrated Security=True" });3engine.Execute(new QueryCommand("SELECT * FROM Person.Contact"));4var factory = new ExecutionEngineFactory();5var engine = factory.Instantiate(new EngineCommand() { ConnectionString = "Data Source=.;Initial Catalog=AdventureWorks2014;Integrated Security=True" });6engine.Execute(new QueryCommand("SELECT * FROM Person.Contact"));7var factory = new ExecutionEngineFactory();8var engine = factory.Instantiate(new EngineCommand() { ConnectionString = "Data Source=.;Initial Catalog=AdventureWorks2014;Integrated Security=True" });9engine.Execute(new QueryCommand("SELECT * FROM Person.Contact"));10var factory = new ExecutionEngineFactory();11var engine = factory.Instantiate(new EngineCommand() { ConnectionString = "Data Source=.;Initial Catalog=AdventureWorks2014;Integrated Security=True" });12engine.Execute(new QueryCommand("SELECT * FROM Person.Contact"));13var factory = new ExecutionEngineFactory();14var engine = factory.Instantiate(new EngineCommand() { ConnectionString = "Data Source=.;Initial Catalog=AdventureWorks2014;Integrated Security=True" });15engine.Execute(new QueryCommand("SELECT * FROM Person.Contact"));16var factory = new ExecutionEngineFactory();17var engine = factory.Instantiate(new EngineCommand() { ConnectionString = "Data Source=.;Initial Catalog=AdventureWorks2014;Integrated Security=True" });18engine.Execute(new QueryCommand("SELECT * FROM Person.Contact"));19var factory = new ExecutionEngineFactory();20var engine = factory.Instantiate(new EngineCommand() { ConnectionString = "Data Source=.;Initial Catalog=

ExecutionEngineFactory

Using AI Code Generation

1var engine = new NBi.Core.Query.Execution.ExecutionEngineFactory().Instantiate("NBi.NUnit.Query.SqlServer");2var connStr = new NBi.Core.ConnectionString.Decoration.ConnectionStringSettings();3connStr.ConnectionString = "Data Source=.;Initial Catalog=AdventureWorks2012;Integrated Security=True";4engine.Setup(connStr);5engine.Execute("select 1");6var engine = new NBi.Core.Query.Execution.ExecutionEngineFactory().Instantiate("NBi.NUnit.Query.SqlServer");7var connStr = new NBi.Core.ConnectionString.Decoration.ConnectionStringSettings();8connStr.ConnectionString = "Data Source=.;Initial Catalog=AdventureWorks2012;Integrated Security=True";9engine.Setup(connStr);10engine.Execute("select 1");11var engine = new NBi.Core.Query.Execution.ExecutionEngineFactory().Instantiate("NBi.NUnit.Query.SqlServer");12var connStr = new NBi.Core.ConnectionString.Decoration.ConnectionStringSettings();13connStr.ConnectionString = "Data Source=.;Initial Catalog=AdventureWorks2012;Integrated Security=True";14engine.Setup(connStr);15engine.Execute("select 1");16var engine = new NBi.Core.Query.Execution.ExecutionEngineFactory().Instantiate("NBi.NUnit.Query.SqlServer");17var connStr = new NBi.Core.ConnectionString.Decoration.ConnectionStringSettings();18connStr.ConnectionString = "Data Source=.;Initial Catalog=AdventureWorks2012;Integrated Security=True";19engine.Setup(connStr);20engine.Execute("select 1");21var engine = new NBi.Core.Query.Execution.ExecutionEngineFactory().Instantiate("NBi.NUnit.Query.SqlServer");22var connStr = new NBi.Core.ConnectionString.Decoration.ConnectionStringSettings();23connStr.ConnectionString = "Data Source=.;Initial Catalog=AdventureWorks2012;Integrated Security=True";24engine.Setup(connStr);25engine.Execute("select 1");26var engine = new NBi.Core.Query.Execution.ExecutionEngineFactory().Instantiate("NBi.N

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.