public void PassAllParameters()
{
//ARRANGE
var rowObject1 = TestDbTypeTable.Row1;
var parameters = new[]
{
new SpecifiedParameter("BigInt", rowObject1.BigInt),
new SpecifiedParameter("Binary50", rowObject1.Binary50),
new SpecifiedParameter("Bit", rowObject1.Bit),
new SpecifiedParameter("Char10", rowObject1.Char10),
new SpecifiedParameter("Date", rowObject1.Date),
new SpecifiedParameter("DateTime", rowObject1.DateTime),
new SpecifiedParameter("DateTime2", rowObject1.DateTime2),
new SpecifiedParameter("DateTimeOffset", rowObject1.DateTimeOffset),
new SpecifiedParameter("Decimal", rowObject1.Decimal),
new SpecifiedParameter("Float", rowObject1.Float),
new SpecifiedParameter("Image", rowObject1.Image),
new SpecifiedParameter("Int", rowObject1.Int),
new SpecifiedParameter("Money", rowObject1.Money),
new SpecifiedParameter("NChar10", rowObject1.NChar10),
new SpecifiedParameter("NText", rowObject1.NText),
new SpecifiedParameter("Numeric", rowObject1.Numeric),
new SpecifiedParameter("NVarchar50", rowObject1.NVarchar50),
new SpecifiedParameter("Real", rowObject1.Real),
new SpecifiedParameter("SmallDateTime", rowObject1.SmallDateTime),
new SpecifiedParameter("SmallInt", rowObject1.SmallInt),
new SpecifiedParameter("SmallMoney", rowObject1.SmallMoney),
new SpecifiedParameter("Text", rowObject1.Text),
new SpecifiedParameter("Time", rowObject1.Time),
new SpecifiedParameter("TinyInt", rowObject1.TinyInt),
new SpecifiedParameter("Uniqueidentifier", rowObject1.Uniqueidentifier),
new SpecifiedParameter("Varbinary50", rowObject1.Varbinary50),
new SpecifiedParameter("Varchar50", rowObject1.Varchar50),
new SpecifiedParameter("Xml", rowObject1.Xml)
};
var query = _queryFactory.CreateQuery();
//ACT
var result = query.Select <dynamic>(ExecuteProcQuery, parameters);
//ASSERT
AssertSingleDynamicObjectWithSingleRow(TestDbTypeTable.Row1, result);
query.Dispose();
}
public void InvokeInTransaction_ShouldSaveData_WhenCommitTransaction()
{
//ARRANGE
var query = _queryFactory.CreateQuery();
//ACT
query.BeginTransaction();
query.Execute("create table #temp(id int)");
query.Execute("insert into #temp(id) values(1)");
query.CommitTransaction();
//ASSERT
int?id = query.Select <int?>("select id from #temp");
Assert.AreEqual(1, id);
query.Dispose();
}
// APIs allowed to access the Auth server
public static async Task <IEnumerable <ApiResource> > GetApiResources(IQueryFactory <ClientRegistration> clientRegistrationQueryFactory)
{
using (var query = clientRegistrationQueryFactory.CreateQuery())
{
var options = clientRegistrationQueryFactory.CreateQueryOptions();
var clients = await query.Execute(options);
return(clients.Select((clientRegistration) =>
new ApiResource(clientRegistration.ScopeId, clientRegistration.ScopeName)
).Distinct().ToList());
}
}
public void PassAllParameters()
{
//ARRANGE
var rowObject1 = TestDbTypeTable.Row1;
var parameters = CreateDefiniedTypeFromRowObject(rowObject1);
var query = _queryFactory.CreateQuery();
//ACT
var result = query.Select <dynamic>(ExecuteProcQuery, parameters);
//ASSERT
AssertSingleDynamicObjectWithSingleRow(rowObject1, result);
query.Dispose();
}
public void PassAllParameters()
{
//ARRANGE
var rowObject1 = TestDbTypeTable.Row1;
var parameters = new object[]
{
rowObject1.BigInt,
rowObject1.Binary50,
rowObject1.Bit,
rowObject1.Char10,
rowObject1.Date,
rowObject1.DateTime,
rowObject1.DateTime2,
rowObject1.DateTimeOffset,
rowObject1.Decimal,
rowObject1.Float,
rowObject1.Image,
rowObject1.Int,
rowObject1.Money,
rowObject1.NChar10,
rowObject1.NText,
rowObject1.Numeric,
rowObject1.NVarchar50,
rowObject1.Real,
rowObject1.SmallDateTime,
rowObject1.SmallInt,
rowObject1.SmallMoney,
rowObject1.Text,
rowObject1.Time,
rowObject1.TinyInt,
rowObject1.Uniqueidentifier,
rowObject1.Varbinary50,
rowObject1.Varchar50,
rowObject1.Xml
};
var query = _queryFactory.CreateQuery();
//ACT
var result = query.Select <dynamic>(ExecuteProcQuery, parameters);
//ASSERT
AssertSingleDynamicObjectWithSingleRow(TestDbTypeTable.Row1, result);
query.Dispose();
}
// Clients allowed to access resources from Auth Server
public static async Task <IEnumerable <Client> > GetClients(IQueryFactory <ClientRegistration> clientRegistrationQueryFactory)
{
using (var query = clientRegistrationQueryFactory.CreateQuery())
{
var options = clientRegistrationQueryFactory.CreateQueryOptions();
var clients = await query.Execute(options);
return(clients.Select((clientRegistration) =>
new Client
{
ClientId = clientRegistration.ClientId,
AllowedGrantTypes = GrantTypes.ClientCredentials,
ClientSecrets =
{
new Secret(clientRegistration.ClientSecret.Sha256())
},
AllowedScopes = { clientRegistration.ScopeId }
}
).ToList());
}
}
private IWindowView Deserialize(string persistString)
{
if (persistString.StartsWith(typeof(ImagesView).FullName))
{
var parts = persistString.Split(';');
if (parts.Length == 1)
{
var images = GetImages();
return(images.View);
}
else if (parts.Length == 2)
{
// get the last query
var queryText = parts[1];
var query = _queryCompiler.Compile(new StringReader(queryText), new NullQueryErrorListener());
if (query == null)
{
query = _queryFactory.CreateQuery();
}
var images = GetImages();
_dontShowImagesWindow = true;
try
{
_queryHistory.ExecuteQuery(query);
}
finally
{
_dontShowImagesWindow = false;
}
return(images.View);
}
}
return(null);
}
private IQueryGenerator <T> BaseQuery <T>() where T : class
{
return(_queryFactory.CreateQuery <T>());
}
protected TQuery GetQuery <TQuery>() where TQuery : IQuery
{
return(_factory.CreateQuery <TQuery>());
}
//----------------------------------------------------------------//
public FeedManager(ISession session, IServiceProvider provider)
{
_commandFactory = provider.GetService <ICommandFactory>();
_queryFactory = provider.GetService <IQueryFactory>();
_genreCommand = _commandFactory.CreateCommand <IGenreCommand>(session);
_companyCommand = _commandFactory.CreateCommand <ICompanyCommand>(session);
_countryCommand = _commandFactory.CreateCommand <ICountryCommand>(session);
_peopleCommad = _commandFactory.CreateCommand <IPeopleCommand>(session);
_movieCommand = _commandFactory.CreateCommand <IMovieCommand>(session);
_castCommand = _commandFactory.CreateCommand <ICastCommand>(session);
_crewCommand = _commandFactory.CreateCommand <ICrewCommand>(session);
_jobCommand = _commandFactory.CreateCommand <IJobCommand>(session);
_departmentCommand = _commandFactory.CreateCommand <IDepartmentCommand>(session);
_movieGenreCommand = _commandFactory.CreateCommand <IMovieGenreCommand>(session);
_movieCompanyCommand = _commandFactory.CreateCommand <IMovieCompanyCommand>(session);
_movieCountryCommand = _commandFactory.CreateCommand <IMovieCountryCommand>(session);
_movieCountryQuery = _queryFactory.CreateQuery <IMovieCountryQuery>(session);
_movieCompanyQuery = _queryFactory.CreateQuery <IMovieCompanyQuery>(session);
_movieGenreQuery = _queryFactory.CreateQuery <IMovieGenreQuery>(session);
_movieQuery = _queryFactory.CreateQuery <IMovieQuery>(session);
_genreQuery = _queryFactory.CreateQuery <IGenreQuery>(session);
_companyQuery = _queryFactory.CreateQuery <ICompanyQuery>(session);
_countryQuery = _queryFactory.CreateQuery <ICountryQuery>(session);
_castQuery = _queryFactory.CreateQuery <ICastQuery>(session);
_crewQuery = _queryFactory.CreateQuery <ICrewQuery>(session);
_peopleQuery = _queryFactory.CreateQuery <IPeopleQuery>(session);
_jobQuery = _queryFactory.CreateQuery <IJobQuery>(session);
_departmentQuery = _queryFactory.CreateQuery <IDepartmentQuery>(session);
_loadDataService = provider.GetRequiredService <ILoadDataService>();
}
public void PassAllParameters()
{
//ARRANGE
var rowObject1 = TestDbTypeTable.Row1;
var dataTable = new DataTable();
dataTable.Columns.Add("BigInt", typeof(long));
dataTable.Columns.Add("Binary50", typeof(byte[]));
dataTable.Columns.Add("Bit", typeof(bool));
dataTable.Columns.Add("Char10", typeof(string));
dataTable.Columns.Add("Date", typeof(DateTime));
dataTable.Columns.Add("DateTime", typeof(DateTime));
dataTable.Columns.Add("DateTime2", typeof(DateTime));
dataTable.Columns.Add("DateTimeOffset", typeof(DateTimeOffset));
dataTable.Columns.Add("Decimal", typeof(decimal));
dataTable.Columns.Add("Float", typeof(double));
dataTable.Columns.Add("Image", typeof(byte[]));
dataTable.Columns.Add("Int", typeof(int));
dataTable.Columns.Add("Money", typeof(decimal));
dataTable.Columns.Add("NChar10", typeof(string));
dataTable.Columns.Add("NText", typeof(string));
dataTable.Columns.Add("Numeric", typeof(decimal));
dataTable.Columns.Add("NVarchar50", typeof(string));
dataTable.Columns.Add("Real", typeof(float));
dataTable.Columns.Add("SmallDateTime", typeof(DateTime));
dataTable.Columns.Add("SmallInt", typeof(short));
dataTable.Columns.Add("SmallMoney", typeof(decimal));
dataTable.Columns.Add("Text", typeof(string));
dataTable.Columns.Add("Time", typeof(TimeSpan));
dataTable.Columns.Add("TinyInt", typeof(byte));
dataTable.Columns.Add("Uniqueidentifier", typeof(Guid));
dataTable.Columns.Add("Varbinary50", typeof(byte[]));
dataTable.Columns.Add("Varchar50", typeof(string));
dataTable.Columns.Add("Xml", typeof(string));
dataTable.Rows.Add(new object[]
{
rowObject1.BigInt,
rowObject1.Binary50,
rowObject1.Bit,
rowObject1.Char10,
rowObject1.Date,
rowObject1.DateTime,
rowObject1.DateTime2,
rowObject1.DateTimeOffset,
rowObject1.Decimal,
rowObject1.Float,
rowObject1.Image,
rowObject1.Int,
rowObject1.Money,
rowObject1.NChar10,
rowObject1.NText,
rowObject1.Numeric,
rowObject1.NVarchar50,
rowObject1.Real,
rowObject1.SmallDateTime,
rowObject1.SmallInt,
rowObject1.SmallMoney,
rowObject1.Text,
rowObject1.Time,
rowObject1.TinyInt,
rowObject1.Uniqueidentifier,
rowObject1.Varbinary50,
rowObject1.Varchar50,
rowObject1.Xml
});
var query = _queryFactory.CreateQuery();
//ACT
var result = query.Select <dynamic>(ExecuteProcQuery, dataTable);
//ASSERT
AssertSingleDynamicObjectWithSingleRow(TestDbTypeTable.Row1, result);
query.Dispose();
}
public void ExitSource(QueryParser.SourceContext context)
{
string viewIdentifier = null;
var viewIdentifierToken = context.ID();
if (viewIdentifierToken != null)
{
viewIdentifier = viewIdentifierToken.Symbol.Text;
}
else
{
viewIdentifierToken = context.COMPLEX_ID();
if (viewIdentifierToken != null)
{
viewIdentifier = ParseComplexIdentifier(viewIdentifierToken.Symbol);
}
}
// create a query SELECT view
if (viewIdentifier != null)
{
// if there is a cycle, report it and halt
if (ReportCycle(
viewIdentifierToken.Symbol.Line,
viewIdentifierToken.Symbol.Column,
viewIdentifier))
{
return;
}
// otherwise, compile the view
var view = _compiler.Views.Find(viewIdentifier);
if (view == null)
{
ReportError(
viewIdentifierToken.Symbol.Line,
viewIdentifierToken.Symbol.Column,
$"Unknown view '{viewIdentifier}'");
return;
}
// compile view
var query = _compiler.Compile(
new StringReader(view.Text),
_errorListener,
_parameters.Create(view.Name)) as IQuery;
if (query == null) // compilation of the view failed
{
HaltCompilation();
return;
}
_queries.Push(query.View(viewIdentifier));
}
else if (context.STRING() != null) // create a query SELECT pattern
{
var patternSymbol = context.STRING().Symbol;
var pattern = ParseStringValue(patternSymbol);
try
{
var query = _queryFactory.CreateQuery(pattern) as IQuery;
_queries.Push(query);
}
catch (ArgumentException) // invalid pattern
{
ReportError(
patternSymbol.Line,
patternSymbol.Column,
$"Invalid path pattern: {pattern}");
}
}
// otherwise, this is a subquery => it will push its own tree to the stack
}
private void View_OpenDirectory(object sender, DirectoryEventArgs e)
{
_state.ExecuteQuery(_queryFactory.CreateQuery(e.FullPath));
}