class documentation

class DeprecatedSelectGenerations(object):

Known subclasses: sqlalchemy.sql.expression.Select

View In Hierarchy

A collection of methods available on _sql.Select, these are all deprecated methods as they modify the _sql.Select object in -place.
Method append​_column Append the given column expression to the columns clause of this select() construct.
Method append​_correlation Append the given correlation expression to this select() construct.
Method append​_from Append the given _expression.FromClause expression to this select() construct's FROM clause.
Method append​_having Append the given expression to this select() construct's HAVING criterion.
Method append​_prefix Append the given columns clause prefix expression to this select() construct.
Method append​_whereclause Append the given expression to this select() construct's WHERE criterion.
@util.deprecated('1.4', 'The :meth:`_expression.Select.append_column` method is deprecated and will be removed in a future release. Use the generative method :meth:`_expression.Select.add_columns`.')
def append_column(self, column):

Append the given column expression to the columns clause of this select() construct.

E.g.:

my_select.append_column(some_table.c.new_column)

This is an in-place mutation method; the _expression.Select.add_columns method is preferred, as it provides standard :term:`method chaining`.

@util.deprecated('1.4', 'The :meth:`_expression.Select.append_correlation` method is deprecated and will be removed in a future release. Use the generative method :meth:`_expression.Select.correlate`.')
def append_correlation(self, fromclause):

Append the given correlation expression to this select() construct.

This is an in-place mutation method; the _expression.Select.correlate method is preferred, as it provides standard :term:`method chaining`.

@util.deprecated('1.4', 'The :meth:`_expression.Select.append_from` method is deprecated and will be removed in a future release. Use the generative method :meth:`_expression.Select.select_from`.')
def append_from(self, fromclause):

Append the given _expression.FromClause expression to this select() construct's FROM clause.

This is an in-place mutation method; the _expression.Select.select_from method is preferred, as it provides standard :term:`method chaining`.

@util.deprecated('1.4', 'The :meth:`_expression.Select.append_having` method is deprecated and will be removed in a future release. Use the generative method :meth:`_expression.Select.having`.')
def append_having(self, having):

Append the given expression to this select() construct's HAVING criterion.

The expression will be joined to existing HAVING criterion via AND.

This is an in-place mutation method; the _expression.Select.having method is preferred, as it provides standard :term:`method chaining`.

@util.deprecated('1.4', 'The :meth:`_expression.Select.append_prefix` method is deprecated and will be removed in a future release. Use the generative method :meth:`_expression.Select.prefix_with`.')
def append_prefix(self, clause):

Append the given columns clause prefix expression to this select() construct.

This is an in-place mutation method; the _expression.Select.prefix_with method is preferred, as it provides standard :term:`method chaining`.

@util.deprecated('1.4', 'The :meth:`_expression.Select.append_whereclause` method is deprecated and will be removed in a future release. Use the generative method :meth:`_expression.Select.where`.')
def append_whereclause(self, whereclause):

Append the given expression to this select() construct's WHERE criterion.

The expression will be joined to existing WHERE criterion via AND.

This is an in-place mutation method; the _expression.Select.where method is preferred, as it provides standard :term:`method chaining`.