summaryrefslogtreecommitdiff
path: root/docs
Commit message (Collapse)AuthorAgeFilesLines
...
* changelog updatesMike Bayer2023-03-052-10/+13
| | | | Change-Id: I2c796e4120a4674a46f4ebedbf63d9e40ebe49b9
* Update example to sqlalchemy 2 (#1171)Sam Bull2023-03-011-3/+3
|
* Merge "Improved support for expression indexes" into mainmike bayer2023-03-013-0/+26
|\
| * Improved support for expression indexesCaselIT2023-02-263-0/+26
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Added support for autogenerate comparison of indexes on PostgreSQL which include SQL expressions; the previous warning that such indexes were skipped is now removed. This functionality requires SQLAlchemy 2.0. For older SQLAlchemy versions, these indexes are still skipped. Fixed issue where indexes on SQLite which include SQL expressions would not compare against themselves correctly, generating false positives. SQLAlchemy as of version 2 has no support for reflecting expression based indexes on SQLite; so for now, the behavior is that SQLite expression-based indexes are ignored for autogenerate compare, in the same way that PostgreSQL expression-based indexes were ignored for the time that SQLAlchemy did not support reflection of such indexes (which is now supported in SQLAlchemy 2.0 as well as this release of Alembic). Fixed issue in index detection where autogenerate change detection would consider indexes with the same columns but with different order as equal, while in general they are not equivalent in how a database will use them. Fixes: #1165 Fixes: #1166 Change-Id: I226408eed855b923172e5df0bdab005ed2cc9f53
* | Merge "add recursive_version_locations option for searching revision files" ↵mike bayer2023-03-012-0/+18
|\ \ | | | | | | | | | into main
| * | add recursive_version_locations option for searching revision filesostr000002023-02-282-0/+18
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Recursive traversal of revision files in a particular revision directory is now supported, by indicating ``recursive_version_locations = true`` in alembic.ini. Pull request courtesy ostr00000. Fixes: #760 Closes: #1182 Pull-request: https://github.com/sqlalchemy/alembic/pull/1182 Pull-request-sha: ecb0da48b459abd3f5e95390ec7030a7e3fcbc6d Change-Id: I711ca2dbd35fb9a2acdbfd374bcac13043b0d129
* | | Merge "set next version at 1.10.0" into mainmike bayer2023-03-011-1/+1
|\ \ \ | | |/ | |/|
| * | set next version at 1.10.0Mike Bayer2023-02-251-1/+1
| |/ | | | | | | | | | | | | | | | | | | | | | | Will rebase current 1.10 gerrits to this one until we are very close to 1.10 issues being very close to ready for release. In the interim, I'd rather not have an 0.9 branch for emergency bugfixes. We are mostly here waiting on I226408eed855b923172e5df0bdab005ed2cc9f53 for 1.10 to be close to release. Change-Id: I9b568a19d6653ed54069b84187dcb10ad4150274
* | Escape sql server constriant namesCaselIT2023-02-281-0/+8
|/ | | | | | | | | Properly escape constraint name on SQL Server when dropping a column while specifying ``mssql_drop_default=True`` or ``mssql_drop_check=True`` or ``mssql_drop_foreign_key=True``. Fixes: #1187 Change-Id: I060442bc63c4e53f64724985e20e6e15e4335b6b
* Version 1.9.5 placeholderMike Bayer2023-02-161-0/+4
|
* - 1.9.4rel_1_9_4Mike Bayer2023-02-165-40/+43
|
* Merge "dont use server_default render_item for SQL compare" into mainmike bayer2023-02-161-0/+9
|\
| * dont use server_default render_item for SQL compareMike Bayer2023-02-151-0/+9
| | | | | | | | | | | | | | | | | | | | | | | | Removed a mis-use of the :paramref:`.EnvironmentContext.configure.render_item` callable where the "server_default" renderer would be erroneously used within the server default comparison process, which is working against SQL expressions, not Python code. Change-Id: Id6fad1e6f5ac0a68bbd0e6b7e6088e451bf6dc2b References: #641 Fixes: #1180
* | Merge "collapse all chars for mssql defaults, move quoting" into mainmike bayer2023-02-161-0/+21
|\ \ | |/
| * collapse all chars for mssql defaults, move quotingMike Bayer2023-02-151-0/+21
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Ongoing fixes for SQL Server server default comparisons under autogenerate, adjusting for SQL Server's collapsing of whitespace between SQL function arguments when reporting on a function-based server default, as well as its arbitrary addition of parenthesis within arguments; the approach has now been made more aggressive by stripping the two default strings to compare of all whitespace, parenthesis, and quoting characters. Fixed PostgreSQL server default comparison to handle SQL expressions sent as ``text()`` constructs, such as ``text("substring('name', 1, 3)")``, which previously would raise errors when attempting to run a server-based comparison. Change-Id: Icd861f62653fc7b3900164c0d047821125e1305e Fixes: #1177
* | Merge "restore config object to merge command" into mainmike bayer2023-02-151-0/+7
|\ \
| * | restore config object to merge commandBrendan Gann2023-02-141-0/+7
| |/ | | | | | | | | | | | | | | | | | | | | | | | | Fixed regression introduced in 1.7.0 where the "config" object passed to the template context when running the :func:`.merge` command programmatically failed to be correctly populated. Pull request courtesy Brendan Gann. Closes: #1176 Pull-request: https://github.com/sqlalchemy/alembic/pull/1176 Pull-request-sha: cf6a886915f6bef6eeef8041804e316038955402 Change-Id: Idbab2dc0339cce6f8827d2f49156791600a82c1a
* | Follow up Ia98c8f9a93953f049378f5029e355a3f249ed638CaselIT2023-02-141-38/+8
|/ | | | | | that was merged prematurely Change-Id: I131dfb8dabf10457954f5216b1abadc976aebd38
* Include missing part of env.pySam Bull2023-02-131-12/+12
| | | | | | | | | | | This part is missing from the example, and if a user started with the async template, then they would have an `asyncio.run()` call in here, which breaks the script. Fixes: #1174 Closes: #1172 Pull-request: https://github.com/sqlalchemy/alembic/pull/1172 Pull-request-sha: fa2c55319d09fab4e1435433fa2d7e5fca5dc820 Change-Id: Ia98c8f9a93953f049378f5029e355a3f249ed638
* pin sphinx-copybutton and change configMike Bayer2023-02-092-1/+5
| | | | | | | | | | | | | | sphinx-copybutton introduced a new feature in 0.5.1 which includes a default configuration that breaks the regexp prompt matching scheme. set copybutton_exclude to not include ".gp" as that's the class where we exactly look for the prompts we are matching. pin sphinx-copybutton at 0.5.1 to avoid future problems. Change-Id: Ie03bc27a9190e71b63fc68b484f23e53b8cb72dc References: https://github.com/executablebooks/sphinx-copybutton/issues/185
* Version 1.9.4 placeholderMike Bayer2023-02-071-0/+4
|
* - 1.9.3rel_1_9_3Mike Bayer2023-02-073-11/+12
|
* add variant render step for user-defined typesMike Bayer2023-02-071-0/+8
| | | | | | | | | | | | | due to SQLA 2.0's variant being integrated into types, the variant rendering conditional would no longer take effect as the type was not under the "sqlalchemy" module namespace. Fixed issue where rendering of user-defined types that then went onto use the ``.with_variant()`` method would fail to render, if using SQLAlchemy 2.0's version of variants. Change-Id: I3c6f14325d6dffb2ddc1bf955753ee5a2de2cedd Fixes: #1167
* Version 1.9.3 placeholderMike Bayer2023-01-141-0/+4
|
* - 1.9.2rel_1_9_2Mike Bayer2023-01-144-18/+20
|
* Add commit to cookbook exampleCaselIT2023-01-111-0/+2
| | | | | | | | A commit is now required to end the transaction before start executing the migration Fixes: #1150 Change-Id: I704db15155454dafed9d15f768b97f8e2ebfff81
* repair regression in SQL Server server default comapre logicMike Bayer2023-01-101-0/+7
| | | | | | | | | Fixed regression caused by :ticket:`1145` where the string transformations applied to server defaults caused expressions such as ``(getdate())`` to no longer compare as equivalent on SQL Server, others. Change-Id: I9c611edd70765487746f652c9eb09e54d935da28 Fixes: #1152
* Merge "add overload stubs for proxied classes" into mainmike bayer2023-01-031-0/+8
|\
| * add overload stubs for proxied classesVincent Fazio2023-01-031-0/+8
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | <!-- Provide a general summary of your proposed changes in the Title field above --> ### Description Closes #1146 Closes #1147 <!-- Describe your changes in detail --> Overloaded functions would not have type stubs generated by the stub generator for proxied classes. Now they will. ### Checklist <!-- go over following points. check them with an `x` if they do apply, (they turn into clickable checkboxes once the PR is submitted, so no need to do everything at once) --> This pull request is: - [ ] A documentation / typographical error fix - Good to go, no issue or tests are needed - [x] A short code fix - please include the issue number, and create an issue if none exists, which must include a complete example of the issue. one line code fixes without an issue and demonstration will not be accepted. - Please include: `Fixes: #<issue number>` in the commit message - please include tests. one line code fixes without tests will not be accepted. - [ ] A new feature implementation - please include the issue number, and create an issue if none exists, which must include a complete example of how the feature would look. - Please include: `Fixes: #<issue number>` in the commit message - please include tests. Closes: #1148 Pull-request: https://github.com/sqlalchemy/alembic/pull/1148 Pull-request-sha: ed3c28cc78e57314b7a4e533d77108efc6751949 Change-Id: I7c0ee9d333015174ee6ab754909748f745af2ff9
* | happy new year 2023Mike Bayer2023-01-031-1/+1
|/ | | | Change-Id: Ia163c800e074443b92cd59c786ac09073267c271
* Version 1.9.2 placeholderMike Bayer2022-12-231-0/+4
|
* - 1.9.1rel_1_9_1Mike Bayer2022-12-233-32/+33
|
* Merge "dont use repr to quote string in compare_server_default" into mainmike bayer2022-12-231-0/+29
|\
| * dont use repr to quote string in compare_server_defaultMike Bayer2022-12-231-0/+29
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed issue where server default compare would not work for string defaults that contained backslashes, due to mis-rendering of these values when comparing their contents. The server default comparison still has a lot of not-robust behaviors, however at least get in place a parameterized test suite so that we can add new scenarios quickly. Made a slight adjustment to SQLite's compare server default implementation to better handle defaults with or without parens around them, from both the reflected and the local metadata side. Implemented basic server default comparison for the Oracle backend; previously, Oracle's formatting of reflected defaults prevented any matches from occurring. Change-Id: If5a69eec4b22d243a564d2c89e78ae33ba5be88f Fixes: #1145
* | Version 1.9.1 placeholderMike Bayer2022-12-151-0/+4
| |
* | - 1.9.0rel_1_9_0Mike Bayer2022-12-155-33/+36
|/
* add check command for upgrade diffsNathan Louie2022-12-153-1/+57
| | | | | | | | | | | | | | | | | Added new Alembic command ``alembic check``. This performs the widely requested feature of running an "autogenerate" comparison between the current database and the :class:`.MetaData` that's currently set up for autogenerate, returning an error code if the two do not match, based on current autogenerate settings. Pull request courtesy Nathan Louie. As this is a new feature we will call this 1.9.0 Fixes: #724 Closes: #1101 Pull-request: https://github.com/sqlalchemy/alembic/pull/1101 Pull-request-sha: 807ed545df70e7a10b913e2951a1b636f138a4ff Change-Id: I03b146eaf762be464a0ff0858ff5730cc9366c84
* adjust for tox changes to passenvMike Bayer2022-12-111-0/+6
| | | | | | | | | Fixed issue in tox.ini file where changes in the tox 4.0 series to the format of "passenv" caused tox to not function correctly, in particular raising an error as of tox 4.0.6. Change-Id: I659c8fc523a71deaa02a89103c9e7241cf81d831 References: https://github.com/tox-dev/tox/issues/2676
* add width + overflow to keep toc from flowing out of sidebarMike Bayer2022-11-283-1/+15
| | | | | | | | also add sphinx-autobuild to the makefile Change-Id: I7abd08cefe98d6b57394fad20bd06c3e0b928465 References: https://github.com/sphinx-doc/sphinx/issues/11000 (cherry picked from commit 9eafd483018775d9e1144512ed820ba2a80d2e61)
* Merge "add typing parameters" into mainmike bayer2022-11-161-0/+10
|\
| * add typing parametersMike Bayer2022-11-151-0/+10
| | | | | | | | | | | | | | | | | | | | Fixed typing issue where :paramref:`.revision.process_revision_directives` was not fully typed; additionally ensured all ``Callable`` and ``Dict`` arguments to :meth:`.EnvironmentContext.configure` include parameters in the typing declaration. Change-Id: I3ac389992f357359439be5659af33525fc290f96 Fixes: #1110
* | Updated cookbook docs (#1111)Amel Alispahic2022-11-071-2/+2
|/
* fix search path indicatorMike Bayer2022-10-171-1/+3
| | | | | Change-Id: I341a57f0bbf7c237c86cb8de4c94a37d737c3c85 Fixes: #1096
* Fix typo in docs/build/api/runtime.rst (#1084)Johnny Deuss2022-09-081-1/+1
|
* add docs for naming convention bypass caseMike Bayer2022-07-191-2/+53
| | | | | Change-Id: I8d604eaab7865466b8a7008693621c00f954397d References: #453
* Version 1.8.2 placeholderMike Bayer2022-07-131-0/+4
|
* - 1.8.1rel_1_8_1Mike Bayer2022-07-134-27/+29
|
* build fixesMike Bayer2022-07-132-7/+10
| | | | | | | | | | * hardcode rev ids in test that's sensitive to overlapping substrings * turn off nitpicky mode * fix a few rst keywords * ensure unreleased files not considered as indexable Change-Id: I31a0f2cbf40c794204c1e7dbc68bfcf43992c65f
* implement SQLite RENAME TABLE w schema syntaxMike Bayer2022-07-121-0/+11
| | | | | | | | | | | | | Fixed bug where the SQLite implementation of :meth:`.Operations.rename_table` would render an explicit schema name for both the old and new table name, which while is the standard ALTER syntax, is not accepted by SQLite's syntax which doesn't support a rename across schemas. In particular, the syntax issue would prevent batch mode from working for SQLite databases that made use of attached databases (which are treated as "schemas" in SQLAlchemy). Change-Id: I02d8163b39cd33568c7528158218828ff0813695 Fixes: #1065
* fail gracefully for batch_alter_table() called in --sql modeMike Bayer2022-07-011-0/+13
| | | | | | | | | | | | | | | Added an error raise for the condition where :meth:`.Operations.batch_alter_table` is used in ``--sql`` mode, where the operation requires table reflection, as is the case when running against SQLite without giving it a fixed ``Table`` object. Previously the operation would fail with an internal error. To get a "move and copy" batch operation as a SQL script without connecting to a database, a ``Table`` object should be passed to the :paramref:`.Operations.batch_alter_table.copy_from` parameter so that reflection may be skipped. Change-Id: I2d040e7e5771eefabba1649d71ed451567c25283 Fixes: #1021
View Lorry Controller Status