diff options
Diffstat (limited to 'lib/sqlalchemy/dialects')
53 files changed, 131 insertions, 131 deletions
diff --git a/lib/sqlalchemy/dialects/__init__.py b/lib/sqlalchemy/dialects/__init__.py index 22b47597a..e06eb0995 100644 --- a/lib/sqlalchemy/dialects/__init__.py +++ b/lib/sqlalchemy/dialects/__init__.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php __all__ = ( "firebird", diff --git a/lib/sqlalchemy/dialects/firebird/__init__.py b/lib/sqlalchemy/dialects/firebird/__init__.py index 24a2daad0..d4a054c3b 100644 --- a/lib/sqlalchemy/dialects/firebird/__init__.py +++ b/lib/sqlalchemy/dialects/firebird/__init__.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php from sqlalchemy.dialects.firebird.base import BIGINT from sqlalchemy.dialects.firebird.base import BLOB diff --git a/lib/sqlalchemy/dialects/firebird/base.py b/lib/sqlalchemy/dialects/firebird/base.py index 1f0c66ffb..61e3e4508 100644 --- a/lib/sqlalchemy/dialects/firebird/base.py +++ b/lib/sqlalchemy/dialects/firebird/base.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php r""" @@ -77,7 +77,7 @@ the SQLAlchemy ``returning()`` method, such as:: print(raises.fetchall()) -.. _dialects: http://mc-computing.com/Databases/Firebird/SQL_Dialect.html +.. _dialects: https://mc-computing.com/Databases/Firebird/SQL_Dialect.html """ import datetime @@ -553,7 +553,7 @@ class FBDDLCompiler(sql.compiler.DDLCompiler): """Generate a ``CREATE GENERATOR`` statement for the sequence.""" # no syntax for these - # http://www.firebirdsql.org/manual/generatorguide-sqlsyntax.html + # https://www.firebirdsql.org/manual/generatorguide-sqlsyntax.html if create.element.start is not None: raise NotImplementedError( "Firebird SEQUENCE doesn't support START WITH" @@ -716,7 +716,7 @@ class FBDialect(default.DefaultDialect): def get_table_names(self, connection, schema=None, **kw): # there are two queries commonly mentioned for this. # this one, using view_blr, is at the Firebird FAQ among other places: - # http://www.firebirdfaq.org/faq174/ + # https://www.firebirdfaq.org/faq174/ s = """ select rdb$relation_name from rdb$relations @@ -726,7 +726,7 @@ class FBDialect(default.DefaultDialect): # the other query is this one. It's not clear if there's really # any difference between these two. This link: - # http://www.alberton.info/firebird_sql_meta_info.html#.Ur3vXfZGni8 + # https://www.alberton.info/firebird_sql_meta_info.html#.Ur3vXfZGni8 # states them as interchangeable. Some discussion at [ticket:2898] # SELECT DISTINCT rdb$relation_name # FROM rdb$relation_fields @@ -739,7 +739,7 @@ class FBDialect(default.DefaultDialect): @reflection.cache def get_view_names(self, connection, schema=None, **kw): - # see http://www.firebirdfaq.org/faq174/ + # see https://www.firebirdfaq.org/faq174/ s = """ select rdb$relation_name from rdb$relations @@ -880,7 +880,7 @@ class FBDialect(default.DefaultDialect): # the value comes down as "DEFAULT 'value'": there may be # more than one whitespace around the "DEFAULT" keyword # and it may also be lower case - # (see also http://tracker.firebirdsql.org/browse/CORE-356) + # (see also https://tracker.firebirdsql.org/browse/CORE-356) defexpr = row["fdefault"].lstrip() assert defexpr[:8].rstrip().upper() == "DEFAULT", ( "Unrecognized default value: %s" % defexpr diff --git a/lib/sqlalchemy/dialects/firebird/fdb.py b/lib/sqlalchemy/dialects/firebird/fdb.py index 18ed65f45..4687809df 100644 --- a/lib/sqlalchemy/dialects/firebird/fdb.py +++ b/lib/sqlalchemy/dialects/firebird/fdb.py @@ -3,14 +3,14 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php """ .. dialect:: firebird+fdb :name: fdb :dbapi: pyodbc :connectstring: firebird+fdb://user:password@host:port/path/to/db[?key=value&key=value...] - :url: http://pypi.python.org/pypi/fdb/ + :url: https://pypi.org/project/fdb/ fdb is a kinterbasdb compatible DBAPI for Firebird. @@ -56,7 +56,7 @@ accept every argument that Kinterbasdb does. .. seealso:: - http://pythonhosted.org/fdb/usage-guide.html#retaining-transactions + https://pythonhosted.org/fdb/usage-guide.html#retaining-transactions - information on the "retaining" flag. """ # noqa diff --git a/lib/sqlalchemy/dialects/firebird/kinterbasdb.py b/lib/sqlalchemy/dialects/firebird/kinterbasdb.py index 7c91db639..102222de0 100644 --- a/lib/sqlalchemy/dialects/firebird/kinterbasdb.py +++ b/lib/sqlalchemy/dialects/firebird/kinterbasdb.py @@ -3,14 +3,14 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php """ .. dialect:: firebird+kinterbasdb :name: kinterbasdb :dbapi: kinterbasdb :connectstring: firebird+kinterbasdb://user:password@host:port/path/to/db[?key=value&key=value...] - :url: http://firebirdsql.org/index.php?op=devel&sub=python + :url: https://firebirdsql.org/index.php?op=devel&sub=python Arguments ---------- @@ -29,11 +29,11 @@ In addition, it also accepts the following: .. seealso:: - http://sourceforge.net/projects/kinterbasdb + https://sourceforge.net/projects/kinterbasdb - http://kinterbasdb.sourceforge.net/dist_docs/usage.html#adv_param_conv_dynamic_type_translation + https://kinterbasdb.sourceforge.net/dist_docs/usage.html#adv_param_conv_dynamic_type_translation - http://kinterbasdb.sourceforge.net/dist_docs/usage.html#special_issue_concurrency + https://kinterbasdb.sourceforge.net/dist_docs/usage.html#special_issue_concurrency """ # noqa @@ -142,7 +142,7 @@ class FBDialect_kinterbasdb(FBDialect): initialized = getattr(self.dbapi, "initialized", None) if initialized is None: # CVS rev 1.96 changed the name of the attribute: - # http://kinterbasdb.cvs.sourceforge.net/viewvc/kinterbasdb/ + # https://kinterbasdb.cvs.sourceforge.net/viewvc/kinterbasdb/ # Kinterbasdb-3.0/__init__.py?r1=1.95&r2=1.96 initialized = getattr(self.dbapi, "_initialized", False) if not initialized: diff --git a/lib/sqlalchemy/dialects/mssql/__init__.py b/lib/sqlalchemy/dialects/mssql/__init__.py index d6d0a4711..3aa1e344a 100644 --- a/lib/sqlalchemy/dialects/mssql/__init__.py +++ b/lib/sqlalchemy/dialects/mssql/__init__.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php from . import base # noqa from . import mxodbc # noqa diff --git a/lib/sqlalchemy/dialects/mssql/base.py b/lib/sqlalchemy/dialects/mssql/base.py index 4ca83a697..67d31226c 100644 --- a/lib/sqlalchemy/dialects/mssql/base.py +++ b/lib/sqlalchemy/dialects/mssql/base.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php """ .. dialect:: mssql :name: Microsoft SQL Server @@ -410,7 +410,7 @@ Large Text/Binary Type Deprecation ---------------------------------- Per -`SQL Server 2012/2014 Documentation <http://technet.microsoft.com/en-us/library/ms187993.aspx>`_, +`SQL Server 2012/2014 Documentation <https://technet.microsoft.com/en-us/library/ms187993.aspx>`_, the ``NTEXT``, ``TEXT`` and ``IMAGE`` datatypes are to be removed from SQL Server in a future release. SQLAlchemy normally relates these types to the :class:`.UnicodeText`, :class:`_expression.TextClause` and @@ -740,7 +740,7 @@ following ALTER DATABASE commands executed at the SQL prompt:: ALTER DATABASE MyDatabase SET READ_COMMITTED_SNAPSHOT ON Background on SQL Server snapshot isolation is available at -http://msdn.microsoft.com/en-us/library/ms175095.aspx. +https://msdn.microsoft.com/en-us/library/ms175095.aspx. """ # noqa @@ -790,7 +790,7 @@ from ...util import update_wrapper from ...util.langhelpers import public_factory -# http://sqlserverbuilds.blogspot.com/ +# https://sqlserverbuilds.blogspot.com/ MS_2017_VERSION = (14,) MS_2016_VERSION = (13,) MS_2014_VERSION = (12,) diff --git a/lib/sqlalchemy/dialects/mssql/information_schema.py b/lib/sqlalchemy/dialects/mssql/information_schema.py index eb8f6db5b..fa0386faa 100644 --- a/lib/sqlalchemy/dialects/mssql/information_schema.py +++ b/lib/sqlalchemy/dialects/mssql/information_schema.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php from ... import cast from ... import Column diff --git a/lib/sqlalchemy/dialects/mssql/mxodbc.py b/lib/sqlalchemy/dialects/mssql/mxodbc.py index 637b04869..3f3fe4ed1 100644 --- a/lib/sqlalchemy/dialects/mssql/mxodbc.py +++ b/lib/sqlalchemy/dialects/mssql/mxodbc.py @@ -3,14 +3,14 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php """ .. dialect:: mssql+mxodbc :name: mxODBC :dbapi: mxodbc :connectstring: mssql+mxodbc://<username>:<password>@<dsnname> - :url: http://www.egenix.com/ + :url: https://www.egenix.com/ .. deprecated:: 1.4 The mxODBC DBAPI is deprecated and will be removed in a future version. Please use one of the supported DBAPIs to diff --git a/lib/sqlalchemy/dialects/mssql/pymssql.py b/lib/sqlalchemy/dialects/mssql/pymssql.py index a8361e990..b559384ba 100644 --- a/lib/sqlalchemy/dialects/mssql/pymssql.py +++ b/lib/sqlalchemy/dialects/mssql/pymssql.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php """ .. dialect:: mssql+pymssql @@ -12,7 +12,7 @@ :connectstring: mssql+pymssql://<username>:<password>@<freetds_name>/?charset=utf8 pymssql is a Python module that provides a Python DBAPI interface around -`FreeTDS <http://www.freetds.org/>`_. +`FreeTDS <https://www.freetds.org/>`_. .. note:: diff --git a/lib/sqlalchemy/dialects/mssql/pyodbc.py b/lib/sqlalchemy/dialects/mssql/pyodbc.py index 8c99c1d0b..a27a3c5d0 100644 --- a/lib/sqlalchemy/dialects/mssql/pyodbc.py +++ b/lib/sqlalchemy/dialects/mssql/pyodbc.py @@ -3,13 +3,13 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php r""" .. dialect:: mssql+pyodbc :name: PyODBC :dbapi: pyodbc :connectstring: mssql+pyodbc://<username>:<password>@<dsnname> - :url: http://pypi.python.org/pypi/pyodbc/ + :url: https://pypi.org/project/pyodbc/ Connecting to PyODBC -------------------- @@ -401,11 +401,11 @@ class MSExecutionContext_pyodbc(MSExecutionContext): statement. Background on why "scope_identity()" is preferable to "@@identity": - http://msdn.microsoft.com/en-us/library/ms190315.aspx + https://msdn.microsoft.com/en-us/library/ms190315.aspx Background on why we attempt to embed "scope_identity()" into the same statement as the INSERT: - http://code.google.com/p/pyodbc/wiki/FAQs#How_do_I_retrieve_autogenerated/identity_values? + https://code.google.com/p/pyodbc/wiki/FAQs#How_do_I_retrieve_autogenerated/identity_values? """ diff --git a/lib/sqlalchemy/dialects/mysql/__init__.py b/lib/sqlalchemy/dialects/mysql/__init__.py index 4db05984c..8631ea3b9 100644 --- a/lib/sqlalchemy/dialects/mysql/__init__.py +++ b/lib/sqlalchemy/dialects/mysql/__init__.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php from . import base # noqa from . import cymysql # noqa diff --git a/lib/sqlalchemy/dialects/mysql/aiomysql.py b/lib/sqlalchemy/dialects/mysql/aiomysql.py index 6c77e7525..3275d1888 100644 --- a/lib/sqlalchemy/dialects/mysql/aiomysql.py +++ b/lib/sqlalchemy/dialects/mysql/aiomysql.py @@ -3,7 +3,7 @@ # file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php r""" .. dialect:: mysql+aiomysql :name: aiomysql diff --git a/lib/sqlalchemy/dialects/mysql/base.py b/lib/sqlalchemy/dialects/mysql/base.py index e39010762..9bf12e194 100644 --- a/lib/sqlalchemy/dialects/mysql/base.py +++ b/lib/sqlalchemy/dialects/mysql/base.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php r""" @@ -344,7 +344,7 @@ required. .. seealso:: `The utf8mb4 Character Set \ - <http://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html>`_ - \ + <https://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html>`_ - \ in the MySQL documentation .. _mysql_binary_introducer: @@ -651,7 +651,7 @@ storage engine. .. seealso:: - `CREATE INDEX <http://dev.mysql.com/doc/refman/5.0/en/create-index.html>`_ - MySQL documentation + `CREATE INDEX <https://dev.mysql.com/doc/refman/5.0/en/create-index.html>`_ - MySQL documentation Index Types ~~~~~~~~~~~~~ @@ -672,9 +672,9 @@ type for your MySQL storage engine. More information can be found at: -http://dev.mysql.com/doc/refman/5.0/en/create-index.html +https://dev.mysql.com/doc/refman/5.0/en/create-index.html -http://dev.mysql.com/doc/refman/5.0/en/create-table.html +https://dev.mysql.com/doc/refman/5.0/en/create-table.html Index Parsers ~~~~~~~~~~~~~ @@ -784,7 +784,7 @@ usual need to use a trigger in such a case where server-side update changes are desired. MySQL 5.6 introduced a new flag `explicit_defaults_for_timestamp -<http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html +<https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html #sysvar_explicit_defaults_for_timestamp>`_ which disables the above behavior, and in MySQL 8 this flag defaults to true, meaning in order to get a MySQL "on update timestamp" without changing this flag, the above DDL must be @@ -891,7 +891,7 @@ to be a NOT NULL, even though we did not specify it as such. This behavior of MySQL can be changed on the MySQL side using the `explicit_defaults_for_timestamp -<http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html +<https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html #sysvar_explicit_defaults_for_timestamp>`_ configuration flag introduced in MySQL 5.6. With this server setting enabled, TIMESTAMP columns behave like any other datatype on the MySQL side with regards to defaults and nullability. @@ -1816,7 +1816,7 @@ class MySQLCompiler(compiler.SQLCompiler): elif offset_clause is not None: # As suggested by the MySQL docs, need to apply an # artificial limit if one wasn't provided - # http://dev.mysql.com/doc/refman/5.0/en/select.html + # https://dev.mysql.com/doc/refman/5.0/en/select.html if limit_clause is None: # hardwire the upper limit. Currently # needed by OurSQL with Python 3 @@ -1981,7 +1981,7 @@ class MySQLDDLCompiler(compiler.DDLCompiler): if not column.nullable: colspec.append("NOT NULL") - # see: http://docs.sqlalchemy.org/en/latest/dialects/mysql.html#mysql_timestamp_null # noqa + # see: https://docs.sqlalchemy.org/en/latest/dialects/mysql.html#mysql_timestamp_null # noqa elif column.nullable and is_timestamp: colspec.append("NULL") diff --git a/lib/sqlalchemy/dialects/mysql/cymysql.py b/lib/sqlalchemy/dialects/mysql/cymysql.py index ec9fd6edd..f729e4a18 100644 --- a/lib/sqlalchemy/dialects/mysql/cymysql.py +++ b/lib/sqlalchemy/dialects/mysql/cymysql.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php r""" .. dialect:: mysql+cymysql diff --git a/lib/sqlalchemy/dialects/mysql/enumerated.py b/lib/sqlalchemy/dialects/mysql/enumerated.py index 3b61e4e90..9f9a838c5 100644 --- a/lib/sqlalchemy/dialects/mysql/enumerated.py +++ b/lib/sqlalchemy/dialects/mysql/enumerated.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php import re diff --git a/lib/sqlalchemy/dialects/mysql/json.py b/lib/sqlalchemy/dialects/mysql/json.py index e66fb2986..8d052cc7c 100644 --- a/lib/sqlalchemy/dialects/mysql/json.py +++ b/lib/sqlalchemy/dialects/mysql/json.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php from __future__ import absolute_import diff --git a/lib/sqlalchemy/dialects/mysql/mariadbconnector.py b/lib/sqlalchemy/dialects/mysql/mariadbconnector.py index 6e3a24950..0997abc7a 100644 --- a/lib/sqlalchemy/dialects/mysql/mariadbconnector.py +++ b/lib/sqlalchemy/dialects/mysql/mariadbconnector.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php """ diff --git a/lib/sqlalchemy/dialects/mysql/mysqlconnector.py b/lib/sqlalchemy/dialects/mysql/mysqlconnector.py index 80f20688b..e17da3174 100644 --- a/lib/sqlalchemy/dialects/mysql/mysqlconnector.py +++ b/lib/sqlalchemy/dialects/mysql/mysqlconnector.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php r""" .. dialect:: mysql+mysqlconnector diff --git a/lib/sqlalchemy/dialects/mysql/mysqldb.py b/lib/sqlalchemy/dialects/mysql/mysqldb.py index e1d11a785..72a64d3b8 100644 --- a/lib/sqlalchemy/dialects/mysql/mysqldb.py +++ b/lib/sqlalchemy/dialects/mysql/mysqldb.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php """ @@ -17,7 +17,7 @@ Driver Status ------------- The mysqlclient DBAPI is a maintained fork of the -`MySQL-Python <http://sourceforge.net/projects/mysql-python>`_ DBAPI +`MySQL-Python <https://sourceforge.net/projects/mysql-python>`_ DBAPI that is no longer maintained. `mysqlclient`_ supports Python 2 and Python 3 and is very stable. diff --git a/lib/sqlalchemy/dialects/mysql/oursql.py b/lib/sqlalchemy/dialects/mysql/oursql.py index 06a6115b4..6ec7ce9b9 100644 --- a/lib/sqlalchemy/dialects/mysql/oursql.py +++ b/lib/sqlalchemy/dialects/mysql/oursql.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php """ @@ -11,7 +11,7 @@ :name: OurSQL :dbapi: oursql :connectstring: mysql+oursql://<user>:<password>@<host>[:<port>]/<dbname> - :url: http://packages.python.org/oursql/ + :url: https://packages.python.org/oursql/ .. note:: diff --git a/lib/sqlalchemy/dialects/mysql/pymysql.py b/lib/sqlalchemy/dialects/mysql/pymysql.py index ec8f6ac8e..1d2c3be2d 100644 --- a/lib/sqlalchemy/dialects/mysql/pymysql.py +++ b/lib/sqlalchemy/dialects/mysql/pymysql.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php r""" diff --git a/lib/sqlalchemy/dialects/mysql/pyodbc.py b/lib/sqlalchemy/dialects/mysql/pyodbc.py index 7bc9ff14f..69cc6487d 100644 --- a/lib/sqlalchemy/dialects/mysql/pyodbc.py +++ b/lib/sqlalchemy/dialects/mysql/pyodbc.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php r""" @@ -12,7 +12,7 @@ r""" :name: PyODBC :dbapi: pyodbc :connectstring: mysql+pyodbc://<username>:<password>@<dsnname> - :url: http://pypi.python.org/pypi/pyodbc/ + :url: https://pypi.org/project/pyodbc/ .. note:: diff --git a/lib/sqlalchemy/dialects/mysql/reflection.py b/lib/sqlalchemy/dialects/mysql/reflection.py index a1ad3adfe..503c9614c 100644 --- a/lib/sqlalchemy/dialects/mysql/reflection.py +++ b/lib/sqlalchemy/dialects/mysql/reflection.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php import re diff --git a/lib/sqlalchemy/dialects/mysql/types.py b/lib/sqlalchemy/dialects/mysql/types.py index 3318006e6..dee58b4a5 100644 --- a/lib/sqlalchemy/dialects/mysql/types.py +++ b/lib/sqlalchemy/dialects/mysql/types.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php import datetime diff --git a/lib/sqlalchemy/dialects/oracle/__init__.py b/lib/sqlalchemy/dialects/oracle/__init__.py index a6af7d8c4..3d4aca136 100644 --- a/lib/sqlalchemy/dialects/oracle/__init__.py +++ b/lib/sqlalchemy/dialects/oracle/__init__.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php from . import base # noqa from . import cx_oracle # noqa diff --git a/lib/sqlalchemy/dialects/oracle/base.py b/lib/sqlalchemy/dialects/oracle/base.py index a72088a46..b1d7bc440 100644 --- a/lib/sqlalchemy/dialects/oracle/base.py +++ b/lib/sqlalchemy/dialects/oracle/base.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php r""" .. dialect:: oracle @@ -331,7 +331,7 @@ ON UPDATE CASCADE Oracle doesn't have native ON UPDATE CASCADE functionality. A trigger based solution is available at -http://asktom.oracle.com/tkyte/update_cascade/index.html . +https://asktom.oracle.com/tkyte/update_cascade/index.html . When using the SQLAlchemy ORM, the ORM has limited ability to manually issue cascading updates - specify ForeignKey objects using the @@ -1304,7 +1304,7 @@ class OracleDDLCompiler(compiler.DDLCompiler): # oracle has no ON UPDATE CASCADE - # its only available via triggers - # http://asktom.oracle.com/tkyte/update_cascade/index.html + # https://asktom.oracle.com/tkyte/update_cascade/index.html if constraint.onupdate is not None: util.warn( "Oracle does not contain native UPDATE CASCADE " @@ -1733,7 +1733,7 @@ class OracleDialect(default.DefaultDialect): if dblink: # using user_db_links here since all_db_links appears # to have more restricted permissions. - # http://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_admin005.htm + # https://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_admin005.htm # will need to hear from more users if we are doing # the right thing here. See [ticket:2619] owner = connection.scalar( diff --git a/lib/sqlalchemy/dialects/oracle/cx_oracle.py b/lib/sqlalchemy/dialects/oracle/cx_oracle.py index f007c2b32..60c25e135 100644 --- a/lib/sqlalchemy/dialects/oracle/cx_oracle.py +++ b/lib/sqlalchemy/dialects/oracle/cx_oracle.py @@ -2,7 +2,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php r""" .. dialect:: oracle+cx_oracle @@ -237,7 +237,7 @@ altering the type coercion behavior at the same time. Users of the cx_Oracle dialect are **strongly encouraged** to read through cx_Oracle's list of built-in datatype symbols at -http://cx-oracle.readthedocs.io/en/latest/module.html#database-types. +https://cx-oracle.readthedocs.io/en/latest/api_manual/module.html#database-types. Note that in some cases, significant performance degradation can occur when using these types vs. not, in particular when specifying ``cx_Oracle.CLOB``. diff --git a/lib/sqlalchemy/dialects/postgresql/__init__.py b/lib/sqlalchemy/dialects/postgresql/__init__.py index 108e27c8f..0de84e579 100644 --- a/lib/sqlalchemy/dialects/postgresql/__init__.py +++ b/lib/sqlalchemy/dialects/postgresql/__init__.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php from . import base from . import pg8000 # noqa from . import psycopg2 # noqa diff --git a/lib/sqlalchemy/dialects/postgresql/array.py b/lib/sqlalchemy/dialects/postgresql/array.py index c2d99845f..d8e54ae0c 100644 --- a/lib/sqlalchemy/dialects/postgresql/array.py +++ b/lib/sqlalchemy/dialects/postgresql/array.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php import re diff --git a/lib/sqlalchemy/dialects/postgresql/asyncpg.py b/lib/sqlalchemy/dialects/postgresql/asyncpg.py index 4a191cd28..825558f26 100644 --- a/lib/sqlalchemy/dialects/postgresql/asyncpg.py +++ b/lib/sqlalchemy/dialects/postgresql/asyncpg.py @@ -3,7 +3,7 @@ # file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php r""" .. dialect:: postgresql+asyncpg :name: asyncpg diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py index 4c654a643..ea2eda902 100644 --- a/lib/sqlalchemy/dialects/postgresql/base.py +++ b/lib/sqlalchemy/dialects/postgresql/base.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php r""" .. dialect:: postgresql @@ -288,7 +288,7 @@ via foreign key constraint, a decision must be made as to how the ``.schema`` is represented in those remote tables, in the case where that remote schema name is also a member of the current `PostgreSQL search path -<http://www.postgresql.org/docs/current/static/ddl-schemas.html#DDL-SCHEMAS-PATH>`_. +<https://www.postgresql.org/docs/current/static/ddl-schemas.html#DDL-SCHEMAS-PATH>`_. By default, the PostgreSQL dialect mimics the behavior encouraged by PostgreSQL's own ``pg_get_constraintdef()`` builtin procedure. This function @@ -409,7 +409,7 @@ which is in the ``public`` (i.e. default) schema will always have the .. seealso:: `The Schema Search Path - <http://www.postgresql.org/docs/9.0/static/ddl-schemas.html#DDL-SCHEMAS-PATH>`_ + <https://www.postgresql.org/docs/9.0/static/ddl-schemas.html#DDL-SCHEMAS-PATH>`_ - on the PostgreSQL website. INSERT/UPDATE...RETURNING @@ -486,7 +486,7 @@ and :meth:`~.postgresql.Insert.on_conflict_do_nothing`: .. seealso:: `INSERT .. ON CONFLICT - <http://www.postgresql.org/docs/current/static/sql-insert.html#SQL-ON-CONFLICT>`_ + <https://www.postgresql.org/docs/current/static/sql-insert.html#SQL-ON-CONFLICT>`_ - in the PostgreSQL documentation. Specifying the Target @@ -830,7 +830,7 @@ Operator Classes PostgreSQL allows the specification of an *operator class* for each column of an index (see -http://www.postgresql.org/docs/8.3/interactive/indexes-opclass.html). +https://www.postgresql.org/docs/8.3/interactive/indexes-opclass.html). The :class:`.Index` construct allows these to be specified via the ``postgresql_ops`` keyword argument:: @@ -872,7 +872,7 @@ Index Types PostgreSQL provides several index types: B-Tree, Hash, GiST, and GIN, as well as the ability for users to create their own (see -http://www.postgresql.org/docs/8.3/static/indexes-types.html). These can be +https://www.postgresql.org/docs/8.3/static/indexes-types.html). These can be specified on :class:`.Index` using the ``postgresql_using`` keyword argument:: Index('my_index', my_table.c.data, postgresql_using='gin') @@ -1039,7 +1039,7 @@ dialect in conjunction with the :class:`_schema.Table` construct: .. seealso:: `PostgreSQL CREATE TABLE options - <http://www.postgresql.org/docs/current/static/sql-createtable.html>`_ + <https://www.postgresql.org/docs/current/static/sql-createtable.html>`_ .. _postgresql_table_valued_overview: @@ -3185,7 +3185,7 @@ class PGDialect(default.DefaultDialect): # psycopg2, others may have placed ENUM here as well self.colspecs.pop(ENUM, None) - # http://www.postgresql.org/docs/9.3/static/release-9-2.html#AEN116689 + # https://www.postgresql.org/docs/9.3/static/release-9-2.html#AEN116689 self.supports_smallserial = self.server_version_info >= (9, 2) if self.server_version_info < (8, 2): @@ -3942,7 +3942,7 @@ class PGDialect(default.DefaultDialect): n.oid = c.relnamespace ORDER BY 1 """ - # http://www.postgresql.org/docs/9.0/static/sql-createtable.html + # https://www.postgresql.org/docs/9.0/static/sql-createtable.html FK_REGEX = re.compile( r"FOREIGN KEY \((.*?)\) REFERENCES (?:(.*?)\.)?(.*?)\((.*?)\)" r"[\s]?(MATCH (FULL|PARTIAL|SIMPLE)+)?" @@ -4031,7 +4031,7 @@ class PGDialect(default.DefaultDialect): def _pg_index_any(self, col, compare_to): if self.server_version_info < (8, 1): - # http://www.postgresql.org/message-id/10279.1124395722@sss.pgh.pa.us + # https://www.postgresql.org/message-id/10279.1124395722@sss.pgh.pa.us # "In CVS tip you could replace this with "attnum = ANY (indkey)". # Unfortunately, most array support doesn't work on int2vector in # pre-8.1 releases, so I think you're kinda stuck with the above diff --git a/lib/sqlalchemy/dialects/postgresql/dml.py b/lib/sqlalchemy/dialects/postgresql/dml.py index c98bc9f76..bb6345cf4 100644 --- a/lib/sqlalchemy/dialects/postgresql/dml.py +++ b/lib/sqlalchemy/dialects/postgresql/dml.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php from . import ext from ... import util diff --git a/lib/sqlalchemy/dialects/postgresql/ext.py b/lib/sqlalchemy/dialects/postgresql/ext.py index 959e6597b..f9e4c1d6c 100644 --- a/lib/sqlalchemy/dialects/postgresql/ext.py +++ b/lib/sqlalchemy/dialects/postgresql/ext.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php from .array import ARRAY from ... import util @@ -92,7 +92,7 @@ class ExcludeConstraint(ColumnCollectionConstraint): Defines an EXCLUDE constraint as described in the `PostgreSQL documentation`__. - __ http://www.postgresql.org/docs/9.0/static/sql-createtable.html#SQL-CREATETABLE-EXCLUDE + __ https://www.postgresql.org/docs/9.0/static/sql-createtable.html#SQL-CREATETABLE-EXCLUDE """ # noqa diff --git a/lib/sqlalchemy/dialects/postgresql/hstore.py b/lib/sqlalchemy/dialects/postgresql/hstore.py index cfd94b9b3..30e2d4bc2 100644 --- a/lib/sqlalchemy/dialects/postgresql/hstore.py +++ b/lib/sqlalchemy/dialects/postgresql/hstore.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php import re diff --git a/lib/sqlalchemy/dialects/postgresql/json.py b/lib/sqlalchemy/dialects/postgresql/json.py index 1b165630c..2277d3cbe 100644 --- a/lib/sqlalchemy/dialects/postgresql/json.py +++ b/lib/sqlalchemy/dialects/postgresql/json.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php from __future__ import absolute_import from ... import types as sqltypes diff --git a/lib/sqlalchemy/dialects/postgresql/pg8000.py b/lib/sqlalchemy/dialects/postgresql/pg8000.py index 7230c2ce2..3d1051b7d 100644 --- a/lib/sqlalchemy/dialects/postgresql/pg8000.py +++ b/lib/sqlalchemy/dialects/postgresql/pg8000.py @@ -3,7 +3,7 @@ # file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php r""" .. dialect:: postgresql+pg8000 :name: pg8000 diff --git a/lib/sqlalchemy/dialects/postgresql/psycopg2.py b/lib/sqlalchemy/dialects/postgresql/psycopg2.py index 19ca14265..e28c01f11 100644 --- a/lib/sqlalchemy/dialects/postgresql/psycopg2.py +++ b/lib/sqlalchemy/dialects/postgresql/psycopg2.py @@ -3,13 +3,13 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php r""" .. dialect:: postgresql+psycopg2 :name: psycopg2 :dbapi: psycopg2 :connectstring: postgresql+psycopg2://user:password@host:port/dbname[?key=value&key=value...] - :url: http://pypi.python.org/pypi/psycopg2/ + :url: https://pypi.org/project/psycopg2/ psycopg2 Connect Arguments -------------------------- @@ -110,7 +110,7 @@ using ``host`` as an additional keyword argument:: .. seealso:: `PQconnectdbParams \ - <http://www.postgresql.org/docs/9.1/static/libpq-connect.html#LIBPQ-PQCONNECTDBPARAMS>`_ + <https://www.postgresql.org/docs/9.1/static/libpq-connect.html#LIBPQ-PQCONNECTDBPARAMS>`_ .. _psycopg2_multi_host: @@ -202,7 +202,7 @@ Psycopg2 Fast Execution Helpers Modern versions of psycopg2 include a feature known as `Fast Execution Helpers \ -<http://initd.org/psycopg/docs/extras.html#fast-execution-helpers>`_, which +<https://initd.org/psycopg/docs/extras.html#fast-execution-helpers>`_, which have been shown in benchmarking to improve psycopg2's executemany() performance, primarily with INSERT statements, by multiple orders of magnitude. SQLAlchemy internally makes use of these extensions for ``executemany()`` style @@ -596,7 +596,7 @@ class PGExecutionContext_psycopg2(PGExecutionContext): def create_server_side_cursor(self): # use server-side cursors: - # http://lists.initd.org/pipermail/psycopg/2007-January/005251.html + # https://lists.initd.org/pipermail/psycopg/2007-January/005251.html ident = "c_%s_%s" % (hex(id(self))[2:], hex(_server_side_id())[2:]) return self._dbapi_connection.cursor(ident) diff --git a/lib/sqlalchemy/dialects/postgresql/psycopg2cffi.py b/lib/sqlalchemy/dialects/postgresql/psycopg2cffi.py index 780244be9..5be52a870 100644 --- a/lib/sqlalchemy/dialects/postgresql/psycopg2cffi.py +++ b/lib/sqlalchemy/dialects/postgresql/psycopg2cffi.py @@ -3,13 +3,13 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php r""" .. dialect:: postgresql+psycopg2cffi :name: psycopg2cffi :dbapi: psycopg2cffi :connectstring: postgresql+psycopg2cffi://user:password@host:port/dbname[?key=value&key=value...] - :url: http://pypi.python.org/pypi/psycopg2cffi/ + :url: https://pypi.org/project/psycopg2cffi/ ``psycopg2cffi`` is an adaptation of ``psycopg2``, using CFFI for the C layer. This makes it suitable for use in e.g. PyPy. Documentation diff --git a/lib/sqlalchemy/dialects/postgresql/pygresql.py b/lib/sqlalchemy/dialects/postgresql/pygresql.py index 718bbf78f..42ef3c31e 100644 --- a/lib/sqlalchemy/dialects/postgresql/pygresql.py +++ b/lib/sqlalchemy/dialects/postgresql/pygresql.py @@ -3,13 +3,13 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php """ .. dialect:: postgresql+pygresql :name: pygresql :dbapi: pgdb :connectstring: postgresql+pygresql://user:password@host:port/dbname[?key=value&key=value...] - :url: http://www.pygresql.org/ + :url: https://www.pygresql.org/ .. note:: diff --git a/lib/sqlalchemy/dialects/postgresql/pypostgresql.py b/lib/sqlalchemy/dialects/postgresql/pypostgresql.py index 7d4783867..1d646df44 100644 --- a/lib/sqlalchemy/dialects/postgresql/pypostgresql.py +++ b/lib/sqlalchemy/dialects/postgresql/pypostgresql.py @@ -3,13 +3,13 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php """ .. dialect:: postgresql+pypostgresql :name: py-postgresql :dbapi: pypostgresql :connectstring: postgresql+pypostgresql://user:password@host:port/dbname[?key=value&key=value...] - :url: http://python.projects.pgfoundry.org/ + :url: https://python.projects.pgfoundry.org/ .. note:: diff --git a/lib/sqlalchemy/dialects/postgresql/ranges.py b/lib/sqlalchemy/dialects/postgresql/ranges.py index ab44fa590..f251a04bd 100644 --- a/lib/sqlalchemy/dialects/postgresql/ranges.py +++ b/lib/sqlalchemy/dialects/postgresql/ranges.py @@ -2,7 +2,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php from ... import types as sqltypes @@ -18,7 +18,7 @@ class RangeOperators(object): provided in the ``postgres`` dialect and can likely be used for any range types you create yourself. - __ http://www.postgresql.org/docs/devel/static/functions-range.html + __ https://www.postgresql.org/docs/devel/static/functions-range.html No extra support is provided for the Range Functions listed in Table 9-45 of the PostgreSQL documentation. For these, the normal diff --git a/lib/sqlalchemy/dialects/sqlite/__init__.py b/lib/sqlalchemy/dialects/sqlite/__init__.py index 8b24a19fd..6e3ad0e66 100644 --- a/lib/sqlalchemy/dialects/sqlite/__init__.py +++ b/lib/sqlalchemy/dialects/sqlite/__init__.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php from . import base # noqa from . import pysqlcipher # noqa diff --git a/lib/sqlalchemy/dialects/sqlite/aiosqlite.py b/lib/sqlalchemy/dialects/sqlite/aiosqlite.py index 1d09a619d..eb750b0e7 100644 --- a/lib/sqlalchemy/dialects/sqlite/aiosqlite.py +++ b/lib/sqlalchemy/dialects/sqlite/aiosqlite.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php r""" diff --git a/lib/sqlalchemy/dialects/sqlite/base.py b/lib/sqlalchemy/dialects/sqlite/base.py index 66a556ae0..dc5ebc3f0 100644 --- a/lib/sqlalchemy/dialects/sqlite/base.py +++ b/lib/sqlalchemy/dialects/sqlite/base.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php r""" .. dialect:: sqlite @@ -39,7 +39,7 @@ so that the column continues to have textual affinity. .. seealso:: - `Type Affinity <http://www.sqlite.org/datatype3.html#affinity>`_ - + `Type Affinity <https://www.sqlite.org/datatype3.html#affinity>`_ - in the SQLite documentation .. _sqlite_autoincrement: @@ -47,7 +47,7 @@ so that the column continues to have textual affinity. SQLite Auto Incrementing Behavior ---------------------------------- -Background on SQLite's autoincrement is at: http://sqlite.org/autoinc.html +Background on SQLite's autoincrement is at: https://sqlite.org/autoinc.html Key concepts: @@ -123,7 +123,7 @@ name to be ``INTEGER`` when compiled against SQLite:: :ref:`sqlalchemy.ext.compiler_toplevel` - `Datatypes In SQLite Version 3 <http://sqlite.org/datatype3.html>`_ + `Datatypes In SQLite Version 3 <https://sqlite.org/datatype3.html>`_ .. _sqlite_concurrency: @@ -163,7 +163,7 @@ achieving a high degree of write-concurrency with SQLite is a losing battle. For more information on SQLite's lack of write concurrency by design, please see `Situations Where Another RDBMS May Work Better - High Concurrency -<http://www.sqlite.org/whentouse.html>`_ near the bottom of the page. +<https://www.sqlite.org/whentouse.html>`_ near the bottom of the page. The following subsections introduce areas that are impacted by SQLite's file-based architecture and additionally will usually require workarounds to @@ -176,7 +176,7 @@ Transaction Isolation Level / Autocommit SQLite supports "transaction isolation" in a non-standard way, along two axes. One is that of the -`PRAGMA read_uncommitted <http://www.sqlite.org/pragma.html#pragma_read_uncommitted>`_ +`PRAGMA read_uncommitted <https://www.sqlite.org/pragma.html#pragma_read_uncommitted>`_ instruction. This setting can essentially switch SQLite between its default mode of ``SERIALIZABLE`` isolation, and a "dirty read" isolation mode normally referred to as ``READ UNCOMMITTED``. @@ -201,7 +201,7 @@ of the setting. 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 <http://sqlite.org/lang_transaction.html>`_. A straight +`BEGIN TRANSACTION <https://sqlite.org/lang_transaction.html>`_. A straight ``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, @@ -291,7 +291,7 @@ new connections through the usage of events:: .. seealso:: - `SQLite Foreign Key Support <http://www.sqlite.org/foreignkeys.html>`_ + `SQLite Foreign Key Support <https://www.sqlite.org/foreignkeys.html>`_ - on the SQLite web site. :ref:`event_toplevel` - SQLAlchemy event API. @@ -628,7 +628,7 @@ This lookup table is present within the SQLite dialect as it is for all other dialects. However, the SQLite dialect has a different "fallback" routine for when a particular type name is not located in the lookup map; it instead implements the SQLite "type affinity" scheme located at -http://www.sqlite.org/datatype3.html section 2.1. +https://www.sqlite.org/datatype3.html section 2.1. The provided typemap will make direct associations from an exact string name match for the following types: @@ -1903,12 +1903,12 @@ class SQLiteDialect(default.DefaultDialect): ) self.supports_cast = self.dbapi.sqlite_version_info >= (3, 2, 3) self.supports_multivalues_insert = ( - # http://www.sqlite.org/releaselog/3_7_11.html + # https://www.sqlite.org/releaselog/3_7_11.html self.dbapi.sqlite_version_info >= (3, 7, 11) ) - # see http://www.sqlalchemy.org/trac/ticket/2568 - # as well as http://www.sqlite.org/src/info/600482d161 + # see https://www.sqlalchemy.org/trac/ticket/2568 + # as well as https://www.sqlite.org/src/info/600482d161 self._broken_fk_pragma_quotes = self.dbapi.sqlite_version_info < ( 3, 6, @@ -1940,7 +1940,7 @@ class SQLiteDialect(default.DefaultDialect): if res: value = res[0] else: - # http://www.sqlite.org/changes.html#version_3_3_3 + # https://www.sqlite.org/changes.html#version_3_3_3 # "Optional READ UNCOMMITTED isolation (instead of the # default isolation level of SERIALIZABLE) and # table level locking when database connections @@ -2159,7 +2159,7 @@ class SQLiteDialect(default.DefaultDialect): Internally, SQLite handles this with a 'data type affinity' for each column definition, mapping to one of 'TEXT', 'NUMERIC', 'INTEGER', 'REAL', or 'NONE' (raw bits). The algorithm that determines this is - listed in http://www.sqlite.org/datatype3.html section 2.1. + listed in https://www.sqlite.org/datatype3.html section 2.1. This method allows SQLAlchemy to support that algorithm, while still providing access to smarter reflection utilities by recognizing @@ -2465,7 +2465,7 @@ class SQLiteDialect(default.DefaultDialect): include_auto_indexes = kw.pop("include_auto_indexes", False) for row in pragma_indexes: # ignore implicit primary key index. - # http://www.mail-archive.com/sqlite-users@sqlite.org/msg30517.html + # https://www.mail-archive.com/sqlite-users@sqlite.org/msg30517.html if not include_auto_indexes and row[1].startswith( "sqlite_autoindex" ): @@ -2534,7 +2534,7 @@ class SQLiteDialect(default.DefaultDialect): if not cursor._soft_closed: # work around SQLite issue whereby cursor.description # is blank when PRAGMA returns no rows: - # http://www.sqlite.org/cvstrac/tktview?tn=1884 + # https://www.sqlite.org/cvstrac/tktview?tn=1884 result = cursor.fetchall() else: result = [] diff --git a/lib/sqlalchemy/dialects/sqlite/dml.py b/lib/sqlalchemy/dialects/sqlite/dml.py index a444c34c0..a93e31beb 100644 --- a/lib/sqlalchemy/dialects/sqlite/dml.py +++ b/lib/sqlalchemy/dialects/sqlite/dml.py @@ -2,7 +2,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php from ... import util from ...sql import coercions diff --git a/lib/sqlalchemy/dialects/sqlite/pysqlcipher.py b/lib/sqlalchemy/dialects/sqlite/pysqlcipher.py index aafc00844..3765191c1 100644 --- a/lib/sqlalchemy/dialects/sqlite/pysqlcipher.py +++ b/lib/sqlalchemy/dialects/sqlite/pysqlcipher.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php """ .. dialect:: sqlite+pysqlcipher diff --git a/lib/sqlalchemy/dialects/sqlite/pysqlite.py b/lib/sqlalchemy/dialects/sqlite/pysqlite.py index 8df0037bf..96a5351da 100644 --- a/lib/sqlalchemy/dialects/sqlite/pysqlite.py +++ b/lib/sqlalchemy/dialects/sqlite/pysqlite.py @@ -3,14 +3,14 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php r""" .. dialect:: sqlite+pysqlite :name: pysqlite :dbapi: sqlite3 :connectstring: sqlite+pysqlite:///file_path - :url: http://docs.python.org/library/sqlite3.html + :url: https://docs.python.org/library/sqlite3.html Note that ``pysqlite`` is the same driver as the ``sqlite3`` module included with the Python distribution. @@ -381,7 +381,7 @@ scope is to begin, we emit ``"BEGIN"`` ourselves. When we take control of ``"BEGIN"``, we can also control directly SQLite's locking modes, introduced at -`BEGIN TRANSACTION <http://sqlite.org/lang_transaction.html>`_, +`BEGIN TRANSACTION <https://sqlite.org/lang_transaction.html>`_, by adding the desired locking mode to our ``"BEGIN"``:: @event.listens_for(engine, "begin") @@ -390,13 +390,13 @@ by adding the desired locking mode to our ``"BEGIN"``:: .. seealso:: - `BEGIN TRANSACTION <http://sqlite.org/lang_transaction.html>`_ - + `BEGIN TRANSACTION <https://sqlite.org/lang_transaction.html>`_ - on the SQLite site - `sqlite3 SELECT does not BEGIN a transaction <http://bugs.python.org/issue9924>`_ - + `sqlite3 SELECT does not BEGIN a transaction <https://bugs.python.org/issue9924>`_ - on the Python bug tracker - `sqlite3 module breaks transactions and potentially corrupts data <http://bugs.python.org/issue10740>`_ - + `sqlite3 module breaks transactions and potentially corrupts data <https://bugs.python.org/issue10740>`_ - on the Python bug tracker diff --git a/lib/sqlalchemy/dialects/sybase/__init__.py b/lib/sqlalchemy/dialects/sybase/__init__.py index 5d3eb8290..87a90fb06 100644 --- a/lib/sqlalchemy/dialects/sybase/__init__.py +++ b/lib/sqlalchemy/dialects/sybase/__init__.py @@ -3,7 +3,7 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php from . import base # noqa from . import pyodbc # noqa diff --git a/lib/sqlalchemy/dialects/sybase/base.py b/lib/sqlalchemy/dialects/sybase/base.py index 5b6aefe9e..120093015 100644 --- a/lib/sqlalchemy/dialects/sybase/base.py +++ b/lib/sqlalchemy/dialects/sybase/base.py @@ -3,11 +3,11 @@ # <see AUTHORS file> # get_select_precolumns(), limit_clause() implementation # copyright (C) 2007 Fisch Asset Management -# AG http://www.fam.ch, with coding by Alexander Houben +# AG https://www.fam.ch, with coding by Alexander Houben # alexander.houben@thor-solutions.ch # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php """ diff --git a/lib/sqlalchemy/dialects/sybase/mxodbc.py b/lib/sqlalchemy/dialects/sybase/mxodbc.py index 7002217c0..4e8c8aeab 100644 --- a/lib/sqlalchemy/dialects/sybase/mxodbc.py +++ b/lib/sqlalchemy/dialects/sybase/mxodbc.py @@ -3,14 +3,14 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php """ .. dialect:: sybase+mxodbc :name: mxODBC :dbapi: mxodbc :connectstring: sybase+mxodbc://<username>:<password>@<dsnname> - :url: http://www.egenix.com/ + :url: https://www.egenix.com/ .. note:: diff --git a/lib/sqlalchemy/dialects/sybase/pyodbc.py b/lib/sqlalchemy/dialects/sybase/pyodbc.py index bbaaa7e02..afc315f26 100644 --- a/lib/sqlalchemy/dialects/sybase/pyodbc.py +++ b/lib/sqlalchemy/dialects/sybase/pyodbc.py @@ -3,14 +3,14 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php """ .. dialect:: sybase+pyodbc :name: PyODBC :dbapi: pyodbc :connectstring: sybase+pyodbc://<username>:<password>@<dsnname>[/<database>] - :url: http://pypi.python.org/pypi/pyodbc/ + :url: https://pypi.org/project/pyodbc/ Unicode Support --------------- diff --git a/lib/sqlalchemy/dialects/sybase/pysybase.py b/lib/sqlalchemy/dialects/sybase/pysybase.py index 0c5557e99..0f408e801 100644 --- a/lib/sqlalchemy/dialects/sybase/pysybase.py +++ b/lib/sqlalchemy/dialects/sybase/pysybase.py @@ -3,14 +3,14 @@ # <see AUTHORS file> # # This module is part of SQLAlchemy and is released under -# the MIT License: http://www.opensource.org/licenses/mit-license.php +# the MIT License: https://www.opensource.org/licenses/mit-license.php """ .. dialect:: sybase+pysybase :name: Python-Sybase :dbapi: Sybase :connectstring: sybase+pysybase://<username>:<password>@<dsn>/[database name] - :url: http://python-sybase.sourceforge.net/ + :url: https://python-sybase.sourceforge.net/ Unicode Support --------------- |