public static void SetFormatShouldOutputSqlSetter()
{
SetFormat set = new SetFormat();
set.AddAssignment("monkey", "blah");
set.AddAssignment("gorilla", "dksl");
Expect.AreEqual(2, set.Parameters.Length);
Out(set.Parse());
}
public static void FormatPartsShouldTrackParameters()
{
SetFormat setFormat = new SetFormat();
setFormat.AddAssignment("monkey", "bananas");
setFormat.AddAssignment("blah", "kasdfl");
Expect.AreEqual(1, setFormat.StartNumber);
Expect.AreEqual(3, setFormat.NextNumber);
Out(setFormat.Parse());
}
public static void SetFormatShouldTakeStartNumber()
{
SetFormat set = new SetFormat();
set.AddAssignment("monkey", "blah");
set.AddAssignment("gorilla", "dksl");
set.AddAssignment("blah", "dflkae");
Expect.AreEqual(3, set.Parameters.Length);
set.StartNumber = 5;
Expect.AreEqual(8, set.NextNumber);
Out(set.Parse());
}
public static void FormatPartsShouldHaveValidStartAndEnd()
{
SetFormat setFormat = new SetFormat();
setFormat.AddAssignment("monkey", "bananas");
Expect.AreEqual(1, setFormat.StartNumber);
Expect.AreEqual(2, setFormat.NextNumber);
Out(setFormat.Parse());
}
public static SetFormat GetSetFormat(string tableName, StringBuilder stringBuilder, int?startNumber, params AssignValue[] values)
{
SetFormat set = new SetFormat();
set.ColumnNameFormatter = (c) => c;
set.ParameterPrefix = "@";
foreach (AssignValue value in values)
{
set.AddAssignment(value);
}
set.StartNumber = startNumber;
stringBuilder.Append(set.Parse());
return(set);
}
