/// <summary>
/// Build 'DELETE' command.
/// </summary>
/// <param name="command">The 'DELETE' command.</param>
/// <returns>The DbCommand.</returns>
public DbCommand BuildDeleteCommand(APSqlDeleteCommand command)
{
if (command == null)
throw new ArgumentNullException("command");
return ParseDelete(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 APSqlDeleteCommand from(this APSqlDeleteCommand command, params APSqlFromPhrase[] phrases)
{
if (phrases != null && phrases.Length != 0)
{
command.FromClause = new APSqlFromClause(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 APSqlDeleteCommand from(this APSqlDeleteCommand command, IEnumerable <APSqlFromPhrase> phrases)
{
if (phrases != null)
{
command.FromClause = new APSqlFromClause(phrases);
}
return(command);
}
/// <summary>
/// Build 'DELETE' command.
/// </summary>
/// <param name="command">The 'DELETE' command.</param>
/// <returns>The DbCommand.</returns>
public DbCommand BuildDeleteCommand(APSqlDeleteCommand command)
{
if (command == null)
{
throw new ArgumentNullException("command");
}
return(ParseDelete(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 APSqlDeleteCommand where (this APSqlDeleteCommand 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 APSqlDeleteCommand where (this APSqlDeleteCommand command, APSqlConditionJoinType joinType, IEnumerable <APSqlWherePhrase> phrases)
{
if (phrases != null)
{
command.WhereClause = new APSqlWhereClause(joinType, phrases);
}
else
{
command.WhereClause = null;
}
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 APSqlDeleteCommand from_add(this APSqlDeleteCommand command, params 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 ParseDelete(APSqlDeleteCommand command)
{
StringBuilder sb = new StringBuilder();
OracleCommand dbCmd = new OracleCommand();
using (ParserWriter writer = new ParserWriter(sb, command.CommandNameSuitable))
{
WriteDelete(writer, command);
writer.Idented++;
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 APSqlDeleteCommand where_or(this APSqlDeleteCommand 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 'FROM' clause extensions.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="clause">The 'FROM' clause.</param>
/// <returns>The command.</returns>
public static APSqlDeleteCommand from(this APSqlDeleteCommand command, APSqlFromClause clause)
{
command.FromClause = clause;
return(command);
}
/// <summary> /// Parse 'DELETE' command. /// </summary> /// <param name="command">The 'DELETE' command.</param> /// <returns>The DbCommand.</returns> protected abstract DbCommand ParseDelete(APSqlDeleteCommand command);
private void WriteDelete(ParserWriter writer, APSqlDeleteCommand command)
{
writer.WriteDirect("DELETE FROM");
writer.Write(command.TableDef.TableName);
}
protected override DbCommand ParseDelete(APSqlDeleteCommand command)
{
StringBuilder sb = new StringBuilder();
SqlCommand dbCmd = new SqlCommand();
using (ParserWriter writer = new ParserWriter(sb, command.CommandNameSuitable))
{
WriteDelete(writer, command);
writer.Idented++;
WriteFrom(writer, command.FromClause, dbCmd);
WriteWhere(writer, command.WhereClause, dbCmd);
}
dbCmd.CommandText = sb.ToString();
return dbCmd;
}
/// <summary>
/// Execute.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="db">The database.</param>
public static void execute(this APSqlDeleteCommand 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 APSqlDeleteCommand from(this APSqlDeleteCommand command, APSqlFromPhrase phrase)
{
command.FromClause = new APSqlFromClause(phrase);
return(command);
}
/// <summary> /// Build 'DELETE' command. /// </summary> /// <param name="command">The 'DELETE' command.</param> /// <returns>The DbCommand.</returns> public abstract DbCommand BuildDeleteCommand(APSqlDeleteCommand command);
/// <summary>
/// Build 'DELETE' command.
/// </summary>
/// <param name="command">The 'DELETE' command.</param>
/// <returns>The DbCommand.</returns>
public override DbCommand BuildDeleteCommand(APSqlDeleteCommand command)
{
return(_parser.BuildDeleteCommand(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 APSqlDeleteCommand where (this APSqlDeleteCommand command, APSqlWherePhrase phrase)
{
command.WhereClause = new APSqlWhereClause(phrase);
return(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 APSqlDeleteCommand where (this APSqlDeleteCommand command, APSqlWhereClause clause)
{
command.WhereClause = clause;
return(command);
}
private void WriteDelete(ParserWriter writer, APSqlDeleteCommand command)
{
writer.WriteDirect("DELETE FROM");
writer.Write(command.TableDef.TableName);
}
/// <summary> /// Parse 'DELETE' command. /// </summary> /// <param name="command">The 'DELETE' command.</param> /// <returns>The DbCommand.</returns> protected abstract DbCommand ParseDelete(APSqlDeleteCommand command);
/// <summary>
/// Build 'DELETE' command.
/// </summary>
/// <param name="command">The 'DELETE' command.</param>
/// <returns>The DbCommand.</returns>
public override DbCommand BuildDeleteCommand(APSqlDeleteCommand command)
{
return _parser.BuildDeleteCommand(command);
}
/// <summary> /// Build 'DELETE' command. /// </summary> /// <param name="command">The 'DELETE' command.</param> /// <returns>The DbCommand.</returns> public abstract DbCommand BuildDeleteCommand(APSqlDeleteCommand command);