public virtual string GetDeleteSQL(string table, Dictionary <string, object> filters = null)
{
ICriteria criteria = GetNewCriteria();
if (filters != null)
{
foreach (string col in filters.Keys)
{
criteria.AddEqualTo("\"" + col + "\"", filters[col]);
}
}
return(string.Format(DeleteFormat, "\"" + table + "\"", criteria.GetClauses()));
}
public virtual string GetUpdateSQL(string table, Dictionary <string, object> values, Dictionary <string, object> filters = null)
{
ICriteria criteria = GetNewCriteria();
if (filters != null)
{
foreach (string col in filters.Keys)
{
criteria.AddEqualTo("\"" + col + "\"", filters[col]);
}
}
string sets = string.Join(", ", values.Keys.Select(key => "\"" + key + "\" = " + criteria.ParseFormatValue(values[key])));
return(string.Format(UpdateFormat, "\"" + table + "\"", sets, criteria.GetClauses()));
}
public virtual string GetSelectSQL(string table, List <string> columns = null, Dictionary <string, object> filters = null)
{
string cols = "*";
if (columns != null && columns.Count > 0)
{
cols = string.Join(",", columns.Select(column => "\"" + column + "\""));
}
ICriteria criteria = GetNewCriteria();
if (filters != null)
{
foreach (string col in filters.Keys)
{
criteria.AddEqualTo("\"" + col + "\"", filters[col]);
}
}
return(string.Format(SelectFormat, "\"" + table + "\"", cols, criteria.GetClauses()));
}
