Title: Introspection method returns primary key indexes, making Alembic migrations inconvenient · Issue #231 · googleapis/python-spanner-sqlalchemy · GitHub
Open Graph Title: Introspection method returns primary key indexes, making Alembic migrations inconvenient · Issue #231 · googleapis/python-spanner-sqlalchemy
X Title: Introspection method returns primary key indexes, making Alembic migrations inconvenient · Issue #231 · googleapis/python-spanner-sqlalchemy
Description: When we generate migrations with Alembic, it always tries to drop a bunch of indexes. Running the migration fails because they are used by foreign keys. The dropped indexes are those for the primary key of each table. Those indexes are n...
Open Graph Description: When we generate migrations with Alembic, it always tries to drop a bunch of indexes. Running the migration fails because they are used by foreign keys. The dropped indexes are those for the primar...
X Description: When we generate migrations with Alembic, it always tries to drop a bunch of indexes. Running the migration fails because they are used by foreign keys. The dropped indexes are those for the primar...
Opengraph URL: https://github.com/googleapis/python-spanner-sqlalchemy/issues/231
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Introspection method returns primary key indexes, making Alembic migrations inconvenient","articleBody":"When we generate migrations with Alembic, it always tries to drop a bunch of indexes. Running the migration fails because they are used by foreign keys.\r\n\r\nThe dropped indexes are those for the primary key of each table. Those indexes are never explicitly created by Alembic, but they are implicitly by virtue of being on primary key columns. This might explain why Alembic tries to drop them.\r\nRight now, we delete those drop_index manually every time we generate a migration, which is tedious","author":{"url":"https://github.com/IlyaFaer","@type":"Person","name":"IlyaFaer"},"datePublished":"2022-08-18T08:01:05.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":12},"url":"https://github.com/231/python-spanner-sqlalchemy/issues/231"}| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:f68eaf36-d961-d33d-abe1-7d8c3b90ce9c |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | 8BAE:1F16:2BD7DEC:3F6B4F5:6A4FE5FA |
| html-safe-nonce | 0cd58b512dcbc389b5475cbee1575ed9348166329812cfe83c583cadbf99d0a7 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI4QkFFOjFGMTY6MkJEN0RFQzozRjZCNEY1OjZBNEZFNUZBIiwidmlzaXRvcl9pZCI6IjIzMzI1MDcwMDU0ODk1MDU3ODYiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | f6a3c61f9aa9919053c73603bf5707cb42f20374f411c9f8f6d385256fc4fe4c |
| hovercard-subject-tag | issue:1342707701 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/googleapis/python-spanner-sqlalchemy/231/issue_layout |
| twitter:image | https://opengraph.githubassets.com/6b68e316581007d2fd6ca8235445d1bb93c64f9f2faa2d5883a17f1c8351799e/googleapis/python-spanner-sqlalchemy/issues/231 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/6b68e316581007d2fd6ca8235445d1bb93c64f9f2faa2d5883a17f1c8351799e/googleapis/python-spanner-sqlalchemy/issues/231 |
| og:image:alt | When we generate migrations with Alembic, it always tries to drop a bunch of indexes. Running the migration fails because they are used by foreign keys. The dropped indexes are those for the primar... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | IlyaFaer |
| hostname | github.com |
| expected-hostname | github.com |
| None | 19b98c3d9767bb8a56238a89ff8401d1cbdf3bc5c353799aacf49fe6c76b4b7c |
| turbo-cache-control | no-preview |
| go-import | github.com/googleapis/python-spanner-sqlalchemy git https://github.com/googleapis/python-spanner-sqlalchemy.git |
| octolytics-dimension-user_id | 16785467 |
| octolytics-dimension-user_login | googleapis |
| octolytics-dimension-repository_id | 335511641 |
| octolytics-dimension-repository_nwo | googleapis/python-spanner-sqlalchemy |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 335511641 |
| octolytics-dimension-repository_network_root_nwo | googleapis/python-spanner-sqlalchemy |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 142593e66413bbae27fd485859993597d5a3b104 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width