public void Commit_BindColumnToForInsert_InsertWorksCorrectly()
{
var factory = GetProviderFactory();
var provider = new StubSqlProvider();
provider.SetObjectToReturn(1);
using (mocks.Record())
{
factory.CreateProvider("somestring");
LastCall.Return(provider).IgnoreArguments();
}
Guid personId = Guid.NewGuid();
Guid addressId = Guid.NewGuid();
DataBoy
.ForTable("Person")
.Row("Id", personId)
.ReturnValue("IdPerson").AtKey("IdOfPerson")
.ForTable("Address")
.Row("Id", addressId)
.BindColumn("IdPerson").To("IdOfPerson")
.Commit();
string expectedSql = string.Format("INSERT INTO Address (ID, IdPerson) VALUES('{0}', 1)", addressId);
Assert.IsTrue(provider.HasAnySqlMatching(expectedSql));
}
public void Commit_WithReturnValue_SelectExecutedAsExpected()
{
//INSERT INTO Address (ID, IdPerson) VALUES('7e7304db-2b77-4040-ae64-9eb6a686a036', 1)
var factory = GetProviderFactory();
var provider = new StubSqlProvider();
provider.SetObjectToReturn(1);
using (mocks.Record())
{
factory.CreateProvider("somestring");
LastCall.Return(provider).IgnoreArguments();
}
Guid personId = Guid.NewGuid();
DataBoy
.ForTable("Person")
.Row("Id", personId)
.ReturnValue("IdPerson").AtKey("IdOfPerson")
//.ForTable("Address")
// .Row("Id", Guid.NewGuid())
// .BindColumn("IdPerson").To("IdOfPerson")
.Commit();
//HasAnySqlMatching
string expectedSql = string.Format("SELECT IdPerson FROM Person WHERE Id = '{0}'", personId);
Assert.IsTrue(provider.HasAnySqlMatching(expectedSql));
}