public SqliteDataReader Update(SQLStatement sqlStatement)
{
if (sqlStatement == null)
{
return(null);
}
string sql = string.Format(
"UPDATE {0} SET {1} WHERE {2}"
, sqlStatement.tableName, sqlStatement.GetUpdateFields(), sqlStatement.GetConditions());
return(Execute(sql));
}
public SqliteDataReader Delete(SQLStatement sqlStatement)
{
if (sqlStatement == null)
{
return(null);
}
string sql = string.Format(
"DELETE FROM {0} WHERE {1}"
, sqlStatement.tableName, sqlStatement.GetConditions());
return(Execute(sql));
}
public SqliteDataReader Query(SQLStatement sqlStatement)
{
if (sqlStatement == null)
{
return(null);
}
StringBuilder sql = new StringBuilder();
sql.Append(string.Format(
"SELECT {0} FROM {1}"
, sqlStatement.GetSelectFields(), sqlStatement.tableName));
string conditions = sqlStatement.GetConditions();
if (!string.IsNullOrEmpty(conditions))
{
sql.Append(" WHERE ");
sql.Append(conditions);
}
string groupBy = sqlStatement.GetGroupByFields();
if (!string.IsNullOrEmpty(groupBy))
{
sql.Append(" GROUP BY ");
sql.Append(groupBy);
}
string orderBy = sqlStatement.GetOrderByFields();
if (!string.IsNullOrEmpty(orderBy))
{
sql.Append(" ORDER BY ");
sql.Append(orderBy);
}
string limit = sqlStatement.GetLimit();
if (!string.IsNullOrEmpty(limit))
{
sql.Append(" LIMIT ");
sql.Append(limit);
}
return(Execute(sql.ToString()));
}