From 7ec092063a7defe2b60d8f01b2eb3cda9dd28c90 Mon Sep 17 00:00:00 2001 From: Lele Gaifax Date: Sun, 30 Dec 2018 21:16:11 -0500 Subject: commit 1b774808c926665047bf353222ecd191679a95d1 Author: Lele Gaifax Date: Tue Dec 25 12:35:41 2018 +0100 Consistently use "PostgreSQL", fixing also a few doc glitches commit 0e382aaee4427193926f0dc10ad29056bc12c85e Author: Lele Gaifax Date: Tue Dec 25 12:08:49 2018 +0100 Remove duplicated words Change-Id: Iaa586b9412f46a50fe6ff3bbb92e07d6cb1905c8 (cherry picked from commit c0f9708fde39175c8695fdd87873464f516fdf98) --- lib/sqlalchemy/dialects/mysql/base.py | 2 +- lib/sqlalchemy/dialects/sqlite/base.py | 2 +- lib/sqlalchemy/sql/sqltypes.py | 8 ++++---- lib/sqlalchemy/testing/plugin/plugin_base.py | 2 +- 4 files changed, 7 insertions(+), 7 deletions(-) (limited to 'lib/sqlalchemy') diff --git a/lib/sqlalchemy/dialects/mysql/base.py b/lib/sqlalchemy/dialects/mysql/base.py index 1b25e1427..a4b8d9b6f 100644 --- a/lib/sqlalchemy/dialects/mysql/base.py +++ b/lib/sqlalchemy/dialects/mysql/base.py @@ -359,7 +359,7 @@ the generative method :meth:`~.mysql.dml.Insert.on_duplicate_key_update`:: conn.execute(on_duplicate_key_stmt) -Unlike Postgresql's "ON CONFLICT" phrase, the "ON DUPLICATE KEY UPDATE" +Unlike PostgreSQL's "ON CONFLICT" phrase, the "ON DUPLICATE KEY UPDATE" phrase will always match on any primary key or unique key, and will always perform an UPDATE if there's a match; there are no options for it to raise an error or to skip performing an UPDATE. diff --git a/lib/sqlalchemy/dialects/sqlite/base.py b/lib/sqlalchemy/dialects/sqlite/base.py index 6e0d430ce..917544c5a 100644 --- a/lib/sqlalchemy/dialects/sqlite/base.py +++ b/lib/sqlalchemy/dialects/sqlite/base.py @@ -189,7 +189,7 @@ The other axis along which SQLite's transactional locking is impacted is via the nature of the ``BEGIN`` statement used. The three varieties are "deferred", "immediate", and "exclusive", as described at `BEGIN TRANSACTION `_. A straight -``BEGIN`` statement uses the "deferred" mode, where the the database file is +``BEGIN`` statement uses the "deferred" mode, where the database file is not locked until the first read or write operation, and read access remains open to other transactions until the first write operation. But again, it is critical to note that the pysqlite driver interferes with this behavior diff --git a/lib/sqlalchemy/sql/sqltypes.py b/lib/sqlalchemy/sql/sqltypes.py index c0cd515b3..fb7720e4a 100644 --- a/lib/sqlalchemy/sql/sqltypes.py +++ b/lib/sqlalchemy/sql/sqltypes.py @@ -1890,13 +1890,13 @@ class JSON(Indexable, TypeEngine): Index operations return an expression object whose type defaults to :class:`.JSON` by default, so that further JSON-oriented instructions may be called upon the result type. Note that there are backend-specific - idiosyncracies here, including that the Postgresql database does not generally + idiosyncracies here, including that the PostgreSQL database does not generally compare a "json" to a "json" structure without type casts. These idiosyncracies - can be accommodated in a backend-neutral way by by making explicit use + can be accommodated in a backend-neutral way by making explicit use of the :func:`.cast` and :func:`.type_coerce` constructs. Comparison of specific index elements of a :class:`.JSON` object - to other objects work best if the **left hand side is CAST to a string** - and the **right hand side is rendered as a json string**; a future SQLAlchemy + to other objects works best if the **left hand side is CAST to a string** + and the **right hand side is rendered as a JSON string**; a future SQLAlchemy feature such as a generic "astext" modifier may simplify this at some point: * **Compare an element of a JSON structure to a string**:: diff --git a/lib/sqlalchemy/testing/plugin/plugin_base.py b/lib/sqlalchemy/testing/plugin/plugin_base.py index 8939ff7c6..0ffcae093 100644 --- a/lib/sqlalchemy/testing/plugin/plugin_base.py +++ b/lib/sqlalchemy/testing/plugin/plugin_base.py @@ -66,7 +66,7 @@ def setup_options(make_option): make_option("--nomemory", action="store_true", dest="nomemory", help="Don't run memory profiling tests") make_option("--postgresql-templatedb", type="string", - help="name of template database to use for Postgresql " + help="name of template database to use for PostgreSQL " "CREATE DATABASE (defaults to current database)") make_option("--low-connections", action="store_true", dest="low_connections", -- cgit v1.2.1