]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Add support for Partitioning and Sample pages on mysql
authorRamonWill <ramonwilliams@hotmail.co.uk>
Tue, 25 Aug 2020 00:17:19 +0000 (20:17 -0400)
committerFederico Caselli <cfederico87@gmail.com>
Thu, 11 Aug 2022 19:39:45 +0000 (21:39 +0200)
commita134ec1760df6295d537ff63df7aee83d957bf6a
tree2c69701259576dfa58e4ebe742f7272f66f0cfc5
parent6f75807063771496a34b7725d2565acf2528d76f
Add support for Partitioning and Sample pages on mysql

Add support for Partitioning and Sample pages on MySQL and MariaDB
reflected options.
The options are stored in the table dialect options dictionary, so
the following keyword need to be prefixed with ``mysql_`` or ``mariadb_``
depending on the backend.
Supported options are:

* ``stats_sample_pages``
* ``partition_by``
* ``partitions``
* ``subpartition_by``

These options are also reflected when loading a table from database,
and will populate the table :attr:`_schema.Table.dialect_options`.
Pull request courtesy of Ramon Will.

Fixes: #4038
Closes: #5536
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/5536
Pull-request-sha: f8852cabe15c9a91de85d27980988051f7a1306d

Change-Id: I69b60576532af04c725c998e9e8fec6e2040b149
doc/build/changelog/unreleased_20/4038.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/mysql/reflection.py
test/dialect/mysql/test_reflection.py