/// <summary>
/// Build 'UPDATE' command.
/// </summary>
/// <param name="command">The 'UPDATE' command.</param>
/// <returns>The DbCommand.</returns>
public DbCommand BuildUpdateCommand(APSqlUpdateCommand command)
{
if (command == null)
throw new ArgumentNullException("command");
return ParseUpdate(command);
}
/// <summary>
/// SQL 'FROM' clause extensions.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="phrases">The 'FROM' phrases.</param>
/// <returns>The command.</returns>
public static APSqlUpdateCommand from(this APSqlUpdateCommand command, IEnumerable <APSqlFromPhrase> phrases)
{
if (phrases != null)
{
command.FromClause = new APSqlFromClause(phrases);
}
return(command);
}
/// <summary>
/// SQL 'VALUES' clause extensions.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="phrases">The 'SET' phrases</param>
/// <returns>The command.</returns>
public static APSqlUpdateCommand values(this APSqlUpdateCommand command, IEnumerable <APSqlSetPhrase> phrases)
{
if (phrases != null)
{
command.ValuesClause = new APSqlValuesClause(phrases);
}
return(command);
}
/// <summary>
/// SQL 'FROM' clause extensions.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="phrases">The 'FROM' phrases.</param>
/// <returns>The command.</returns>
public static APSqlUpdateCommand from(this APSqlUpdateCommand command, params APSqlFromPhrase[] phrases)
{
if (phrases != null && phrases.Length != 0)
{
command.FromClause = new APSqlFromClause(phrases);
}
return(command);
}
/// <summary>
/// SQL 'VALUES' clause extensions.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="phrases">The 'SET' phrases</param>
/// <returns>The command.</returns>
public static APSqlUpdateCommand values(this APSqlUpdateCommand command, params APSqlSetPhrase[] phrases)
{
if (phrases != null && phrases.Length != 0)
{
command.ValuesClause = new APSqlValuesClause(phrases);
}
return(command);
}
/// <summary>
/// Build 'UPDATE' command.
/// </summary>
/// <param name="command">The 'UPDATE' command.</param>
/// <returns>The DbCommand.</returns>
public DbCommand BuildUpdateCommand(APSqlUpdateCommand command)
{
if (command == null)
{
throw new ArgumentNullException("command");
}
return(ParseUpdate(command));
}
/// <summary>
/// SQL 'WHERE' phrase extensions.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="joinType">Join type.</param>
/// <param name="phrases">The 'WHERE' phrases.</param>
/// <returns>The command.</returns>
public static APSqlUpdateCommand where (this APSqlUpdateCommand command, APSqlConditionJoinType joinType, params APSqlWherePhrase[] phrases)
{
if (phrases != null && phrases.Length != 0)
{
command.WhereClause = new APSqlWhereClause(joinType, phrases);
}
else
{
command.WhereClause = null;
}
return(command);
}
/// <summary>
/// SQL 'WHERE' phrase extensions.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="joinType">Join type.</param>
/// <param name="phrases">The 'WHERE' phrases.</param>
/// <returns>The command.</returns>
public static APSqlUpdateCommand where (this APSqlUpdateCommand command, APSqlConditionJoinType joinType, IEnumerable <APSqlWherePhrase> phrases)
{
if (phrases != null)
{
command.WhereClause = new APSqlWhereClause(joinType, phrases);
}
else
{
command.WhereClause = null;
}
return(command);
}
/// <summary>
/// SQL 'VALUES' clause extensions. Add new 'SET' in clause.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="phrases">The 'SET' phrases.</param>
/// <returns>The command.</returns>
public static APSqlUpdateCommand set(this APSqlUpdateCommand command, params APSqlSetPhrase[] phrases)
{
if (command.ValuesClause == null || command.ValuesClause.Next == null)
{
command.ValuesClause = new APSqlValuesClause(phrases);
}
else
{
APSqlSetPhrase exist = command.ValuesClause.Last as APSqlSetPhrase;
exist.SetNext(phrases);
}
return(command);
}
/// <summary>
/// SQL 'FROM' clause extensions. Add new 'FROM' in clause.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="phrases">The 'FROM' phrases.</param>
/// <returns>The command.</returns>
public static APSqlUpdateCommand from_add(this APSqlUpdateCommand command, IEnumerable <APSqlFromPhrase> phrases)
{
if (command.FromClause == null || command.FromClause.Next == null)
{
command.FromClause = new APSqlFromClause(phrases);
}
else
{
APSqlFromPhrase exist = command.FromClause.Last as APSqlFromPhrase;
exist.SetNext(phrases);
}
return(command);
}
protected override DbCommand ParseUpdate(APSqlUpdateCommand command)
{
StringBuilder sb = new StringBuilder();
OracleCommand dbCmd = new OracleCommand();
using (ParserWriter writer = new ParserWriter(sb, command.CommandNameSuitable))
{
WriteUpdate(writer, command);
writer.Idented++;
WriteSet(writer, command.ValuesClause, dbCmd);
WriteFrom(writer, command.FromClause, dbCmd);
WriteWhere(writer, command.WhereClause, dbCmd);
}
dbCmd.CommandText = sb.ToString();
return(dbCmd);
}
/// <summary>
/// SQL 'WHERE' phrase extensions. Add new condition join 'OR' with exist condition.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="phrase">The new 'WHERE' phrase.</param>
/// <returns>The command.</returns>
public static APSqlUpdateCommand where_or(this APSqlUpdateCommand command, APSqlWherePhrase phrase)
{
if (command.WhereClause == null || command.WhereClause.Next == null)
{
command.WhereClause = new APSqlWhereClause(phrase);
}
else
{
APSqlWherePhrase exist = command.WhereClause.Next as APSqlWherePhrase;
if (exist is APSqlConditionOrPhrase)
{
(exist as APSqlConditionOrPhrase).Child.Last.SetNext(phrase);
}
else
{
command.WhereClause = new APSqlWhereClause(APSqlConditionJoinType.OR, exist, phrase);
}
}
return(command);
}
/// <summary>
/// SQL 'VALUES' clause extensions. Add new 'SET' in clause.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="assignmentExpr">SQL assignment Expression.</param>
/// <param name="value">Value.</param>
/// <param name="paramName">Parameter name.</param>
/// <returns>The command.</returns>
public static APSqlUpdateCommand set(this APSqlUpdateCommand command, APSqlColumnExpr assignmentExpr, object value, string paramName)
{
return(set(command, new APSqlSetPhrase(assignmentExpr, value, paramName)));
}
/// <summary>
/// SQL 'VALUES' clause extensions.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="clause">The 'VALUES' clause.</param>
/// <returns>The command.</returns>
public static APSqlUpdateCommand values(this APSqlUpdateCommand command, APSqlValuesClause clause)
{
command.ValuesClause = clause;
return(command);
}
/// <summary> /// Parse 'UPDATE' command. /// </summary> /// <param name="command">The 'UPDATE' command.</param> /// <returns>The DbCommand.</returns> protected abstract DbCommand ParseUpdate(APSqlUpdateCommand command);
protected override DbCommand ParseUpdate(APSqlUpdateCommand command)
{
StringBuilder sb = new StringBuilder();
SqlCommand dbCmd = new SqlCommand();
using (ParserWriter writer = new ParserWriter(sb, command.CommandNameSuitable))
{
WriteUpdate(writer, command);
writer.Idented++;
WriteSet(writer, command.ValuesClause, dbCmd);
WriteFrom(writer, command.FromClause, dbCmd);
WriteWhere(writer, command.WhereClause, dbCmd);
}
dbCmd.CommandText = sb.ToString();
return dbCmd;
}
private void WriteUpdate(ParserWriter writer, APSqlUpdateCommand command)
{
writer.WriteDirect("UPDATE");
writer.Write(command.TableDef.TableName);
}
/// <summary>
/// SQL 'VALUES' clause extensions.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="phrase">The 'SET' phrase</param>
/// <returns>The command.</returns>
public static APSqlUpdateCommand values(this APSqlUpdateCommand command, APSqlSetPhrase phrase)
{
command.ValuesClause = new APSqlValuesClause(phrase);
return(command);
}
private void WriteUpdate(ParserWriter writer, APSqlUpdateCommand command)
{
writer.WriteDirect("UPDATE");
writer.Write(command.TableDef.TableName);
}
/// <summary>
/// SQL 'FROM' clause extensions.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="clause">The 'FROM' clause.</param>
/// <returns>The command.</returns>
public static APSqlUpdateCommand from(this APSqlUpdateCommand command, APSqlFromClause clause)
{
command.FromClause = clause;
return(command);
}
/// <summary>
/// SQL 'VALUES' clause extensions. Add new 'SET' in clause.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="assignmentExpr">SQL assignment Expression.</param>
/// <param name="valueExpr">SQL value of assignment Expression.</param>
/// <returns>The command.</returns>
public static APSqlUpdateCommand set(this APSqlUpdateCommand command, APSqlColumnExpr assignmentExpr, IAPSqlValueExpr valueExpr)
{
return(set(command, new APSqlSetPhrase(assignmentExpr, valueExpr)));
}
/// <summary> /// Parse 'UPDATE' command. /// </summary> /// <param name="command">The 'UPDATE' command.</param> /// <returns>The DbCommand.</returns> protected abstract DbCommand ParseUpdate(APSqlUpdateCommand command);
/// <summary> /// Build 'UPDATE' command. /// </summary> /// <param name="command">The 'UPDATE' command.</param> /// <returns>The DbCommand.</returns> public abstract DbCommand BuildUpdateCommand(APSqlUpdateCommand command);
/// <summary>
/// Build 'UPDATE' command.
/// </summary>
/// <param name="command">The 'UPDATE' command.</param>
/// <returns>The DbCommand.</returns>
public override DbCommand BuildUpdateCommand(APSqlUpdateCommand command)
{
return(_parser.BuildUpdateCommand(command));
}
/// <summary>
/// SQL 'WHERE' clause extensions.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="clause">The 'WHERE' clause.</param>
/// <returns>The command.</returns>
public static APSqlUpdateCommand where (this APSqlUpdateCommand command, APSqlWhereClause clause)
{
command.WhereClause = clause;
return(command);
}
/// <summary>
/// SQL 'WHERE' phrase extensions.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="phrase">The 'WHERE' phrase.</param>
/// <returns>The command.</returns>
public static APSqlUpdateCommand where (this APSqlUpdateCommand command, APSqlWherePhrase phrase)
{
command.WhereClause = new APSqlWhereClause(phrase);
return(command);
}
/// <summary>
/// Execute.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="db">The database.</param>
public static void execute(this APSqlUpdateCommand command, APDatabase db)
{
db.ExecuteNonQuery(command);
}
/// <summary>
/// SQL 'FROM' clause extensions.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="phrase">The 'FROM' phrase.</param>
/// <returns>The command.</returns>
public static APSqlUpdateCommand from(this APSqlUpdateCommand command, APSqlFromPhrase phrase)
{
command.FromClause = new APSqlFromClause(phrase);
return(command);
}
/// <summary>
/// Build 'UPDATE' command.
/// </summary>
/// <param name="command">The 'UPDATE' command.</param>
/// <returns>The DbCommand.</returns>
public override DbCommand BuildUpdateCommand(APSqlUpdateCommand command)
{
return _parser.BuildUpdateCommand(command);
}
/// <summary> /// Build 'UPDATE' command. /// </summary> /// <param name="command">The 'UPDATE' command.</param> /// <returns>The DbCommand.</returns> public abstract DbCommand BuildUpdateCommand(APSqlUpdateCommand command);