public void Matches_SqlQueryAndMembers_Succesful() { var sql = "select " + "'Executive General and Administration' union select " + "'Inventory Management' union select " + "'Manufacturing' union select " + "'Research and Development' union select " + "'Quality Assurance' union select " + "'Sales and Marketing' "; var args = new QueryResultSetResolverArgs(new QueryResolverArgs(sql, ConnectionStringReader.GetSqlClient(), null, null, new TimeSpan(0, 0, 30), System.Data.CommandType.Text)); var factory = new ResultSetResolverFactory(new ServiceLocator()); var resolver = factory.Instantiate(args); var discovery = new DiscoveryRequestFactory().Build( ConnectionStringReader.GetAdomd() , "Corporate" , "Adventure Works" , "Department" , "Departments" , null); var ctr = new EquivalentToConstraint(resolver); Assert.That(discovery, ctr); }
protected ResultSet GetResultSet(IQuery query) { var argsQuery = new QueryResolverArgs(query.Statement, query.ConnectionString, query.Parameters, query.TemplateTokens, query.Timeout, query.CommandType); var args = new QueryResultSetResolverArgs(argsQuery); var factory = new ResultSetResolverFactory(null); var resolver = factory.Instantiate(args); return(resolver.Execute()); }
protected ResultSet GetResultSet(Object obj) { if (!(obj is IDbCommand)) { throw new ArgumentException(); } var args = new QueryResultSetResolverArgs(new DbCommandQueryResolverArgs((IDbCommand)obj)); var factory = new ResultSetResolverFactory(); var resolver = factory.Instantiate(args); return(resolver.Execute()); }
protected virtual IResultSetService InstantiateSystemUnderTest(ExecutionXml executionXml) { var commandFactory = new CommandProvider(); var argsBuilder = new QueryResolverArgsBuilder(ServiceLocator); var connectionString = executionXml.Item.GetConnectionString(); var statement = (executionXml.Item as QueryableXml).GetQuery(); IEnumerable <IQueryParameter> parameters = null; IEnumerable <IQueryTemplateVariable> templateVariables = null; int timeout = 0; var commandType = CommandType.Text; if (executionXml.BaseItem is QueryXml) { parameters = argsBuilder.BuildParameters(((QueryXml)executionXml.BaseItem).GetParameters()); templateVariables = ((QueryXml)executionXml.BaseItem).GetTemplateVariables(); timeout = ((QueryXml)executionXml.BaseItem).Timeout; } if (executionXml.BaseItem is ReportXml) { parameters = argsBuilder.BuildParameters(((ReportXml)executionXml.BaseItem).GetParameters()); } if (executionXml.BaseItem is ReportXml) { commandType = ((ReportXml)executionXml.BaseItem).GetCommandType(); } var queryArgs = new QueryResolverArgs(statement, connectionString, parameters, templateVariables, new TimeSpan(0, 0, timeout), commandType); var args = new QueryResultSetResolverArgs(queryArgs); var factory = ServiceLocator.GetResultSetResolverFactory(); var resolver = factory.Instantiate(args); var builder = new ResultSetServiceBuilder(); builder.Setup(resolver); var service = builder.GetService(); return(service); }
protected virtual IResultSetService InstantiateSystemUnderTest(ExecutionXml executionXml) { var commandBuilder = new CommandBuilder(); var connectionString = executionXml.Item.GetConnectionString(); var commandText = (executionXml.Item as QueryableXml).GetQuery(); IEnumerable <IQueryParameter> parameters = null; IEnumerable <IQueryTemplateVariable> variables = null; int timeout = 0; if (executionXml.BaseItem is QueryXml) { var paramBuilder = new QueryResolverArgsBuilder(); parameters = paramBuilder.BuildParameters(((QueryXml)executionXml.BaseItem).GetParameters()); variables = ((QueryXml)executionXml.BaseItem).GetVariables(); timeout = ((QueryXml)executionXml.BaseItem).Timeout; } if (executionXml.BaseItem is ReportXml) { var paramBuilder = new QueryResolverArgsBuilder(); parameters = paramBuilder.BuildParameters(((ReportXml)executionXml.BaseItem).GetParameters()); } var cmd = commandBuilder.Build(connectionString, commandText, parameters, variables, timeout); if (executionXml.BaseItem is ReportXml) { cmd.CommandType = ((ReportXml)executionXml.BaseItem).GetCommandType(); } var args = new QueryResultSetResolverArgs(new DbCommandQueryResolverArgs(cmd)); var factory = new ResultSetResolverFactory(); var resolver = factory.Instantiate(args); var builder = new ResultSetServiceBuilder(); builder.Setup(resolver); var service = builder.GetService(); return(service); }
protected IEnumerable <string> GetMembersFromResultSet(Object obj) { if (!(obj is IDbCommand)) { throw new ArgumentException(); } var args = new QueryResultSetResolverArgs(new DbCommandQueryResolverArgs((IDbCommand)obj)); var factory = new ResultSetResolverFactory(); var resolver = factory.Instantiate(args); var rs = resolver.Execute(); var members = new List <string>(); foreach (DataRow row in rs.Rows) { members.Add(row.ItemArray[0].ToString()); } return(members); }