public void configTest()
{
SqlBuilder da = SqlBuilder.getInstance();
Assert.AreEqual("test", da.getTablename("test"));
SqlBuilderConfig config = new SqlBuilderConfig();
config.TableName = "da_{0}";
config.PrimaryKey = "{0}_id";
SqlBuilder da1 = new SqlBuilder(config);
Assert.AreEqual("da_test", da1.getTablename("test"));
}
public void getInsertTest()
{
SqlBuilderConfig config = new SqlBuilderConfig();
config.TableName = "da_{0}";
config.PrimaryKey = "{0}_id";
SqlBuilder da = new SqlBuilder(config);
Dictionary<string, object> dict = new Dictionary<string, object>();
dict["title"] = "是否可行";
dict["question"] = "是否";
dict["answer"] = "是的";
dict["askname"] = "小y";
dict["createtime"] = new SqlLiteral("NOW");
string sql = da.getInsert("zhidao", dict);
Console.Write(sql);
Assert.AreEqual("INSERT INTO da_zhidao (title,question,answer,askname,createtime) VALUES('是否可行','是否','是的','小y',NOW)", sql);
}
public void getSelectTest()
{
SqlBuilderConfig config = new SqlBuilderConfig();
config.TableName = "da_{0}";
config.PrimaryKey = "{0}_id";
SqlBuilder da = new SqlBuilder(config);
string actual;
string expected;
// 1
actual= da.getSelect("item", "", "", "limit 1,2");
expected = "SELECT * FROM da_item limit 1,2";
Assert.AreEqual(expected, actual);
// 2
actual= da.getSelect("item", "id, name, title", "a=1", "order by desc");
expected = "SELECT id, name, title FROM da_item a=1 order by desc";
Console.Write(actual);
Assert.AreEqual(expected, actual);
}
public SqlBuilder(SqlBuilderConfig config)
{
_config = config;
}
public SqlBuilder()
{
_config = new SqlBuilderConfig();
_config.TableName = "{0}";
_config.PrimaryKey = "{0}_id";
}
