public void generateInsertSqlString_ReturnsProperString_ForManyElements()
{
DbStringBuilder builder = new DbStringBuilder();
builder.DbAppendix = "fx";
builder.Add("Value", 1);
builder.Add("Name", "abc");
builder.Add("Date", new DateTime(2017, 3, 12));
builder.Add("IsActive", true);
string expected = "INSERT INTO fx.{0}(Value, Name, Date, IsActive) VALUES(1, 'abc', '2017-03-12 00:00:00', 1);";
Assert.AreEqual(expected, builder.GenerateInsertSqlString());
}
public void generateUpdateSqlString_ReturnsProperString_ForManyElements()
{
DbStringBuilder builder = new DbStringBuilder();
builder.Add("Value", 1);
builder.Add("Name", "abc");
builder.Add("Date", new DateTime(2017, 3, 12));
builder.Add("IsActive", true);
builder.AddWhere("Id", 1);
string expected = "UPDATE {0} SET Value = 1, Name = 'abc', Date = '2017-03-12 00:00:00', IsActive = 1 WHERE Id = 1;";
string actual = builder.GenerateUpdateSqlString();
Assert.AreEqual(expected, actual);
}
public void afterClearing_dictionaryIsEmpty()
{
DbStringBuilder builder = new DbStringBuilder();
builder.Add("key", "1");
builder.Clear();
Assert.AreEqual(0, builder.CountElements());
}
public void generateInsertSqlString_ReturnsProperString_ForSingleElementAndEmptyDbAppendix()
{
DbStringBuilder builder = new DbStringBuilder();
builder.DbAppendix = string.Empty;
builder.Add("Value", 1);
string expected = "INSERT INTO {0}(Value) VALUES(1);";
Assert.AreEqual(expected, builder.GenerateInsertSqlString());
}
public void afterAddingElementByKeyAndDatetimeValue_DictionaryHasThisElement()
{
DbStringBuilder builder = new DbStringBuilder();
string key = "key";
DateTime added = new DateTime(2017, 4, 21);
string expected = "'2017-04-21 00:00:00'";
builder.Add(key, added);
string value = builder.getValue(key);
Assert.AreEqual(expected, value);
}
public void afterAddingElementByKeyAndBooleanValue_DictionaryHasThisElement()
{
DbStringBuilder builder = new DbStringBuilder();
string key = "key";
bool added = true;
string expected = "1";
builder.Add(key, added);
string value = builder.getValue(key);
Assert.AreEqual(expected, value);
}
public void afterAddingElementByKeyAndDoubleValue_DictionaryHasThisElement()
{
DbStringBuilder builder = new DbStringBuilder();
string key = "key";
double added = 1.23456789;
string expected = "1.23457";
builder.Add(key, added);
string value = builder.getValue(key);
Assert.AreEqual(expected, value);
}
public void generateUpdateSqlString_ReturnsProperString_ForSingleElement()
{
DbStringBuilder builder = new DbStringBuilder();
builder.DbAppendix = "fx";
builder.Add("Value", 1);
builder.AddWhere("Id", 1);
string expected = "UPDATE fx.{0} SET Value = 1 WHERE Id = 1;";
Assert.AreEqual(expected, builder.GenerateUpdateSqlString());
}
public void getValue_returnProperValue_ForExistingItem()
{
DbStringBuilder builder = new DbStringBuilder();
string key = "a";
int value = 1;
string expected = "1";
builder.Add(key, value);
string actual = builder.getValue(key);
Assert.AreEqual(expected, actual);
}
public void generateUpdateSqlString_ReturnsProperString_ForSingleElementAndEmptyDbAppendix()
{
DbStringBuilder builder = new DbStringBuilder();
builder.DbAppendix = string.Empty;
builder.Add("Value", 1);
builder.AddWhere("Id", 1);
string expected = "UPDATE {0} SET Value = 1 WHERE Id = 1;";
string actual = builder.GenerateUpdateSqlString();
Assert.AreEqual(expected, actual);
}
