/// <summary>
/// Initializes a <see cref="CompatibilityQueryNpgsqlFixure"/>.
/// </summary>
// ReSharper disable once UnusedMember.Global
public CompatibilityQueryNpgsqlFixure()
{
TestSqlLoggerFactory = new TestSqlLoggerFactory();
_testStore = NpgsqlTestStore.CreateScratch();
using (CompatibilityContext context = CreateContext())
{
context.Database.EnsureCreated();
context.CompatibilityTestEntities.AddRange(
new CompatibilityTestEntity
{
Id = 1,
DateTime = new DateTime(2018, 06, 23)
},
new CompatibilityTestEntity
{
Id = 2,
DateTime = new DateTime(2018, 06, 23)
},
new CompatibilityTestEntity
{
Id = 3,
DateTime = new DateTime(2018, 06, 23)
});
context.SaveChanges();
}
}
public static void Seed(CompatibilityContext context)
{
context.TestEntities.AddRange(
new CompatibilityTestEntity {
Id = 1, SomeInt = 8
},
new CompatibilityTestEntity {
Id = 2, SomeInt = 10
});
context.SaveChanges();
}
public void GivenDateTimeAdd_WhenVersionIsNotSupported_ThenDoesNotTranslate(string version)
{
using (CompatibilityContext context = Fixture.CreateContext(postgresVersion: Version.Parse(version)))
{
// ReSharper disable once ConvertToConstant.Local
int years = 2;
DateTime[] _ =
context.CompatibilityTestEntities
.Select(x => x.DateTime.AddYears(years))
.ToArray();
AssertDoesNotContainsSql("SELECT (x.\"DateTime\" + MAKE_INTERVAL(years => @__years_0))");
}
}
public static void Seed(CompatibilityContext context)
{
context.CompatibilityTestEntities.AddRange(
new CompatibilityTestEntity
{
Id = 1,
DateTime = new DateTime(2018, 06, 23)
},
new CompatibilityTestEntity
{
Id = 2,
DateTime = new DateTime(2018, 06, 23)
},
new CompatibilityTestEntity
{
Id = 3,
DateTime = new DateTime(2018, 06, 23)
});
context.SaveChanges();
}
public virtual Task InitializeAsync()
{
_testStore = NpgsqlTestStoreFactory.Instance.GetOrCreate(StoreName);
_testStore.Initialize(null, CreateContext, c => CompatibilityContext.Seed((CompatibilityContext)c));
return(Task.CompletedTask);
}
