public void GenerateQueryWithManyToOneSingleProperties()
{
var Mappings = new MappingSource(new IMapping[] {
new ManyToOneOnePropertiesMapping(),
new ManyToOneManyPropertiesMapping()
},
new MockDatabaseMapping(),
new QueryProviderManager(new[] { new SQLServerQueryProvider(Configuration, ObjectPool) }, Logger),
Canister.Builder.Bootstrapper.Resolve <ILogger>(),
ObjectPool);
var ManyToOneOneProperty = Mappings.Mappings[typeof(ManyToOneOneProperties)].ManyToOneProperties[0];
var TempDataModel = new Inflatable.Schema.DataModel(Mappings, Configuration, Logger, DataModeler, Sherlock, Helper);
ManyToOneOneProperty.Setup(Mappings, TempDataModel.SourceSpec);
var TestObject = new DataLoadQuery <ManyToOneOneProperties>(Mappings, ObjectPool);
var TempManyToOneOne = new ManyToOneOneProperties {
ID = 10, BoolValue = true
};
TempManyToOneOne.ManyToOneClass = new ManyToOneManyProperties {
ID = 1
};
var Result = TestObject.GenerateQueries(new Dynamo[] { new Dynamo(new { ID = 1 }) })[0];
Assert.Equal(CommandType.Text, Result.DatabaseCommandType);
Assert.Single(Result.Parameters);
Assert.Equal(1, Result.Parameters[0].InternalValue);
Assert.Equal("ID0", Result.Parameters[0].ID);
Assert.Equal("SELECT [dbo].[ManyToOneOneProperties_].[ID_] AS [ID],[dbo].[ManyToOneOneProperties_].[BoolValue_] AS [BoolValue]\r\nFROM [dbo].[ManyToOneOneProperties_]\r\nWHERE ([dbo].[ManyToOneOneProperties_].[ID_]=@ID0);", Result.QueryString);
Assert.Equal(QueryType.LoadData, Result.QueryType);
}
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 GenerateQueryWithManyToOneOneFromComplexGraphProperties()
{
var Mappings = new MappingSource(new IMapping[] {
new ManyToOneOneFromComplexClassMapping(),
new IManyToOneOneMapping(),
new AllReferencesAndIDMappingWithDatabase()
},
new MockDatabaseMapping(),
new QueryProviderManager(new[] { new SQLServerQueryProvider(Configuration, ObjectPool) }, Logger),
Canister.Builder.Bootstrapper.Resolve <ILogger>(),
ObjectPool);
var ManyToOneManyProperty = Mappings.Mappings[typeof(ManyToOneOneFromComplexClass)].ManyToOneProperties.First();
var TempDataModel = new Inflatable.Schema.DataModel(Mappings, Configuration, Logger, DataModeler, Sherlock, Helper);
ManyToOneManyProperty.Setup(Mappings, TempDataModel.SourceSpec);
var TestObject = new LoadPropertiesQuery <ManyToOneOneFromComplexClass>(Mappings, ObjectPool);
var TempManyToOneMany = new ManyToOneOneFromComplexClass {
ID = 10, BoolValue = true
};
TempManyToOneMany.ManyToOneClass = new AllReferencesAndID {
ID = 1
};
var Result = TestObject.GenerateQueries(TempManyToOneMany, ManyToOneManyProperty)[0];
Assert.Equal(CommandType.Text, Result.DatabaseCommandType);
Assert.Single(Result.Parameters);
Assert.Equal(10, Result.Parameters[0].InternalValue);
Assert.Equal("ID", Result.Parameters[0].ID);
Assert.Equal("SELECT [dbo].[AllReferencesAndID_].[ID_] AS [ID],[dbo].[AllReferencesAndID_].[BoolValue_] AS [BoolValue],[dbo].[AllReferencesAndID_].[ByteArrayValue_] AS [ByteArrayValue],[dbo].[AllReferencesAndID_].[ByteValue_] AS [ByteValue],[dbo].[AllReferencesAndID_].[CharValue_] AS [CharValue],[dbo].[AllReferencesAndID_].[DateTimeValue_] AS [DateTimeValue],[dbo].[AllReferencesAndID_].[DecimalValue_] AS [DecimalValue],[dbo].[AllReferencesAndID_].[DoubleValue_] AS [DoubleValue],[dbo].[AllReferencesAndID_].[FloatValue_] AS [FloatValue],[dbo].[AllReferencesAndID_].[GuidValue_] AS [GuidValue],[dbo].[AllReferencesAndID_].[IntValue_] AS [IntValue],[dbo].[AllReferencesAndID_].[LongValue_] AS [LongValue],[dbo].[AllReferencesAndID_].[NullableBoolValue_] AS [NullableBoolValue],[dbo].[AllReferencesAndID_].[NullableByteValue_] AS [NullableByteValue],[dbo].[AllReferencesAndID_].[NullableCharValue_] AS [NullableCharValue],[dbo].[AllReferencesAndID_].[NullableDateTimeValue_] AS [NullableDateTimeValue],[dbo].[AllReferencesAndID_].[NullableDecimalValue_] AS [NullableDecimalValue],[dbo].[AllReferencesAndID_].[NullableDoubleValue_] AS [NullableDoubleValue],[dbo].[AllReferencesAndID_].[NullableFloatValue_] AS [NullableFloatValue],[dbo].[AllReferencesAndID_].[NullableGuidValue_] AS [NullableGuidValue],[dbo].[AllReferencesAndID_].[NullableIntValue_] AS [NullableIntValue],[dbo].[AllReferencesAndID_].[NullableLongValue_] AS [NullableLongValue],[dbo].[AllReferencesAndID_].[NullableSByteValue_] AS [NullableSByteValue],[dbo].[AllReferencesAndID_].[NullableShortValue_] AS [NullableShortValue],[dbo].[AllReferencesAndID_].[NullableTimeSpanValue_] AS [NullableTimeSpanValue],[dbo].[AllReferencesAndID_].[NullableUIntValue_] AS [NullableUIntValue],[dbo].[AllReferencesAndID_].[NullableULongValue_] AS [NullableULongValue],[dbo].[AllReferencesAndID_].[NullableUShortValue_] AS [NullableUShortValue],[dbo].[AllReferencesAndID_].[SByteValue_] AS [SByteValue],[dbo].[AllReferencesAndID_].[ShortValue_] AS [ShortValue],[dbo].[AllReferencesAndID_].[StringValue1_] AS [StringValue1],[dbo].[AllReferencesAndID_].[StringValue2_] AS [StringValue2],[dbo].[AllReferencesAndID_].[TimeSpanValue_] AS [TimeSpanValue],[dbo].[AllReferencesAndID_].[UIntValue_] AS [UIntValue],[dbo].[AllReferencesAndID_].[ULongValue_] AS [ULongValue],[dbo].[AllReferencesAndID_].[UShortValue_] AS [UShortValue],[dbo].[AllReferencesAndID_].[UriValue_] AS [UriValue]\r\nFROM [dbo].[AllReferencesAndID_]\r\nINNER JOIN [dbo].[IManyToOneOne_] as [IManyToOneOne_2] ON [IManyToOneOne_2].[AllReferencesAndID_ID_]=[dbo].[AllReferencesAndID_].[ID_]\r\nWHERE [IManyToOneOne_2].[ID_]=@ID;", Result.QueryString);
Assert.Equal(QueryType.LoadProperty, 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 GenerateQueryWithManyToOneManyProperties()
{
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 ManyToOneManyProperty = Mappings.Mappings[typeof(ManyToOneManyProperties)].ManyToOneProperties.First();
var TempDataModel = new Inflatable.Schema.DataModel(Mappings, Configuration, Logger, DataModeler, Sherlock, Helper);
ManyToOneManyProperty.Setup(Mappings, TempDataModel.SourceSpec);
ManyToOneManyProperty.SetColumnInfo(Mappings);
var TestObject = new SavePropertiesQuery <ManyToOneManyProperties>(Mappings, ObjectPool);
var TempManyToOneMany = new ManyToOneManyProperties {
ID = 10, BoolValue = true
};
TempManyToOneMany.ManyToOneClass.Add(new ManyToOneOneProperties {
ID = 1
});
TempManyToOneMany.ManyToOneClass.Add(new ManyToOneOneProperties {
ID = 2
});
var Result = TestObject.GenerateQueries(TempManyToOneMany, ManyToOneManyProperty)[0];
Assert.Equal(CommandType.Text, Result.DatabaseCommandType);
Assert.Equal(2, Result.Parameters.Length);
Assert.Equal(10, Result.Parameters[0].InternalValue);
Assert.Equal(1, Result.Parameters[1].InternalValue);
Assert.Equal("ManyToOneManyProperties_ID_", Result.Parameters[0].ID);
Assert.Equal("ID_", Result.Parameters[1].ID);
Assert.Equal("UPDATE [dbo].[ManyToOneOneProperties_] SET [dbo].[ManyToOneOneProperties_].[ManyToOneManyProperties_ID_] = @ManyToOneManyProperties_ID_ FROM [dbo].[ManyToOneOneProperties_] WHERE [dbo].[ManyToOneOneProperties_].[ID_] = @ID_;", Result.QueryString);
Assert.Equal(QueryType.JoinsSave, Result.QueryType);
Result = TestObject.GenerateQueries(TempManyToOneMany, ManyToOneManyProperty)[1];
Assert.Equal(CommandType.Text, Result.DatabaseCommandType);
Assert.Equal(2, Result.Parameters.Length);
Assert.Equal(10, Result.Parameters[0].InternalValue);
Assert.Equal(2, Result.Parameters[1].InternalValue);
Assert.Equal("ManyToOneManyProperties_ID_", Result.Parameters[0].ID);
Assert.Equal("ID_", Result.Parameters[1].ID);
Assert.Equal("UPDATE [dbo].[ManyToOneOneProperties_] SET [dbo].[ManyToOneOneProperties_].[ManyToOneManyProperties_ID_] = @ManyToOneManyProperties_ID_ FROM [dbo].[ManyToOneOneProperties_] WHERE [dbo].[ManyToOneOneProperties_].[ID_] = @ID_;", Result.QueryString);
Assert.Equal(QueryType.JoinsSave, Result.QueryType);
}
