public void TheConnectionStringIsSetAndANewInsertHasTheSameColumns()
{
const string connection = "some connection";
var insertStatement = new Insert(SomeTable)[FirstColumn.WillBe(FirstValue)].ConnectTo(connection);
var newStatement = insertStatement.ConnectTo(connection);
newStatement.Columns.Should().BeEquivalentTo(insertStatement.Columns);
}
public void TheConnectionStringIsAllowedToBeSet()
{
const string connection = "some connection";
var insertStatement =
new Insert(SomeTable)
[
FirstColumn.WillBe(_fakeValue)
]
.ConnectTo(connection);
RetrieveValueFromObject(insertStatement, ConnectionKeyword).ToString().Should().Be(connection);
}
public void ANewInsertIsCreatedWhenSettingTheColumnsAndTheConnectionIsTheSame()
{
const string firstConnection = "connectionA";
const string secondConnection = "connectionB";
var insertStatement = new Insert(SomeTable)[FirstColumn.WillBe(_fakeValue)].ConnectTo(firstConnection);
var newStatement = insertStatement.ConnectTo(secondConnection);
var connectionA = RetrieveValueFromObject(insertStatement, ConnectionKeyword);
var connectionB = RetrieveValueFromObject(newStatement, ConnectionKeyword);
connectionA.Should().Be(connectionB);
}
public void ANewInsertIsCreatedWhenSettingTheColumns()
{
var insertStatement =
new Insert(SomeTable)
[
FirstColumn.WillBe(_fakeValue),
SecondColumn.WillBe(SecondValue)
];
var newStatement = insertStatement[FirstColumn.WillBe(_fakeValue)];
insertStatement.Should().NotBe(newStatement);
}
public Insert this[params ColumnItem[] items]
{
get
{
var result = new Insert(TableName) { _connection = _connection, _columns = Columns };
foreach (var item in items)
{
_columns.Add(item);
}
return result;
}
}
public void TheInsertCanCreateAValidStatement()
{
var insertStatement =
new Insert(SomeTable)
[
FirstColumn.WillBe(_fakeValue),
SecondColumn.WillBe(SecondValue)
];
insertStatement.CreateSql().Should().Be("INSERT INTO " + SomeTable + "(" + FirstColumn + ", " + SecondColumn + ") VALUES (@" + FirstColumn + ", @" + SecondColumn + ")");
}
public void TheConnectionStringIsSetAndANewInsertIsCreated()
{
const string connection = "some connection";
var insertStatement = new Insert(SomeTable).ConnectTo(connection);
var newStatement = insertStatement.ConnectTo(connection);
insertStatement.Should().NotBe(newStatement);
}
