forked from ThatRendle/Simple.Data
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathDeleteHelper.cs
More file actions
42 lines (36 loc) · 1.31 KB
/
DeleteHelper.cs
File metadata and controls
42 lines (36 loc) · 1.31 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Simple.Data.Ado.Schema;
namespace Simple.Data.Ado
{
internal class DeleteHelper
{
private readonly DatabaseSchema _schema;
private readonly ICommandBuilder _commandBuilder;
private readonly IExpressionFormatter _expressionFormatter;
public DeleteHelper(DatabaseSchema schema)
{
_schema = schema;
_commandBuilder = new CommandBuilder(schema);
_expressionFormatter = new ExpressionFormatter(_commandBuilder, _schema);
}
public ICommandBuilder GetDeleteCommand(string tableName, SimpleExpression criteria)
{
_commandBuilder.Append(GetDeleteClause(tableName));
if (criteria != null)
{
var whereCondition = _expressionFormatter.Format(criteria);
if (!string.IsNullOrEmpty(whereCondition))
_commandBuilder.Append(" where " + whereCondition);
}
return _commandBuilder;
}
private string GetDeleteClause(string tableName)
{
var table = _schema.FindTable(tableName);
return string.Concat("delete from ", table.QualifiedName);
}
}
}