public void GenerateQueryWithManyToManyProperties()
{
var Mappings = new MappingSource(new IMapping[] {
new AllReferencesAndIDMappingWithDatabase(),
new ManyToManyPropertiesMapping()
},
new MockDatabaseMapping(),
new QueryProviderManager(new[] { new SQLServerQueryProvider(Configuration, ObjectPool) }, Logger),
Canister.Builder.Bootstrapper.Resolve <ILogger>(),
ObjectPool);
var ManyToManyProperty = Mappings.Mappings[typeof(ManyToManyProperties)].ManyToManyProperties.First();
var TempDataModel = new Inflatable.Schema.DataModel(Mappings, Configuration, Logger, DataModeler, Sherlock, Helper);
ManyToManyProperty.Setup(Mappings, TempDataModel.SourceSpec);
var TestObject = new DeletePropertiesQuery <ManyToManyProperties>(Mappings, ObjectPool);
var TempManyToMany = new ManyToManyProperties {
ID = 10, BoolValue = true
};
TempManyToMany.ManyToManyClass.Add(new TestDatabases.SimpleTest.AllReferencesAndID {
ID = 1
});
TempManyToMany.ManyToManyClass.Add(new TestDatabases.SimpleTest.AllReferencesAndID {
ID = 2
});
var Result = TestObject.GenerateQueries(TempManyToMany, ManyToManyProperty)[0];
Assert.Equal(CommandType.Text, Result.DatabaseCommandType);
Assert.Single(Result.Parameters);
Assert.Equal(10, Result.Parameters[0].InternalValue);
Assert.Equal("ManyToManyProperties_ID_", Result.Parameters[0].ID);
Assert.Equal("DELETE FROM [dbo].[AllReferencesAndID_ManyToManyProperties] WHERE ([dbo].[AllReferencesAndID_ManyToManyProperties].[ManyToManyProperties_ID_] = @ManyToManyProperties_ID_);", Result.QueryString);
Assert.Equal(QueryType.JoinsDelete, Result.QueryType);
}
public void GenerateQueryWithManyToOneSingleProperties()
{
var Mappings = new MappingSource(new IMapping[] {
new ManyToOneManyPropertiesMapping(),
new ManyToOneOnePropertiesMapping()
},
new MockDatabaseMapping(),
new QueryProviderManager(new[] { new SQLServerQueryProvider(Configuration, ObjectPool) }, Logger),
Canister.Builder.Bootstrapper.Resolve <ILogger>(),
ObjectPool);
var ManyToOneProperty = Mappings.Mappings[typeof(ManyToOneOneProperties)].ManyToOneProperties.First();
var TempDataModel = new Inflatable.Schema.DataModel(Mappings, Configuration, Logger, DataModeler, Sherlock, Helper);
ManyToOneProperty.Setup(Mappings, TempDataModel.SourceSpec);
var TestObject = new DeletePropertiesQuery <ManyToOneOneProperties>(Mappings, ObjectPool);
var TempManyToOne = new ManyToOneOneProperties {
ID = 10, BoolValue = true
};
TempManyToOne.ManyToOneClass = new ManyToOneManyProperties {
ID = 1
};
var Result = TestObject.GenerateQueries(TempManyToOne, ManyToOneProperty);
Assert.Empty(Result);
}
public void Creation()
{
var Mappings = new MappingSource(new IMapping[] {
new BaseClass1Mapping(),
new ConcreteClass1Mapping(),
new ConcreteClass2Mapping(),
new ConcreteClass3Mapping(),
new IInterface1Mapping(),
new IInterface2Mapping()
},
new MockDatabaseMapping(),
new QueryProviderManager(new[] { new SQLServerQueryProvider(Configuration, ObjectPool) }, Logger),
Canister.Builder.Bootstrapper.Resolve <ILogger>(),
ObjectPool);
var TestObject = new DeletePropertiesQuery <ConcreteClass1>(Mappings, ObjectPool);
Assert.Equal(typeof(ConcreteClass1), TestObject.AssociatedType);
Assert.Same(Mappings, TestObject.MappingInformation);
Assert.Equal(QueryType.JoinsDelete, TestObject.QueryType);
}
public void GenerateDeclarations()
{
var Mappings = new MappingSource(new IMapping[] {
new BaseClass1Mapping(),
new ConcreteClass1Mapping(),
new ConcreteClass2Mapping(),
new ConcreteClass3Mapping(),
new IInterface1Mapping(),
new IInterface2Mapping()
},
new MockDatabaseMapping(),
new QueryProviderManager(new[] { new SQLServerQueryProvider(Configuration, ObjectPool) }, Logger),
Canister.Builder.Bootstrapper.Resolve <ILogger>(),
ObjectPool);
var TestObject = new DeletePropertiesQuery <ConcreteClass1>(Mappings, ObjectPool);
var Result = TestObject.GenerateDeclarations();
Assert.Equal(CommandType.Text, Result[0].DatabaseCommandType);
Assert.Empty(Result[0].Parameters);
Assert.Equal("", Result[0].QueryString);
Assert.Equal(QueryType.JoinsDelete, Result[0].QueryType);
}
