Title: Alembic settings primary key to nullable · Issue #119 · fastapi/sqlmodel · GitHub
Open Graph Title: Alembic settings primary key to nullable · Issue #119 · fastapi/sqlmodel
X Title: Alembic settings primary key to nullable · Issue #119 · fastapi/sqlmodel
Description: First Check I added a very descriptive title to this issue. I used the GitHub search to find a similar issue and didn't find it. I searched the SQLModel documentation, with the integrated search. I already searched in Google "How to X in...
Open Graph Description: First Check I added a very descriptive title to this issue. I used the GitHub search to find a similar issue and didn't find it. I searched the SQLModel documentation, with the integrated search. I...
X Description: First Check I added a very descriptive title to this issue. I used the GitHub search to find a similar issue and didn't find it. I searched the SQLModel documentation, with the integrated searc...
Opengraph URL: https://github.com/fastapi/sqlmodel/issues/119
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Alembic settings primary key to nullable","articleBody":"### First Check\n\n- [X] I added a very descriptive title to this issue.\n- [X] I used the GitHub search to find a similar issue and didn't find it.\n- [X] I searched the SQLModel documentation, with the integrated search.\n- [X] I already searched in Google \"How to X in SQLModel\" and didn't find any information.\n- [X] I already read and followed all the tutorial in the docs and didn't find an answer.\n- [X] I already checked if it is not related to SQLModel but to [Pydantic](https://github.com/samuelcolvin/pydantic).\n- [X] I already checked if it is not related to SQLModel but to [SQLAlchemy](https://github.com/sqlalchemy/sqlalchemy).\n\n### Commit to Help\n\n- [X] I commit to help with one of those options 👆\n\n### Example Code\n\n```python\nclass Foo(SQLModel, table=True):\r\n id: Optional[int] = Field(default=None, primary_key=True)\r\n bar: str\n```\n\n\n### Description\n\n- Create model, with id field as described in docs\r\n- Run alembic migrations \r\n- Upgrade head\r\n- Run alembic migrations again\r\n\r\nAlembic reads the primary key as nullable.\r\nWhen running second time it tries to alter the field\r\nYou will then get an error when trying to upgrade.\r\nI using psycopg2-binary \r\n\r\n*Adding nullable=False to id declaration fixes this. Should this be added to the tutorial? \n\n### Operating System\n\nmacOS\n\n### Operating System Details\n\n_No response_\n\n### SQLModel Version\n\n0.0.4\n\n### Python Version\n\n3.8\n\n### Additional Context\n\n\"\"\"foo\r\n\r\nRevision ID: 6d4a123a9ff6\r\nRevises: 2910ce9e323e\r\nCreate Date: 2021-10-01 12:53:59.432921\r\n\r\n\"\"\"\r\nfrom alembic import op\r\nimport sqlalchemy as sa\r\nimport sqlmodel\r\n\r\n\r\n# revision identifiers, used by Alembic.\r\nrevision = '6d4a123a9ff6'\r\ndown_revision = '2910ce9e323e'\r\nbranch_labels = None\r\ndepends_on = None\r\n\r\n\r\ndef upgrade():\r\n # ### commands auto generated by Alembic - please adjust! ###\r\n op.create_table('foo',\r\n sa.Column('id', sa.Integer(), nullable=True),\r\n sa.Column('bar', sqlmodel.sql.sqltypes.AutoString(), nullable=False),\r\n sa.PrimaryKeyConstraint('id')\r\n )\r\n op.create_index(op.f('ix_foo_bar'), 'foo', ['bar'], unique=False)\r\n op.create_index(op.f('ix_foo_id'), 'foo', ['id'], unique=False)\r\n # ### end Alembic commands ###\r\n\r\n\r\ndef downgrade():\r\n # ### commands auto generated by Alembic - please adjust! ###\r\n op.drop_index(op.f('ix_foo_id'), table_name='foo')\r\n op.drop_index(op.f('ix_foo_bar'), table_name='foo')\r\n op.drop_table('foo')\r\n # ### end Alembic commands ###\r\n","author":{"url":"https://github.com/adlmtl","@type":"Person","name":"adlmtl"},"datePublished":"2021-10-01T16:59:31Z","url":"https://github.com/fastapi/sqlmodel/issues/119"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| 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:e351224f-eeb0-3cb8-26c5-8e98bc605075 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | 8D44:1B6C2:6BB74A:98D741:6AFDF29B |
| html-safe-nonce | 2acdb4e7840b480ea0aa4267effc4a530b9b77135dff743f4e0395cc038faf1c |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI4RDQ0OjFCNkMyOjZCQjc0QTo5OEQ3NDE6NkFGREYyOUIiLCJ2aXNpdG9yX2lkIjoiMTgwMTE0NTkzOTU0MTIyNjEzOSIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | 61c0b8be7bafa1f8435b91a46c9db07b5d678c2d8fdb6b05a19ea736821ff177 |
| hovercard-subject-tag | issue:1013566249 |
| 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/fastapi/sqlmodel/119/issue_layout |
| twitter:image | https://opengraph.githubassets.com/ff71ed819ffa42e42272ecc25c42302a2ce55092f6f025d22177cab750b98e48/fastapi/sqlmodel/issues/119 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/ff71ed819ffa42e42272ecc25c42302a2ce55092f6f025d22177cab750b98e48/fastapi/sqlmodel/issues/119 |
| og:image:alt | First Check I added a very descriptive title to this issue. I used the GitHub search to find a similar issue and didn't find it. I searched the SQLModel documentation, with the integrated search. I... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | adlmtl |
| hostname | github.com |
| expected-hostname | github.com |
| None | dd812ec581ecac95855f5ec917ef9827506c39a9da1443f43ddb4179a46471eb |
| turbo-cache-control | no-preview |
| go-import | github.com/fastapi/sqlmodel git https://github.com/fastapi/sqlmodel.git |
| octolytics-dimension-user_id | 156354296 |
| octolytics-dimension-user_login | fastapi |
| octolytics-dimension-repository_id | 399495186 |
| octolytics-dimension-repository_nwo | fastapi/sqlmodel |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 399495186 |
| octolytics-dimension-repository_network_root_nwo | fastapi/sqlmodel |
| 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 | 32ac708bac264dafdc28e10ff49b4d137f0c34a7 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width