public void WriteStartUpdate_WhenDisposed_ThrowsObjectDisposed()
{
StringBuilder builder = new StringBuilder();
SqlWriter writer = new SqlWriter(builder);
writer.Dispose();
AssertEx.Throws<ObjectDisposedException>(() => writer.WriteStartUpdate());
}
public void WriteStartUpdate_WhenDisposed_ThrowsObjectDisposed()
{
StringBuilder builder = new StringBuilder();
SqlWriter writer = new SqlWriter(builder);
writer.Dispose();
AssertEx.Throws <ObjectDisposedException>(() => writer.WriteStartUpdate());
}
public void WriteUnion_WhenInvalidState_ThrowsInvalidOperation()
{
StringBuilder builder = new StringBuilder();
using (SqlWriter writer = new SqlWriter(builder))
{
writer.WriteStartUpdate();
Assert.AreEqual(SqlWriterState.StartUpdate, writer.WriteState);
AssertEx.Throws<InvalidOperationException>(() => writer.WriteUnion());
}
}
public void WriteStartUpdate_WritesUpdate()
{
StringBuilder builder = new StringBuilder();
using (SqlWriter writer = new SqlWriter(builder))
{
writer.WriteStartUpdate();
Assert.AreEqual(SqlWriterState.StartUpdate, writer.WriteState);
}
Assert.AreEqual("UPDATE", builder.ToString());
}
public void WriteUnion_WhenInvalidState_ThrowsInvalidOperation()
{
StringBuilder builder = new StringBuilder();
using (SqlWriter writer = new SqlWriter(builder))
{
writer.WriteStartUpdate();
Assert.AreEqual(SqlWriterState.StartUpdate, writer.WriteState);
AssertEx.Throws <InvalidOperationException>(() => writer.WriteUnion());
}
}
public void WriteTable_WhenUpdateStatement_WritesTable()
{
StringBuilder builder = new StringBuilder();
using (SqlWriter writer = new SqlWriter(builder))
{
writer.WriteStartUpdate();
writer.WriteTable("Users");
Assert.AreEqual(SqlWriterState.Update, writer.WriteState);
}
Assert.AreEqual("UPDATE [Users]", builder.ToString());
}
public void WriteStartUpdate_WritesUpdate()
{
StringBuilder builder = new StringBuilder();
using (SqlWriter writer = new SqlWriter(builder))
{
writer.WriteStartUpdate();
Assert.AreEqual(SqlWriterState.StartUpdate, writer.WriteState);
}
Assert.AreEqual("UPDATE", builder.ToString());
}
public void WriteTable_WhenUpdateStatement_WritesTable()
{
StringBuilder builder = new StringBuilder();
using (SqlWriter writer = new SqlWriter(builder))
{
writer.WriteStartUpdate();
writer.WriteTable("Users");
Assert.AreEqual(SqlWriterState.Update, writer.WriteState);
}
Assert.AreEqual("UPDATE [Users]", builder.ToString());
}
public void WriteStartSet_WhenUpdateStatement_WritesParametersAndValues()
{
StringBuilder builder = new StringBuilder();
using (SqlWriter writer = new SqlWriter(builder))
{
writer.WriteStartUpdate();
writer.WriteTable("Users");
writer.WriteStartSet();
writer.WriteColumn("Id");
writer.WriteValue(15);
writer.WriteColumn("UserName");
writer.WriteParameter("UserName");
writer.WriteColumn("Email");
writer.WriteParameter("Email");
Assert.AreEqual(SqlWriterState.Set, writer.WriteState);
}
Assert.AreEqual("UPDATE [Users] SET [Id] = 15, [UserName] = @UserName, [Email] = @Email", builder.ToString());
}
public void WriteStartSet_WhenUpdateStatement_WritesParametersAndValues()
{
StringBuilder builder = new StringBuilder();
using (SqlWriter writer = new SqlWriter(builder))
{
writer.WriteStartUpdate();
writer.WriteTable("Users");
writer.WriteStartSet();
writer.WriteColumn("Id");
writer.WriteValue(15);
writer.WriteColumn("UserName");
writer.WriteParameter("UserName");
writer.WriteColumn("Email");
writer.WriteParameter("Email");
Assert.AreEqual(SqlWriterState.Set, writer.WriteState);
}
Assert.AreEqual("UPDATE [Users] SET [Id] = 15, [UserName] = @UserName, [Email] = @Email", builder.ToString());
}
