public void WriteValue_WhenBulkInsertStatement_WritesValues()
{
StringBuilder builder = new StringBuilder();
using (SqlWriter writer = new SqlWriter(builder))
{
writer.WriteStartInsert();
writer.WriteStartInto();
writer.WriteTable("Users");
writer.WriteColumn("Id");
writer.WriteColumn("UserName");
writer.WriteColumn("Email");
writer.WriteStartValues();
writer.WriteOpenParenthesis();
Assert.AreEqual(SqlWriterState.StartValues, writer.WriteState);
writer.WriteValue(15);
writer.WriteValue("My user name.");
writer.WriteValue("*****@*****.**");
writer.WriteEndValues();
Assert.AreEqual(SqlWriterState.EndValues, writer.WriteState);
writer.WriteStartValues();
Assert.AreEqual(SqlWriterState.StartValues, writer.WriteState);
writer.WriteValue(16);
writer.WriteValue("My second user name.");
writer.WriteValue("*****@*****.**");
writer.WriteEndValues();
Assert.AreEqual(SqlWriterState.EndValues, writer.WriteState);
writer.WriteCloseParenthesis();
}
Assert.AreEqual("INSERT INTO [Users] ([Id], [UserName], [Email]) VALUES ((15, 'My user name.', '*****@*****.**'), (16, 'My second user name.', '*****@*****.**'))", builder.ToString());
}
public void WriteStartInsert_WhenDisposed_ThrowsObjectDisposed()
{
StringBuilder builder = new StringBuilder();
SqlWriter writer = new SqlWriter(builder);
writer.Dispose();
AssertEx.Throws<ObjectDisposedException>(() => writer.WriteStartInsert());
}
public void WriteStartInsert_WhenDisposed_ThrowsObjectDisposed()
{
StringBuilder builder = new StringBuilder();
SqlWriter writer = new SqlWriter(builder);
writer.Dispose();
AssertEx.Throws <ObjectDisposedException>(() => writer.WriteStartInsert());
}
public void WriteStartInsert_WritesInsert()
{
StringBuilder builder = new StringBuilder();
using (SqlWriter writer = new SqlWriter(builder))
{
writer.WriteStartInsert();
Assert.AreEqual(SqlWriterState.StartInsert, writer.WriteState);
}
Assert.AreEqual("INSERT", builder.ToString());
}
public void WriteStartInsert_WritesInsert()
{
StringBuilder builder = new StringBuilder();
using (SqlWriter writer = new SqlWriter(builder))
{
writer.WriteStartInsert();
Assert.AreEqual(SqlWriterState.StartInsert, writer.WriteState);
}
Assert.AreEqual("INSERT", builder.ToString());
}
public void WriteStartInto_WhenInsertStatement_WritesInto()
{
StringBuilder builder = new StringBuilder();
using (SqlWriter writer = new SqlWriter(builder))
{
writer.WriteStartInsert();
writer.WriteStartInto();
Assert.AreEqual(SqlWriterState.StartInto, writer.WriteState);
}
Assert.AreEqual("INSERT INTO", builder.ToString());
}
public void WriteColumn_WhenInsertStatement_WritesColumns()
{
StringBuilder builder = new StringBuilder();
using (SqlWriter writer = new SqlWriter(builder))
{
writer.WriteStartInsert();
writer.WriteStartInto();
writer.WriteTable("Users");
writer.WriteColumn("Id");
writer.WriteColumn("UserName");
writer.WriteColumn("Email");
writer.WriteCloseParenthesis();
Assert.AreEqual(SqlWriterState.Into, writer.WriteState);
}
Assert.AreEqual("INSERT INTO [Users] ([Id], [UserName], [Email])", builder.ToString());
}
public void WriteColumn_WhenInsertStatement_WritesColumns()
{
StringBuilder builder = new StringBuilder();
using (SqlWriter writer = new SqlWriter(builder))
{
writer.WriteStartInsert();
writer.WriteStartInto();
writer.WriteTable("Users");
writer.WriteColumn("Id");
writer.WriteColumn("UserName");
writer.WriteColumn("Email");
writer.WriteCloseParenthesis();
Assert.AreEqual(SqlWriterState.Into, writer.WriteState);
}
Assert.AreEqual("INSERT INTO [Users] ([Id], [UserName], [Email])", builder.ToString());
}
public void WriteParameter_WhenInsertStatement_WritesParameters()
{
StringBuilder builder = new StringBuilder();
using (SqlWriter writer = new SqlWriter(builder))
{
writer.WriteStartInsert();
writer.WriteStartInto();
writer.WriteTable("Users");
writer.WriteColumn("Id");
writer.WriteColumn("UserName");
writer.WriteColumn("Email");
writer.WriteStartValues();
Assert.AreEqual(SqlWriterState.StartValues, writer.WriteState);
writer.WriteParameter("Id");
writer.WriteParameter("UserName");
writer.WriteParameter("Email");
writer.WriteEndValues();
Assert.AreEqual(SqlWriterState.EndValues, writer.WriteState);
}
Assert.AreEqual("INSERT INTO [Users] ([Id], [UserName], [Email]) VALUES (@Id, @UserName, @Email)", builder.ToString());
}
public void WriteParameter_WhenInsertStatement_WritesParameters()
{
StringBuilder builder = new StringBuilder();
using (SqlWriter writer = new SqlWriter(builder))
{
writer.WriteStartInsert();
writer.WriteStartInto();
writer.WriteTable("Users");
writer.WriteColumn("Id");
writer.WriteColumn("UserName");
writer.WriteColumn("Email");
writer.WriteStartValues();
Assert.AreEqual(SqlWriterState.StartValues, writer.WriteState);
writer.WriteParameter("Id");
writer.WriteParameter("UserName");
writer.WriteParameter("Email");
writer.WriteEndValues();
Assert.AreEqual(SqlWriterState.EndValues, writer.WriteState);
}
Assert.AreEqual("INSERT INTO [Users] ([Id], [UserName], [Email]) VALUES (@Id, @UserName, @Email)", builder.ToString());
}
public void WriteTable_WhenInsertStatement_WritesTable()
{
StringBuilder builder = new StringBuilder();
using (SqlWriter writer = new SqlWriter(builder))
{
writer.WriteStartInsert();
writer.WriteStartInto();
writer.WriteTable("Users");
Assert.AreEqual(SqlWriterState.StartInto, writer.WriteState);
}
Assert.AreEqual("INSERT INTO [Users]", builder.ToString());
}
public void WriteValue_WhenInsertStatement_WritesValues()
{
StringBuilder builder = new StringBuilder();
using (SqlWriter writer = new SqlWriter(builder))
{
writer.WriteStartInsert();
writer.WriteStartInto();
writer.WriteTable("Users");
writer.WriteColumn("Id");
writer.WriteColumn("UserName");
writer.WriteColumn("Email");
writer.WriteStartValues();
Assert.AreEqual(SqlWriterState.StartValues, writer.WriteState);
writer.WriteValue(15);
writer.WriteValue("My user name.");
writer.WriteValue("*****@*****.**");
writer.WriteEndValues();
Assert.AreEqual(SqlWriterState.EndValues, writer.WriteState);
}
Assert.AreEqual("INSERT INTO [Users] ([Id], [UserName], [Email]) VALUES (15, 'My user name.', '*****@*****.**')", builder.ToString());
}
