public void Ensure_we_only_update_one_record()
{
var testTableItem = new TableWithNoAutoGeneratedPrimaryKey
{
Id = Guid.NewGuid().ToString("N"), Name = "Michale", SomeNumber = 33
};
var dontTouch = new TableWithNoAutoGeneratedPrimaryKey
{
Id = Guid.NewGuid().ToString("N"), Name = "tgwre", SomeNumber = 33
};
DataBaseScriptRunnerAndBuilder.InsertTableWithNoAutoGeneratedPrimaryKey(Connection,
new[] { testTableItem, dontTouch });
testTableItem.Name = "SomeOtherNAme";
testTableItem.SomeNumber = 532;
Sut.Update(testTableItem);
var records = DataBaseScriptRunnerAndBuilder.GetAll <TableWithNoAutoGeneratedPrimaryKey>(Connection)
.ToArray();
Assert.AreEqual(2, records.Count());
Assert.AreEqual(testTableItem.Id, records.First(f => f.Id == testTableItem.Id).Id);
Assert.AreEqual(testTableItem.SomeNumber, records.First(f => f.Id == testTableItem.Id).SomeNumber);
Assert.AreEqual(testTableItem.Name, records.First(f => f.Id == testTableItem.Id).Name);
Assert.AreEqual(dontTouch.Id, records.First(f => f.Id == dontTouch.Id).Id);
Assert.AreEqual(dontTouch.SomeNumber, records.First(f => f.Id == dontTouch.Id).SomeNumber);
Assert.AreEqual(dontTouch.Name, records.First(f => f.Id == dontTouch.Id).Name);
}
public void Ensure_we_can_Delete_a_record_diff_name()
{
var testTableItem = new TableWithNoAutoGeneratedPrimaryKey {
Id = Guid.NewGuid().ToString("N"), Name = "Michale", SomeNumber = 33
};
var dontTouch = new TableWithNoAutoGeneratedPrimaryKey {
Id = Guid.NewGuid().ToString("N"), Name = "gwgw", SomeNumber = 12
};
DataBaseScriptRunnerAndBuilder.InsertTableWithNoAutoGeneratedPrimaryKey(Connection, new[] { testTableItem, dontTouch });
Sut.Delete(new TableWithNoAutoGeneratedPrimaryKeyDiffSqlName(testTableItem));
var records = DataBaseScriptRunnerAndBuilder.GetAll <TableWithNoAutoGeneratedPrimaryKey>(Connection).ToArray();
Assert.AreEqual(1, records.Count());
Assert.AreEqual(dontTouch.Id, records.First().Id);
Assert.AreEqual(dontTouch.SomeNumber, records.First().SomeNumber);
Assert.AreEqual(dontTouch.Name, records.First().Name);
}
public async Task Ensure_we_can_add_tables_with_diff_name()
{
var testTableItem = new TableWithNoAutoGeneratedPrimaryKey
{
Id = Guid.NewGuid().ToString("N"), Name = "Michale", SomeNumber = 33
};
await Sut.Add(new TableWithNoAutoGeneratedPrimaryKeyDiffSqlName(testTableItem));
var resultInDb = DataBaseScriptRunnerAndBuilder.GetAll <TableWithNoAutoGeneratedPrimaryKey>(Connection);
var items = resultInDb as TableWithNoAutoGeneratedPrimaryKey[] ?? resultInDb.ToArray();
Assert.AreEqual(1, items.Length);
var test = items.FirstOrDefault();
Assert.IsNotNull(test);
Assert.AreEqual(testTableItem.Id, test.Id);
Assert.AreEqual(testTableItem.Name, test.Name);
Assert.AreEqual(testTableItem.SomeNumber, test.SomeNumber);
}
public async Task Ensure_we_dont_ignore_nulls_by_default()
{
var testTableItem = new TableWithNoAutoGeneratedPrimaryKey {
Id = Guid.NewGuid().ToString("N"), Name = "Michale", SomeNumber = 33
};
DataBaseScriptRunnerAndBuilder.InsertTableWithNoAutoGeneratedPrimaryKey(Connection, new [] { testTableItem });
testTableItem.Name = null;
testTableItem.SomeNumber = 532;
await Sut.Update(testTableItem);
var records = DataBaseScriptRunnerAndBuilder.GetAll <TableWithNoAutoGeneratedPrimaryKey>(Connection).ToArray();
Assert.AreEqual(1, records.Count());
Assert.AreEqual(testTableItem.Id, records.First().Id);
Assert.AreEqual(testTableItem.SomeNumber, records.First().SomeNumber);
Assert.IsNull(records.First().Name);
}
public void Ensure_we_can_ignore_null_update_a_record()
{
var testTableItem = new TableWithNoAutoGeneratedPrimaryKey
{
Id = Guid.NewGuid().ToString("N"), Name = "Michale", SomeNumber = 33
};
DataBaseScriptRunnerAndBuilder.InsertTableWithNoAutoGeneratedPrimaryKey(Connection, new[] { testTableItem });
testTableItem.Name = null;
testTableItem.SomeNumber = 532;
Sut.Update(testTableItem, true);
var records = DataBaseScriptRunnerAndBuilder.GetAll <TableWithNoAutoGeneratedPrimaryKey>(Connection)
.ToArray();
Assert.AreEqual(1, records.Count());
Assert.AreEqual(testTableItem.Id, records.First().Id);
Assert.AreEqual(testTableItem.SomeNumber, records.First().SomeNumber);
Assert.AreEqual("Michale", records.First().Name);
}
public async Task Ensure_we_can_update_a_record_diff_name()
{
var testTableItem = new TableWithNoAutoGeneratedPrimaryKey
{
Id = Guid.NewGuid().ToString("N"), Name = "Michale", SomeNumber = 33
};
DataBaseScriptRunnerAndBuilder.InsertTableWithNoAutoGeneratedPrimaryKey(Connection, new[] { testTableItem });
testTableItem.Name = "SomeOtherNAme";
testTableItem.SomeNumber = 532;
await Sut.Update(new TableWithNoAutoGeneratedPrimaryKeyDiffSqlName(testTableItem));
var records = DataBaseScriptRunnerAndBuilder.GetAll <TableWithNoAutoGeneratedPrimaryKey>(Connection)
.ToArray();
Assert.AreEqual(1, records.Count());
Assert.AreEqual(testTableItem.Id, records.First().Id);
Assert.AreEqual(testTableItem.SomeNumber, records.First().SomeNumber);
Assert.AreEqual(testTableItem.Name, records.First().Name);
}
