In python 3 inspect.getargspec is deprecated and
replaced with inspect.getfullargspec which does not
exist on python 2.7. This change uses six to select
the correct version to use based on the python version
used.

Change-Id: I234a3509ff850d0c5616ebcfa240212b03db9e76
Closes-Bug: #1814288

SQLAlchemy 1.3 has deprecated engine.contextual_connect() which
will be removed in 1.4.   Additionally, private methods like
Engine._run_visitor will also be removed.

Change-Id: I319785d7dd83ffe2c6e651a2494b073becc84684

This adds the voting and gating openstack-tox-py36 job
and adds python 3.6 to the classifiers list.

Change-Id: Ida2349de534399103e5d6f294a7e771910188ee4

This makes the openstack-tox-py35 job voting and gating
and adds python 3.5 to the classifiers list.

Change-Id: I11c8cd0e33e0609d740f5742096438a2395b28ed

We can control python version sensitive dependencies
in the single test-requirements.txt file so we can
drop the version-specific files. This should also make
the openstack-tox-py35 job start passing.

Change-Id: Ic3fa2c4417092e387ac5d177be75a22050a6f857

This adds a minimal bindep.txt to install mysql and postgresql
dependencies (copied from nova's bindep.txt). This is needed
now to get python jobs (pep8,py27,etc) working in the gate.

Change-Id: I4b7bccdb7cebd95753e8cd931846213f400aa652
Closes-Bug: #1836087

Support for python 2.6 was dropped in commit
8266c8de but the
tox targets were missed, so they are removed here.

Change-Id: I2271717ce4a35183d2b773063564cbaf774fdfb0

Add the project-specific tox py27sa07 job to this repo, convert it
from legacy-sqlalchemy-migrate-tox-py27sa07 to Zuul v3.

Also, import other jobs from project-config so that the jobs
are managed by the team in-tree.

Change-Id: I9296b3e40246ab89655411b660c5ba45bc9cf2ff

Fixes for docs build:
* Use doc/requirements to follow changes in OpenStack CI for the docs
  building, add a tox environment for this.
* Remove reference to "project's download page", the link was removed in
  change I2db594d279e1229e5b1600cecad86fe0c3612115 and now we have a
  dead link that errors building if warnings are treated as errors.
* Change I2db594d279e1229e5b1600cecad86fe0c3612115 added a column for
  DB2 header but not for any entries, enhance table with extra column.
  This fixes building of the table if warnings are treated as errors.
* Update to sphinx 1.6.x since that is what is used in OpenStack CI job,
  remove issuetracker, it does not work with sphinx 1.6 anymore.
* Disable html_static_path - the content does not exist
* Use python3 for docs building

Change-Id: I76ee4d6dc45f9b04115f093951ae8b745f3ac026

This commit was bulk generated and pushed by the OpenDev sysadmins
as a part of the Git hosting and code review systems migration
detailed in these mailing list posts:

http://lists.openstack.org/pipermail/openstack-discuss/2019-March/003603.html
http://lists.openstack.org/pipermail/openstack-discuss/2019-April/004920.html

Attempts have been made to correct repository namespaces and
hostnames based on simple pattern matching, but it's possible some
were updated incorrectly or missed entirely. Please reach out to us
via the contact information listed at https://opendev.org/ with any
questions you may have.

This is needed to be able to release to pypi:

$ python3 setup.py check --restructuredtext --strict
running check
warning: check: Duplicate implicit target name: "sqlalchemy-migrate".

Change-Id: I26dd765a5273199d6666dd9ed618dc8189a2e8ed

The "force" parameter in SQLAlchemy IdentifierPreparer.quote()
has been a no-op since 0.9 in
https://github.com/sqlalchemy/sqlalchemy/commit/031ef0807838842a827135dbace760da7aec215e,
which was six years ago.   In SQLAlchemy 1.3 this parameter
will be removed entirely.   Bump requirements to 0.9 series
here and remove usage of the "force" flag.

Change-Id: I4492df2e7d2075fefbf13d6782de11f7d402f6b8

The test requirement for MySQL-Python refers to a package that
has had no releases since 2014 and no longer builds on some MySQL /
MariaDB variants.  MySQL-Python has for years been superseded by
the mysqlclient fork which is actively maintained.   mysqlclient
may at some point be allowed to take over the MySQL-Python name
as per PEP-541 however this hasn't happened yet.

Change-Id: I67dd2338dc74e59c2deb2f1bd1b848e3c63e10e8

Use "PRAGMA legacy_alter_table = ON" with sqlite >= 3.26 when
using "ALTER TABLE RENAME TO migration_tmp" to maintain legacy
behavior.

As of sqlite version 3.26, when a table is renamed using
"ALTER TABLE RENAME TO", REFERENCES clauses that refer to the
table will be updated. To maintain legacy (3.24 and earlier)
behavior, "PRAGMA legacy_alter_table" can be set to true and
"PRAGMA foreign_keys" can be set to false. [1]

[1] https://www.sqlite.org/src/info/ae9638e9c0ad0c36

Thanks to "László Böszörményi (GCS)" <gcs@debian.org> for
providing the code for this patch, which has since been
slightly modified.

Change-Id: I539988ab2ad6df6c8f423ecec15364ad8fcc7267
Closes-Bug: 1807262

As of mitaka, the infra team won't have the resources available to
reasonably test py26, also the oslo team is dropping py26 support
from their libraries. sine we rely on oslo for a lot of our work,
and depend on infra for our CI, we should drop py26 support too.

Change-Id: I6af3716f5daf73febdabcd79853a09512428c289
Closes-Bug: 1519510

Change-Id: Ia7738e03aff843b1b120c0d5d13a7b64f2f33201

Change-Id: Ifb66fe22bc607b13f5c4756d3b93f5e8206c33e3

openstack-dev was decomissioned this night in https://review.openstack.org/621258
Update openstack-dev to openstack-discuss

Change-Id: Ic84b2422d37aa1ebb443fff4152c7ebe5a098566

The psycopg2 wheel package warnings are causing some tests
to fail which expect there to be no stderr output. This fixes
the problem by not using the wheel binary for that package.

Closes-Bug: #1811876

Change-Id: Id43e74d8d343ab4e80d1d246543bada1ed4d06ad

It otherwise fails if used against older pbr (e.g distro packaging build)

Change-Id: I19dbd5d14a9135408ad21a34834f0bd1fb3ea55d

The 2.0.0 is breaking in that it removes the use of warnerrors in
build_sphinux.

sqlalchemy-migrate isn't using that feature, so it shoudln't break.

The cap on pbr is preventing other OpenStack projects that would like to
use pbr 2.0.0 (and sphinx 1.5.1) from doing so as it breaks
co-installability with sqlalchemy-migrate

Change-Id: I1c907201c717fe42caca24831985a119f2a1738b
Related-Bug: 1668848

Add simple script to setup mysql and postgresql databases, this script
can be run by users during testing and will be run by CI systems for
specific setup before running unit tests.

This allows to change in project-config the python-db jobs to
python-jobs since python-jobs will call this script initially.

See also
http://lists.openstack.org/pipermail/openstack-dev/2016-November/107784.html

Needed-By: I46d883ce1b25338d01a2b0e2b071b15adab00520
Change-Id: I8c5015616a5a12501edd16932d4148930c01a06b

TrivialFix

Change-Id: I089d9e8b57895d9878bf82d2fac397722fccc083

Starting in SQLAlchemy 1.1, the rules for when "autoincrement=True"
may be set on a column are more strict.  The migrate tests are
testing the alteration of a column from Integer to String
and then regenerating; this means we need to set autoincrement
to False as well.   A related issue in SQLAlchemy 1.1 is
also being fixed (see https://bitbucket.org/zzzeek/sqlalchemy/issues/3835/),
however this fix is not needed in order for the tests to pass here.

Change-Id: Ibd3a75fff13312411df87e17b6e5764865d69728

Currently migrate.versioning.api.upgrade() raises KeyError
instead of sqlalchemy-migrate specific exception if migration
script file is not present in migration repository.

Raised migrate.exception.VersionNotFoundError if the specified
migration script does not exist in the repository. Made
VersionNotFoundError exception class as a subclass of KeyError
in order to avoid breaking existing users looking for KeyError.

Related-Bug: #1546441
Change-Id: I0210d56a6e85f03c44cea027f50863faaf050c1d

Python 3.4 unit test is failing because of
DeprecationWarning: Parameters to load are deprecated.
Called .resolve and .require separately on setuptools >= 11.3.

Made provision to call .resolve() method if setuptools >= 10.2
and less than 11.3 else call .load() method.

Change-Id: I5ba80edfbf6b7c8399c66f01d57c91bd02eab274
Closes-Bug: #1586060

Change-Id: Ie13030d01b439115f0e8f0e8b8ea1844d99644ee

* online doc moved from http://packages.python.org/sqlalchemy-migrate/
  to https://sqlalchemy-migrate.readthedocs.org/
* source code moved from http://code.google.com/p/sqlalchemy-migrate/
  to https://github.com/stackforge/sqlalchemy-migrate
* bug tracker moved from
  http://code.google.com/p/sqlalchemy-migrate/issues/list to
  https://bugs.launchpad.net/sqlalchemy-migrate

Change-Id: I2db594d279e1229e5b1600cecad86fe0c3612115