/// <summary>
/// 创建 DELETE 命令
/// </summary>
/// <param name="dbQuery">查询语义</param>
/// <param name="token">解析上下文</param>
/// <returns></returns>
protected override RawCommand ResolveDeleteCommand <T>(IDbQueryableInfo_Delete dbQuery, ResolveToken token)
{
ISqlBuilder builder = this.CreateSqlBuilder(token);
var typeRuntime = TypeRuntimeInfoCache.GetRuntimeInfo <T>();
builder.Append("DELETE FROM ");
builder.AppendMember(typeRuntime.TableName, !typeRuntime.IsTemporary);
builder.Append(" t0 ");
if (dbQuery.Entity != null)
{
if (typeRuntime.KeyMembers == null || typeRuntime.KeyMembers.Count == 0)
{
throw new XFrameworkException("Delete<T>(T value) require entity must have key column.");
}
object entity = dbQuery.Entity;
builder.AppendNewLine();
builder.Append("WHERE ");
foreach (var m in typeRuntime.KeyMembers)
{
var column = m.Column;
var value = m.Invoke(entity);
var seg = this.DbValue.GetSqlValue(value, token, column);
builder.AppendMember("t0", m.Member.Name);
builder.Append(" = ");
builder.Append(seg);
builder.Append(" AND ");
}
builder.Length -= 5;
}
else if (dbQuery.Query != null)
{
TableAlias aliases = this.PrepareTableAlias(dbQuery.Query, token);
var cmd = new NpgMappingDbCommand(this, aliases, DbExpressionType.Delete, token)
{
HasMany = dbQuery.Query.HasMany
};
var visitor = new NpgJoinExpressionVisitor(this, aliases, dbQuery.Query.Joins, DbExpressionType.Delete);
visitor.Write(cmd);
var visitor_ = new NpgWhereExpressionVisitor(this, aliases, dbQuery.Query.Where);
visitor_.Write(cmd.WhereFragment);
cmd.AddNavMembers(visitor_.NavMembers);
builder.Append(cmd.CommandText);
}
builder.Append(';');
return(new RawCommand(builder.ToString(), builder.Token != null ? builder.Token.Parameters : null, System.Data.CommandType.Text));
}
/// <summary>
/// 创建 UPDATE 命令
/// </summary>
/// <param name="dbQuery">查询语义</param>
/// <param name="token">解析上下文</param>
/// <returns></returns>
protected override RawCommand ResolveUpdateCommand <T>(IDbQueryableInfo_Update dbQuery, ResolveToken token)
{
ISqlBuilder builder = this.CreateSqlBuilder(token);
var typeRuntime = TypeRuntimeInfoCache.GetRuntimeInfo <T>();
builder.Append("UPDATE ");
builder.AppendMember(typeRuntime.TableName, !typeRuntime.IsTemporary);
builder.Append(" t0 SET");
builder.AppendNewLine();
if (dbQuery.Entity != null)
{
object entity = dbQuery.Entity;
ISqlBuilder seg_Where = this.CreateSqlBuilder(token);
bool useKey = false;
int length = 0;
foreach (var m in typeRuntime.Members)
{
var column = m.Column;
if (column != null && column.IsIdentity)
{
goto gotoLabel; // Fix issue# 自增列同时又是主键
}
if (column != null && column.NoMapped)
{
continue;
}
if (m.ForeignKey != null)
{
continue;
}
if (m.Member.MemberType == System.Reflection.MemberTypes.Method)
{
continue;
}
builder.AppendMember(m.Member.Name);
builder.Append(" = ");
gotoLabel:
var value = m.Invoke(entity);
var seg = this.DbValue.GetSqlValueWidthDefault(value, token, column);
if (column == null || !column.IsIdentity)
{
builder.Append(seg);
length = builder.Length;
builder.Append(',');
builder.AppendNewLine();
}
if (column != null && column.IsKey)
{
useKey = true;
seg_Where.AppendMember(m.Member.Name);
seg_Where.Append(" = ");
seg_Where.Append(seg);
seg_Where.Append(" AND ");
}
}
if (!useKey)
{
throw new XFrameworkException("Update<T>(T value) require T must have key column.");
}
builder.Length = length;
seg_Where.Length -= 5;
builder.AppendNewLine();
builder.Append("WHERE ");
builder.Append(seg_Where);
}
else if (dbQuery.Expression != null)
{
TableAlias aliases = this.PrepareTableAlias(dbQuery.Query, token);
var visitor = new NpgUpdateExpressionVisitor(this, aliases, dbQuery.Expression);
visitor.Write(builder);
var cmd = new NpgMappingDbCommand(this, aliases, DbExpressionType.Update, token)
{
HasMany = dbQuery.Query.HasMany
};
var visitor_ = new NpgJoinExpressionVisitor(this, aliases, dbQuery.Query.Joins, DbExpressionType.Update);
visitor_.Write(cmd);
var visitor__ = new NpgWhereExpressionVisitor(this, aliases, dbQuery.Query.Where);
visitor__.Write(cmd.WhereFragment);
cmd.AddNavMembers(visitor__.NavMembers);
builder.Append(cmd.CommandText);
}
builder.Append(';');
return(new RawCommand(builder.ToString(), builder.Token != null ? builder.Token.Parameters : null, System.Data.CommandType.Text));
}