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 async Task Ensure_we_Can_Get_correct_record_Back_when_id_is_a_number_diff_name()
{
var testTableItems = new[]
{
new TableWithAutoIncrementPrimaryKey {
Name = "Michale", SomeNumber = 33
},
};
DataBaseScriptRunnerAndBuilder.InsertTableWithAutoGeneratedPrimaryKey(Connection, testTableItems);
var record = DataBaseScriptRunnerAndBuilder.GetAll <TableWithAutoIncrementPrimaryKey>(Connection).First();
var item = await Sut.GetById(new TableWithAutoIncrementPrimaryKeyDiffSqlName { Id = record.Id });
Assert.IsNotNull(item);
Assert.AreEqual(record.Id, item.Id);
Assert.AreEqual(testTableItems.First().SomeNumber, item.SomeNumber);
Assert.AreEqual(testTableItems.First().Name, item.Name);
}
public async Task Ensure_we_can_add_with_auto_increment_diff_name()
{
var testTableItem = new TableWithAutoIncrementPrimaryKey()
{
Name = "Michale", SomeNumber = 33
};
await Sut.Add(new TableWithAutoIncrementPrimaryKeyDiffSqlName(testTableItem));
var resultInDb = DataBaseScriptRunnerAndBuilder.GetAll <TableWithAutoIncrementPrimaryKey>(Connection);
var items = resultInDb as TableWithAutoIncrementPrimaryKey[] ?? resultInDb.ToArray();
Assert.AreEqual(1, items.Length);
var test = items.FirstOrDefault();
Assert.IsNotNull(test);
Assert.IsNotNull(test.Id);
Assert.True(test.Id > 0);
Assert.AreEqual(testTableItem.Name, test.Name);
Assert.AreEqual(testTableItem.SomeNumber, test.SomeNumber);
}
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 void Ensure_we_can_add_with_null_field_for_other_values()
{
var testTableItem = new TableWithAutoIncrementPrimaryKey()
{
Name = "Michale", SomeNumber = null
};
Sut.Add(testTableItem);
var resultInDb = DataBaseScriptRunnerAndBuilder.GetAll <TableWithAutoIncrementPrimaryKey>(Connection);
var items = resultInDb as TableWithAutoIncrementPrimaryKey[] ?? resultInDb.ToArray();
Assert.AreEqual(1, items.Length);
var test = items.FirstOrDefault();
Assert.IsNotNull(test);
Assert.IsNotNull(test.Id);
Assert.True(test.Id > 0);
Assert.AreEqual(testTableItem.Name, test.Name);
Assert.IsNull(test.SomeNumber);
}
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);
}
