public void CopyForeignKeyColumns_Test()
{
// Arrange
var target = new ManualKeyForeignTable();
var recordReference = new RecordReference<ManualKeyForeignTable>(Helpers.GetTypeGeneratorMock(target).Object, this.attributeDecorator);
recordReference.Populate();
this.insertRecordService = new InsertRecordService(recordReference, this.attributeDecorator, InsertRecordServiceTest.IsKeyReferenceCheckEnforced);
var columns = new[]
{
new Column { Name = "ForeignKey1", Value = "ABCD" },
new Column { Name = "Two", Value = new Variable(null) },
new Column { Name = "ForeignKey2", Value = 3 },
};
// Act
this.insertRecordService.CopyPrimaryToForeignKeyColumns(columns);
// Assert
Assert.AreEqual(columns[0].Value, target.ForeignKey1);
Assert.AreEqual(columns[2].Value, target.ForeignKey2);
}
public InsertRecord(InsertRecordService service, RecordReference recordReference,
IEnumerable<AbstractRepositoryOperation> peers, IAttributeDecorator attributeDecorator)
{
InsertRecord.Logger.Debug("Entering constructor");
this.Peers = peers;
this.RecordReference = recordReference;
this.service = service;
this.attributeDecorator = attributeDecorator;
InsertRecord.Logger.Debug("Exiting constructor");
}
public void CopyForeignKeyColumns_UnknownColumnThrows_Test()
{
// Arrange
var target = new ManualKeyForeignTable();
var recordReference = new RecordReference<ManualKeyForeignTable>(Helpers.GetTypeGeneratorMock(target).Object, this.attributeDecorator);
recordReference.Populate();
this.insertRecordService = new InsertRecordService(recordReference, this.attributeDecorator, InsertRecordServiceTest.IsKeyReferenceCheckEnforced);
var columns = new[]
{
new Column { Name = "ForeignKey1", Value = "ABCD" },
new Column { Name = "Two", Value = new object() },
};
// Act
// Assert
Helpers.ExceptionTest(
() => this.insertRecordService.CopyPrimaryToForeignKeyColumns(columns),
typeof(InvalidOperationException),
"Sequence contains no matching element");
}
public void WritePrimitives_AddPrimaryKeyValue_ManualKeys_Test()
{
// Arrange
var primaryKeyValues = new List<ColumnSymbol>();
const string keyValue1 = "ABCD";
const int keyValue2 = 5;
const string catalogueName = "catABC";
const string schema = "schemaABC";
const string tableName = "XYZ";
ManualKeyPrimaryTable table;
this.insertRecordService =
new InsertRecordService(
new RecordReference<ManualKeyPrimaryTable>(
Helpers.GetTypeGeneratorMock(
table = new ManualKeyPrimaryTable
{
Key1 = keyValue1,
Key2 = keyValue2
}).Object, this.attributeDecorator), this.attributeDecorator, InsertRecordServiceTest.IsKeyReferenceCheckEnforced);
// Act
this.insertRecordService.WritePrimitives(this.writerMock.Object, catalogueName, schema, tableName, Helpers.GetColumns(table, this.attributeDecorator), primaryKeyValues);
// Assert
Assert.AreEqual(2, primaryKeyValues.Count);
Assert.AreEqual(typeof (ManualKeyPrimaryTable), primaryKeyValues[0].TableType);
Assert.AreEqual(keyValue1, primaryKeyValues[0].Value);
Assert.AreEqual("Key1", primaryKeyValues[0].ColumnName);
Assert.AreEqual(typeof (ManualKeyPrimaryTable), primaryKeyValues[1].TableType);
Assert.AreEqual(keyValue2, primaryKeyValues[1].Value);
Assert.AreEqual("Key2", primaryKeyValues[1].ColumnName);
}
public void WritePrimitives_AddPrimaryKeyValue_KeysNone_Test()
{
// Arrange
var columns = new Column[0];
var primaryKeyValues = new List<ColumnSymbol>();
this.insertRecordService =
new InsertRecordService(
new RecordReference<KeyNoneTable>(
Helpers.GetTypeGeneratorMock(
new KeyNoneTable()).Object, this.attributeDecorator), this.attributeDecorator, InsertRecordServiceTest.IsKeyReferenceCheckEnforced);
const string tableName = "ABCD";
const string catalogueName = "catABC";
const string schema = "schemaABC";
// Act
this.insertRecordService.WritePrimitives(this.writerMock.Object, catalogueName, schema, tableName, columns, primaryKeyValues);
// Assert
Assert.IsFalse(primaryKeyValues.Any());
}
public void KeyReferenceCheck_Enabled_Test()
{
// Arrange
var insertRecordService = new InsertRecordService(this.recordReference, this.attributeDecorator, enforceKeyReferenceCheck: true);
var primaryKeySymbols = new List<ColumnSymbol>
{
new ColumnSymbol {ColumnName = "Key1", TableType = typeof (ManualKeyPrimaryTable), Value = "ABCD"},
new ColumnSymbol {ColumnName = "Key2", TableType = typeof (ManualKeyPrimaryTable), Value = 5},
};
var primaryKeyInsertRecordMock = new Mock<InsertRecord>(insertRecordService,
new RecordReference<ManualKeyPrimaryTable>(
Helpers.GetTypeGeneratorMock(new ManualKeyPrimaryTable()).Object, this.attributeDecorator),
this.peers, this.attributeDecorator
);
primaryKeyInsertRecordMock.Setup(m => m.GetPrimaryKeySymbols()).Returns(primaryKeySymbols);
// Act. Assert.
// Remember: Insert record service populated with the record reference as given in the test initialization above.
Helpers.ExceptionTest(
() => insertRecordService.GetForeignKeyColumns(new[] {primaryKeyInsertRecordMock.Object}),
typeof (InserRecordServiceException),
"Foreign key in record found without corresponding record/primary key assigned. Foreign type: Tests.TestModels.ForeignTable, Property name: ForeignKey");
}
public void Initialize()
{
XmlConfigurator.Configure();
this.foreignKeyTable = new ForeignTable();
this.attributeDecorator = new StandardAttributeDecorator(attributeDecorator => null, null);
this.typeGeneratorMock = Helpers.GetTypeGeneratorMock(this.foreignKeyTable);
this.recordReference = new RecordReference<ForeignTable>(this.typeGeneratorMock.Object, this.attributeDecorator);
this.recordReference.Populate();
this.insertRecordService = new InsertRecordService(this.recordReference, this.attributeDecorator, InsertRecordServiceTest.IsKeyReferenceCheckEnforced);
this.writerMock = new Mock<IWritePrimitives>();
this.peers = Enumerable.Empty<AbstractRepositoryOperation>();
this.mainTableColumns = Helpers.GetColumns(this.foreignKeyTable, this.attributeDecorator);
}
public void GetRegularColumns_WriteGuid_Test()
{
// Arrange
var table = new ClassWithGuidKeys();
Mock<ITypeGenerator> typeGeneratorMock = Helpers.GetTypeGeneratorMock(table);
var recordReference = new RecordReference<ClassWithGuidKeys>(typeGeneratorMock.Object, this.attributeDecorator);
recordReference.Populate();
var insertRecordService = new InsertRecordService(recordReference, this.attributeDecorator, InsertRecordServiceTest.IsKeyReferenceCheckEnforced);
Variable v1, v2, v3;
this.writerMock.Setup(m => m.WriteGuid("Key1")).Returns(v1 = new Variable("x"));
this.writerMock.Setup(m => m.WriteGuid("Key3")).Returns(v2 = new Variable("y"));
this.writerMock.Setup(m => m.WriteGuid("Key4")).Returns(v3 = new Variable("z"));
// Act
List<Column> regularColumns = insertRecordService.GetRegularColumns(this.writerMock.Object).ToList();
// Assert
this.writerMock.Verify(m => m.WriteGuid(It.IsAny<string>()), Times.Exactly(3));
Column key1 = regularColumns.First(c => c.Name == "Key1");
Column key3 = regularColumns.First(c => c.Name == "Key3");
Column key4 = regularColumns.First(c => c.Name == "Key4");
Assert.AreEqual(v1, key1.Value);
Assert.AreEqual(v2, key3.Value);
Assert.AreEqual(v3, key4.Value);
}
public void GetRegularColumns_NonAutoPrimaryKey_Test()
{
// Arrange
var table = new ManualKeyPrimaryTable {Key1 = "ABCD", Key2 = 7};
var typeGeneratorMock = Helpers.GetTypeGeneratorMock(table);
var recordReference = new RecordReference<ManualKeyPrimaryTable>(typeGeneratorMock.Object, this.attributeDecorator);
recordReference.Populate();
var insertRecordService = new InsertRecordService(recordReference, this.attributeDecorator, InsertRecordServiceTest.IsKeyReferenceCheckEnforced);
// Act
List<Column> regularColumns = insertRecordService.GetRegularColumns(null).ToList();
// Assert
Assert.AreEqual(2, regularColumns.Count);
Column stringKey = regularColumns.First(c => c.Name == "Key1");
Column intKey = regularColumns.First(c => c.Name == "Key2");
Assert.AreEqual(table.Key1, stringKey.Value);
Assert.AreEqual(table.Key2, intKey.Value);
}
public void GetRegularColumns_ExplicitlySetGuid_Test()
{
// Arrange
var table = new ClassWithGuidKeys {Key1 = Guid.NewGuid(), Key3 = Guid.NewGuid(), Key4 = null};
Mock<ITypeGenerator> typeGeneratorMock = Helpers.GetTypeGeneratorMock(table);
var recordReference = new RecordReference<ClassWithGuidKeys>(typeGeneratorMock.Object, this.attributeDecorator);
recordReference.Set(r => r.Key1, Guid.Empty).Set(r => r.Key3, Guid.Empty).Set(r => r.Key4, Guid.Empty);
recordReference.Populate();
var insertRecordService = new InsertRecordService(recordReference, this.attributeDecorator, InsertRecordServiceTest.IsKeyReferenceCheckEnforced);
// Act
List<Column> regularColumns = insertRecordService.GetRegularColumns(null).ToList();
// Assert
Column key1 = regularColumns.First(c => c.Name == "Key1");
Column key3 = regularColumns.First(c => c.Name == "Key3");
Column key4 = regularColumns.First(c => c.Name == "Key4");
Assert.AreEqual(table.Key1, key1.Value);
Assert.AreEqual(table.Key3, key3.Value);
Assert.AreEqual(null, key4.Value);
}
public void GetForeignKeyColumns_NoForeignKeyPrimaryKeyMatch_Test()
{
// Arrange
var insertRecordService = new InsertRecordService(this.recordReference, this.attributeDecorator, enforceKeyReferenceCheck: false);
var primaryKeySymbols = new List<ColumnSymbol>
{
new ColumnSymbol {ColumnName = "Key1", TableType = typeof (ManualKeyPrimaryTable), Value = "ABCD"},
new ColumnSymbol {ColumnName = "Key2", TableType = typeof (ManualKeyPrimaryTable), Value = 5},
};
var primaryKeyInsertRecordMock = new Mock<InsertRecord>(insertRecordService,
new RecordReference<ManualKeyPrimaryTable>(
Helpers.GetTypeGeneratorMock(new ManualKeyPrimaryTable()).Object, this.attributeDecorator),
this.peers, this.attributeDecorator
);
primaryKeyInsertRecordMock.Setup(m => m.GetPrimaryKeySymbols()).Returns(primaryKeySymbols);
// Act
List<ExtendedColumnSymbol> fkColumns =
// Remember: Insert record service populated with the record reference as given in the test initialization above.
insertRecordService.GetForeignKeyColumns(new[] { primaryKeyInsertRecordMock.Object }).ToList();
// Assert
Assert.AreEqual(1, fkColumns.Count);
Assert.AreEqual("ForeignKey", fkColumns[0].ColumnName);
Assert.AreEqual(Helper.GetDefaultValue(typeof (ForeignTable).GetProperty("ForeignKey").PropertyType),
fkColumns[0].Value);
}
