Class SQLInsertCompiler

Declaration

Methods

• ▶ def as_sql(self) override

  inherited doc Create the SQL for this query. Return the SQL string and list of parameters.

  source link

  This method overrides django.db.models.sql.compiler.SQLCompiler.as_sql.

  If 'with_limits' is False, any limit/offset information is not included
  in the query.

• ▶ def assemble_as_sql(self, fields, value_rows)

  Take a sequence of N fields and a sequence of M rows of values, and

  source link

  generate placeholder SQL and parameters for each field and value.
  Return a pair containing:
   * a sequence of M rows of N SQL placeholder strings, and
   * a sequence of M rows of corresponding parameter values.
  
  Each placeholder string may contain any number of '%s' interpolation
  strings, and each parameter row will contain exactly as many params
  as the total number of '%s's in the corresponding placeholder row.

• ▶ def execute_sql(self, returning_fields=None) override

  inherited doc Run the query against the database and return the result(s). The return value is a single data item if result_type is SINGLE, or an iterator over the results if the result_type is MULTI.

  source link

  This method overrides django.db.models.sql.compiler.SQLCompiler.execute_sql.

  result_type is either MULTI (use fetchmany() to retrieve all rows),
  SINGLE (only retrieve a single row), or None. In this last case, the
  cursor is returned if any query is executed, since it's used by
  subclasses such as InsertQuery). It's possible, however, that no query
  is needed, as the filters describe an empty set. In that case, None is
  returned, to avoid any unnecessary database interaction.

• ▶ def field_as_sql(self, field, val)

  Take a field and a value intended to be saved on that field, and return placeholder SQL and accompanying params. Check for raw values, expressions, and fields with get_placeholder() defined in that order.

  source link

  When field is None, consider the value raw and use it as the
  placeholder, with no corresponding parameters returned.

• ▷ def pre_save_val(self, field, obj)

  Get the given field's value off the given obj. pre_save() is used for things like auto_now on DateTimeField. Skip it if this is a raw query.

  source link
• ▷ def prepare_value(self, field, value)

  Prepare a value to be used in a query by resolving it if it is an expression and otherwise calling the field's get_db_prep_save().

  source link

Inherited methods

• Methods inherited from django.db.models.sql.compiler.SQLCompiler:
  __init__, apply_converters, as_subquery_condition, collapse_group_by, compile, deferred_to_columns, explain_query, find_ordering_name, get_combinator_sql, get_converters, get_default_columns, get_distinct, get_extra_select, get_from_clause, get_group_by, get_order_by, get_related_selections, get_select, get_select_for_update_of_arguments, has_results, pre_sql_setup, quote_name_unless_alias, results_iter, setup_query

Subclasses

• django.db.backends.mysql.compiler.SQLInsertCompiler

Generated by nedoc v0.9 at 2020-12-29 14:04