summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorFederico Caselli <cfederico87@gmail.com>2021-07-04 19:29:19 +0200
committerFederico Caselli <cfederico87@gmail.com>2021-07-04 20:54:33 +0200
commitfb81f9c8d914f9911925dd3f4e77d7fc374b267c (patch)
treebc41febba7eb8c1fab88909a0a13ee04d4cf505a
parentb920869ef54d05e73e2a980b73647d6050ffeb9d (diff)
downloadsqlalchemy-fb81f9c8d914f9911925dd3f4e77d7fc374b267c.tar.gz
Replace all http:// links to https://
Also replace http://pypi.python.org/pypi with https://pypi.org/project Change-Id: I84b5005c39969a82140706472989f2a30b0c7685
-rw-r--r--.github/CODE_OF_CONDUCT.md2
-rw-r--r--.github/ISSUE_TEMPLATE/bug_report.md4
-rw-r--r--CHANGES2
-rw-r--r--README.rst10
-rw-r--r--doc/build/changelog/changelog_02.rst4
-rw-r--r--doc/build/changelog/changelog_04.rst4
-rw-r--r--doc/build/changelog/changelog_05.rst8
-rw-r--r--doc/build/changelog/changelog_06.rst4
-rw-r--r--doc/build/changelog/changelog_07.rst6
-rw-r--r--doc/build/changelog/changelog_08.rst2
-rw-r--r--doc/build/changelog/changelog_09.rst2
-rw-r--r--doc/build/changelog/migration_04.rst14
-rw-r--r--doc/build/changelog/migration_05.rst10
-rw-r--r--doc/build/changelog/migration_06.rst14
-rw-r--r--doc/build/changelog/migration_07.rst34
-rw-r--r--doc/build/changelog/migration_08.rst2
-rw-r--r--doc/build/changelog/migration_09.rst4
-rw-r--r--doc/build/changelog/migration_10.rst4
-rw-r--r--doc/build/changelog/migration_11.rst4
-rw-r--r--doc/build/changelog/migration_12.rst2
-rw-r--r--doc/build/changelog/migration_13.rst4
-rw-r--r--doc/build/changelog/migration_20.rst16
-rw-r--r--doc/build/conf.py6
-rw-r--r--doc/build/copyright.rst2
-rw-r--r--doc/build/core/connections.rst4
-rw-r--r--doc/build/core/engines.rst4
-rw-r--r--doc/build/core/tutorial.rst2
-rw-r--r--doc/build/dialects/index.rst2
-rw-r--r--doc/build/faq/connections.rst2
-rw-r--r--doc/build/faq/metadata_schema.rst2
-rw-r--r--doc/build/faq/ormconfiguration.rst2
-rw-r--r--doc/build/faq/performance.rst2
-rw-r--r--doc/build/faq/sessions.rst6
-rw-r--r--doc/build/glossary.rst36
-rw-r--r--doc/build/intro.rst10
-rw-r--r--doc/build/orm/cascades.rst2
-rw-r--r--doc/build/orm/contextual.rst8
-rw-r--r--doc/build/orm/examples.rst2
-rw-r--r--doc/build/orm/extensions/associationproxy.rst4
-rw-r--r--doc/build/orm/nonstandard_mappings.rst2
-rw-r--r--doc/build/orm/persistence_techniques.rst2
-rw-r--r--doc/build/orm/session_state_management.rst2
-rw-r--r--doc/build/orm/tutorial.rst4
-rw-r--r--doc/build/orm/versioning.rst6
-rw-r--r--doc/build/tutorial/engine.rst2
-rw-r--r--examples/generic_associations/__init__.py2
-rw-r--r--examples/inheritance/single.py2
-rw-r--r--examples/nested_sets/nested_sets.py2
-rw-r--r--examples/postgis/__init__.py2
-rw-r--r--examples/sharding/__init__.py2
-rw-r--r--lib/sqlalchemy/__init__.py2
-rw-r--r--lib/sqlalchemy/cextension/immutabledict.c2
-rw-r--r--lib/sqlalchemy/cextension/processors.c2
-rw-r--r--lib/sqlalchemy/cextension/resultproxy.c2
-rw-r--r--lib/sqlalchemy/connectors/__init__.py2
-rw-r--r--lib/sqlalchemy/connectors/mxodbc.py4
-rw-r--r--lib/sqlalchemy/connectors/pyodbc.py2
-rw-r--r--lib/sqlalchemy/databases/__init__.py2
-rw-r--r--lib/sqlalchemy/dialects/__init__.py2
-rw-r--r--lib/sqlalchemy/dialects/firebird/__init__.py2
-rw-r--r--lib/sqlalchemy/dialects/firebird/base.py14
-rw-r--r--lib/sqlalchemy/dialects/firebird/fdb.py6
-rw-r--r--lib/sqlalchemy/dialects/firebird/kinterbasdb.py12
-rw-r--r--lib/sqlalchemy/dialects/mssql/__init__.py2
-rw-r--r--lib/sqlalchemy/dialects/mssql/base.py8
-rw-r--r--lib/sqlalchemy/dialects/mssql/information_schema.py2
-rw-r--r--lib/sqlalchemy/dialects/mssql/mxodbc.py4
-rw-r--r--lib/sqlalchemy/dialects/mssql/pymssql.py4
-rw-r--r--lib/sqlalchemy/dialects/mssql/pyodbc.py8
-rw-r--r--lib/sqlalchemy/dialects/mysql/__init__.py2
-rw-r--r--lib/sqlalchemy/dialects/mysql/aiomysql.py2
-rw-r--r--lib/sqlalchemy/dialects/mysql/base.py18
-rw-r--r--lib/sqlalchemy/dialects/mysql/cymysql.py2
-rw-r--r--lib/sqlalchemy/dialects/mysql/enumerated.py2
-rw-r--r--lib/sqlalchemy/dialects/mysql/json.py2
-rw-r--r--lib/sqlalchemy/dialects/mysql/mariadbconnector.py2
-rw-r--r--lib/sqlalchemy/dialects/mysql/mysqlconnector.py2
-rw-r--r--lib/sqlalchemy/dialects/mysql/mysqldb.py4
-rw-r--r--lib/sqlalchemy/dialects/mysql/oursql.py4
-rw-r--r--lib/sqlalchemy/dialects/mysql/pymysql.py2
-rw-r--r--lib/sqlalchemy/dialects/mysql/pyodbc.py4
-rw-r--r--lib/sqlalchemy/dialects/mysql/reflection.py2
-rw-r--r--lib/sqlalchemy/dialects/mysql/types.py2
-rw-r--r--lib/sqlalchemy/dialects/oracle/__init__.py2
-rw-r--r--lib/sqlalchemy/dialects/oracle/base.py8
-rw-r--r--lib/sqlalchemy/dialects/oracle/cx_oracle.py4
-rw-r--r--lib/sqlalchemy/dialects/postgresql/__init__.py2
-rw-r--r--lib/sqlalchemy/dialects/postgresql/array.py2
-rw-r--r--lib/sqlalchemy/dialects/postgresql/asyncpg.py2
-rw-r--r--lib/sqlalchemy/dialects/postgresql/base.py20
-rw-r--r--lib/sqlalchemy/dialects/postgresql/dml.py2
-rw-r--r--lib/sqlalchemy/dialects/postgresql/ext.py4
-rw-r--r--lib/sqlalchemy/dialects/postgresql/hstore.py2
-rw-r--r--lib/sqlalchemy/dialects/postgresql/json.py2
-rw-r--r--lib/sqlalchemy/dialects/postgresql/pg8000.py2
-rw-r--r--lib/sqlalchemy/dialects/postgresql/psycopg2.py10
-rw-r--r--lib/sqlalchemy/dialects/postgresql/psycopg2cffi.py4
-rw-r--r--lib/sqlalchemy/dialects/postgresql/pygresql.py4
-rw-r--r--lib/sqlalchemy/dialects/postgresql/pypostgresql.py4
-rw-r--r--lib/sqlalchemy/dialects/postgresql/ranges.py4
-rw-r--r--lib/sqlalchemy/dialects/sqlite/__init__.py2
-rw-r--r--lib/sqlalchemy/dialects/sqlite/aiosqlite.py2
-rw-r--r--lib/sqlalchemy/dialects/sqlite/base.py32
-rw-r--r--lib/sqlalchemy/dialects/sqlite/dml.py2
-rw-r--r--lib/sqlalchemy/dialects/sqlite/pysqlcipher.py2
-rw-r--r--lib/sqlalchemy/dialects/sqlite/pysqlite.py12
-rw-r--r--lib/sqlalchemy/dialects/sybase/__init__.py2
-rw-r--r--lib/sqlalchemy/dialects/sybase/base.py4
-rw-r--r--lib/sqlalchemy/dialects/sybase/mxodbc.py4
-rw-r--r--lib/sqlalchemy/dialects/sybase/pyodbc.py4
-rw-r--r--lib/sqlalchemy/dialects/sybase/pysybase.py4
-rw-r--r--lib/sqlalchemy/engine/__init__.py2
-rw-r--r--lib/sqlalchemy/engine/base.py7
-rw-r--r--lib/sqlalchemy/engine/create.py4
-rw-r--r--lib/sqlalchemy/engine/cursor.py2
-rw-r--r--lib/sqlalchemy/engine/default.py2
-rw-r--r--lib/sqlalchemy/engine/events.py2
-rw-r--r--lib/sqlalchemy/engine/interfaces.py2
-rw-r--r--lib/sqlalchemy/engine/mock.py2
-rw-r--r--lib/sqlalchemy/engine/reflection.py2
-rw-r--r--lib/sqlalchemy/engine/result.py2
-rw-r--r--lib/sqlalchemy/engine/row.py2
-rw-r--r--lib/sqlalchemy/engine/strategies.py2
-rw-r--r--lib/sqlalchemy/engine/url.py2
-rw-r--r--lib/sqlalchemy/engine/util.py2
-rw-r--r--lib/sqlalchemy/event/__init__.py2
-rw-r--r--lib/sqlalchemy/event/api.py2
-rw-r--r--lib/sqlalchemy/event/attr.py2
-rw-r--r--lib/sqlalchemy/event/base.py2
-rw-r--r--lib/sqlalchemy/event/legacy.py2
-rw-r--r--lib/sqlalchemy/event/registry.py2
-rw-r--r--lib/sqlalchemy/events.py2
-rw-r--r--lib/sqlalchemy/exc.py6
-rw-r--r--lib/sqlalchemy/ext/__init__.py2
-rw-r--r--lib/sqlalchemy/ext/associationproxy.py4
-rw-r--r--lib/sqlalchemy/ext/asyncio/__init__.py2
-rw-r--r--lib/sqlalchemy/ext/asyncio/engine.py2
-rw-r--r--lib/sqlalchemy/ext/asyncio/events.py2
-rw-r--r--lib/sqlalchemy/ext/asyncio/exc.py2
-rw-r--r--lib/sqlalchemy/ext/asyncio/result.py2
-rw-r--r--lib/sqlalchemy/ext/asyncio/scoping.py2
-rw-r--r--lib/sqlalchemy/ext/asyncio/session.py2
-rw-r--r--lib/sqlalchemy/ext/automap.py4
-rw-r--r--lib/sqlalchemy/ext/baked.py2
-rw-r--r--lib/sqlalchemy/ext/compiler.py2
-rw-r--r--lib/sqlalchemy/ext/declarative/__init__.py2
-rw-r--r--lib/sqlalchemy/ext/declarative/extensions.py2
-rw-r--r--lib/sqlalchemy/ext/horizontal_shard.py2
-rw-r--r--lib/sqlalchemy/ext/hybrid.py6
-rw-r--r--lib/sqlalchemy/ext/indexable.py2
-rw-r--r--lib/sqlalchemy/ext/mutable.py2
-rw-r--r--lib/sqlalchemy/ext/mypy/apply.py2
-rw-r--r--lib/sqlalchemy/ext/mypy/decl_class.py2
-rw-r--r--lib/sqlalchemy/ext/mypy/infer.py2
-rw-r--r--lib/sqlalchemy/ext/mypy/names.py2
-rw-r--r--lib/sqlalchemy/ext/mypy/plugin.py2
-rw-r--r--lib/sqlalchemy/ext/orderinglist.py2
-rw-r--r--lib/sqlalchemy/ext/serializer.py2
-rw-r--r--lib/sqlalchemy/future/__init__.py2
-rw-r--r--lib/sqlalchemy/future/orm/__init__.py2
-rw-r--r--lib/sqlalchemy/inspection.py2
-rw-r--r--lib/sqlalchemy/log.py2
-rw-r--r--lib/sqlalchemy/orm/__init__.py2
-rw-r--r--lib/sqlalchemy/orm/attributes.py2
-rw-r--r--lib/sqlalchemy/orm/base.py2
-rw-r--r--lib/sqlalchemy/orm/clsregistry.py2
-rw-r--r--lib/sqlalchemy/orm/collections.py2
-rw-r--r--lib/sqlalchemy/orm/context.py2
-rw-r--r--lib/sqlalchemy/orm/decl_api.py2
-rw-r--r--lib/sqlalchemy/orm/decl_base.py2
-rw-r--r--lib/sqlalchemy/orm/dependency.py2
-rw-r--r--lib/sqlalchemy/orm/descriptor_props.py2
-rw-r--r--lib/sqlalchemy/orm/dynamic.py2
-rw-r--r--lib/sqlalchemy/orm/evaluator.py2
-rw-r--r--lib/sqlalchemy/orm/events.py2
-rw-r--r--lib/sqlalchemy/orm/exc.py2
-rw-r--r--lib/sqlalchemy/orm/identity.py2
-rw-r--r--lib/sqlalchemy/orm/instrumentation.py2
-rw-r--r--lib/sqlalchemy/orm/interfaces.py2
-rw-r--r--lib/sqlalchemy/orm/loading.py2
-rw-r--r--lib/sqlalchemy/orm/mapper.py2
-rw-r--r--lib/sqlalchemy/orm/path_registry.py2
-rw-r--r--lib/sqlalchemy/orm/persistence.py2
-rw-r--r--lib/sqlalchemy/orm/properties.py2
-rw-r--r--lib/sqlalchemy/orm/query.py4
-rw-r--r--lib/sqlalchemy/orm/relationships.py2
-rw-r--r--lib/sqlalchemy/orm/scoping.py2
-rw-r--r--lib/sqlalchemy/orm/session.py4
-rw-r--r--lib/sqlalchemy/orm/state.py2
-rw-r--r--lib/sqlalchemy/orm/strategies.py2
-rw-r--r--lib/sqlalchemy/orm/strategy_options.py2
-rw-r--r--lib/sqlalchemy/orm/sync.py2
-rw-r--r--lib/sqlalchemy/orm/unitofwork.py2
-rw-r--r--lib/sqlalchemy/orm/util.py2
-rw-r--r--lib/sqlalchemy/pool/__init__.py2
-rw-r--r--lib/sqlalchemy/pool/base.py2
-rw-r--r--lib/sqlalchemy/pool/dbapi_proxy.py2
-rw-r--r--lib/sqlalchemy/pool/events.py2
-rw-r--r--lib/sqlalchemy/pool/impl.py2
-rw-r--r--lib/sqlalchemy/processors.py2
-rw-r--r--lib/sqlalchemy/schema.py2
-rw-r--r--lib/sqlalchemy/sql/__init__.py2
-rw-r--r--lib/sqlalchemy/sql/annotation.py2
-rw-r--r--lib/sqlalchemy/sql/base.py2
-rw-r--r--lib/sqlalchemy/sql/coercions.py2
-rw-r--r--lib/sqlalchemy/sql/compiler.py2
-rw-r--r--lib/sqlalchemy/sql/crud.py2
-rw-r--r--lib/sqlalchemy/sql/ddl.py4
-rw-r--r--lib/sqlalchemy/sql/default_comparator.py2
-rw-r--r--lib/sqlalchemy/sql/dml.py2
-rw-r--r--lib/sqlalchemy/sql/elements.py2
-rw-r--r--lib/sqlalchemy/sql/events.py2
-rw-r--r--lib/sqlalchemy/sql/expression.py2
-rw-r--r--lib/sqlalchemy/sql/functions.py2
-rw-r--r--lib/sqlalchemy/sql/lambdas.py2
-rw-r--r--lib/sqlalchemy/sql/naming.py2
-rw-r--r--lib/sqlalchemy/sql/operators.py4
-rw-r--r--lib/sqlalchemy/sql/roles.py2
-rw-r--r--lib/sqlalchemy/sql/schema.py2
-rw-r--r--lib/sqlalchemy/sql/selectable.py4
-rw-r--r--lib/sqlalchemy/sql/sqltypes.py12
-rw-r--r--lib/sqlalchemy/sql/type_api.py2
-rw-r--r--lib/sqlalchemy/sql/util.py2
-rw-r--r--lib/sqlalchemy/sql/visitors.py4
-rw-r--r--lib/sqlalchemy/testing/__init__.py2
-rw-r--r--lib/sqlalchemy/testing/assertions.py2
-rw-r--r--lib/sqlalchemy/testing/assertsql.py2
-rw-r--r--lib/sqlalchemy/testing/asyncio.py2
-rw-r--r--lib/sqlalchemy/testing/config.py2
-rw-r--r--lib/sqlalchemy/testing/engines.py2
-rw-r--r--lib/sqlalchemy/testing/entities.py2
-rw-r--r--lib/sqlalchemy/testing/exclusions.py2
-rw-r--r--lib/sqlalchemy/testing/fixtures.py2
-rw-r--r--lib/sqlalchemy/testing/mock.py2
-rw-r--r--lib/sqlalchemy/testing/pickleable.py2
-rw-r--r--lib/sqlalchemy/testing/plugin/plugin_base.py2
-rw-r--r--lib/sqlalchemy/testing/profiling.py2
-rw-r--r--lib/sqlalchemy/testing/requirements.py2
-rw-r--r--lib/sqlalchemy/testing/schema.py2
-rw-r--r--lib/sqlalchemy/testing/util.py2
-rw-r--r--lib/sqlalchemy/testing/warnings.py2
-rw-r--r--lib/sqlalchemy/types.py2
-rw-r--r--lib/sqlalchemy/util/__init__.py2
-rw-r--r--lib/sqlalchemy/util/_collections.py2
-rw-r--r--lib/sqlalchemy/util/_preloaded.py2
-rw-r--r--lib/sqlalchemy/util/compat.py4
-rw-r--r--lib/sqlalchemy/util/deprecations.py2
-rw-r--r--lib/sqlalchemy/util/langhelpers.py2
-rw-r--r--lib/sqlalchemy/util/queue.py2
-rw-r--r--lib/sqlalchemy/util/topological.py4
-rw-r--r--setup.cfg2
-rw-r--r--test/aaa_profiling/test_memusage.py2
-rw-r--r--test/base/test_except.py19
-rw-r--r--test/dialect/mysql/test_types.py4
-rw-r--r--test/dialect/test_sqlite.py2
-rw-r--r--test/ext/test_hybrid.py2
-rw-r--r--test/orm/test_cascade.py10
-rw-r--r--test/orm/test_composites.py2
258 files changed, 465 insertions, 461 deletions
diff --git a/.github/CODE_OF_CONDUCT.md b/.github/CODE_OF_CONDUCT.md
index 3b8e9bf7e..f22ca7be9 100644
--- a/.github/CODE_OF_CONDUCT.md
+++ b/.github/CODE_OF_CONDUCT.md
@@ -3,4 +3,4 @@
Above all, SQLAlchemy places great emphasis on polite, thoughtful, and
constructive communication between users and developers.
Please see our current Code of Conduct at
-[Code of Conduct](http://www.sqlalchemy.org/codeofconduct.html). \ No newline at end of file
+[Code of Conduct](https://www.sqlalchemy.org/codeofconduct.html). \ No newline at end of file
diff --git a/.github/ISSUE_TEMPLATE/bug_report.md b/.github/ISSUE_TEMPLATE/bug_report.md
index 7852e3e2c..f923281fa 100644
--- a/.github/ISSUE_TEMPLATE/bug_report.md
+++ b/.github/ISSUE_TEMPLATE/bug_report.md
@@ -15,7 +15,7 @@ If you are new to SQLAlchemy bug reports, please review our many examples
of [well written bug reports](https://github.com/sqlalchemy/sqlalchemy/issues?q=is%3Aissue+label%3A%22great+mcve%22). Each of these reports include the following features:
1. a **succinct description of the problem** - typically a line or two at most
-2. **succinct, dependency-free code which reproduces the problem**, otherwise known as a [Minimal, Complete, and Verifiable](http://stackoverflow.com/help/mcve) example.
+2. **succinct, dependency-free code which reproduces the problem**, otherwise known as a [Minimal, Complete, and Verifiable](https://stackoverflow.com/help/mcve) example.
3. **complete stack traces for all errors - please avoid screenshots, use formatted text inside issues**
4. Other things as applicable: **SQL log output**, **database backend and DBAPI driver**,
**operating system**, **comparative performance timings** for performance issues.
@@ -26,7 +26,7 @@ of [well written bug reports](https://github.com/sqlalchemy/sqlalchemy/issues?q=
<!-- A clear and concise description of what the bug is. -->
**To Reproduce**
-Provide your [Minimal, Complete, and Verifiable](http://stackoverflow.com/help/mcve) example
+Provide your [Minimal, Complete, and Verifiable](https://stackoverflow.com/help/mcve) example
here.
```py
diff --git a/CHANGES b/CHANGES
index b8c203702..4dfe43451 100644
--- a/CHANGES
+++ b/CHANGES
@@ -4,6 +4,6 @@ MOVED
For an index of all changelogs, please see:
-* On the web: http://www.sqlalchemy.org/docs/latest/changelog/
+* On the web: https://www.sqlalchemy.org/docs/latest/changelog/
* In the source tree: /doc/build/changelog/
* In the released distribution tree: /doc/changelog/index.html
diff --git a/README.rst b/README.rst
index 8871b810d..ad384e621 100644
--- a/README.rst
+++ b/README.rst
@@ -129,18 +129,18 @@ Documentation
Latest documentation is at:
-http://www.sqlalchemy.org/docs/
+https://www.sqlalchemy.org/docs/
Installation / Requirements
---------------------------
Full documentation for installation is at
-`Installation <http://www.sqlalchemy.org/docs/intro.html#installation>`_.
+`Installation <https://www.sqlalchemy.org/docs/intro.html#installation>`_.
Getting Help / Development / Bug reporting
------------------------------------------
-Please refer to the `SQLAlchemy Community Guide <http://www.sqlalchemy.org/support.html>`_.
+Please refer to the `SQLAlchemy Community Guide <https://www.sqlalchemy.org/support.html>`_.
Code of Conduct
---------------
@@ -148,11 +148,11 @@ Code of Conduct
Above all, SQLAlchemy places great emphasis on polite, thoughtful, and
constructive communication between users and developers.
Please see our current Code of Conduct at
-`Code of Conduct <http://www.sqlalchemy.org/codeofconduct.html>`_.
+`Code of Conduct <https://www.sqlalchemy.org/codeofconduct.html>`_.
License
-------
SQLAlchemy is distributed under the `MIT license
-<http://www.opensource.org/licenses/mit-license.php>`_.
+<https://www.opensource.org/licenses/mit-license.php>`_.
diff --git a/doc/build/changelog/changelog_02.rst b/doc/build/changelog/changelog_02.rst
index d65ef9fe6..69805d609 100644
--- a/doc/build/changelog/changelog_02.rst
+++ b/doc/build/changelog/changelog_02.rst
@@ -73,7 +73,7 @@
lazy loads will not fire off for an object that does not have a
database identity (why?
- see http://www.sqlalchemy.org/trac/wiki/WhyDontForeignKeysLoadData)
+ see https://www.sqlalchemy.org/trac/wiki/WhyDontForeignKeysLoadData)
.. change::
:tags:
@@ -1184,4 +1184,4 @@
:tickets:
migration guide is available on the Wiki at
- http://www.sqlalchemy.org/trac/wiki/02Migration
+ https://www.sqlalchemy.org/trac/wiki/02Migration
diff --git a/doc/build/changelog/changelog_04.rst b/doc/build/changelog/changelog_04.rst
index 993a374bb..790fbee86 100644
--- a/doc/build/changelog/changelog_04.rst
+++ b/doc/build/changelog/changelog_04.rst
@@ -60,7 +60,7 @@
convert_unicode logic disabled in the sqlite dialect,
to adjust for pysqlite 2.5.0's new requirement that
only Python unicode objects are accepted;
- http://itsystementwicklung.de/pipermail/list-pysqlite/2008-March/000018.html
+ https://itsystementwicklung.de/pipermail/list-pysqlite/2008-March/000018.html
.. change::
:tags: oracle
@@ -2751,7 +2751,7 @@
:tickets:
(see 0.4.0beta1 for the start of major changes against 0.3,
- as well as http://www.sqlalchemy.org/trac/wiki/WhatsNewIn04 )
+ as well as https://www.sqlalchemy.org/trac/wiki/WhatsNewIn04 )
.. change::
:tags:
diff --git a/doc/build/changelog/changelog_05.rst b/doc/build/changelog/changelog_05.rst
index 218cd6918..67fce9cac 100644
--- a/doc/build/changelog/changelog_05.rst
+++ b/doc/build/changelog/changelog_05.rst
@@ -430,7 +430,7 @@
Added enable_assertions(False) to Query which disables
the usual assertions for expected state - used
by Query subclasses to engineer custom state.. See
- http://www.sqlalchemy.org/trac/wiki/UsageRecipes/PreFilteredQuery
+ https://www.sqlalchemy.org/trac/wiki/UsageRecipes/PreFilteredQuery
for an example.
.. change::
@@ -590,7 +590,7 @@
Call session.add() if you'd like a free-standing object to be
part of your session. Otherwise, a DIY version of
Session.mapper is now documented at
- http://www.sqlalchemy.org/trac/wiki/UsageRecipes/SessionAwareMapper
+ https://www.sqlalchemy.org/trac/wiki/UsageRecipes/SessionAwareMapper
The method will remain deprecated throughout 0.6.
.. change::
@@ -2873,7 +2873,7 @@
logic disabled in the sqlite dialect, to adjust for pysqlite
2.5.0's new requirement that only Python unicode objects are
accepted;
- http://itsystementwicklung.de/pipermail/list-pysqlite/2008-March/000018.html
+ https://itsystementwicklung.de/pipermail/list-pysqlite/2008-March/000018.html
.. change::
:tags: mysql
@@ -3254,7 +3254,7 @@
:tickets:
The "entity_name" feature of SQLAlchemy mappers has been
- removed. For rationale, see http://tinyurl.com/6nm2ne
+ removed. For rationale, see https://tinyurl.com/6nm2ne
.. change::
:tags: orm
diff --git a/doc/build/changelog/changelog_06.rst b/doc/build/changelog/changelog_06.rst
index 080346970..cd3b32d95 100644
--- a/doc/build/changelog/changelog_06.rst
+++ b/doc/build/changelog/changelog_06.rst
@@ -3843,7 +3843,7 @@
:tickets:
For the full set of feature descriptions, see
- http://docs.sqlalchemy.org/en/latest/changelog/migration_06.html .
+ https://docs.sqlalchemy.org/en/latest/changelog/migration_06.html .
This document is a work in progress.
.. change::
@@ -4211,7 +4211,7 @@
in favor of "load=False".
* ScopedSession.mapper remains deprecated. See the
usage recipe at
- http://www.sqlalchemy.org/trac/wiki/UsageRecipes/SessionAwareMapper
+ https://www.sqlalchemy.org/trac/wiki/UsageRecipes/SessionAwareMapper
* passing an InstanceState (internal SQLAlchemy state object) to
attributes.init_collection() or attributes.get_history() is
deprecated. These functions are public API and normally
diff --git a/doc/build/changelog/changelog_07.rst b/doc/build/changelog/changelog_07.rst
index ce561fcbb..a9ae15c3b 100644
--- a/doc/build/changelog/changelog_07.rst
+++ b/doc/build/changelog/changelog_07.rst
@@ -2582,7 +2582,7 @@
you want to emit IN) and now emits a deprecation warning.
To get the 0.8 behavior immediately and remove the warning,
a compiler recipe is given at
- http://www.sqlalchemy.org/docs/07/dialects/mssql.html#scalar-select-comparisons
+ https://www.sqlalchemy.org/docs/07/dialects/mssql.html#scalar-select-comparisons
to override the behavior of visit_binary().
.. change::
@@ -3220,7 +3220,7 @@
This section documents those changes from 0.7b4
to 0.7.0. For an overview of what's new in
SQLAlchemy 0.7, see
- http://docs.sqlalchemy.org/en/latest/changelog/migration_07.html
+ https://docs.sqlalchemy.org/en/latest/changelog/migration_07.html
.. change::
:tags: orm
@@ -4125,7 +4125,7 @@
Detailed descriptions of each change below are
described at:
- http://docs.sqlalchemy.org/en/latest/changelog/migration_07.html
+ https://docs.sqlalchemy.org/en/latest/changelog/migration_07.html
.. change::
:tags: general
diff --git a/doc/build/changelog/changelog_08.rst b/doc/build/changelog/changelog_08.rst
index d0b49a050..4b6b42ec7 100644
--- a/doc/build/changelog/changelog_08.rst
+++ b/doc/build/changelog/changelog_08.rst
@@ -1037,7 +1037,7 @@
:tags: requirements
:versions: 0.9.0b1
- The Python `mock <https://pypi.python.org/pypi/mock>`_ library
+ The Python `mock <https://pypi.org/project/mock>`_ library
is now required in order to run the unit test suite. While part
of the standard library as of Python 3.3, previous Python installations
will need to install this in order to run unit tests or to
diff --git a/doc/build/changelog/changelog_09.rst b/doc/build/changelog/changelog_09.rst
index 620b65c8c..8e77e84b3 100644
--- a/doc/build/changelog/changelog_09.rst
+++ b/doc/build/changelog/changelog_09.rst
@@ -1788,7 +1788,7 @@
:tags: sqlite, bug
Support has been added to SQLite type reflection to fully support
- the "type affinity" contract specified at http://www.sqlite.org/datatype3.html.
+ the "type affinity" contract specified at https://www.sqlite.org/datatype3.html.
In this scheme, keywords like ``INT``, ``CHAR``, ``BLOB`` or
``REAL`` located in the type name generically associate the type with
one of five affinities. Pull request courtesy Erich Blume.
diff --git a/doc/build/changelog/migration_04.rst b/doc/build/changelog/migration_04.rst
index 12727c0a7..b50313407 100644
--- a/doc/build/changelog/migration_04.rst
+++ b/doc/build/changelog/migration_04.rst
@@ -672,14 +672,14 @@ Nested Session Transactions with SAVEPOINT
Available at the Engine and ORM level. ORM docs so far:
-http://www.sqlalchemy.org/docs/04/session.html#unitofwork_managing
+https://www.sqlalchemy.org/docs/04/session.html#unitofwork_managing
Two-Phase Commit Sessions
^^^^^^^^^^^^^^^^^^^^^^^^^
Available at the Engine and ORM level. ORM docs so far:
-http://www.sqlalchemy.org/docs/04/session.html#unitofwork_managing
+https://www.sqlalchemy.org/docs/04/session.html#unitofwork_managing
Inheritance
-----------
@@ -687,7 +687,7 @@ Inheritance
Polymorphic Inheritance with No Joins or Unions
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
-New docs for inheritance: http://www.sqlalchemy.org/docs/04
+New docs for inheritance: https://www.sqlalchemy.org/docs/04
/mappers.html#advdatamapping_mapper_inheritance_joined
Better Polymorphic Behavior with ``get()``
@@ -706,7 +706,7 @@ Types
Custom Subclasses of ``sqlalchemy.types.TypeDecorator``
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
-There is a `New API <http://www.sqlalchemy.org/docs/04/types
+There is a `New API <https://www.sqlalchemy.org/docs/04/types
.html#types_custom>`_ for subclassing a TypeDecorator.
Using the 0.3 API causes compilation errors in some cases.
@@ -720,8 +720,8 @@ All the "anonymous" labels and aliases use a simple
<name>_<number> format now. SQL is much easier to read and
is compatible with plan optimizer caches. Just check out
some of the examples in the tutorials:
-http://www.sqlalchemy.org/docs/04/ormtutorial.html
-http://www.sqlalchemy.org/docs/04/sqlexpression.html
+https://www.sqlalchemy.org/docs/04/ormtutorial.html
+https://www.sqlalchemy.org/docs/04/sqlexpression.html
Generative select() Constructs
------------------------------
@@ -736,7 +736,7 @@ New Operator System
SQL operators and more or less every SQL keyword there is
are now abstracted into the compiler layer. They now act
intelligently and are type/backend aware, see:
-http://www.sqlalchemy.org/docs/04/sqlexpression.html#sql_operators
+https://www.sqlalchemy.org/docs/04/sqlexpression.html#sql_operators
All ``type`` Keyword Arguments Renamed to ``type_``
---------------------------------------------------
diff --git a/doc/build/changelog/migration_05.rst b/doc/build/changelog/migration_05.rst
index 3a6bb2617..64b69e152 100644
--- a/doc/build/changelog/migration_05.rst
+++ b/doc/build/changelog/migration_05.rst
@@ -15,7 +15,7 @@ This guide documents API changes which affect users
migrating their applications from the 0.4 series of
SQLAlchemy to 0.5. It's also recommended for those working
from `Essential SQLAlchemy
-<http://oreilly.com/catalog/9780596516147/>`_, which only
+<https://oreilly.com/catalog/9780596516147/>`_, which only
covers 0.4 and seems to even have some old 0.3isms in it.
Note that SQLAlchemy 0.5 removes many behaviors which were
deprecated throughout the span of the 0.4 series, and also
@@ -34,10 +34,10 @@ highly customized ORM queries and dealing with stale session
state, commits and rollbacks.
* `ORM Tutorial
- <http://www.sqlalchemy.org/docs/05/ormtutorial.html>`_
+ <https://www.sqlalchemy.org/docs/05/ormtutorial.html>`_
* `Session Documentation
- <http://www.sqlalchemy.org/docs/05/session.html>`_
+ <https://www.sqlalchemy.org/docs/05/session.html>`_
Deprecations Source
===================
@@ -58,7 +58,7 @@ Object Relational Mapping
* **Column level expressions within Query.** - as detailed
in the `tutorial
- <http://www.sqlalchemy.org/docs/05/ormtutorial.html>`_,
+ <https://www.sqlalchemy.org/docs/05/ormtutorial.html>`_,
``Query`` has the capability to create specific SELECT
statements, not just those against full rows:
@@ -538,7 +538,7 @@ Removed
single class, break the class into separate subclasses and
map them separately. An example of this is at
[wiki:UsageRecipes/EntityName]. More information
- regarding rationale is described at http://groups.google.c
+ regarding rationale is described at https://groups.google.c
om/group/sqlalchemy/browse_thread/thread/9e23a0641a88b96d?
hl=en .
diff --git a/doc/build/changelog/migration_06.rst b/doc/build/changelog/migration_06.rst
index a4dd5c699..0867fefe0 100644
--- a/doc/build/changelog/migration_06.rst
+++ b/doc/build/changelog/migration_06.rst
@@ -86,10 +86,10 @@ sign "+":
Important Dialect Links:
* Documentation on connect arguments:
- http://www.sqlalchemy.org/docs/06/dbengine.html#create-
+ https://www.sqlalchemy.org/docs/06/dbengine.html#create-
engine-url-arguments.
-* Reference documentation for individual dialects: http://ww
+* Reference documentation for individual dialects: https://ww
w.sqlalchemy.org/docs/06/reference/dialects/index.html
* The tips and tricks at DatabaseNotes.
@@ -312,7 +312,7 @@ using complex composites with SQLite, you now need to turn
the first element into a subquery (which is also compatible
on PG). A new example is in the SQL expression tutorial at
the end of
-[http://www.sqlalchemy.org/docs/06/sqlexpression.html
+[https://www.sqlalchemy.org/docs/06/sqlexpression.html
#unions-and-other-set-operations]. See :ticket:`1665` and
r6690 for more background.
@@ -754,7 +754,7 @@ from Python Unicode to an encoded string, or when the
Unicode type is used explicitly, a warning is raised if the
object is a bytestring. This warning can be suppressed or
converted to an exception using the Python warnings filter
-documented at: http://docs.python.org/library/warnings.html
+documented at: https://docs.python.org/library/warnings.html
Generic Enum Type
-----------------
@@ -1190,7 +1190,7 @@ upon use.
in favor of "load=False".
* ``ScopedSession.mapper`` remains deprecated. See the
- usage recipe at http://www.sqlalchemy.org/trac/wiki/Usag
+ usage recipe at https://www.sqlalchemy.org/trac/wiki/Usag
eRecipes/SessionAwareMapper
* passing an ``InstanceState`` (internal SQLAlchemy state
@@ -1210,7 +1210,7 @@ SQLSoup
SQLSoup has been modernized and updated to reflect common
0.5/0.6 capabilities, including well defined session
-integration. Please read the new docs at [http://www.sqlalc
+integration. Please read the new docs at [https://www.sqlalc
hemy.org/docs/06/reference/ext/sqlsoup.html].
Declarative
@@ -1222,7 +1222,7 @@ modify ``dict_`` to add class attributes (e.g. columns).
This no longer works, the ``DeclarativeMeta`` constructor
now ignores ``dict_``. Instead, the class attributes should
be assigned directly, e.g. ``cls.id=Column(...)``, or the
-`MixIn class <http://www.sqlalchemy.org/docs/reference/ext/d
+`MixIn class <https://www.sqlalchemy.org/docs/reference/ext/d
eclarative.html#mix-in-classes>`_ approach should be used
instead of the metaclass approach.
diff --git a/doc/build/changelog/migration_07.rst b/doc/build/changelog/migration_07.rst
index dbba94eb4..12a3c23e6 100644
--- a/doc/build/changelog/migration_07.rst
+++ b/doc/build/changelog/migration_07.rst
@@ -204,7 +204,7 @@ scenarios. Highlights of this release include:
A demonstration of callcount reduction including a sample
benchmark script is at
-http://techspot.zzzeek.org/2010/12/12/a-tale-of-three-
+https://techspot.zzzeek.org/2010/12/12/a-tale-of-three-
profiles/
Composites Rewritten
@@ -224,7 +224,7 @@ regular attributes. Composites can also act as a proxy for
The major backwards-incompatible change of composites is
that they no longer use the ``mutable=True`` system to
detect in-place mutations. Please use the `Mutation
-Tracking <http://www.sqlalchemy.org/docs/07/orm/extensions/m
+Tracking <https://www.sqlalchemy.org/docs/07/orm/extensions/m
utable.html>`_ extension to establish in-place change events
to existing composite usage.
@@ -273,7 +273,7 @@ unchanged:
# ... etc
`Querying with Joins
-<http://www.sqlalchemy.org/docs/07/orm/tutorial.html
+<https://www.sqlalchemy.org/docs/07/orm/tutorial.html
#querying-with-joins>`_
:ticket:`1923`
@@ -319,10 +319,10 @@ to the ``distinct`` keyword argument of ``select()``, the
accept positional arguments which are rendered as DISTINCT
ON when a PostgreSQL backend is used.
-`distinct() <http://www.sqlalchemy.org/docs/07/core/expressi
+`distinct() <https://www.sqlalchemy.org/docs/07/core/expressi
on_api.html#sqlalchemy.sql.expression.Select.distinct>`_
-`Query.distinct() <http://www.sqlalchemy.org/docs/07/orm/que
+`Query.distinct() <https://www.sqlalchemy.org/docs/07/orm/que
ry.html#sqlalchemy.orm.query.Query.distinct>`_
:ticket:`1069`
@@ -357,7 +357,7 @@ The primary rationale here is for the benefit of declarative
__tablename__ = 'user'
id = Column('id', Integer, primary_key=True)
-`Indexes <http://www.sqlalchemy.org/docs/07/core/schema.html
+`Indexes <https://www.sqlalchemy.org/docs/07/core/schema.html
#indexes>`_
Window Function SQL Construct
@@ -373,7 +373,7 @@ The best introduction to window functions is on PostgreSQL's
site, where window functions have been supported since
version 8.4:
-http://www.postgresql.org/docs/9.0/static/tutorial-
+https://www.postgresql.org/docs/9.0/static/tutorial-
window.html
SQLAlchemy provides a simple construct typically invoked via
@@ -408,7 +408,7 @@ SQL:
avg(empsalary.salary) OVER (PARTITION BY empsalary.depname) AS avg
FROM empsalary
-`sqlalchemy.sql.expression.over <http://www.sqlalchemy.org/d
+`sqlalchemy.sql.expression.over <https://www.sqlalchemy.org/d
ocs/07/core/expression_api.html#sqlalchemy.sql.expression.ov
er>`_
@@ -427,7 +427,7 @@ The default isolation level is set using the
Transaction isolation support is currently only supported by
the PostgreSQL and SQLite backends.
-`execution_options() <http://www.sqlalchemy.org/docs/07/core
+`execution_options() <https://www.sqlalchemy.org/docs/07/core
/connections.html#sqlalchemy.engine.base.Connection.executio
n_options>`_
@@ -461,14 +461,14 @@ Dialects have been added:
* a MySQLdb driver for the Drizzle database:
- `Drizzle <http://www.sqlalchemy.org/docs/07/dialects/drizz
+ `Drizzle <https://www.sqlalchemy.org/docs/07/dialects/drizz
le.html>`_
* support for the pymysql DBAPI:
`pymsql Notes
- <http://www.sqlalchemy.org/docs/07/dialects/mysql.html
+ <https://www.sqlalchemy.org/docs/07/dialects/mysql.html
#module-sqlalchemy.dialects.mysql.pymysql>`_
* psycopg2 now works with Python 3
@@ -719,9 +719,9 @@ implement their own ``get_bind()`` method and arguments to
use those custom arguments with both the ``execute()`` and
``connection()`` methods equally.
-`Session.connection <http://www.sqlalchemy.org/docs/07/orm/s
+`Session.connection <https://www.sqlalchemy.org/docs/07/orm/s
ession.html#sqlalchemy.orm.session.Session.connection>`_
-`Session.execute <http://www.sqlalchemy.org/docs/07/orm/sess
+`Session.execute <https://www.sqlalchemy.org/docs/07/orm/sess
ion.html#sqlalchemy.orm.session.Session.execute>`_
:ticket:`1996`
@@ -781,7 +781,7 @@ mutations, the type object must be constructed with
)
The ``mutable=True`` flag is being phased out, in favor of
-the new `Mutation Tracking <http://www.sqlalchemy.org/docs/0
+the new `Mutation Tracking <https://www.sqlalchemy.org/docs/0
7/orm/extensions/mutable.html>`_ extension. This extension
provides a mechanism by which user-defined datatypes can
provide change events back to the owning parent or parents.
@@ -808,14 +808,14 @@ Mutability detection of ``composite()`` requires the Mutation Tracking Extension
So-called "composite" mapped attributes, those configured
using the technique described at `Composite Column Types
-<http://www.sqlalchemy.org/docs/07/orm/mapper_config.html
+<https://www.sqlalchemy.org/docs/07/orm/mapper_config.html
#composite-column-types>`_, have been re-implemented such
that the ORM internals are no longer aware of them (leading
to shorter and more efficient codepaths in critical
sections). While composite types are generally intended to
be treated as immutable value objects, this was never
enforced. For applications that use composites with
-mutability, the `Mutation Tracking <http://www.sqlalchemy.or
+mutability, the `Mutation Tracking <https://www.sqlalchemy.or
g/docs/07/orm/extensions/mutable.html>`_ extension offers a
base class which establishes a mechanism for user-defined
composite types to send change event messages back to the
@@ -851,7 +851,7 @@ connections are used.
Note that this change **breaks temporary tables used across
Session commits**, due to the way SQLite handles temp
tables. See the note at
-http://www.sqlalchemy.org/docs/dialects/sqlite.html#using-
+https://www.sqlalchemy.org/docs/dialects/sqlite.html#using-
temporary-tables-with-sqlite if temporary tables beyond the
scope of one pool connection are desired.
diff --git a/doc/build/changelog/migration_08.rst b/doc/build/changelog/migration_08.rst
index 0ced6ce85..a4dc58549 100644
--- a/doc/build/changelog/migration_08.rst
+++ b/doc/build/changelog/migration_08.rst
@@ -1500,7 +1500,7 @@ structures and pickled objects. However, the
implementation was never reasonable and forced a very
inefficient mode of usage on the unit-of-work which caused
an expensive scan of all objects to take place during flush.
-In 0.7, the `sqlalchemy.ext.mutable <http://docs.sqlalchemy.
+In 0.7, the `sqlalchemy.ext.mutable <https://docs.sqlalchemy.
org/en/latest/orm/extensions/mutable.html>`_ extension was
introduced so that user-defined datatypes can appropriately
send events to the unit of work as changes occur.
diff --git a/doc/build/changelog/migration_09.rst b/doc/build/changelog/migration_09.rst
index 7dec30203..70fa49e34 100644
--- a/doc/build/changelog/migration_09.rst
+++ b/doc/build/changelog/migration_09.rst
@@ -520,7 +520,7 @@ The "password" portion of a ``create_engine()`` no longer considers the ``+`` si
For whatever reason, the Python function ``unquote_plus()`` was applied to the
"password" field of a URL, which is an incorrect application of the
-encoding rules described in `RFC 1738 <http://www.ietf.org/rfc/rfc1738.txt>`_
+encoding rules described in `RFC 1738 <https://www.ietf.org/rfc/rfc1738.txt>`_
in that it escaped spaces as plus signs. The stringification of a URL
now only encodes ":", "@", or "/" and nothing else, and is now applied to both the
``username`` and ``password`` fields (previously it only applied to the
@@ -1810,7 +1810,7 @@ as desired.
:mod:`sqlalchemy.dialects.firebird.kinterbasdb`
- http://pythonhosted.org/fdb/usage-guide.html#retaining-transactions - information
+ https://pythonhosted.org/fdb/usage-guide.html#retaining-transactions - information
on the "retaining" flag.
:ticket:`2763`
diff --git a/doc/build/changelog/migration_10.rst b/doc/build/changelog/migration_10.rst
index e31b621fe..592bb2482 100644
--- a/doc/build/changelog/migration_10.rst
+++ b/doc/build/changelog/migration_10.rst
@@ -2432,7 +2432,7 @@ The MySQL dialect has always worked around MySQL's implicit NOT NULL
default associated with TIMESTAMP columns by emitting NULL for
such a type, if the column is set up with ``nullable=True``. However,
MySQL 5.6.6 and above features a new flag
-`explicit_defaults_for_timestamp <http://dev.mysql.com/doc/refman/
+`explicit_defaults_for_timestamp <https://dev.mysql.com/doc/refman/
5.6/en/server-system-variables.html
#sysvar_explicit_defaults_for_timestamp>`_ which repairs MySQL's non-standard
behavior to make it behave like any other type; to accommodate this,
@@ -2570,7 +2570,7 @@ on MySQL::
Drizzle Dialect is now an External Dialect
------------------------------------------
-The dialect for `Drizzle <http://www.drizzle.org/>`_ is now an external
+The dialect for `Drizzle <https://www.drizzle.org/>`_ is now an external
dialect, available at https://bitbucket.org/zzzeek/sqlalchemy-drizzle.
This dialect was added to SQLAlchemy right before SQLAlchemy was able to
accommodate third party dialects well; going forward, all databases that aren't
diff --git a/doc/build/changelog/migration_11.rst b/doc/build/changelog/migration_11.rst
index ef55466b8..cc3c7fc0c 100644
--- a/doc/build/changelog/migration_11.rst
+++ b/doc/build/changelog/migration_11.rst
@@ -701,7 +701,7 @@ of its own ``QueryableAttribute`` wrapper::
A lot of testing went into making sure this wrapper works correctly, including
for elaborate schemes like that of the
-`Custom Value Object <http://techspot.zzzeek.org/2011/10/21/hybrids-and-value-agnostic-types/>`_
+`Custom Value Object <https://techspot.zzzeek.org/2011/10/21/hybrids-and-value-agnostic-types/>`_
recipe, however we'll be looking to see that no other regressions occur for
users.
@@ -2604,7 +2604,7 @@ in order to specify TABLESPACE, the same way as accepted by the
Support for PyGreSQL
--------------------
-The `PyGreSQL <https://pypi.python.org/pypi/PyGreSQL>`_ DBAPI is now supported.
+The `PyGreSQL <https://pypi.org/project/PyGreSQL>`_ DBAPI is now supported.
.. seealso::
diff --git a/doc/build/changelog/migration_12.rst b/doc/build/changelog/migration_12.rst
index 44173437f..f0b88c493 100644
--- a/doc/build/changelog/migration_12.rst
+++ b/doc/build/changelog/migration_12.rst
@@ -1544,7 +1544,7 @@ Support for Batch Mode / Fast Execution Helpers
The psycopg2 ``cursor.executemany()`` method has been identified as performing
poorly, particularly with INSERT statements. To alleviate this, psycopg2
-has added `Fast Execution Helpers <http://initd.org/psycopg/docs/extras.html#fast-execution-helpers>`_
+has added `Fast Execution Helpers <https://initd.org/psycopg/docs/extras.html#fast-execution-helpers>`_
which rework statements into fewer server round trips by sending multiple
DML statements in batch. SQLAlchemy 1.2 now includes support for these
helpers to be used transparently whenever the :class:`_engine.Engine` makes use
diff --git a/doc/build/changelog/migration_13.rst b/doc/build/changelog/migration_13.rst
index 665a332ad..b0c77ab52 100644
--- a/doc/build/changelog/migration_13.rst
+++ b/doc/build/changelog/migration_13.rst
@@ -1719,14 +1719,14 @@ keeping the original error message on one line for logging purposes.
This means that an error message that previously looked like this::
- sqlalchemy.exc.StatementError: (sqlalchemy.exc.InvalidRequestError) A value is required for bind parameter 'id' [SQL: 'select * from reviews\nwhere id = ?'] (Background on this error at: http://sqlalche.me/e/cd3x)
+ sqlalchemy.exc.StatementError: (sqlalchemy.exc.InvalidRequestError) A value is required for bind parameter 'id' [SQL: 'select * from reviews\nwhere id = ?'] (Background on this error at: https://sqlalche.me/e/cd3x)
Will now look like this::
sqlalchemy.exc.StatementError: (sqlalchemy.exc.InvalidRequestError) A value is required for bind parameter 'id'
[SQL: select * from reviews
where id = ?]
- (Background on this error at: http://sqlalche.me/e/cd3x)
+ (Background on this error at: https://sqlalche.me/e/cd3x)
The primary impact of this change is that consumers can no longer assume that
a complete exception message is on a single line, however the original
diff --git a/doc/build/changelog/migration_20.rst b/doc/build/changelog/migration_20.rst
index 765a418e4..5bae55a48 100644
--- a/doc/build/changelog/migration_20.rst
+++ b/doc/build/changelog/migration_20.rst
@@ -187,21 +187,21 @@ using Python option ``-W error::DeprecationWarning``.
With warnings turned on, our program now has a lot to say::
$ SQLALCHEMY_WARN_20=1 python2 -W always::DeprecationWarning test3.py
- test3.py:9: RemovedIn20Warning: The Engine.execute() function/method is considered legacy as of the 1.x series of SQLAlchemy and will be removed in 2.0. All statement execution in SQLAlchemy 2.0 is performed by the Connection.execute() method of Connection, or in the ORM by the Session.execute() method of Session. (Background on SQLAlchemy 2.0 at: http://sqlalche.me/e/b8d9) (Background on SQLAlchemy 2.0 at: http://sqlalche.me/e/b8d9)
+ test3.py:9: RemovedIn20Warning: The Engine.execute() function/method is considered legacy as of the 1.x series of SQLAlchemy and will be removed in 2.0. All statement execution in SQLAlchemy 2.0 is performed by the Connection.execute() method of Connection, or in the ORM by the Session.execute() method of Session. (Background on SQLAlchemy 2.0 at: https://sqlalche.me/e/b8d9) (Background on SQLAlchemy 2.0 at: https://sqlalche.me/e/b8d9)
engine.execute("CREATE TABLE foo (id integer)")
- /home/classic/dev/sqlalchemy/lib/sqlalchemy/engine/base.py:2856: RemovedIn20Warning: Passing a string to Connection.execute() is deprecated and will be removed in version 2.0. Use the text() construct, or the Connection.exec_driver_sql() method to invoke a driver-level SQL string. (Background on SQLAlchemy 2.0 at: http://sqlalche.me/e/b8d9)
+ /home/classic/dev/sqlalchemy/lib/sqlalchemy/engine/base.py:2856: RemovedIn20Warning: Passing a string to Connection.execute() is deprecated and will be removed in version 2.0. Use the text() construct, or the Connection.exec_driver_sql() method to invoke a driver-level SQL string. (Background on SQLAlchemy 2.0 at: https://sqlalche.me/e/b8d9)
return connection.execute(statement, *multiparams, **params)
- /home/classic/dev/sqlalchemy/lib/sqlalchemy/engine/base.py:1639: RemovedIn20Warning: The current statement is being autocommitted using implicit autocommit.Implicit autocommit will be removed in SQLAlchemy 2.0. Use the .begin() method of Engine or Connection in order to use an explicit transaction for DML and DDL statements. (Background on SQLAlchemy 2.0 at: http://sqlalche.me/e/b8d9)
+ /home/classic/dev/sqlalchemy/lib/sqlalchemy/engine/base.py:1639: RemovedIn20Warning: The current statement is being autocommitted using implicit autocommit.Implicit autocommit will be removed in SQLAlchemy 2.0. Use the .begin() method of Engine or Connection in order to use an explicit transaction for DML and DDL statements. (Background on SQLAlchemy 2.0 at: https://sqlalche.me/e/b8d9)
self._commit_impl(autocommit=True)
- test3.py:10: RemovedIn20Warning: The Engine.execute() function/method is considered legacy as of the 1.x series of SQLAlchemy and will be removed in 2.0. All statement execution in SQLAlchemy 2.0 is performed by the Connection.execute() method of Connection, or in the ORM by the Session.execute() method of Session. (Background on SQLAlchemy 2.0 at: http://sqlalche.me/e/b8d9) (Background on SQLAlchemy 2.0 at: http://sqlalche.me/e/b8d9)
+ test3.py:10: RemovedIn20Warning: The Engine.execute() function/method is considered legacy as of the 1.x series of SQLAlchemy and will be removed in 2.0. All statement execution in SQLAlchemy 2.0 is performed by the Connection.execute() method of Connection, or in the ORM by the Session.execute() method of Session. (Background on SQLAlchemy 2.0 at: https://sqlalche.me/e/b8d9) (Background on SQLAlchemy 2.0 at: https://sqlalche.me/e/b8d9)
engine.execute("INSERT INTO foo (id) VALUES (1)")
- /home/classic/dev/sqlalchemy/lib/sqlalchemy/engine/base.py:2856: RemovedIn20Warning: Passing a string to Connection.execute() is deprecated and will be removed in version 2.0. Use the text() construct, or the Connection.exec_driver_sql() method to invoke a driver-level SQL string. (Background on SQLAlchemy 2.0 at: http://sqlalche.me/e/b8d9)
+ /home/classic/dev/sqlalchemy/lib/sqlalchemy/engine/base.py:2856: RemovedIn20Warning: Passing a string to Connection.execute() is deprecated and will be removed in version 2.0. Use the text() construct, or the Connection.exec_driver_sql() method to invoke a driver-level SQL string. (Background on SQLAlchemy 2.0 at: https://sqlalche.me/e/b8d9)
return connection.execute(statement, *multiparams, **params)
- /home/classic/dev/sqlalchemy/lib/sqlalchemy/engine/base.py:1639: RemovedIn20Warning: The current statement is being autocommitted using implicit autocommit.Implicit autocommit will be removed in SQLAlchemy 2.0. Use the .begin() method of Engine or Connection in order to use an explicit transaction for DML and DDL statements. (Background on SQLAlchemy 2.0 at: http://sqlalche.me/e/b8d9)
+ /home/classic/dev/sqlalchemy/lib/sqlalchemy/engine/base.py:1639: RemovedIn20Warning: The current statement is being autocommitted using implicit autocommit.Implicit autocommit will be removed in SQLAlchemy 2.0. Use the .begin() method of Engine or Connection in order to use an explicit transaction for DML and DDL statements. (Background on SQLAlchemy 2.0 at: https://sqlalche.me/e/b8d9)
self._commit_impl(autocommit=True)
- /home/classic/dev/sqlalchemy/lib/sqlalchemy/sql/selectable.py:4271: RemovedIn20Warning: The legacy calling style of select() is deprecated and will be removed in SQLAlchemy 2.0. Please use the new calling style described at select(). (Background on SQLAlchemy 2.0 at: http://sqlalche.me/e/b8d9) (Background on SQLAlchemy 2.0 at: http://sqlalche.me/e/b8d9)
+ /home/classic/dev/sqlalchemy/lib/sqlalchemy/sql/selectable.py:4271: RemovedIn20Warning: The legacy calling style of select() is deprecated and will be removed in SQLAlchemy 2.0. Please use the new calling style described at select(). (Background on SQLAlchemy 2.0 at: https://sqlalche.me/e/b8d9) (Background on SQLAlchemy 2.0 at: https://sqlalche.me/e/b8d9)
return cls.create_legacy_select(*args, **kw)
- test3.py:14: RemovedIn20Warning: The Engine.execute() function/method is considered legacy as of the 1.x series of SQLAlchemy and will be removed in 2.0. All statement execution in SQLAlchemy 2.0 is performed by the Connection.execute() method of Connection, or in the ORM by the Session.execute() method of Session. (Background on SQLAlchemy 2.0 at: http://sqlalche.me/e/b8d9) (Background on SQLAlchemy 2.0 at: http://sqlalche.me/e/b8d9)
+ test3.py:14: RemovedIn20Warning: The Engine.execute() function/method is considered legacy as of the 1.x series of SQLAlchemy and will be removed in 2.0. All statement execution in SQLAlchemy 2.0 is performed by the Connection.execute() method of Connection, or in the ORM by the Session.execute() method of Session. (Background on SQLAlchemy 2.0 at: https://sqlalche.me/e/b8d9) (Background on SQLAlchemy 2.0 at: https://sqlalche.me/e/b8d9)
result = engine.execute(select([foo.c.id]))
[(1,)]
diff --git a/doc/build/conf.py b/doc/build/conf.py
index b7ef6d43b..0e63e6796 100644
--- a/doc/build/conf.py
+++ b/doc/build/conf.py
@@ -87,14 +87,14 @@ changelog_inner_tag_sort = [
# how to render changelog links
-changelog_render_ticket = "http://www.sqlalchemy.org/trac/ticket/%s"
+changelog_render_ticket = "https://www.sqlalchemy.org/trac/ticket/%s"
changelog_render_pullreq = {
"default": "https://github.com/sqlalchemy/sqlalchemy/pull/%s",
"github": "https://github.com/sqlalchemy/sqlalchemy/pull/%s",
}
-changelog_render_changeset = "http://www.sqlalchemy.org/trac/changeset/%s"
+changelog_render_changeset = "https://www.sqlalchemy.org/trac/changeset/%s"
exclude_patterns = ["build", "**/unreleased*/*", "*_include.rst"]
@@ -200,7 +200,7 @@ release = "1.4.20"
release_date = "June 28, 2021"
-site_base = os.environ.get("RTD_SITE_BASE", "http://www.sqlalchemy.org")
+site_base = os.environ.get("RTD_SITE_BASE", "https://www.sqlalchemy.org")
site_adapter_template = "docs_adapter.mako"
site_adapter_py = "docs_adapter.py"
diff --git a/doc/build/copyright.rst b/doc/build/copyright.rst
index 1fbdbbee1..b38d3ae29 100644
--- a/doc/build/copyright.rst
+++ b/doc/build/copyright.rst
@@ -4,7 +4,7 @@
Appendix: Copyright
====================
-This is the MIT license: `<http://www.opensource.org/licenses/mit-license.php>`_
+This is the MIT license: `<https://www.opensource.org/licenses/mit-license.php>`_
Copyright (c) 2005-2021 Michael Bayer and contributors.
SQLAlchemy is a trademark of Michael Bayer.
diff --git a/doc/build/core/connections.rst b/doc/build/core/connections.rst
index ffe738c06..5b9613def 100644
--- a/doc/build/core/connections.rst
+++ b/doc/build/core/connections.rst
@@ -1751,7 +1751,7 @@ Calling Stored Procedures
-------------------------
For stored procedures with special syntactical or parameter concerns,
-DBAPI-level `callproc <http://legacy.python.org/dev/peps/pep-0249/#callproc>`_
+DBAPI-level `callproc <https://legacy.python.org/dev/peps/pep-0249/#callproc>`_
may be used::
connection = engine.raw_connection()
@@ -1768,7 +1768,7 @@ Multiple Result Sets
--------------------
Multiple result set support is available from a raw DBAPI cursor using the
-`nextset <http://legacy.python.org/dev/peps/pep-0249/#nextset>`_ method::
+`nextset <https://legacy.python.org/dev/peps/pep-0249/#nextset>`_ method::
connection = engine.raw_connection()
try:
diff --git a/doc/build/core/engines.rst b/doc/build/core/engines.rst
index af11a8a68..753be0554 100644
--- a/doc/build/core/engines.rst
+++ b/doc/build/core/engines.rst
@@ -57,7 +57,7 @@ Database Urls
The :func:`_sa.create_engine` function produces an :class:`_engine.Engine` object based
on a URL. These URLs follow `RFC-1738
-<http://rfc.net/rfc1738.html>`_, and usually can include username, password,
+<https://rfc.net/rfc1738.html>`_, and usually can include username, password,
hostname, database name as well as optional keyword arguments for additional configuration.
In some cases a file path is accepted, and in others a "data source name" replaces
the "host" and "database" portions. The typical form of a database URL is::
@@ -471,7 +471,7 @@ Configuring Logging
===================
Python's standard `logging
-<http://docs.python.org/library/logging.html>`_ module is used to
+<https://docs.python.org/library/logging.html>`_ module is used to
implement informational and debug log output with SQLAlchemy. This allows
SQLAlchemy's logging to integrate in a standard way with other applications
and libraries. There are also two parameters
diff --git a/doc/build/core/tutorial.rst b/doc/build/core/tutorial.rst
index 2ef10096e..8c030414f 100644
--- a/doc/build/core/tutorial.rst
+++ b/doc/build/core/tutorial.rst
@@ -56,7 +56,7 @@ While there is overlap among the usage patterns of the ORM and the Expression
Language, the similarities are more superficial than they may at first appear.
One approaches the structure and content of data from the perspective of a
user-defined `domain model
-<http://en.wikipedia.org/wiki/Domain_model>`_ which is transparently
+<https://en.wikipedia.org/wiki/Domain_model>`_ which is transparently
persisted and refreshed from its underlying storage model. The other
approaches it from the perspective of literal schema and SQL expression
representations which are explicitly composed into messages consumed
diff --git a/doc/build/dialects/index.rst b/doc/build/dialects/index.rst
index 400b68ac0..a778f4d7c 100644
--- a/doc/build/dialects/index.rst
+++ b/doc/build/dialects/index.rst
@@ -133,7 +133,7 @@ Currently maintained external dialect projects for SQLAlchemy include:
.. _PyHive: https://github.com/dropbox/PyHive#sqlalchemy
.. _teradatasqlalchemy: https://pypi.org/project/teradatasqlalchemy/
.. _pybigquery: https://github.com/mxmzdlv/pybigquery/
-.. _sqlalchemy-redshift: https://pypi.python.org/pypi/sqlalchemy-redshift
+.. _sqlalchemy-redshift: https://pypi.org/project/sqlalchemy-redshift
.. _sqlalchemy-drill: https://github.com/JohnOmernik/sqlalchemy-drill
.. _sqlalchemy-hana: https://github.com/SAP/sqlalchemy-hana
.. _sqlalchemy-solr: https://github.com/aadel/sqlalchemy-solr
diff --git a/doc/build/faq/connections.rst b/doc/build/faq/connections.rst
index 719009b69..7ac2bb17d 100644
--- a/doc/build/faq/connections.rst
+++ b/doc/build/faq/connections.rst
@@ -368,7 +368,7 @@ any database that has any kind of transaction isolation, including MySQL with
InnoDB. Any connection that is still inside an old transaction will return
stale data, if that data was already queried on that connection within
isolation. For background on why you might see stale data even on MySQL, see
-http://dev.mysql.com/doc/refman/5.1/en/innodb-transaction-model.html
+https://dev.mysql.com/doc/refman/5.1/en/innodb-transaction-model.html
I'm on MyISAM - how do I turn it off?
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
diff --git a/doc/build/faq/metadata_schema.rst b/doc/build/faq/metadata_schema.rst
index b0cc3a5ba..4eed369e5 100644
--- a/doc/build/faq/metadata_schema.rst
+++ b/doc/build/faq/metadata_schema.rst
@@ -104,4 +104,4 @@ However, there are simple ways to get on-construction behaviors using creation
functions, and behaviors related to the linkages between schema objects such as
constraint conventions or naming conventions using attachment events.
An example of many of these
-techniques can be seen at `Naming Conventions <http://www.sqlalchemy.org/trac/wiki/UsageRecipes/NamingConventions>`_.
+techniques can be seen at `Naming Conventions <https://www.sqlalchemy.org/trac/wiki/UsageRecipes/NamingConventions>`_.
diff --git a/doc/build/faq/ormconfiguration.rst b/doc/build/faq/ormconfiguration.rst
index e4463d7fd..3eab21854 100644
--- a/doc/build/faq/ormconfiguration.rst
+++ b/doc/build/faq/ormconfiguration.rst
@@ -42,7 +42,7 @@ and is also key to the most common (and not-so-common) patterns of ORM usage.
In almost all cases, a table does have a so-called :term:`candidate key`, which is a column or series
of columns that uniquely identify a row. If a table truly doesn't have this, and has actual
-fully duplicate rows, the table is not corresponding to `first normal form <http://en.wikipedia.org/wiki/First_normal_form>`_ and cannot be mapped. Otherwise, whatever columns comprise the best candidate key can be
+fully duplicate rows, the table is not corresponding to `first normal form <https://en.wikipedia.org/wiki/First_normal_form>`_ and cannot be mapped. Otherwise, whatever columns comprise the best candidate key can be
applied directly to the mapper::
class SomeClass(Base):
diff --git a/doc/build/faq/performance.rst b/doc/build/faq/performance.rst
index ff02e7cc9..ae5aabe18 100644
--- a/doc/build/faq/performance.rst
+++ b/doc/build/faq/performance.rst
@@ -322,7 +322,7 @@ With cPython 2.7, runtimes observed::
SQLAlchemy Core: Total time for 100000 records 0.21024107933 secs
sqlite3: Total time for 100000 records 0.137335062027 sec
-We can reduce the time by a factor of nearly three using recent versions of `PyPy <http://pypy.org/>`_::
+We can reduce the time by a factor of nearly three using recent versions of `PyPy <https://pypy.org/>`_::
SQLAlchemy ORM: Total time for 100000 records 2.39429616928 secs
SQLAlchemy ORM pk given: Total time for 100000 records 1.51412987709 secs
diff --git a/doc/build/faq/sessions.rst b/doc/build/faq/sessions.rst
index 2ab471dd1..20e64fa56 100644
--- a/doc/build/faq/sessions.rst
+++ b/doc/build/faq/sessions.rst
@@ -225,7 +225,7 @@ above code is predictable and consistent.
How do I make a Query that always adds a certain filter to every query?
------------------------------------------------------------------------------------------------
-See the recipe at `FilteredQuery <http://www.sqlalchemy.org/trac/wiki/UsageRecipes/FilteredQuery>`_.
+See the recipe at `FilteredQuery <https://www.sqlalchemy.org/trac/wiki/UsageRecipes/FilteredQuery>`_.
.. _faq_query_deduplicating:
@@ -462,7 +462,7 @@ have meaning until the row is inserted; otherwise there is no row yet::
specific programming scenarios encountered by users which involve the repurposing
of the ORM's usual object states.
-The recipe `ExpireRelationshipOnFKChange <http://www.sqlalchemy.org/trac/wiki/UsageRecipes/ExpireRelationshipOnFKChange>`_ features an example using SQLAlchemy events
+The recipe `ExpireRelationshipOnFKChange <https://www.sqlalchemy.org/trac/wiki/UsageRecipes/ExpireRelationshipOnFKChange>`_ features an example using SQLAlchemy events
in order to coordinate the setting of foreign key attributes with many-to-one
relationships.
@@ -544,7 +544,7 @@ When people read the many-to-many example in the docs, they get hit with the
fact that if you create the same ``Keyword`` twice, it gets put in the DB twice.
Which is somewhat inconvenient.
-This `UniqueObject <http://www.sqlalchemy.org/trac/wiki/UsageRecipes/UniqueObject>`_ recipe was created to address this issue.
+This `UniqueObject <https://www.sqlalchemy.org/trac/wiki/UsageRecipes/UniqueObject>`_ recipe was created to address this issue.
.. _faq_post_update_update:
diff --git a/doc/build/glossary.rst b/doc/build/glossary.rst
index 31cdf20f0..4bdaa8bcb 100644
--- a/doc/build/glossary.rst
+++ b/doc/build/glossary.rst
@@ -227,7 +227,7 @@ Glossary
In Python, a descriptor is an object attribute with “binding behavior”,
one whose attribute access has been overridden by methods in the
- `descriptor protocol <http://docs.python.org/howto/descriptor.html>`_.
+ `descriptor protocol <https://docs.python.org/howto/descriptor.html>`_.
Those methods are ``__get__()``, ``__set__()``, and ``__delete__()``.
If any of those methods are defined for an object, it is said to be a
descriptor.
@@ -275,7 +275,7 @@ Glossary
:ref:`metadata_toplevel`
- `DDL (via Wikipedia) <http://en.wikipedia.org/wiki/Data_definition_language>`_
+ `DDL (via Wikipedia) <https://en.wikipedia.org/wiki/Data_definition_language>`_
:term:`DML`
@@ -290,7 +290,7 @@ Glossary
.. seealso::
- `DML (via Wikipedia) <http://en.wikipedia.org/wiki/Data_manipulation_language>`_
+ `DML (via Wikipedia) <https://en.wikipedia.org/wiki/Data_manipulation_language>`_
:term:`DDL`
@@ -422,7 +422,7 @@ Glossary
.. seealso::
- `Identity Map (via Martin Fowler) <http://martinfowler.com/eaaCatalog/identityMap.html>`_
+ `Identity Map (via Martin Fowler) <https://martinfowler.com/eaaCatalog/identityMap.html>`_
lazy initialization
A tactic of delaying some initialization action, such as creating objects,
@@ -450,7 +450,7 @@ Glossary
.. seealso::
- `Lazy Load (via Martin Fowler) <http://martinfowler.com/eaaCatalog/lazyLoad.html>`_
+ `Lazy Load (via Martin Fowler) <https://martinfowler.com/eaaCatalog/lazyLoad.html>`_
:term:`N plus one problem`
@@ -611,7 +611,7 @@ Glossary
.. seealso::
- `PEP 249 - Python Database API Specification v2.0 <http://www.python.org/dev/peps/pep-0249/>`_
+ `PEP 249 - Python Database API Specification v2.0 <https://www.python.org/dev/peps/pep-0249/>`_
domain model
@@ -621,7 +621,7 @@ Glossary
.. seealso::
- `Domain Model (via Wikipedia) <http://en.wikipedia.org/wiki/Domain_model>`_
+ `Domain Model (via Wikipedia) <https://en.wikipedia.org/wiki/Domain_model>`_
unit of work
This pattern is where the system transparently keeps
@@ -632,7 +632,7 @@ Glossary
.. seealso::
- `Unit of Work (via Martin Fowler) <http://martinfowler.com/eaaCatalog/unitOfWork.html>`_
+ `Unit of Work (via Martin Fowler) <https://martinfowler.com/eaaCatalog/unitOfWork.html>`_
:doc:`orm/session`
@@ -829,7 +829,7 @@ Glossary
:term:`durability`
- `ACID Model (via Wikipedia) <http://en.wikipedia.org/wiki/ACID_Model>`_
+ `ACID Model (via Wikipedia) <https://en.wikipedia.org/wiki/ACID_Model>`_
atomicity
Atomicity is one of the components of the :term:`ACID` model,
@@ -844,7 +844,7 @@ Glossary
:term:`ACID`
- `Atomicity (via Wikipedia) <http://en.wikipedia.org/wiki/Atomicity_(database_systems)>`_
+ `Atomicity (via Wikipedia) <https://en.wikipedia.org/wiki/Atomicity_(database_systems)>`_
consistency
Consistency is one of the components of the :term:`ACID` model,
@@ -859,7 +859,7 @@ Glossary
:term:`ACID`
- `Consistency (via Wikipedia) <http://en.wikipedia.org/wiki/Consistency_(database_systems)>`_
+ `Consistency (via Wikipedia) <https://en.wikipedia.org/wiki/Consistency_(database_systems)>`_
isolation
isolated
@@ -878,7 +878,7 @@ Glossary
:term:`ACID`
- `Isolation (via Wikipedia) <http://en.wikipedia.org/wiki/Isolation_(database_systems)>`_
+ `Isolation (via Wikipedia) <https://en.wikipedia.org/wiki/Isolation_(database_systems)>`_
:term:`read uncommitted`
@@ -944,7 +944,7 @@ Glossary
:term:`ACID`
- `Durability (via Wikipedia) <http://en.wikipedia.org/wiki/Durability_(database_systems)>`_
+ `Durability (via Wikipedia) <https://en.wikipedia.org/wiki/Durability_(database_systems)>`_
RETURNING
This is a non-SQL standard clause provided in various forms by
@@ -1334,7 +1334,7 @@ Glossary
:term:`primary key`
- `Candidate key (via Wikipedia) <http://en.wikipedia.org/wiki/Candidate_key>`_
+ `Candidate key (via Wikipedia) <https://en.wikipedia.org/wiki/Candidate_key>`_
https://www.databasestar.com/database-keys/
@@ -1364,7 +1364,7 @@ Glossary
:term:`composite primary key`
- `Primary key (via Wikipedia) <http://en.wikipedia.org/wiki/Primary_Key>`_
+ `Primary key (via Wikipedia) <https://en.wikipedia.org/wiki/Primary_Key>`_
composite primary key
@@ -1392,7 +1392,7 @@ Glossary
.. seealso::
- `Foreign Key Constraint (via Wikipedia) <http://en.wikipedia.org/wiki/Foreign_key_constraint>`_
+ `Foreign Key Constraint (via Wikipedia) <https://en.wikipedia.org/wiki/Foreign_key_constraint>`_
check constraint
@@ -1412,7 +1412,7 @@ Glossary
.. seealso::
- `CHECK constraint (via Wikipedia) <http://en.wikipedia.org/wiki/Check_constraint>`_
+ `CHECK constraint (via Wikipedia) <https://en.wikipedia.org/wiki/Check_constraint>`_
unique constraint
unique key index
@@ -1429,7 +1429,7 @@ Glossary
.. seealso::
- `Unique key (via Wikipedia) <http://en.wikipedia.org/wiki/Unique_key#Defining_unique_keys>`_
+ `Unique key (via Wikipedia) <https://en.wikipedia.org/wiki/Unique_key#Defining_unique_keys>`_
transient
This describes one of the major object states which
diff --git a/doc/build/intro.rst b/doc/build/intro.rst
index 877b67bdd..8b2135b7d 100644
--- a/doc/build/intro.rst
+++ b/doc/build/intro.rst
@@ -86,7 +86,7 @@ applications is at :ref:`examples_toplevel`.
There is also a wide variety of examples involving both core SQLAlchemy
constructs as well as the ORM on the wiki. See
-`Theatrum Chemicum <http://www.sqlalchemy.org/trac/wiki/UsageRecipes>`_.
+`Theatrum Chemicum <https://www.sqlalchemy.org/trac/wiki/UsageRecipes>`_.
.. _installation:
@@ -100,7 +100,7 @@ SQLAlchemy has been tested against the following platforms:
* cPython 2.7
* cPython 3.6 and higher
-* `PyPy <http://pypy.org/>`_ 2.1 or greater
+* `PyPy <https://pypy.org/>`_ 2.1 or greater
.. versionchanged:: 1.4
Within the Python 3 series, 3.6 is now the minimum Python 3 version supported.
@@ -113,9 +113,9 @@ Supported Installation Methods
-------------------------------
SQLAlchemy installation is via standard Python methodologies that are
-based on `setuptools <http://pypi.python.org/pypi/setuptools/>`_, either
+based on `setuptools <https://pypi.org/project/setuptools/>`_, either
by referring to ``setup.py`` directly or by using
-`pip <http://pypi.python.org/pypi/pip/>`_ or other setuptools-compatible
+`pip <https://pypi.org/project/pip/>`_ or other setuptools-compatible
approaches.
.. versionchanged:: 1.1 setuptools is now required by the setup.py file;
@@ -130,7 +130,7 @@ downloaded from PyPI and installed in one step::
pip install SQLAlchemy
This command will download the latest **released** version of SQLAlchemy from the `Python
-Cheese Shop <http://pypi.python.org/pypi/SQLAlchemy>`_ and install it to your system.
+Cheese Shop <https://pypi.org/project/SQLAlchemy>`_ and install it to your system.
In order to install the latest **prerelease** version, such as ``1.4.0b1``,
pip requires that the ``--pre`` flag be used::
diff --git a/doc/build/orm/cascades.rst b/doc/build/orm/cascades.rst
index ead4f75e9..9e497e354 100644
--- a/doc/build/orm/cascades.rst
+++ b/doc/build/orm/cascades.rst
@@ -674,7 +674,7 @@ desired state::
False
There is a recipe for intercepting :meth:`.Session.delete` and invoking this
-expiration automatically; see `ExpireRelationshipOnFKChange <http://www.sqlalchemy.org/trac/wiki/UsageRecipes/ExpireRelationshipOnFKChange>`_ for this. However, the usual practice of
+expiration automatically; see `ExpireRelationshipOnFKChange <https://www.sqlalchemy.org/trac/wiki/UsageRecipes/ExpireRelationshipOnFKChange>`_ for this. However, the usual practice of
deleting items within collections is to forego the usage of
:meth:`~.Session.delete` directly, and instead use cascade behavior to
automatically invoke the deletion as a result of removing the object from the
diff --git a/doc/build/orm/contextual.rst b/doc/build/orm/contextual.rst
index aebcfc3ff..94f985ae8 100644
--- a/doc/build/orm/contextual.rst
+++ b/doc/build/orm/contextual.rst
@@ -17,7 +17,7 @@ integration systems to help construct their integration schemes.
The object is the :class:`.scoped_session` object, and it represents a
**registry** of :class:`.Session` objects. If you're not familiar with the
registry pattern, a good introduction can be found in `Patterns of Enterprise
-Architecture <http://martinfowler.com/eaaCatalog/registry.html>`_.
+Architecture <https://martinfowler.com/eaaCatalog/registry.html>`_.
.. note::
@@ -27,8 +27,8 @@ Architecture <http://martinfowler.com/eaaCatalog/registry.html>`_.
management. If you're new to SQLAlchemy, and especially if the
term "thread-local variable" seems strange to you, we recommend that
if possible you familiarize first with an off-the-shelf integration
- system such as `Flask-SQLAlchemy <http://packages.python.org/Flask-SQLAlchemy/>`_
- or `zope.sqlalchemy <http://pypi.python.org/pypi/zope.sqlalchemy>`_.
+ system such as `Flask-SQLAlchemy <https://packages.python.org/Flask-SQLAlchemy/>`_
+ or `zope.sqlalchemy <https://pypi.org/project/zope.sqlalchemy>`_.
A :class:`.scoped_session` is constructed by calling it, passing it a
**factory** which can create new :class:`.Session` objects. A factory
@@ -117,7 +117,7 @@ to be in place such that multiple calls across many threads don't actually get
a handle to the same session. We call this notion **thread local storage**,
which means, a special object is used that will maintain a distinct object
per each application thread. Python provides this via the
-`threading.local() <http://docs.python.org/library/threading.html#threading.local>`_
+`threading.local() <https://docs.python.org/library/threading.html#threading.local>`_
construct. The :class:`.scoped_session` object by default uses this object
as storage, so that a single :class:`.Session` is maintained for all who call
upon the :class:`.scoped_session` registry, but only within the scope of a single
diff --git a/doc/build/orm/examples.rst b/doc/build/orm/examples.rst
index 10cafb2d2..dee737f86 100644
--- a/doc/build/orm/examples.rst
+++ b/doc/build/orm/examples.rst
@@ -10,7 +10,7 @@ runnable and can be found in the ``/examples`` directory of the
distribution. Descriptions and source code for all can be found here.
Additional SQLAlchemy examples, some user contributed, are available on the
-wiki at `<http://www.sqlalchemy.org/trac/wiki/UsageRecipes>`_.
+wiki at `<https://www.sqlalchemy.org/trac/wiki/UsageRecipes>`_.
Mapping Recipes
diff --git a/doc/build/orm/extensions/associationproxy.rst b/doc/build/orm/extensions/associationproxy.rst
index 640810117..de2001e6f 100644
--- a/doc/build/orm/extensions/associationproxy.rst
+++ b/doc/build/orm/extensions/associationproxy.rst
@@ -96,7 +96,7 @@ for us transparently::
[<__main__.Keyword object at 0x12cdd30>, <__main__.Keyword object at 0x12cde30>]
The :class:`.AssociationProxy` object produced by the :func:`.association_proxy` function
-is an instance of a `Python descriptor <http://docs.python.org/howto/descriptor.html>`_.
+is an instance of a `Python descriptor <https://docs.python.org/howto/descriptor.html>`_.
It is always declared with the user-defined class being mapped, regardless of
whether Declarative or classical mappings via the :func:`.mapper` function are used.
@@ -432,7 +432,7 @@ One caveat with our example above is that because ``Keyword`` objects are create
for each dictionary set operation, the example fails to maintain uniqueness for
the ``Keyword`` objects on their string name, which is a typical requirement for
a tagging scenario such as this one. For this use case the recipe
-`UniqueObject <http://www.sqlalchemy.org/trac/wiki/UsageRecipes/UniqueObject>`_, or
+`UniqueObject <https://www.sqlalchemy.org/trac/wiki/UsageRecipes/UniqueObject>`_, or
a comparable creational strategy, is
recommended, which will apply a "lookup first, then create" strategy to the constructor
of the ``Keyword`` class, so that an already existing ``Keyword`` is returned if the
diff --git a/doc/build/orm/nonstandard_mappings.rst b/doc/build/orm/nonstandard_mappings.rst
index 16473e26c..193531c91 100644
--- a/doc/build/orm/nonstandard_mappings.rst
+++ b/doc/build/orm/nonstandard_mappings.rst
@@ -197,5 +197,5 @@ directly to mapped table columns. The feature was removed and replaced
with a simple recipe-oriented approach to accomplishing this task
without any ambiguity of instrumentation - to create new subclasses, each
mapped individually. This pattern is now available as a recipe at `Entity Name
-<http://www.sqlalchemy.org/trac/wiki/UsageRecipes/EntityName>`_.
+<https://www.sqlalchemy.org/trac/wiki/UsageRecipes/EntityName>`_.
diff --git a/doc/build/orm/persistence_techniques.rst b/doc/build/orm/persistence_techniques.rst
index dad1f9f46..29b755cb7 100644
--- a/doc/build/orm/persistence_techniques.rst
+++ b/doc/build/orm/persistence_techniques.rst
@@ -651,7 +651,7 @@ keyword, described at :ref:`declarative_abstract`.
.. seealso::
- `Django-style Database Routers in SQLAlchemy <http://techspot.zzzeek.org/2012/01/11/django-style-database-routers-in-sqlalchemy/>`_ - blog post on a more comprehensive example of :meth:`.Session.get_bind`
+ `Django-style Database Routers in SQLAlchemy <https://techspot.zzzeek.org/2012/01/11/django-style-database-routers-in-sqlalchemy/>`_ - blog post on a more comprehensive example of :meth:`.Session.get_bind`
Horizontal Partitioning
-----------------------
diff --git a/doc/build/orm/session_state_management.rst b/doc/build/orm/session_state_management.rst
index 7b82ab240..64efffd76 100644
--- a/doc/build/orm/session_state_management.rst
+++ b/doc/build/orm/session_state_management.rst
@@ -648,5 +648,5 @@ transactions, an understanding of the isolation behavior in effect is essential.
:term:`isolation` - glossary explanation of isolation which includes links
to Wikipedia.
- `The SQLAlchemy Session In-Depth <http://techspot.zzzeek.org/2012/11/14/pycon-canada-the-sqlalchemy-session-in-depth/>`_ - a video + slides with an in-depth discussion of the object
+ `The SQLAlchemy Session In-Depth <https://techspot.zzzeek.org/2012/11/14/pycon-canada-the-sqlalchemy-session-in-depth/>`_ - a video + slides with an in-depth discussion of the object
lifecycle including the role of data expiration.
diff --git a/doc/build/orm/tutorial.rst b/doc/build/orm/tutorial.rst
index c64e1fc3b..0b1183589 100644
--- a/doc/build/orm/tutorial.rst
+++ b/doc/build/orm/tutorial.rst
@@ -1233,7 +1233,7 @@ See the docstring for :func:`_orm.relationship` for more detail on argument styl
and is a built in function of the relational database.
* FOREIGN KEY can refer to its own table. This is referred to as a "self-referential"
foreign key.
- * Read more about foreign keys at `Foreign Key - Wikipedia <http://en.wikipedia.org/wiki/Foreign_key>`_.
+ * Read more about foreign keys at `Foreign Key - Wikipedia <https://en.wikipedia.org/wiki/Foreign_key>`_.
We'll need to create the ``addresses`` table in the database, so we will issue
another CREATE from our metadata, which will skip over tables which have
@@ -1351,7 +1351,7 @@ Querying with Joins
Now that we have two tables, we can show some more features of :class:`_query.Query`,
specifically how to create queries that deal with both tables at the same time.
The `Wikipedia page on SQL JOIN
-<http://en.wikipedia.org/wiki/Join_%28SQL%29>`_ offers a good introduction to
+<https://en.wikipedia.org/wiki/Join_%28SQL%29>`_ offers a good introduction to
join techniques, several of which we'll illustrate here.
To construct a simple implicit join between ``User`` and ``Address``,
diff --git a/doc/build/orm/versioning.rst b/doc/build/orm/versioning.rst
index 64bc706e5..a141df6a0 100644
--- a/doc/build/orm/versioning.rst
+++ b/doc/build/orm/versioning.rst
@@ -45,7 +45,7 @@ transaction).
.. seealso::
- `Repeatable Read Isolation Level <http://www.postgresql.org/docs/9.1/static/transaction-iso.html#XACT-REPEATABLE-READ>`_ - PostgreSQL's implementation of repeatable read, including a description of the error condition.
+ `Repeatable Read Isolation Level <https://www.postgresql.org/docs/9.1/static/transaction-iso.html#XACT-REPEATABLE-READ>`_ - PostgreSQL's implementation of repeatable read, including a description of the error condition.
Simple Version Counting
-----------------------
@@ -141,7 +141,7 @@ some means of generating new identifiers when a row is subject to an INSERT
as well as with an UPDATE. For the UPDATE case, typically an update trigger
is needed, unless the database in question supports some other native
version identifier. The PostgreSQL database in particular supports a system
-column called `xmin <http://www.postgresql.org/docs/9.1/static/ddl-system-columns.html>`_
+column called `xmin <https://www.postgresql.org/docs/9.1/static/ddl-system-columns.html>`_
which provides UPDATE versioning. We can make use
of the PostgreSQL ``xmin`` column to version our ``User``
class as follows::
@@ -205,7 +205,7 @@ missed version counters::
It is *strongly recommended* that server side version counters only be used
when absolutely necessary and only on backends that support :term:`RETURNING`,
e.g. PostgreSQL, Oracle, SQL Server (though SQL Server has
-`major caveats <http://blogs.msdn.com/b/sqlprogrammability/archive/2008/07/11/update-with-output-clause-triggers-and-sqlmoreresults.aspx>`_ when triggers are used), Firebird.
+`major caveats <https://blogs.msdn.com/b/sqlprogrammability/archive/2008/07/11/update-with-output-clause-triggers-and-sqlmoreresults.aspx>`_ when triggers are used), Firebird.
.. versionadded:: 0.9.0
diff --git a/doc/build/tutorial/engine.rst b/doc/build/tutorial/engine.rst
index a23cc939f..fc8973c46 100644
--- a/doc/build/tutorial/engine.rst
+++ b/doc/build/tutorial/engine.rst
@@ -40,7 +40,7 @@ facts:
2. What :term:`DBAPI` are we using? The Python :term:`DBAPI` is a third party
driver that SQLAlchemy uses to interact with a particular database. In
this case, we're using the name ``pysqlite``, which in modern Python
- use is the `sqlite3 <http://docs.python.org/library/sqlite3.html>`_ standard
+ use is the `sqlite3 <https://docs.python.org/library/sqlite3.html>`_ standard
library interface for SQLite. If omitted, SQLAlchemy will use a default
:term:`DBAPI` for the particular database selected.
diff --git a/examples/generic_associations/__init__.py b/examples/generic_associations/__init__.py
index dd6f5321b..ba648060c 100644
--- a/examples/generic_associations/__init__.py
+++ b/examples/generic_associations/__init__.py
@@ -11,7 +11,7 @@ which contains ``Address`` objects.
The :viewsource:`.discriminator_on_association` and :viewsource:`.generic_fk` scripts
are modernized versions of recipes presented in the 2007 blog post
-`Polymorphic Associations with SQLAlchemy <http://techspot.zzzeek.org/2007/05/29/polymorphic-associations-with-sqlalchemy/>`_.
+`Polymorphic Associations with SQLAlchemy <https://techspot.zzzeek.org/2007/05/29/polymorphic-associations-with-sqlalchemy/>`_.
.. autosource::
diff --git a/examples/inheritance/single.py b/examples/inheritance/single.py
index 0d5871cb1..47cfd64eb 100644
--- a/examples/inheritance/single.py
+++ b/examples/inheritance/single.py
@@ -54,7 +54,7 @@ class Engineer(Person):
primary_language = Column(String(30))
# illustrate a single-inh "conflicting" column declaration;
- # see http://docs.sqlalchemy.org/en/latest/orm/extensions/
+ # see https://docs.sqlalchemy.org/en/latest/orm/extensions/
# declarative/inheritance.html#resolving-column-conflicts
@declared_attr
def status(cls):
diff --git a/examples/nested_sets/nested_sets.py b/examples/nested_sets/nested_sets.py
index ca3e91c9a..0450551f3 100644
--- a/examples/nested_sets/nested_sets.py
+++ b/examples/nested_sets/nested_sets.py
@@ -1,6 +1,6 @@
"""Celko's "Nested Sets" Tree Structure.
-http://www.intelligententerprise.com/001020/celko.jhtml
+https://www.intelligententerprise.com/001020/celko.jhtml
"""
diff --git a/examples/postgis/__init__.py b/examples/postgis/__init__.py
index dcdbfcf57..63eeb30ec 100644
--- a/examples/postgis/__init__.py
+++ b/examples/postgis/__init__.py
@@ -4,7 +4,7 @@ embed PostGIS functionality.
This example was originally developed in the hopes that it would be
extrapolated into a comprehensive PostGIS integration layer. We are
pleased to announce that this has come to fruition as `GeoAlchemy
-<http://www.geoalchemy.org/>`_.
+<https://geoalchemy-2.readthedocs.io>`_.
The example illustrates:
diff --git a/examples/sharding/__init__.py b/examples/sharding/__init__.py
index 90cf6cc6c..36f2fa412 100644
--- a/examples/sharding/__init__.py
+++ b/examples/sharding/__init__.py
@@ -32,7 +32,7 @@ to the issue of organizing instances among multiple databases. For a
more plain-spoken alternative, the "distinct entity" approach
is a simple method of assigning objects to different tables (and potentially
database nodes) in an explicit way - described on the wiki at
-`EntityName <http://www.sqlalchemy.org/trac/wiki/UsageRecipes/EntityName>`_.
+`EntityName <https://www.sqlalchemy.org/trac/wiki/UsageRecipes/EntityName>`_.
.. autosource::
diff --git a/lib/sqlalchemy/__init__.py b/lib/sqlalchemy/__init__.py
index 1f9127e05..5b9d626a7 100644
--- a/lib/sqlalchemy/__init__.py
+++ b/lib/sqlalchemy/__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 util as _util
from .engine import create_engine
diff --git a/lib/sqlalchemy/cextension/immutabledict.c b/lib/sqlalchemy/cextension/immutabledict.c
index a185f85b8..0b1003d63 100644
--- a/lib/sqlalchemy/cextension/immutabledict.c
+++ b/lib/sqlalchemy/cextension/immutabledict.c
@@ -3,7 +3,7 @@ immuatbledict.c
Copyright (C) 2005-2021 the SQLAlchemy authors and contributors <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
*/
#include <Python.h>
diff --git a/lib/sqlalchemy/cextension/processors.c b/lib/sqlalchemy/cextension/processors.c
index b6f37a7bb..f6f203e74 100644
--- a/lib/sqlalchemy/cextension/processors.c
+++ b/lib/sqlalchemy/cextension/processors.c
@@ -4,7 +4,7 @@ Copyright (C) 2010-2021 the SQLAlchemy authors and contributors <see AUTHORS fil
Copyright (C) 2010-2011 Gaetan de Menten gdementen@gmail.com
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
*/
#include <Python.h>
diff --git a/lib/sqlalchemy/cextension/resultproxy.c b/lib/sqlalchemy/cextension/resultproxy.c
index d869a058b..dc828698c 100644
--- a/lib/sqlalchemy/cextension/resultproxy.c
+++ b/lib/sqlalchemy/cextension/resultproxy.c
@@ -4,7 +4,7 @@ Copyright (C) 2010-2021 the SQLAlchemy authors and contributors <see AUTHORS fil
Copyright (C) 2010-2011 Gaetan de Menten gdementen@gmail.com
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
*/
#include <Python.h>
diff --git a/lib/sqlalchemy/connectors/__init__.py b/lib/sqlalchemy/connectors/__init__.py
index d2b9ba09f..fee8b3836 100644
--- a/lib/sqlalchemy/connectors/__init__.py
+++ b/lib/sqlalchemy/connectors/__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
class Connector(object):
diff --git a/lib/sqlalchemy/connectors/mxodbc.py b/lib/sqlalchemy/connectors/mxodbc.py
index 153a836d2..1c2fb00c0 100644
--- a/lib/sqlalchemy/connectors/mxodbc.py
+++ b/lib/sqlalchemy/connectors/mxodbc.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
"""
Provide a SQLALchemy connector for the eGenix mxODBC commercial
@@ -15,7 +15,7 @@ This has been tested for use with mxODBC 3.1.2 on SQL Server 2005
and 2008, using the SQL Server Native driver. However, it is
possible for this to be used on other database platforms.
-For more info on mxODBC, see http://www.egenix.com/
+For more info on mxODBC, see 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/connectors/pyodbc.py b/lib/sqlalchemy/connectors/pyodbc.py
index ddff62db6..ed7260d6b 100644
--- a/lib/sqlalchemy/connectors/pyodbc.py
+++ b/lib/sqlalchemy/connectors/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
import re
diff --git a/lib/sqlalchemy/databases/__init__.py b/lib/sqlalchemy/databases/__init__.py
index 276441be6..017680425 100644
--- a/lib/sqlalchemy/databases/__init__.py
+++ b/lib/sqlalchemy/databases/__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
"""Include imports from the sqlalchemy.dialects package for backwards
compatibility with pre 0.6 versions.
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
---------------
diff --git a/lib/sqlalchemy/engine/__init__.py b/lib/sqlalchemy/engine/__init__.py
index 237c40b26..3761f5005 100644
--- a/lib/sqlalchemy/engine/__init__.py
+++ b/lib/sqlalchemy/engine/__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
"""SQL connections, SQL execution and high-level DB-API interface.
diff --git a/lib/sqlalchemy/engine/base.py b/lib/sqlalchemy/engine/base.py
index 4d9750121..c26d9a0a7 100644
--- a/lib/sqlalchemy/engine/base.py
+++ b/lib/sqlalchemy/engine/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
from __future__ import with_statement
import contextlib
@@ -1222,8 +1222,9 @@ class Connection(Connectable):
Note above, the usage of a question mark "?" or other
symbol is contingent upon the "paramstyle" accepted by the DBAPI
in use, which may be any of "qmark", "named", "pyformat", "format",
- "numeric". See `pep-249 <http://www.python.org/dev/peps/pep-0249/>`_
- for details on paramstyle.
+ "numeric". See `pep-249
+ <https://www.python.org/dev/peps/pep-0249/>`_ for details on
+ paramstyle.
To execute a textual SQL statement which uses bound parameters in a
DBAPI-agnostic way, use the :func:`_expression.text` construct.
diff --git a/lib/sqlalchemy/engine/create.py b/lib/sqlalchemy/engine/create.py
index 3cf339cfc..b5ec22116 100644
--- a/lib/sqlalchemy/engine/create.py
+++ b/lib/sqlalchemy/engine/create.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
@@ -369,7 +369,7 @@ def create_engine(url, **kwargs):
be used instead. Can be used for testing of DBAPIs as well as to
inject "mock" DBAPI implementations into the :class:`_engine.Engine`.
- :param paramstyle=None: The `paramstyle <http://legacy.python.org/dev/peps/pep-0249/#paramstyle>`_
+ :param paramstyle=None: The `paramstyle <https://legacy.python.org/dev/peps/pep-0249/#paramstyle>`_
to use when rendering bound parameters. This style defaults to the
one recommended by the DBAPI itself, which is retrieved from the
``.paramstyle`` attribute of the DBAPI. However, most DBAPIs accept
diff --git a/lib/sqlalchemy/engine/cursor.py b/lib/sqlalchemy/engine/cursor.py
index 965959846..09c6a4db7 100644
--- a/lib/sqlalchemy/engine/cursor.py
+++ b/lib/sqlalchemy/engine/cursor.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
"""Define cursor-specific result set constructs including
:class:`.BaseCursorResult`, :class:`.CursorResult`."""
diff --git a/lib/sqlalchemy/engine/default.py b/lib/sqlalchemy/engine/default.py
index 7b3fa091f..8d6f40ff6 100644
--- a/lib/sqlalchemy/engine/default.py
+++ b/lib/sqlalchemy/engine/default.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
"""Default implementations of per-dialect sqlalchemy.engine classes.
diff --git a/lib/sqlalchemy/engine/events.py b/lib/sqlalchemy/engine/events.py
index c6e27c03c..f3775aed7 100644
--- a/lib/sqlalchemy/engine/events.py
+++ b/lib/sqlalchemy/engine/events.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 .base import Engine
diff --git a/lib/sqlalchemy/engine/interfaces.py b/lib/sqlalchemy/engine/interfaces.py
index b7190662f..8379c731a 100644
--- a/lib/sqlalchemy/engine/interfaces.py
+++ b/lib/sqlalchemy/engine/interfaces.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
"""Define core interfaces used by the engine system."""
diff --git a/lib/sqlalchemy/engine/mock.py b/lib/sqlalchemy/engine/mock.py
index f6cb71d40..803fe30a2 100644
--- a/lib/sqlalchemy/engine/mock.py
+++ b/lib/sqlalchemy/engine/mock.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 operator import attrgetter
diff --git a/lib/sqlalchemy/engine/reflection.py b/lib/sqlalchemy/engine/reflection.py
index 2cdd9ac3b..715781b7a 100644
--- a/lib/sqlalchemy/engine/reflection.py
+++ b/lib/sqlalchemy/engine/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
"""Provides an abstraction for obtaining database schema information.
diff --git a/lib/sqlalchemy/engine/result.py b/lib/sqlalchemy/engine/result.py
index fb4a7a4f3..119bf4a9e 100644
--- a/lib/sqlalchemy/engine/result.py
+++ b/lib/sqlalchemy/engine/result.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
"""Define generic result set constructs."""
diff --git a/lib/sqlalchemy/engine/row.py b/lib/sqlalchemy/engine/row.py
index 7c15b7f6e..dc11e3548 100644
--- a/lib/sqlalchemy/engine/row.py
+++ b/lib/sqlalchemy/engine/row.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
"""Define row constructs including :class:`.Row`."""
diff --git a/lib/sqlalchemy/engine/strategies.py b/lib/sqlalchemy/engine/strategies.py
index 1e9b707e8..bda1c7fae 100644
--- a/lib/sqlalchemy/engine/strategies.py
+++ b/lib/sqlalchemy/engine/strategies.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
"""Deprecated mock engine strategy used by Alembic.
diff --git a/lib/sqlalchemy/engine/url.py b/lib/sqlalchemy/engine/url.py
index f60b9d56d..d72654c73 100644
--- a/lib/sqlalchemy/engine/url.py
+++ b/lib/sqlalchemy/engine/url.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
"""Provides the :class:`~sqlalchemy.engine.url.URL` class which encapsulates
information about a database connection specification.
diff --git a/lib/sqlalchemy/engine/util.py b/lib/sqlalchemy/engine/util.py
index 17e3510aa..4f2e031ab 100644
--- a/lib/sqlalchemy/engine/util.py
+++ b/lib/sqlalchemy/engine/util.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 exc
from .. import util
diff --git a/lib/sqlalchemy/event/__init__.py b/lib/sqlalchemy/event/__init__.py
index 76738519f..15aae8d6d 100644
--- a/lib/sqlalchemy/event/__init__.py
+++ b/lib/sqlalchemy/event/__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 .api import CANCEL
from .api import contains
diff --git a/lib/sqlalchemy/event/api.py b/lib/sqlalchemy/event/api.py
index f1a2bb774..5a01c4b02 100644
--- a/lib/sqlalchemy/event/api.py
+++ b/lib/sqlalchemy/event/api.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
"""Public API functions for the event system.
diff --git a/lib/sqlalchemy/event/attr.py b/lib/sqlalchemy/event/attr.py
index e428d2635..a0c299221 100644
--- a/lib/sqlalchemy/event/attr.py
+++ b/lib/sqlalchemy/event/attr.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
"""Attribute implementation for _Dispatch classes.
diff --git a/lib/sqlalchemy/event/base.py b/lib/sqlalchemy/event/base.py
index fb75d9e3e..f8cbfbd7f 100644
--- a/lib/sqlalchemy/event/base.py
+++ b/lib/sqlalchemy/event/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
"""Base implementation classes.
diff --git a/lib/sqlalchemy/event/legacy.py b/lib/sqlalchemy/event/legacy.py
index ce2ed2d4f..0dbf69504 100644
--- a/lib/sqlalchemy/event/legacy.py
+++ b/lib/sqlalchemy/event/legacy.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
"""Routines to handle adaption of legacy call signatures,
generation of deprecation notes and docstrings.
diff --git a/lib/sqlalchemy/event/registry.py b/lib/sqlalchemy/event/registry.py
index 13310b11b..1f7cc43f1 100644
--- a/lib/sqlalchemy/event/registry.py
+++ b/lib/sqlalchemy/event/registry.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
"""Provides managed registration services on behalf of :func:`.listen`
arguments.
diff --git a/lib/sqlalchemy/events.py b/lib/sqlalchemy/events.py
index 3087c1b0f..8c0c5ff8d 100644
--- a/lib/sqlalchemy/events.py
+++ b/lib/sqlalchemy/events.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
"""Core event interfaces."""
diff --git a/lib/sqlalchemy/exc.py b/lib/sqlalchemy/exc.py
index 4501976e2..a24cf7ba4 100644
--- a/lib/sqlalchemy/exc.py
+++ b/lib/sqlalchemy/exc.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
"""Exceptions used with SQLAlchemy.
@@ -36,7 +36,7 @@ class HasDescriptionCode(object):
else:
return (
"(Background on this error at: "
- "http://sqlalche.me/e/%s/%s)"
+ "https://sqlalche.me/e/%s/%s)"
% (
_version_token,
self.code,
@@ -684,7 +684,7 @@ class RemovedIn20Warning(SADeprecationWarning):
def __str__(self):
return (
super(RemovedIn20Warning, self).__str__()
- + " (Background on SQLAlchemy 2.0 at: http://sqlalche.me/e/b8d9)"
+ + " (Background on SQLAlchemy 2.0 at: https://sqlalche.me/e/b8d9)"
)
diff --git a/lib/sqlalchemy/ext/__init__.py b/lib/sqlalchemy/ext/__init__.py
index 5f1783f75..a4a9b34ab 100644
--- a/lib/sqlalchemy/ext/__init__.py
+++ b/lib/sqlalchemy/ext/__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 util as _sa_util
diff --git a/lib/sqlalchemy/ext/associationproxy.py b/lib/sqlalchemy/ext/associationproxy.py
index 0b4d5954e..411033a6b 100644
--- a/lib/sqlalchemy/ext/associationproxy.py
+++ b/lib/sqlalchemy/ext/associationproxy.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
"""Contain the ``AssociationProxy`` class.
@@ -1326,7 +1326,7 @@ class _AssociationDict(_AssociationCollection):
elif len(a) == 1:
seq_or_map = a[0]
# discern dict from sequence - took the advice from
- # http://www.voidspace.org.uk/python/articles/duck_typing.shtml
+ # https://www.voidspace.org.uk/python/articles/duck_typing.shtml
# still not perfect :(
if hasattr(seq_or_map, "keys"):
for item in seq_or_map:
diff --git a/lib/sqlalchemy/ext/asyncio/__init__.py b/lib/sqlalchemy/ext/asyncio/__init__.py
index 19e6079dc..ac3b905c6 100644
--- a/lib/sqlalchemy/ext/asyncio/__init__.py
+++ b/lib/sqlalchemy/ext/asyncio/__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 .engine import AsyncConnection
from .engine import AsyncEngine
diff --git a/lib/sqlalchemy/ext/asyncio/engine.py b/lib/sqlalchemy/ext/asyncio/engine.py
index 8e5c01919..f5c3bdca4 100644
--- a/lib/sqlalchemy/ext/asyncio/engine.py
+++ b/lib/sqlalchemy/ext/asyncio/engine.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 exc as async_exc
from .base import ProxyComparable
from .base import StartableContext
diff --git a/lib/sqlalchemy/ext/asyncio/events.py b/lib/sqlalchemy/ext/asyncio/events.py
index bafcf5a4d..e3d845690 100644
--- a/lib/sqlalchemy/ext/asyncio/events.py
+++ b/lib/sqlalchemy/ext/asyncio/events.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 .engine import AsyncConnectable
from .session import AsyncSession
diff --git a/lib/sqlalchemy/ext/asyncio/exc.py b/lib/sqlalchemy/ext/asyncio/exc.py
index ef9e76370..fc53f5c4b 100644
--- a/lib/sqlalchemy/ext/asyncio/exc.py
+++ b/lib/sqlalchemy/ext/asyncio/exc.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 exc
diff --git a/lib/sqlalchemy/ext/asyncio/result.py b/lib/sqlalchemy/ext/asyncio/result.py
index 4781b3ead..2fdaec741 100644
--- a/lib/sqlalchemy/ext/asyncio/result.py
+++ b/lib/sqlalchemy/ext/asyncio/result.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 operator
diff --git a/lib/sqlalchemy/ext/asyncio/scoping.py b/lib/sqlalchemy/ext/asyncio/scoping.py
index 4d1cea9f9..92d894599 100644
--- a/lib/sqlalchemy/ext/asyncio/scoping.py
+++ b/lib/sqlalchemy/ext/asyncio/scoping.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 .session import AsyncSession
from ...orm.scoping import ScopedSessionMixin
diff --git a/lib/sqlalchemy/ext/asyncio/session.py b/lib/sqlalchemy/ext/asyncio/session.py
index 16e15c873..59b6a2b15 100644
--- a/lib/sqlalchemy/ext/asyncio/session.py
+++ b/lib/sqlalchemy/ext/asyncio/session.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 engine
from . import result as _result
from .base import ReversibleProxy
diff --git a/lib/sqlalchemy/ext/automap.py b/lib/sqlalchemy/ext/automap.py
index 8b75dce7b..7cb2c4400 100644
--- a/lib/sqlalchemy/ext/automap.py
+++ b/lib/sqlalchemy/ext/automap.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"""Define an extension to the :mod:`sqlalchemy.ext.declarative` system
which automatically generates mapped classes and relationships from a database
@@ -185,7 +185,7 @@ are known as :func:`.classname_for_table`,
and :func:`.name_for_collection_relationship`. Any or all of these
functions are provided as in the example below, where we use a "camel case"
scheme for class names and a "pluralizer" for collection names using the
-`Inflect <https://pypi.python.org/pypi/inflect>`_ package::
+`Inflect <https://pypi.org/project/inflect>`_ package::
import re
import inflect
diff --git a/lib/sqlalchemy/ext/baked.py b/lib/sqlalchemy/ext/baked.py
index 5d33bc76d..61328fce9 100644
--- a/lib/sqlalchemy/ext/baked.py
+++ b/lib/sqlalchemy/ext/baked.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
"""Baked query extension.
Provides a creational pattern for the :class:`.query.Query` object which
diff --git a/lib/sqlalchemy/ext/compiler.py b/lib/sqlalchemy/ext/compiler.py
index 47fb6720b..c7eb7cc32 100644
--- a/lib/sqlalchemy/ext/compiler.py
+++ b/lib/sqlalchemy/ext/compiler.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"""Provides an API for creation of custom ClauseElements and compilers.
diff --git a/lib/sqlalchemy/ext/declarative/__init__.py b/lib/sqlalchemy/ext/declarative/__init__.py
index 9fc45dfaa..b1c1d3691 100644
--- a/lib/sqlalchemy/ext/declarative/__init__.py
+++ b/lib/sqlalchemy/ext/declarative/__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 .extensions import AbstractConcreteBase
from .extensions import ConcreteBase
diff --git a/lib/sqlalchemy/ext/declarative/extensions.py b/lib/sqlalchemy/ext/declarative/extensions.py
index 5e1e3fe85..1a12b1205 100644
--- a/lib/sqlalchemy/ext/declarative/extensions.py
+++ b/lib/sqlalchemy/ext/declarative/extensions.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
"""Public API functions and helpers for declarative."""
diff --git a/lib/sqlalchemy/ext/horizontal_shard.py b/lib/sqlalchemy/ext/horizontal_shard.py
index 0829d9f13..8fb3bf282 100644
--- a/lib/sqlalchemy/ext/horizontal_shard.py
+++ b/lib/sqlalchemy/ext/horizontal_shard.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
"""Horizontal sharding support.
diff --git a/lib/sqlalchemy/ext/hybrid.py b/lib/sqlalchemy/ext/hybrid.py
index 378e6c18b..298d957f6 100644
--- a/lib/sqlalchemy/ext/hybrid.py
+++ b/lib/sqlalchemy/ext/hybrid.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"""Define attributes on ORM-mapped classes that have "hybrid" behavior.
@@ -646,11 +646,11 @@ measurement, currencies and encrypted passwords.
.. seealso::
`Hybrids and Value Agnostic Types
- <http://techspot.zzzeek.org/2011/10/21/hybrids-and-value-agnostic-types/>`_
+ <https://techspot.zzzeek.org/2011/10/21/hybrids-and-value-agnostic-types/>`_
- on the techspot.zzzeek.org blog
`Value Agnostic Types, Part II
- <http://techspot.zzzeek.org/2011/10/29/value-agnostic-types-part-ii/>`_ -
+ <https://techspot.zzzeek.org/2011/10/29/value-agnostic-types-part-ii/>`_ -
on the techspot.zzzeek.org blog
.. _hybrid_transformers:
diff --git a/lib/sqlalchemy/ext/indexable.py b/lib/sqlalchemy/ext/indexable.py
index b64a358ce..313ad11af 100644
--- a/lib/sqlalchemy/ext/indexable.py
+++ b/lib/sqlalchemy/ext/indexable.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
"""Define attributes on ORM-mapped classes that have "index" attributes for
columns with :class:`_types.Indexable` types.
diff --git a/lib/sqlalchemy/ext/mutable.py b/lib/sqlalchemy/ext/mutable.py
index fef886501..4eed3b2af 100644
--- a/lib/sqlalchemy/ext/mutable.py
+++ b/lib/sqlalchemy/ext/mutable.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"""Provide support for tracking of in-place changes to scalar values,
which are propagated into ORM change events on owning parent objects.
diff --git a/lib/sqlalchemy/ext/mypy/apply.py b/lib/sqlalchemy/ext/mypy/apply.py
index 5dc9ec0b1..293ef2f9a 100644
--- a/lib/sqlalchemy/ext/mypy/apply.py
+++ b/lib/sqlalchemy/ext/mypy/apply.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 typing import Optional
from typing import Union
diff --git a/lib/sqlalchemy/ext/mypy/decl_class.py b/lib/sqlalchemy/ext/mypy/decl_class.py
index 61737fd66..45d025fc9 100644
--- a/lib/sqlalchemy/ext/mypy/decl_class.py
+++ b/lib/sqlalchemy/ext/mypy/decl_class.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 typing import Optional
from typing import Union
diff --git a/lib/sqlalchemy/ext/mypy/infer.py b/lib/sqlalchemy/ext/mypy/infer.py
index 2fea6d340..ca2b62966 100644
--- a/lib/sqlalchemy/ext/mypy/infer.py
+++ b/lib/sqlalchemy/ext/mypy/infer.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 typing import Optional
from typing import Sequence
diff --git a/lib/sqlalchemy/ext/mypy/names.py b/lib/sqlalchemy/ext/mypy/names.py
index 6ee600cd7..653ce4985 100644
--- a/lib/sqlalchemy/ext/mypy/names.py
+++ b/lib/sqlalchemy/ext/mypy/names.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 typing import Dict
from typing import List
diff --git a/lib/sqlalchemy/ext/mypy/plugin.py b/lib/sqlalchemy/ext/mypy/plugin.py
index 76aac5152..687aeb851 100644
--- a/lib/sqlalchemy/ext/mypy/plugin.py
+++ b/lib/sqlalchemy/ext/mypy/plugin.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
"""
Mypy plugin for SQLAlchemy ORM.
diff --git a/lib/sqlalchemy/ext/orderinglist.py b/lib/sqlalchemy/ext/orderinglist.py
index 2cb85588b..a5c418e72 100644
--- a/lib/sqlalchemy/ext/orderinglist.py
+++ b/lib/sqlalchemy/ext/orderinglist.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
"""A custom list that manages index/position information for contained
elements.
diff --git a/lib/sqlalchemy/ext/serializer.py b/lib/sqlalchemy/ext/serializer.py
index 08c5cfc06..18a54e079 100644
--- a/lib/sqlalchemy/ext/serializer.py
+++ b/lib/sqlalchemy/ext/serializer.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
"""Serializer/Deserializer objects for usage with SQLAlchemy query structures,
allowing "contextual" deserialization.
diff --git a/lib/sqlalchemy/future/__init__.py b/lib/sqlalchemy/future/__init__.py
index 976c20136..9bf4d042d 100644
--- a/lib/sqlalchemy/future/__init__.py
+++ b/lib/sqlalchemy/future/__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
"""Future 2.0 API features.
diff --git a/lib/sqlalchemy/future/orm/__init__.py b/lib/sqlalchemy/future/orm/__init__.py
index abf6476e3..89b490d71 100644
--- a/lib/sqlalchemy/future/orm/__init__.py
+++ b/lib/sqlalchemy/future/orm/__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
"""Future 2.0 API features for Orm.
diff --git a/lib/sqlalchemy/inspection.py b/lib/sqlalchemy/inspection.py
index 3341bfac8..40b746655 100644
--- a/lib/sqlalchemy/inspection.py
+++ b/lib/sqlalchemy/inspection.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
"""The inspection module provides the :func:`_sa.inspect` function,
which delivers runtime information about a wide variety
diff --git a/lib/sqlalchemy/log.py b/lib/sqlalchemy/log.py
index 687cc066b..9ec3842a6 100644
--- a/lib/sqlalchemy/log.py
+++ b/lib/sqlalchemy/log.py
@@ -4,7 +4,7 @@
# Includes alterations by Vinay Sajip vinay_sajip@yahoo.co.uk
#
# 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
"""Logging control and utilities.
diff --git a/lib/sqlalchemy/orm/__init__.py b/lib/sqlalchemy/orm/__init__.py
index 66c3e7e33..a247b597b 100644
--- a/lib/sqlalchemy/orm/__init__.py
+++ b/lib/sqlalchemy/orm/__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
"""
Functional constructs for ORM configuration.
diff --git a/lib/sqlalchemy/orm/attributes.py b/lib/sqlalchemy/orm/attributes.py
index 105a9cfd2..33154ad00 100644
--- a/lib/sqlalchemy/orm/attributes.py
+++ b/lib/sqlalchemy/orm/attributes.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
"""Defines instrumentation for class attributes and their interaction
with instances.
diff --git a/lib/sqlalchemy/orm/base.py b/lib/sqlalchemy/orm/base.py
index 2932f1bb9..59af92935 100644
--- a/lib/sqlalchemy/orm/base.py
+++ b/lib/sqlalchemy/orm/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
"""Constants and rudimental functions used throughout the ORM.
diff --git a/lib/sqlalchemy/orm/clsregistry.py b/lib/sqlalchemy/orm/clsregistry.py
index 0bc888197..4ec31bcf7 100644
--- a/lib/sqlalchemy/orm/clsregistry.py
+++ b/lib/sqlalchemy/orm/clsregistry.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
"""Routines to handle the string class registry used by declarative.
This system allows specification of classes and expressions used in
diff --git a/lib/sqlalchemy/orm/collections.py b/lib/sqlalchemy/orm/collections.py
index 3874cd5f9..ec4d00cb0 100644
--- a/lib/sqlalchemy/orm/collections.py
+++ b/lib/sqlalchemy/orm/collections.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
"""Support for collections of mapped entities.
diff --git a/lib/sqlalchemy/orm/context.py b/lib/sqlalchemy/orm/context.py
index 78026efb1..26e35b66e 100644
--- a/lib/sqlalchemy/orm/context.py
+++ b/lib/sqlalchemy/orm/context.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 attributes
from . import interfaces
from . import loading
diff --git a/lib/sqlalchemy/orm/decl_api.py b/lib/sqlalchemy/orm/decl_api.py
index e829de5f6..54e927ee4 100644
--- a/lib/sqlalchemy/orm/decl_api.py
+++ b/lib/sqlalchemy/orm/decl_api.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
"""Public API functions and helpers for declarative."""
from __future__ import absolute_import
diff --git a/lib/sqlalchemy/orm/decl_base.py b/lib/sqlalchemy/orm/decl_base.py
index f52827ad1..e1945e8ee 100644
--- a/lib/sqlalchemy/orm/decl_base.py
+++ b/lib/sqlalchemy/orm/decl_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
"""Internal implementation for declarative."""
from __future__ import absolute_import
diff --git a/lib/sqlalchemy/orm/dependency.py b/lib/sqlalchemy/orm/dependency.py
index 85f6b68ff..eae50a6db 100644
--- a/lib/sqlalchemy/orm/dependency.py
+++ b/lib/sqlalchemy/orm/dependency.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
"""Relationship dependencies.
diff --git a/lib/sqlalchemy/orm/descriptor_props.py b/lib/sqlalchemy/orm/descriptor_props.py
index f8c42ee60..822a0a5a3 100644
--- a/lib/sqlalchemy/orm/descriptor_props.py
+++ b/lib/sqlalchemy/orm/descriptor_props.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
"""Descriptor properties are more "auxiliary" properties
that exist as configurational elements, but don't participate
diff --git a/lib/sqlalchemy/orm/dynamic.py b/lib/sqlalchemy/orm/dynamic.py
index 5cc00dbff..405498aaf 100644
--- a/lib/sqlalchemy/orm/dynamic.py
+++ b/lib/sqlalchemy/orm/dynamic.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
"""Dynamic collection API.
diff --git a/lib/sqlalchemy/orm/evaluator.py b/lib/sqlalchemy/orm/evaluator.py
index 135125663..69d80dd8b 100644
--- a/lib/sqlalchemy/orm/evaluator.py
+++ b/lib/sqlalchemy/orm/evaluator.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 operator
diff --git a/lib/sqlalchemy/orm/events.py b/lib/sqlalchemy/orm/events.py
index 926c2dea7..2c8d155ad 100644
--- a/lib/sqlalchemy/orm/events.py
+++ b/lib/sqlalchemy/orm/events.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
"""ORM event interfaces.
diff --git a/lib/sqlalchemy/orm/exc.py b/lib/sqlalchemy/orm/exc.py
index 9aab78e06..dbb499d5d 100644
--- a/lib/sqlalchemy/orm/exc.py
+++ b/lib/sqlalchemy/orm/exc.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
"""SQLAlchemy ORM exceptions."""
from .. import exc as sa_exc
diff --git a/lib/sqlalchemy/orm/identity.py b/lib/sqlalchemy/orm/identity.py
index c0ed38365..7eec4fd8d 100644
--- a/lib/sqlalchemy/orm/identity.py
+++ b/lib/sqlalchemy/orm/identity.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 weakref
diff --git a/lib/sqlalchemy/orm/instrumentation.py b/lib/sqlalchemy/orm/instrumentation.py
index 1edcab72a..02fc73793 100644
--- a/lib/sqlalchemy/orm/instrumentation.py
+++ b/lib/sqlalchemy/orm/instrumentation.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
"""Defines SQLAlchemy's system of class instrumentation.
diff --git a/lib/sqlalchemy/orm/interfaces.py b/lib/sqlalchemy/orm/interfaces.py
index 28b4bfb2d..f17cc6159 100644
--- a/lib/sqlalchemy/orm/interfaces.py
+++ b/lib/sqlalchemy/orm/interfaces.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/orm/loading.py b/lib/sqlalchemy/orm/loading.py
index b063635ea..948f33ad5 100644
--- a/lib/sqlalchemy/orm/loading.py
+++ b/lib/sqlalchemy/orm/loading.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
"""private module containing functions used to convert database
rows into object instances and associated state.
diff --git a/lib/sqlalchemy/orm/mapper.py b/lib/sqlalchemy/orm/mapper.py
index bab2eb6b9..d691b8e1d 100644
--- a/lib/sqlalchemy/orm/mapper.py
+++ b/lib/sqlalchemy/orm/mapper.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
"""Logic to map Python classes to and from selectables.
diff --git a/lib/sqlalchemy/orm/path_registry.py b/lib/sqlalchemy/orm/path_registry.py
index 13ff90cdb..d50a242ee 100644
--- a/lib/sqlalchemy/orm/path_registry.py
+++ b/lib/sqlalchemy/orm/path_registry.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
"""Path tracking utilities, representing mapper graph traversals.
"""
diff --git a/lib/sqlalchemy/orm/persistence.py b/lib/sqlalchemy/orm/persistence.py
index 7ab9eeda7..4747d0bba 100644
--- a/lib/sqlalchemy/orm/persistence.py
+++ b/lib/sqlalchemy/orm/persistence.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
"""private module containing functions used to emit INSERT, UPDATE
and DELETE statements on behalf of a :class:`_orm.Mapper` and its descending
diff --git a/lib/sqlalchemy/orm/properties.py b/lib/sqlalchemy/orm/properties.py
index 18121bb04..1a1806c9e 100644
--- a/lib/sqlalchemy/orm/properties.py
+++ b/lib/sqlalchemy/orm/properties.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
"""MapperProperty implementations.
diff --git a/lib/sqlalchemy/orm/query.py b/lib/sqlalchemy/orm/query.py
index a89b86c79..6ad7f3020 100644
--- a/lib/sqlalchemy/orm/query.py
+++ b/lib/sqlalchemy/orm/query.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
"""The Query class and support.
@@ -510,7 +510,7 @@ class Query(
Here is the `PostgreSQL WITH
RECURSIVE example
- <http://www.postgresql.org/docs/8.4/static/queries-with.html>`_.
+ <https://www.postgresql.org/docs/8.4/static/queries-with.html>`_.
Note that, in this example, the ``included_parts`` cte and the
``incl_alias`` alias of it are Core selectables, which
means the columns are accessed via the ``.c.`` attribute. The
diff --git a/lib/sqlalchemy/orm/relationships.py b/lib/sqlalchemy/orm/relationships.py
index 2224b4902..4429720c3 100644
--- a/lib/sqlalchemy/orm/relationships.py
+++ b/lib/sqlalchemy/orm/relationships.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
"""Heuristics related to join conditions as used in
:func:`_orm.relationship`.
diff --git a/lib/sqlalchemy/orm/scoping.py b/lib/sqlalchemy/orm/scoping.py
index 6bd052dde..be16bc911 100644
--- a/lib/sqlalchemy/orm/scoping.py
+++ b/lib/sqlalchemy/orm/scoping.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 class_mapper
from . import exc as orm_exc
diff --git a/lib/sqlalchemy/orm/session.py b/lib/sqlalchemy/orm/session.py
index 81da15283..8302f70d6 100644
--- a/lib/sqlalchemy/orm/session.py
+++ b/lib/sqlalchemy/orm/session.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
"""Provides the Session class and related utilities."""
@@ -1770,7 +1770,7 @@ class Session(_SessionClassMethods):
the connections are no longer safe to be used.
Below illustrates a scenario when using `gevent
- <http://www.gevent.org/>`_, which can produce ``Timeout`` exceptions
+ <https://www.gevent.org/>`_, which can produce ``Timeout`` exceptions
that may mean the underlying connection should be discarded::
import gevent
diff --git a/lib/sqlalchemy/orm/state.py b/lib/sqlalchemy/orm/state.py
index 884e364c6..994cbe53e 100644
--- a/lib/sqlalchemy/orm/state.py
+++ b/lib/sqlalchemy/orm/state.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
"""Defines instrumentation of instances.
diff --git a/lib/sqlalchemy/orm/strategies.py b/lib/sqlalchemy/orm/strategies.py
index 2a254f8de..6d8a5f817 100644
--- a/lib/sqlalchemy/orm/strategies.py
+++ b/lib/sqlalchemy/orm/strategies.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
"""sqlalchemy.orm.interfaces.LoaderStrategy
implementations, and related MapperOptions."""
diff --git a/lib/sqlalchemy/orm/strategy_options.py b/lib/sqlalchemy/orm/strategy_options.py
index 91e627525..043ecfed3 100644
--- a/lib/sqlalchemy/orm/strategy_options.py
+++ b/lib/sqlalchemy/orm/strategy_options.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
"""
diff --git a/lib/sqlalchemy/orm/sync.py b/lib/sqlalchemy/orm/sync.py
index 691961f38..9d684a2a8 100644
--- a/lib/sqlalchemy/orm/sync.py
+++ b/lib/sqlalchemy/orm/sync.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
"""private module containing functions used for copying data
between instances based on join conditions.
diff --git a/lib/sqlalchemy/orm/unitofwork.py b/lib/sqlalchemy/orm/unitofwork.py
index ae99da059..f29d11bcd 100644
--- a/lib/sqlalchemy/orm/unitofwork.py
+++ b/lib/sqlalchemy/orm/unitofwork.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
"""The internals for the unit of work system.
diff --git a/lib/sqlalchemy/orm/util.py b/lib/sqlalchemy/orm/util.py
index 15f584c1f..7cfb3589d 100644
--- a/lib/sqlalchemy/orm/util.py
+++ b/lib/sqlalchemy/orm/util.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/pool/__init__.py b/lib/sqlalchemy/pool/__init__.py
index 125c5d894..5b4f4ebb1 100644
--- a/lib/sqlalchemy/pool/__init__.py
+++ b/lib/sqlalchemy/pool/__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
"""Connection pooling for DB-API connections.
diff --git a/lib/sqlalchemy/pool/base.py b/lib/sqlalchemy/pool/base.py
index 8a3abb82f..db63dfec8 100644
--- a/lib/sqlalchemy/pool/base.py
+++ b/lib/sqlalchemy/pool/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
"""Base constructs for connection pools.
diff --git a/lib/sqlalchemy/pool/dbapi_proxy.py b/lib/sqlalchemy/pool/dbapi_proxy.py
index 96b5e8cba..7dfb59e36 100644
--- a/lib/sqlalchemy/pool/dbapi_proxy.py
+++ b/lib/sqlalchemy/pool/dbapi_proxy.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
"""DBAPI proxy utility.
diff --git a/lib/sqlalchemy/pool/events.py b/lib/sqlalchemy/pool/events.py
index 03106019e..18ef28fa5 100644
--- a/lib/sqlalchemy/pool/events.py
+++ b/lib/sqlalchemy/pool/events.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 .base import Pool
from .. import event
diff --git a/lib/sqlalchemy/pool/impl.py b/lib/sqlalchemy/pool/impl.py
index 99d0c94d2..8a3412385 100644
--- a/lib/sqlalchemy/pool/impl.py
+++ b/lib/sqlalchemy/pool/impl.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
"""Pool implementation classes.
diff --git a/lib/sqlalchemy/processors.py b/lib/sqlalchemy/processors.py
index c090548e8..0c0aa1bd6 100644
--- a/lib/sqlalchemy/processors.py
+++ b/lib/sqlalchemy/processors.py
@@ -4,7 +4,7 @@
# Copyright (C) 2010 Gaetan de Menten gdementen@gmail.com
#
# 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
"""defines generic type conversion functions, as used in bind and result
processors.
diff --git a/lib/sqlalchemy/schema.py b/lib/sqlalchemy/schema.py
index 9bd780f7e..eeb7f751a 100644
--- a/lib/sqlalchemy/schema.py
+++ b/lib/sqlalchemy/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
"""Compatibility namespace for sqlalchemy.sql.schema and related.
diff --git a/lib/sqlalchemy/sql/__init__.py b/lib/sqlalchemy/sql/__init__.py
index 35621e93d..f374d555d 100644
--- a/lib/sqlalchemy/sql/__init__.py
+++ b/lib/sqlalchemy/sql/__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 .base import Executable
from .compiler import COLLECT_CARTESIAN_PRODUCTS
diff --git a/lib/sqlalchemy/sql/annotation.py b/lib/sqlalchemy/sql/annotation.py
index 2436c9c3f..e6618937a 100644
--- a/lib/sqlalchemy/sql/annotation.py
+++ b/lib/sqlalchemy/sql/annotation.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
"""The :class:`.Annotated` class and related routines; creates hash-equivalent
copies of SQL constructs which contain context-specific markers and
diff --git a/lib/sqlalchemy/sql/base.py b/lib/sqlalchemy/sql/base.py
index d7f5e1c0e..d998e8e5c 100644
--- a/lib/sqlalchemy/sql/base.py
+++ b/lib/sqlalchemy/sql/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
"""Foundational utilities common to many sql modules.
diff --git a/lib/sqlalchemy/sql/coercions.py b/lib/sqlalchemy/sql/coercions.py
index ea2289a9d..1da1fee86 100644
--- a/lib/sqlalchemy/sql/coercions.py
+++ b/lib/sqlalchemy/sql/coercions.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 numbers
import re
diff --git a/lib/sqlalchemy/sql/compiler.py b/lib/sqlalchemy/sql/compiler.py
index 67da03683..4b3b2c293 100644
--- a/lib/sqlalchemy/sql/compiler.py
+++ b/lib/sqlalchemy/sql/compiler.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
"""Base SQL and DDL compiler implementations.
diff --git a/lib/sqlalchemy/sql/crud.py b/lib/sqlalchemy/sql/crud.py
index 25dc0d232..de847fb7f 100644
--- a/lib/sqlalchemy/sql/crud.py
+++ b/lib/sqlalchemy/sql/crud.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
"""Functions used by compiler.py to determine the parameters rendered
within INSERT and UPDATE statements.
diff --git a/lib/sqlalchemy/sql/ddl.py b/lib/sqlalchemy/sql/ddl.py
index 4d69e5edc..233e79f7c 100644
--- a/lib/sqlalchemy/sql/ddl.py
+++ b/lib/sqlalchemy/sql/ddl.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
"""
Provides the hierarchy of DDL-defining schema items as well as routines
to invoke them for a create/drop call.
@@ -1098,7 +1098,7 @@ class SchemaDropper(DDLBase):
# traverse client side defaults which may refer to server-side
# sequences. noting that some of these client side defaults may also be
- # set up as server side defaults (see http://docs.sqlalchemy.org/en/
+ # set up as server side defaults (see https://docs.sqlalchemy.org/en/
# latest/core/defaults.html#associating-a-sequence-as-the-server-side-
# default), so have to be dropped after the table is dropped.
for column in table.columns:
diff --git a/lib/sqlalchemy/sql/default_comparator.py b/lib/sqlalchemy/sql/default_comparator.py
index 88f9e6523..557095d04 100644
--- a/lib/sqlalchemy/sql/default_comparator.py
+++ b/lib/sqlalchemy/sql/default_comparator.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
"""Default implementation of SQL comparison operations.
"""
diff --git a/lib/sqlalchemy/sql/dml.py b/lib/sqlalchemy/sql/dml.py
index a6ef62619..dd012ac86 100644
--- a/lib/sqlalchemy/sql/dml.py
+++ b/lib/sqlalchemy/sql/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
"""
Provide :class:`_expression.Insert`, :class:`_expression.Update` and
:class:`_expression.Delete`.
diff --git a/lib/sqlalchemy/sql/elements.py b/lib/sqlalchemy/sql/elements.py
index 709106b6b..73311f110 100644
--- a/lib/sqlalchemy/sql/elements.py
+++ b/lib/sqlalchemy/sql/elements.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
"""Core SQL expression elements, including :class:`_expression.ClauseElement`,
:class:`_expression.ColumnElement`, and derived classes.
diff --git a/lib/sqlalchemy/sql/events.py b/lib/sqlalchemy/sql/events.py
index 18c0e8c60..a6c5c8e28 100644
--- a/lib/sqlalchemy/sql/events.py
+++ b/lib/sqlalchemy/sql/events.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 .base import SchemaEventTarget
from .. import event
diff --git a/lib/sqlalchemy/sql/expression.py b/lib/sqlalchemy/sql/expression.py
index f47dc5fdf..129e628ab 100644
--- a/lib/sqlalchemy/sql/expression.py
+++ b/lib/sqlalchemy/sql/expression.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
"""Defines the public namespace for SQL expression constructs.
diff --git a/lib/sqlalchemy/sql/functions.py b/lib/sqlalchemy/sql/functions.py
index 0aa870ce4..dd807210f 100644
--- a/lib/sqlalchemy/sql/functions.py
+++ b/lib/sqlalchemy/sql/functions.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
"""SQL function API, factories, and built-in functions.
diff --git a/lib/sqlalchemy/sql/lambdas.py b/lib/sqlalchemy/sql/lambdas.py
index b3f47252a..d33e8ebfb 100644
--- a/lib/sqlalchemy/sql/lambdas.py
+++ b/lib/sqlalchemy/sql/lambdas.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 itertools
import operator
diff --git a/lib/sqlalchemy/sql/naming.py b/lib/sqlalchemy/sql/naming.py
index b79316435..d01eabb58 100644
--- a/lib/sqlalchemy/sql/naming.py
+++ b/lib/sqlalchemy/sql/naming.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
"""Establish constraint and index naming conventions.
diff --git a/lib/sqlalchemy/sql/operators.py b/lib/sqlalchemy/sql/operators.py
index 408a505aa..771de1e47 100644
--- a/lib/sqlalchemy/sql/operators.py
+++ b/lib/sqlalchemy/sql/operators.py
@@ -3,10 +3,10 @@
# <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
# 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
"""Defines operators used in SQL expressions."""
diff --git a/lib/sqlalchemy/sql/roles.py b/lib/sqlalchemy/sql/roles.py
index 8982cb159..a5eefc7b5 100644
--- a/lib/sqlalchemy/sql/roles.py
+++ b/lib/sqlalchemy/sql/roles.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 util
diff --git a/lib/sqlalchemy/sql/schema.py b/lib/sqlalchemy/sql/schema.py
index a8870f7f1..d9c7eb8b9 100644
--- a/lib/sqlalchemy/sql/schema.py
+++ b/lib/sqlalchemy/sql/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
"""The schema module provides the building blocks for database metadata.
diff --git a/lib/sqlalchemy/sql/selectable.py b/lib/sqlalchemy/sql/selectable.py
index 557c443bf..0092fe094 100644
--- a/lib/sqlalchemy/sql/selectable.py
+++ b/lib/sqlalchemy/sql/selectable.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
"""The :class:`_expression.FromClause` class of SQL expression elements,
representing
@@ -2152,7 +2152,7 @@ class HasCTE(roles.HasCTERole):
from those already selected.
The following examples include two from PostgreSQL's documentation at
- http://www.postgresql.org/docs/current/static/queries-with.html,
+ https://www.postgresql.org/docs/current/static/queries-with.html,
as well as additional examples.
Example 1, non recursive::
diff --git a/lib/sqlalchemy/sql/sqltypes.py b/lib/sqlalchemy/sql/sqltypes.py
index 4ae121163..cc5f9a6b7 100644
--- a/lib/sqlalchemy/sql/sqltypes.py
+++ b/lib/sqlalchemy/sql/sqltypes.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
"""SQL specific types.
@@ -608,7 +608,7 @@ class Numeric(_LookupExpressionAdapter, TypeEngine):
The Python ``decimal.Decimal`` class is generally slow
performing; cPython 3.3 has now switched to use the `cdecimal
- <http://pypi.python.org/pypi/cdecimal/>`_ library natively. For
+ <https://pypi.org/project/cdecimal/>`_ library natively. For
older Python versions, the ``cdecimal`` library can be patched
into any application where it will replace the ``decimal``
library fully, however this needs to be applied globally and
@@ -874,7 +874,7 @@ class DateTime(_LookupExpressionAdapter, TypeEngine):
@util.memoized_property
def _expression_adaptations(self):
- # Based on http://www.postgresql.org/docs/current/\
+ # Based on https://www.postgresql.org/docs/current/\
# static/functions-datetime.html.
return {
@@ -898,7 +898,7 @@ class Date(_LookupExpressionAdapter, TypeEngine):
@util.memoized_property
def _expression_adaptations(self):
- # Based on http://www.postgresql.org/docs/current/\
+ # Based on https://www.postgresql.org/docs/current/\
# static/functions-datetime.html.
return {
@@ -939,7 +939,7 @@ class Time(_LookupExpressionAdapter, TypeEngine):
@util.memoized_property
def _expression_adaptations(self):
- # Based on http://www.postgresql.org/docs/current/\
+ # Based on https://www.postgresql.org/docs/current/\
# static/functions-datetime.html.
return {
@@ -1997,7 +1997,7 @@ class Boolean(Emulated, TypeEngine, SchemaType):
class _AbstractInterval(_LookupExpressionAdapter, TypeEngine):
@util.memoized_property
def _expression_adaptations(self):
- # Based on http://www.postgresql.org/docs/current/\
+ # Based on https://www.postgresql.org/docs/current/\
# static/functions-datetime.html.
return {
diff --git a/lib/sqlalchemy/sql/type_api.py b/lib/sqlalchemy/sql/type_api.py
index 5f409559f..632334574 100644
--- a/lib/sqlalchemy/sql/type_api.py
+++ b/lib/sqlalchemy/sql/type_api.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
"""Base types API.
diff --git a/lib/sqlalchemy/sql/util.py b/lib/sqlalchemy/sql/util.py
index 85b20a568..456469941 100644
--- a/lib/sqlalchemy/sql/util.py
+++ b/lib/sqlalchemy/sql/util.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
"""High level utilities which build upon other modules here.
diff --git a/lib/sqlalchemy/sql/visitors.py b/lib/sqlalchemy/sql/visitors.py
index c750c546a..1cd7b63cd 100644
--- a/lib/sqlalchemy/sql/visitors.py
+++ b/lib/sqlalchemy/sql/visitors.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
"""Visitor/traversal interface and library functions.
@@ -19,7 +19,7 @@ transformations to expressions.
Examples of how the visit system is used can be seen in the source code
of for example the ``sqlalchemy.sql.util`` and the ``sqlalchemy.sql.compiler``
modules. Some background on clause adaption is also at
-http://techspot.zzzeek.org/2008/01/23/expression-transformations/ .
+https://techspot.zzzeek.org/2008/01/23/expression-transformations/ .
"""
diff --git a/lib/sqlalchemy/testing/__init__.py b/lib/sqlalchemy/testing/__init__.py
index 1bb2943e1..d78e24181 100644
--- a/lib/sqlalchemy/testing/__init__.py
+++ b/lib/sqlalchemy/testing/__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 config
diff --git a/lib/sqlalchemy/testing/assertions.py b/lib/sqlalchemy/testing/assertions.py
index cf61bf95c..0cf0cbc7a 100644
--- a/lib/sqlalchemy/testing/assertions.py
+++ b/lib/sqlalchemy/testing/assertions.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/testing/assertsql.py b/lib/sqlalchemy/testing/assertsql.py
index 98261a374..2d41d6dab 100644
--- a/lib/sqlalchemy/testing/assertsql.py
+++ b/lib/sqlalchemy/testing/assertsql.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 collections
import contextlib
diff --git a/lib/sqlalchemy/testing/asyncio.py b/lib/sqlalchemy/testing/asyncio.py
index ef92fa5b9..877d1eb94 100644
--- a/lib/sqlalchemy/testing/asyncio.py
+++ b/lib/sqlalchemy/testing/asyncio.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
# functions and wrappers to run tests, fixtures, provisioning and
diff --git a/lib/sqlalchemy/testing/config.py b/lib/sqlalchemy/testing/config.py
index 6589e5097..097eb94e4 100644
--- a/lib/sqlalchemy/testing/config.py
+++ b/lib/sqlalchemy/testing/config.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 collections
diff --git a/lib/sqlalchemy/testing/engines.py b/lib/sqlalchemy/testing/engines.py
index 1d740b4f3..7d78dcc1a 100644
--- a/lib/sqlalchemy/testing/engines.py
+++ b/lib/sqlalchemy/testing/engines.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/testing/entities.py b/lib/sqlalchemy/testing/entities.py
index 050a30a89..9daa5c61f 100644
--- a/lib/sqlalchemy/testing/entities.py
+++ b/lib/sqlalchemy/testing/entities.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 sqlalchemy as sa
from .. import exc as sa_exc
diff --git a/lib/sqlalchemy/testing/exclusions.py b/lib/sqlalchemy/testing/exclusions.py
index 6502487f0..d5522289b 100644
--- a/lib/sqlalchemy/testing/exclusions.py
+++ b/lib/sqlalchemy/testing/exclusions.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 contextlib
diff --git a/lib/sqlalchemy/testing/fixtures.py b/lib/sqlalchemy/testing/fixtures.py
index aeb97572f..30ada71cd 100644
--- a/lib/sqlalchemy/testing/fixtures.py
+++ b/lib/sqlalchemy/testing/fixtures.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 contextlib
import re
diff --git a/lib/sqlalchemy/testing/mock.py b/lib/sqlalchemy/testing/mock.py
index 1bbde3a1e..8fe08a678 100644
--- a/lib/sqlalchemy/testing/mock.py
+++ b/lib/sqlalchemy/testing/mock.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 stub for mock library.
"""
diff --git a/lib/sqlalchemy/testing/pickleable.py b/lib/sqlalchemy/testing/pickleable.py
index dcdfcb1a9..430cb5fb6 100644
--- a/lib/sqlalchemy/testing/pickleable.py
+++ b/lib/sqlalchemy/testing/pickleable.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
"""Classes used in pickling tests, need to be at the module level for
unpickling.
diff --git a/lib/sqlalchemy/testing/plugin/plugin_base.py b/lib/sqlalchemy/testing/plugin/plugin_base.py
index 492a3224d..8f486dc8d 100644
--- a/lib/sqlalchemy/testing/plugin/plugin_base.py
+++ b/lib/sqlalchemy/testing/plugin/plugin_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
"""Testing extensions.
diff --git a/lib/sqlalchemy/testing/profiling.py b/lib/sqlalchemy/testing/profiling.py
index 5e4f19273..de4847f2f 100644
--- a/lib/sqlalchemy/testing/profiling.py
+++ b/lib/sqlalchemy/testing/profiling.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
"""Profiling support for unit and performance tests.
diff --git a/lib/sqlalchemy/testing/requirements.py b/lib/sqlalchemy/testing/requirements.py
index 673fa15cd..702a40fe2 100644
--- a/lib/sqlalchemy/testing/requirements.py
+++ b/lib/sqlalchemy/testing/requirements.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
"""Global database feature support policy.
diff --git a/lib/sqlalchemy/testing/schema.py b/lib/sqlalchemy/testing/schema.py
index ede3702e5..9c6bf9e4c 100644
--- a/lib/sqlalchemy/testing/schema.py
+++ b/lib/sqlalchemy/testing/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
import sys
diff --git a/lib/sqlalchemy/testing/util.py b/lib/sqlalchemy/testing/util.py
index 01185c284..a4d55a8f2 100644
--- a/lib/sqlalchemy/testing/util.py
+++ b/lib/sqlalchemy/testing/util.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 decimal
import gc
diff --git a/lib/sqlalchemy/testing/warnings.py b/lib/sqlalchemy/testing/warnings.py
index df0e5aa5e..40a579101 100644
--- a/lib/sqlalchemy/testing/warnings.py
+++ b/lib/sqlalchemy/testing/warnings.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/types.py b/lib/sqlalchemy/types.py
index 6cc3e6fbc..ecc351fc9 100644
--- a/lib/sqlalchemy/types.py
+++ b/lib/sqlalchemy/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
"""Compatibility namespace for sqlalchemy.sql.types.
diff --git a/lib/sqlalchemy/util/__init__.py b/lib/sqlalchemy/util/__init__.py
index db3966849..10139fb9f 100644
--- a/lib/sqlalchemy/util/__init__.py
+++ b/lib/sqlalchemy/util/__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 collections import defaultdict
diff --git a/lib/sqlalchemy/util/_collections.py b/lib/sqlalchemy/util/_collections.py
index 7484a8f1a..535ae4780 100644
--- a/lib/sqlalchemy/util/_collections.py
+++ b/lib/sqlalchemy/util/_collections.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
"""Collection classes and helpers."""
diff --git a/lib/sqlalchemy/util/_preloaded.py b/lib/sqlalchemy/util/_preloaded.py
index 2e0c2625d..c8da9230a 100644
--- a/lib/sqlalchemy/util/_preloaded.py
+++ b/lib/sqlalchemy/util/_preloaded.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
"""supplies the "preloaded" registry to resolve circular module imports at
runtime.
diff --git a/lib/sqlalchemy/util/compat.py b/lib/sqlalchemy/util/compat.py
index 620d059c3..37239f532 100644
--- a/lib/sqlalchemy/util/compat.py
+++ b/lib/sqlalchemy/util/compat.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
"""Handle Python version/platform incompatibilities."""
@@ -502,7 +502,7 @@ def with_metaclass(meta, *bases, **kw):
Drops the middle class upon creation.
- Source: http://lucumr.pocoo.org/2013/5/21/porting-to-python-3-redux/
+ Source: https://lucumr.pocoo.org/2013/5/21/porting-to-python-3-redux/
"""
diff --git a/lib/sqlalchemy/util/deprecations.py b/lib/sqlalchemy/util/deprecations.py
index 425a5f044..c1acde39b 100644
--- a/lib/sqlalchemy/util/deprecations.py
+++ b/lib/sqlalchemy/util/deprecations.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
"""Helpers related to deprecation of functions, methods, classes, other
functionality."""
diff --git a/lib/sqlalchemy/util/langhelpers.py b/lib/sqlalchemy/util/langhelpers.py
index e506b7529..8036ea3e2 100644
--- a/lib/sqlalchemy/util/langhelpers.py
+++ b/lib/sqlalchemy/util/langhelpers.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
"""Routines to help with the creation, loading and introspection of
modules, classes, hierarchies, attributes, functions, and methods.
diff --git a/lib/sqlalchemy/util/queue.py b/lib/sqlalchemy/util/queue.py
index 935ace7ef..12b372202 100644
--- a/lib/sqlalchemy/util/queue.py
+++ b/lib/sqlalchemy/util/queue.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
"""An adaptation of Py2.3/2.4's Queue module which supports reentrant
behavior, using RLock instead of Lock for its mutex object. The
diff --git a/lib/sqlalchemy/util/topological.py b/lib/sqlalchemy/util/topological.py
index 8390c5554..ae4b37426 100644
--- a/lib/sqlalchemy/util/topological.py
+++ b/lib/sqlalchemy/util/topological.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
"""Topological sorting algorithms."""
@@ -58,7 +58,7 @@ def sort(tuples, allitems, deterministic_order=True):
def find_cycles(tuples, allitems):
# adapted from:
- # http://neopythonic.blogspot.com/2009/01/detecting-cycles-in-directed-graph.html
+ # https://neopythonic.blogspot.com/2009/01/detecting-cycles-in-directed-graph.html
edges = util.defaultdict(set)
for parent, child in tuples:
diff --git a/setup.cfg b/setup.cfg
index 744b858e8..846b72848 100644
--- a/setup.cfg
+++ b/setup.cfg
@@ -7,7 +7,7 @@ name = SQLAlchemy
description = Database Abstraction Library
long_description = file: README.rst
long_description_content_type = text/x-rst
-url = http://www.sqlalchemy.org
+url = https://www.sqlalchemy.org
author = Mike Bayer
author_email = mike_mp@zzzcomputing.com
license = MIT
diff --git a/test/aaa_profiling/test_memusage.py b/test/aaa_profiling/test_memusage.py
index 2fedcdfdc..6462ab9f1 100644
--- a/test/aaa_profiling/test_memusage.py
+++ b/test/aaa_profiling/test_memusage.py
@@ -1056,7 +1056,7 @@ class MemUsageWBackendTest(EnsureZeroed):
# fails on newer versions of pysqlite due to unusual memory behavior
# in pysqlite itself. background at:
- # http://thread.gmane.org/gmane.comp.python.db.pysqlite.user/2290
+ # https://thread.gmane.org/gmane.comp.python.db.pysqlite.user/2290
@testing.crashes("mysql+cymysql", "blocking")
def test_join_cache_deprecated_coercion(self):
diff --git a/test/base/test_except.py b/test/base/test_except.py
index 7ef077659..94dc8520e 100644
--- a/test/base/test_except.py
+++ b/test/base/test_except.py
@@ -83,7 +83,7 @@ class WrapTest(fixtures.TestBase):
str(exc),
"(test.base.test_except.OperationalError) \n"
"[SQL: this is a message]\n"
- "(Background on this error at: http://sqlalche.me/e/%s/e3q8)"
+ "(Background on this error at: https://sqlalche.me/e/%s/e3q8)"
% sa_exceptions._version_token,
)
@@ -101,7 +101,7 @@ class WrapTest(fixtures.TestBase):
"(test.base.test_except.OperationalError) \n"
"[SQL: this is a message\nthis is the next line\n"
"the last line]\n"
- "(Background on this error at: http://sqlalche.me/e/%s/e3q8)"
+ "(Background on this error at: https://sqlalche.me/e/%s/e3q8)"
% sa_exceptions._version_token,
)
@@ -135,7 +135,7 @@ class WrapTest(fixtures.TestBase):
"(sqlalchemy.exc.InvalidRequestError) hello\n"
"[SQL: select * from table]\n"
"[parameters: [{'x': 1}]]\n"
- "(Background on this error at: http://sqlalche.me/e/%s/abcd)"
+ "(Background on this error at: https://sqlalche.me/e/%s/abcd)"
% sa_exceptions._version_token,
)
eq_(err.args, ("(sqlalchemy.exc.InvalidRequestError) hello",))
@@ -147,7 +147,7 @@ class WrapTest(fixtures.TestBase):
eq_(
str(orig),
"(2006, 'Test raise operational error')\n"
- "(Background on this error at: http://sqlalche.me/e/%s/dbapi)"
+ "(Background on this error at: https://sqlalche.me/e/%s/dbapi)"
% sa_exceptions._version_token,
)
@@ -159,7 +159,8 @@ class WrapTest(fixtures.TestBase):
compat.text_type(orig),
compat.u(
"méil\n(Background on this error at: "
- "http://sqlalche.me/e/%s/dbapi)" % sa_exceptions._version_token
+ "https://sqlalche.me/e/%s/dbapi)"
+ % sa_exceptions._version_token
),
)
eq_(orig.args, (u("méil"),))
@@ -232,7 +233,7 @@ class WrapTest(fixtures.TestBase):
"[SQL: this is a message]\n"
"[parameters: [{1: 1}, {1: 1}, {1: 1}, {1: 1}, {1: 1},"
" {1: 1}, {1: 1}, {1: 1}, {1: 1}, {1: 1}]]\n"
- "(Background on this error at: http://sqlalche.me/e/%s/e3q8)"
+ "(Background on this error at: https://sqlalche.me/e/%s/e3q8)"
% sa_exceptions._version_token,
)
eq_(
@@ -268,7 +269,7 @@ class WrapTest(fixtures.TestBase):
"{1: 1}, {1: 1}, {1: 1}, {1: 1}, {1: 1}, "
"{1: 1}, {1: 1} ... displaying 10 of 11 total "
"bound parameter sets ... {1: 1}, {1: 1}]]\n"
- "(Background on this error at: http://sqlalche.me/e/%s/e3q8)"
+ "(Background on this error at: https://sqlalche.me/e/%s/e3q8)"
% sa_exceptions._version_token,
)
try:
@@ -286,7 +287,7 @@ class WrapTest(fixtures.TestBase):
"[SQL: this is a message]\n"
"[parameters: [(1,), "
"(1,), (1,), (1,), (1,), (1,), (1,), (1,), (1,), (1,)]]\n"
- "(Background on this error at: http://sqlalche.me/e/%s/e3q8)"
+ "(Background on this error at: https://sqlalche.me/e/%s/e3q8)"
% sa_exceptions._version_token,
)
try:
@@ -318,7 +319,7 @@ class WrapTest(fixtures.TestBase):
"(1,), (1,), (1,), (1,), (1,), (1,), (1,) "
"... displaying 10 of 11 total bound "
"parameter sets ... (1,), (1,)]]\n"
- "(Background on this error at: http://sqlalche.me/e/%s/e3q8)"
+ "(Background on this error at: https://sqlalche.me/e/%s/e3q8)"
% sa_exceptions._version_token,
)
diff --git a/test/dialect/mysql/test_types.py b/test/dialect/mysql/test_types.py
index cf39ce4bc..0d466e26d 100644
--- a/test/dialect/mysql/test_types.py
+++ b/test/dialect/mysql/test_types.py
@@ -473,7 +473,7 @@ class TypeRoundTripTest(fixtures.TestBase, AssertsExecutionResults):
__backend__ = True
# fixed in mysql-connector as of 2.0.1,
- # see http://bugs.mysql.com/bug.php?id=73266
+ # see https://bugs.mysql.com/bug.php?id=73266
def test_precision_float_roundtrip(self, metadata, connection):
t = Table(
"t",
@@ -675,7 +675,7 @@ class TypeRoundTripTest(fixtures.TestBase, AssertsExecutionResults):
# TIMESTAMP without NULL inserts current time when passed
# NULL. when not passed, generates 0000-00-00 quite
# annoyingly.
- # the flag http://dev.mysql.com/doc/refman/5.6/en/\
+ # the flag https://dev.mysql.com/doc/refman/5.6/en/\
# server-system-variables.html#sysvar_explicit_defaults_for_timestamp
# changes this for 5.6 if set.
diff --git a/test/dialect/test_sqlite.py b/test/dialect/test_sqlite.py
index 9285041df..b5ce291eb 100644
--- a/test/dialect/test_sqlite.py
+++ b/test/dialect/test_sqlite.py
@@ -667,7 +667,7 @@ class DialectTest(
that start and end with quotes.
SQLite claims to have fixed this in
- http://www.sqlite.org/src/info/600482d161, however
+ https://www.sqlite.org/src/info/600482d161, however
it still fails if the FK points to a table name that actually
has quotes as part of its name.
diff --git a/test/ext/test_hybrid.py b/test/ext/test_hybrid.py
index 9085ccc96..3345d872d 100644
--- a/test/ext/test_hybrid.py
+++ b/test/ext/test_hybrid.py
@@ -943,7 +943,7 @@ class SpecialObjectTest(fixtures.TestBase, AssertsCompiledSQL):
"""tests against hybrids that return a non-ClauseElement.
use cases derived from the example at
- http://techspot.zzzeek.org/2011/10/21/hybrids-and-value-agnostic-types/
+ https://techspot.zzzeek.org/2011/10/21/hybrids-and-value-agnostic-types/
"""
diff --git a/test/orm/test_cascade.py b/test/orm/test_cascade.py
index a7156be4a..c2a2cef6e 100644
--- a/test/orm/test_cascade.py
+++ b/test/orm/test_cascade.py
@@ -1396,9 +1396,11 @@ class NoSaveCascadeFlushTest(_fixtures.FixtureTest):
'"Address" object is being merged into a Session along '
'the backref cascade path for relationship "User.addresses"'
# link added to this specific warning
- r".*Background on this error at: http://sqlalche.me/e/14/s9r1"
+ r".*Background on this error at: "
+ r"https://sqlalche.me/e/14/s9r1"
# link added to all RemovedIn20Warnings
- r".*Background on SQLAlchemy 2.0 at: http://sqlalche.me/e/b8d9"
+ r".*Background on SQLAlchemy 2.0 at: "
+ r"https://sqlalche.me/e/b8d9"
):
a1.user = u1
sess.add(a1)
@@ -3014,8 +3016,8 @@ class PendingOrphanTestSingleLevel(fixtures.MappedTest):
class PendingOrphanTestTwoLevel(fixtures.MappedTest):
"""test usages stated at
- http://article.gmane.org/gmane.comp.python.sqlalchemy.user/3085
- http://article.gmane.org/gmane.comp.python.sqlalchemy.user/3119
+ https://article.gmane.org/gmane.comp.python.sqlalchemy.user/3085
+ https://article.gmane.org/gmane.comp.python.sqlalchemy.user/3119
"""
@classmethod
diff --git a/test/orm/test_composites.py b/test/orm/test_composites.py
index 5fb7cf50f..b91c21d32 100644
--- a/test/orm/test_composites.py
+++ b/test/orm/test_composites.py
@@ -377,7 +377,7 @@ class PointTest(fixtures.MappedTest, testing.AssertsCompiledSQL):
"""test saving a null composite value
See google groups thread for more context:
- http://groups.google.com/group/sqlalchemy/browse_thread/thread/0c6580a1761b2c29
+ https://groups.google.com/group/sqlalchemy/browse_thread/thread/0c6580a1761b2c29
"""