From 5e7acf14a48e8ba1d57e460d686e89d49213e31b Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Thu, 17 Sep 2020 18:15:42 -0400 Subject: new docs WIP This WIP is part of the final push for 1.4's docs to fully "2.0-ize" what we can, and have it all ready. So far this includes a rewrite of the 2.0 migration, set up for the 1.4 /2.0 docs style, and a total redesign of the index page using a new flex layout in zzzeeksphinx. It also reworks some of the API reference sections to have more subheaders. zzzeeksphinx is also enhanced to provide automatic summaries for all api doc section. Change-Id: I01d360cb9c8749520246b96ee6496143c6037918 --- lib/sqlalchemy/sql/elements.py | 25 +++++++++++++++++-------- 1 file changed, 17 insertions(+), 8 deletions(-) (limited to 'lib/sqlalchemy/sql/elements.py') diff --git a/lib/sqlalchemy/sql/elements.py b/lib/sqlalchemy/sql/elements.py index dc3e5f476..59f3fa86b 100644 --- a/lib/sqlalchemy/sql/elements.py +++ b/lib/sqlalchemy/sql/elements.py @@ -1641,12 +1641,9 @@ class TextClause( t = text("EXEC my_procedural_thing()").\ execution_options(autocommit=True) - Note that SQLAlchemy's usual "autocommit" behavior applies to - :func:`_expression.text` constructs implicitly - that is, - statements which begin - with a phrase such as ``INSERT``, ``UPDATE``, ``DELETE``, - or a variety of other phrases specific to certain backends, will - be eligible for autocommit if no transaction is in progress. + .. deprecated:: 1.4 The "autocommit" execution option is deprecated + and will be removed in SQLAlchemy 2.0. See + :ref:`migration_20_autocommit` for discussion. :param text: the text of the SQL statement to be created. Use ``:`` @@ -3401,12 +3398,18 @@ class CollectionAggregate(UnaryExpression): # mysql '5 = ANY (SELECT value FROM table)' expr = 5 == any_(select(table.c.value)) - .. versionadded:: 1.1 + The operator is more conveniently available from any + :class:`_sql.ColumnElement` object that makes use of the + :class:`_types.ARRAY` datatype:: + + expr = mytable.c.somearray.any(5) .. seealso:: :func:`_expression.all_` + :meth:`_types.ARRAY.any` + """ expr = coercions.expect(roles.ExpressionElementRole, expr) @@ -3432,12 +3435,18 @@ class CollectionAggregate(UnaryExpression): # mysql '5 = ALL (SELECT value FROM table)' expr = 5 == all_(select(table.c.value)) - .. versionadded:: 1.1 + The operator is more conveniently available from any + :class:`_sql.ColumnElement` object that makes use of the + :class:`_types.ARRAY` datatype:: + + expr = mytable.c.somearray.all(5) .. seealso:: :func:`_expression.any_` + :meth:`_types.ARRAY.Comparator.all` + """ expr = coercions.expect(roles.ExpressionElementRole, expr) -- cgit v1.2.1