Package com.northconcepts.datapipeline.jdbc.sql.delete

Class Delete

java.lang.Object
com.northconcepts.datapipeline.jdbc.sql.SqlPart
com.northconcepts.datapipeline.jdbc.sql.delete.Delete
public class Delete extends SqlPart
Builds a DELETE FROM table WHERE ... statement with its parameter values.

  • Constructor Details

    • Delete

      public Delete(String table)

  • Method Details

    • setPretty

      public Select setPretty(boolean pretty)
      Description copied from class: SqlPart
      Indicates if SqlPart.getSqlFragment() adds line breaks and indentation instead of using one line (default is false).
      Overrides:
      setPretty in class SqlPart

    • getTable

      public String getTable()

    • getCriteria

      public QueryCriteria getCriteria()

    • where

      public Delete where(String criteria, Object... value)
      ANDs a condition, such as "id = ?", and its parameter values with any existing WHERE conditions.

    • collectSqlFragment

      public void collectSqlFragment(CodeWriter writer)
      Description copied from class: SqlPart
      Writes this part's SQL to the writer; used by SqlPart.getSqlFragment() and by enclosing parts.
      Specified by:
      collectSqlFragment in class SqlPart

    • collectParameterValues

      public void collectParameterValues(List<Object> values)
      Description copied from class: SqlPart
      Appends the values for this part's ? parameters to the list in order; adds nothing by default.
      Overrides:
      collectParameterValues in class SqlPart