public void TestSqlInsertCreater()
{
string expected = "INSERT INTO Test (field1,field2) VALUES (10,20)";
List <SqlFieldValuePair> fieldValuePairs = new List <SqlFieldValuePair>()
{
new SqlFieldValuePair(
new KeyValuePair <string, object>("field1", 10), SqlCompareOperator.Equal),
new SqlFieldValuePair(
new KeyValuePair <string, object>("field2", 20), SqlCompareOperator.Equal),
};
string result = SqlCommandCreater.CreateInsertCommand("Test", fieldValuePairs);
Assert.AreEqual(expected, result);
}
public void TestSqlSelectCreator()
{
string expected = "SELECT * FROM Test";
string result = SqlCommandCreater.CreateSelectCommand("Test");
Assert.AreEqual(result, expected);
expected = "SELECT field1,field2,field3 FROM Test";
List <string> fields = new List <string>
{
"field1",
"field2",
"field3"
};
result = SqlCommandCreater.CreateSelectCommand("Test", fields);
Assert.AreEqual(result, expected);
expected = "SELECT field1,field2,field3 " +
"FROM Test " +
"WHERE field1=10 AND field2=20 OR field3=40";
List <SqlFieldValuePair> fieldvaluepairs = new List <SqlFieldValuePair>()
{
new SqlFieldValuePair(
new KeyValuePair <string, object>("field1", 10),
SqlCompareOperator.Equal),
new SqlFieldValuePair(
new KeyValuePair <string, object>("field2", 20),
SqlCompareOperator.Equal),
new SqlFieldValuePair(
new KeyValuePair <string, object>("field3", 40),
SqlCompareOperator.Equal),
};
List <SqlConditions> conditions = new List <SqlConditions>()
{
SqlConditions.AND,
SqlConditions.OR,
};
result = SqlCommandCreater.CreateSelectCommand("Test",
fields,
fieldvaluepairs,
conditions);
Assert.AreEqual(expected, result);
expected = "SELECT field1,field2,field3 " +
"FROM Test " +
"WHERE field1=10 AND field2=20 AND field3=40";
result = SqlCommandCreater.CreateSelectCommand("Test", fields, fieldvaluepairs, SqlConditions.AND);
Assert.AreEqual(expected, result);
}
private string CreateCommand()
{
var row = dataGridView_AddRow.Rows[0];
List <SqlFieldValuePair> pairs = new List <SqlFieldValuePair>();
foreach (DataGridViewColumn column in dataGridView_AddRow.Columns)
{
int index = column.Index;
if (row.Cells[index].Value != null)
{
pairs.Add(new SqlFieldValuePair(
new KeyValuePair <string, object>(column.Name, row.Cells[index]), SqlCompareOperator.Equal));
}
}
return(SqlCommandCreater.CreateInsertCommand(CurrentTable.Name, pairs));
}
public void TestSqlUpdateCreater()
{
string expected = "UPDATE Test SET field1=10,field2=20";
List <SqlFieldValuePair> fieldValuePairs = new List <SqlFieldValuePair>()
{
new SqlFieldValuePair(
new KeyValuePair <string, object>("field1", 10), SqlCompareOperator.Equal),
new SqlFieldValuePair(
new KeyValuePair <string, object>("field2", 20), SqlCompareOperator.Equal),
};
List <SqlFieldValuePair> whereConditions = new List <SqlFieldValuePair>()
{
new SqlFieldValuePair(
new KeyValuePair <string, object>("field1", 20), SqlCompareOperator.Bigger),
new SqlFieldValuePair(
new KeyValuePair <string, object>("field2", 30), SqlCompareOperator.NotEqual),
};
string result = SqlCommandCreater.CreateUpdateCommand("Test", fieldValuePairs);
Assert.AreEqual(expected, result);
expected = "UPDATE Test SET field1=10,field2=20 WHERE field1>20 OR field2!=30";
result = SqlCommandCreater.CreateUpdateCommand("Test", fieldValuePairs, whereConditions, SqlConditions.OR);
Assert.AreEqual(expected, result);
}
