public void Insert_ShouldConstructInsertStatementFromAnotherOrmType()
{
// Arrange:
const string Expected = "insert into AnotherOrmType(Name) values(@Name)";
var anotherOrmType = new AnotherOrmType
{
Id = 1,
Name = "AnotherOrmType",
OrmType = new OrmType()
};
// Act:
var statement = SqlBuilder.Insert(anotherOrmType);
// Assert:
statement.Sql.Should().Be.EqualTo(Expected);
}
public void Update_ShouldHaveParameterWhenStatementHaveRestrictions()
{
// Arrange:
var anotherOrmType = new AnotherOrmType
{
Id = 1,
Name = "AnotherOrmType",
OrmType = new OrmType()
};
// Act:
var statement = SqlBuilder.Update(anotherOrmType).Where(a => a.Id).Equal(1);
var parameters = statement.Parameters;
// Assert:
parameters.Length.Should().Be.EqualTo(2);
}
public void Update_ShouldConstructUpdateStatementFromAnotherOrmType()
{
// Arrange:
var anotherOrmType = new AnotherOrmType
{
Id = 1,
Name = "AnotherOrmType",
OrmType = new OrmType()
};
const string expected = "update AnotherOrmType set Name = @Name where Id = @IdEq";
// Act:
var statement = SqlBuilder.Update(anotherOrmType).Where(a => a.Id).Equal(1);
// Assert:
statement.Sql.Should().Be.EqualTo(expected);
}
public void Insert_ShouldHaveParametersWhenBuildStatement()
{
// Arrange:
var anotherOrmType = new AnotherOrmType
{
Id = 1,
Name = "AnotherOrmType",
OrmType = new OrmType()
};
// Act:
var statement = SqlBuilder.Insert(anotherOrmType);
var parameters = statement.Parameters;
// Assert:
parameters.Length.Should().Be.EqualTo(1);
parameters[0].Column.Should().Be.EqualTo("@Name");
parameters[0].Value.Should().Be.EqualTo(anotherOrmType.Name);
}
public void Update_ShouldHaveParameterWhenStatementDontHaveRestrictions()
{
// Arrange:
var anotherOrmType = new AnotherOrmType
{
Id = 1,
Name = "AnotherOrmType",
OrmType = new OrmType()
};
// Act:
var statement = SqlBuilder.Update(anotherOrmType);
var parameters = statement.Parameters;
// Assert:
parameters.Length.Should().Be.EqualTo(1);
parameters[0].Column.Should().Be.EqualTo("@Name");
parameters[0].Value.Should().Be.EqualTo(anotherOrmType.Name);
}