public async Task Add()
{
var fixture = new NC_RDBNull_DbFixtureInitDb();
await fixture.Initalize();
using (var orderContext = fixture.CreateContext())
{
Assert.Equal(8, orderContext.Categories.Count());
Assert.Equal(4, orderContext.Customers.Count());
Assert.Equal(3, orderContext.Orders.Count());
Assert.Equal(7, orderContext.OrderItems.Count());
Assert.Equal(5, orderContext.ShippingAddresses.Count());
Assert.Equal(5, orderContext.CustomerShippingAddress.Count());
var category = orderContext.Categories.Single(t => t.Name == "jackets");
Assert.Equal("clothes", orderContext.Categories.Single(t => t.Id == category.ParentId).Name);
Assert.Equal(2, orderContext.Categories.Where(t => t.ParentId == category.Id).Count());
var order1 = orderContext.Orders.Include(t => t.Items).Single(t => t.Name == "Order 1");
Assert.Equal(3, order1.Items.Count());
var order2 = orderContext.Orders.Include(t => t.Items).Single(t => t.Name == "Order 2");
Assert.Equal(2, order2.Items.Count());
var order3 = orderContext.Orders.Include(t => t.Items).Single(t => t.Name == "Order unknown");
Assert.Equal(2, order3.Items.Count());
}
}
private static async Task <T[]> Execute <T>(String request, Object requestData, Func <OrderContext, IEnumerable <T> > fromDbFunc)
{
var fixture = new NC_RDBNull_DbFixtureInitDb();
await fixture.Initalize();
var parser = new OeParser(new Uri("http://dummy/"), fixture.OeDataAdapter, fixture.EdmModel);
var responseStream = new MemoryStream();
var requestUri = new Uri(@"http://dummy/" + request);
if (requestData == null)
{
await parser.ExecuteGetAsync(requestUri, OeRequestHeaders.JsonDefault, responseStream, CancellationToken.None);
}
else
{
String data = JsonConvert.SerializeObject(requestData);
var requestStream = new MemoryStream(Encoding.UTF8.GetBytes(data));
await parser.ExecutePostAsync(requestUri, OeRequestHeaders.JsonDefault, requestStream, responseStream, CancellationToken.None);
}
var reader = new ResponseReader(fixture.EdmModel, fixture.DbDataAdapter);
responseStream.Position = 0;
T[] fromOe;
if (typeof(T) == typeof(int))
{
String count = new StreamReader(responseStream).ReadToEnd();
fromOe = count == "" ? null : new T[] { (T)(Object)int.Parse(count) };
}
else
{
fromOe = reader.Read <T>(responseStream).ToArray();
}
if (fromDbFunc == null)
{
return(fromOe);
}
T[] fromDb;
using (var orderContext = (OrderContext)fixture.DbDataAdapter.CreateDataContext())
fromDb = fromDbFunc(orderContext).ToArray();
var settings = new JsonSerializerSettings()
{
DateFormatString = "yyyy'-'MM'-'dd'T'HH':'mm':'ss'.'ffffff",
DateTimeZoneHandling = DateTimeZoneHandling.Utc,
ReferenceLoopHandling = ReferenceLoopHandling.Ignore,
NullValueHandling = NullValueHandling.Ignore
};
String jsonOe = JsonConvert.SerializeObject(fromOe, settings);
String jsonDb = JsonConvert.SerializeObject(fromDb, settings);
Console.WriteLine(requestUri);
Assert.Equal(jsonDb, jsonOe);
return(fromOe);
}
public async Task ScalarFunctionWithParameters_get()
{
String request = "dbo.ScalarFunctionWithParameters(name='Order 1',id=1,status=null)";
int[] result = await Execute <int>(request, null, null);
var fixture = new NC_RDBNull_DbFixtureInitDb();
using (var orderContext = (OrderContext)fixture.DbDataAdapter.CreateDataContext())
{
int count = orderContext.ScalarFunctionWithParameters(1, "Order 1", null);
Assert.Equal(count, result[0]);
}
}
public async Task ScalarFunction_get()
{
String request = "dbo.ScalarFunction";
int[] result = await Execute <int>(request, null, null);
var fixture = new NC_RDBNull_DbFixtureInitDb();
using (var orderContext = (OrderContext)fixture.DbDataAdapter.CreateDataContext())
{
int count = orderContext.ScalarFunction();
Assert.Equal(count, result[0]);
}
}
public async Task ScalarFunction_get()
{
String request = "dbo.ScalarFunction";
Object[] result = await Execute <int>(request, null, null);
var fixture = new NC_RDBNull_DbFixtureInitDb();
using (OrderContext orderContext = fixture.CreateContext())
{
int count = orderContext.ScalarFunction();
Assert.Equal(count, (int)result[0]);
}
}
public async Task ScalarFunctionWithParameters_post()
{
String request = "dbo.ScalarFunctionWithParameters";
var requestData = new { id = (int?)1, name = "Order 1", status = (OrderStatus?)null };
int[] result = await Execute <int>(request, requestData, null);
var fixture = new NC_RDBNull_DbFixtureInitDb();
using (var orderContext = (OrderContext)fixture.DbDataAdapter.CreateDataContext())
{
int count = orderContext.ScalarFunctionWithParameters(1, "Order 1", null);
Assert.Equal(count, result[0]);
}
}
public async Task ResetDb_post()
{
String request = "ResetDb";
await Execute <int>(request, "", null);
var fixture = new NC_RDBNull_DbFixtureInitDb();
using (var orderContext = (OrderContext)fixture.DbDataAdapter.CreateDataContext())
{
int count = orderContext.Categories.Count() +
orderContext.Customers.Count() +
orderContext.Orders.Count() +
orderContext.OrderItems.Count();
Assert.Equal(0, count);
}
}
public async Task ResetDb_get()
{
String request = "ResetDb";
await Execute <int>(request, null, null);
var fixture = new NC_RDBNull_DbFixtureInitDb();
using (OrderContext orderContext = fixture.CreateContext())
{
int count = orderContext.Categories.Count() +
orderContext.Customers.Count() +
orderContext.Orders.Count() +
orderContext.OrderItems.Count();
Assert.Equal(0, count);
}
}
public async Task Delete()
{
var fixture = new NC_RDBNull_DbFixtureInitDb();
await fixture.Initalize();
await fixture.ExecuteBatchAsync("Delete").ConfigureAwait(false);
using (var orderContext = fixture.CreateContext())
{
Assert.Equal(5, orderContext.Categories.Count());
Assert.Equal(4, orderContext.Customers.Count());
Assert.Equal(2, orderContext.Orders.Count());
Assert.Equal(3, orderContext.OrderItems.Count());
var order1 = orderContext.Orders.Include(t => t.Items).Single(t => t.Name == "Order 1");
Assert.Equal("Product order 1 item 3", order1.Items.Single().Product);
}
}
public void Test()
{
SelectTestDefinition[] requestMethodNames = SelectTestDefinition.GetSelectTestDefinitions();
requestMethodNames = requestMethodNames.Where(t => t.MethodName == "FilterEnum" || t.MethodName == "FilterEnumNull").ToArray();
var fixture = new NC_RDBNull_DbFixtureInitDb();
var parser = new OeGetParser(fixture.EdmModel);
for (int i = 0; i < requestMethodNames.Length; i++)
{
OeQueryContext queryContext1 = parser.CreateQueryContext(fixture.ParseUri(requestMethodNames[i].Request), 0, false, OeMetadataLevel.Minimal);
OeQueryContext queryContext2 = parser.CreateQueryContext(fixture.ParseUri(requestMethodNames[i].Request), 0, false, OeMetadataLevel.Minimal);
var constantToParameterMapper = new FakeReadOnlyDictionary <ConstantNode, OeQueryCacheDbParameterDefinition>();
if (queryContext1.ODataUri.Skip != null)
{
var constantNode = OeCacheComparerParameterValues.CreateSkipConstantNode((int)queryContext1.ODataUri.Skip.Value, queryContext1.ODataUri.Path);
constantToParameterMapper.Add(constantNode, new OeQueryCacheDbParameterDefinition("p_0", typeof(int)));
}
if (queryContext1.ODataUri.Top != null)
{
var constantNode = OeCacheComparerParameterValues.CreateTopConstantNode((int)queryContext1.ODataUri.Top.Value, queryContext1.ODataUri.Path);
constantToParameterMapper.Add(constantNode, new OeQueryCacheDbParameterDefinition($"p_{constantToParameterMapper.Count}", typeof(int)));
}
OeCacheContext cacheContext1 = queryContext1.CreateCacheContext();
OeCacheContext cacheContext2 = queryContext2.CreateCacheContext();
bool result = new OeCacheComparer(constantToParameterMapper, false).Compare(cacheContext1, cacheContext2);
Assert.True(result);
for (int j = i + 1; j < requestMethodNames.Length; j++)
{
queryContext2 = parser.CreateQueryContext(fixture.ParseUri(requestMethodNames[j].Request), 0, false, OeMetadataLevel.Minimal);
constantToParameterMapper = new FakeReadOnlyDictionary <ConstantNode, OeQueryCacheDbParameterDefinition>();
result = new OeCacheComparer(constantToParameterMapper, false).Compare(cacheContext1, cacheContext2);
Assert.False(result);
}
}
}
//[Fact]
public void CacheCode()
{
var hashes = new Dictionary <int, List <String> >();
SelectTestDefinition[] requestMethodNames = SelectTestDefinition.GetSelectTestDefinitions();
var fixture = new NC_RDBNull_DbFixtureInitDb();
var parser = new OeGetParser(fixture.EdmModel);
for (int i = 0; i < requestMethodNames.Length; i++)
{
OeQueryContext queryContext = parser.CreateQueryContext(fixture.ParseUri(requestMethodNames[i].Request), 0, false, OeMetadataLevel.Minimal);
int hash = OeCacheComparer.GetCacheCode(queryContext.CreateCacheContext());
if (!hashes.TryGetValue(hash, out List <String> value))
{
value = new List <String>();
hashes.Add(hash, value);
}
value.Add(requestMethodNames[i].MethodName);
}
var duplicate = hashes.Where(p => p.Value.Count > 1).Select(p => p.Value).ToArray();
}
public async Task Update()
{
var fixture = new NC_RDBNull_DbFixtureInitDb();
await fixture.Initalize();
await fixture.ExecuteBatchAsync("Update").ConfigureAwait(false);
using (var orderContext = fixture.CreateContext())
{
var category = orderContext.Categories.Single(t => t.Name == "sombrero jacket");
Assert.Equal("jackets", orderContext.Categories.Single(t => t.Id == category.ParentId).Name);
Assert.Equal(4, orderContext.Customers.Count());
Assert.Equal(3, orderContext.Orders.Count());
Assert.Equal(7, orderContext.OrderItems.Count());
var order1 = orderContext.Orders.Include(t => t.Items).Single(t => t.Id == 1);
Assert.Equal("New Order 1", order1.Name);
Assert.Equal("New Product order 1 item 3", order1.Items.Single(t => t.Id == 3).Product);
Assert.Equal(Sex.Female, orderContext.Customers.Single(c => c.Country == "RU" && c.Id == 1).Sex);
Assert.Null(orderContext.Customers.Single(c => c.Country == "EN" && c.Id == 1).Sex);
}
}
