Title: psycopg2.errors.UndefinedObject: type MY_ENUM does not exist · Issue #131 · fastapi/sqlmodel · GitHub
Open Graph Title: psycopg2.errors.UndefinedObject: type MY_ENUM does not exist · Issue #131 · fastapi/sqlmodel
X Title: psycopg2.errors.UndefinedObject: type MY_ENUM does not exist · Issue #131 · 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/131
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"psycopg2.errors.UndefinedObject: type MY_ENUM does not exist","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\nimport pytest\r\nfrom pytest_postgresql.compat import connection\r\nfrom sqlmodel import Session, SQLModel, create_engine\r\n\r\n\r\n@pytest.fixture(name=\"session\")\r\ndef session_fixture(postgresql: connection):\r\n engine = create_engine(\r\n \"postgresql+psycopg2://\",\r\n connect_args=postgresql.get_dsn_parameters(),\r\n pool_pre_ping=True,\r\n )\r\n\r\n SQLModel.metadata.create_all(engine)\r\n with Session(engine) as session:\r\n yield session\r\n\r\n\r\n\r\n----------------\r\n\r\nSQLModel\r\n\r\nclass TaxIdType(enum.Enum):\r\n USA_SSN = \"USA_SSN\"\r\n NOT_SPECIFIED = \"NOT_SPECIFIED\"\r\n\r\nclass IdentityBase(SQLModel):\r\n pass\r\n\r\nclass IdentityCreate(IdentityBase):\r\n given_name: str = Field(..., description=\", e.g., John\")\r\n ...\r\n tax_id_type: Optional[TaxIdType] = Field(None, sa_column=Column(Enum(TaxIdType)))\n```\n\n\n### Description\n\n* Create a pytest fixture using [pytest_postgresql](https://pypi.org/project/pytest-postgresql/) to create a connection to a postgres db and return a session\r\n* Error thrown when calling `SQLModel.metadata.create_all(engine)`\r\n\r\n```\r\n________________________________________________ ERROR at setup of test_createUser_succeeds _________________________________________________\r\n\r\nself = \u003csqlalchemy.future.engine.Connection object at 0x1044ce430>\r\ndialect = \u003csqlalchemy.dialects.postgresql.psycopg2.PGDialect_psycopg2 object at 0x1044cebe0>\r\nconstructor = \u003cbound method DefaultExecutionContext._init_ddl of \u003cclass 'sqlalchemy.dialects.postgresql.psycopg2.PGExecutionContext_psycopg2'>>\r\nstatement = '\\nCREATE TABLE identity (\\n\\ttax_id_type taxidtype, \\n\\tfunding_source fundingsource[], \\n\\tgiven_name VARCHAR NOT NU...T, \\n\\tid UUID NOT NULL, \\n\\tuser_id UUID, \\n\\tPRIMARY KEY (id), \\n\\tFOREIGN KEY(user_id) REFERENCES users (id)\\n)\\n\\n'\r\nparameters = {}, execution_options = immutabledict({'autocommit': True})\r\nargs = (\u003csqlalchemy.dialects.postgresql.base.PGDDLCompiler object at 0x10452e2b0>,), kw = {}\r\nbranched = \u003csqlalchemy.future.engine.Connection object at 0x1044ce430>, conn = \u003csqlalchemy.pool.base._ConnectionFairy object at 0x1046ae160>\r\ncontext = \u003csqlalchemy.dialects.postgresql.psycopg2.PGExecutionContext_psycopg2 object at 0x10452e2e0>\r\ncursor = \u003ccursor object at 0x1043069a0; closed: -1>, evt_handled = False\r\n\r\n def _execute_context(\r\n self,\r\n dialect,\r\n constructor,\r\n statement,\r\n parameters,\r\n execution_options,\r\n *args,\r\n **kw\r\n ):\r\n \"\"\"Create an :class:`.ExecutionContext` and execute, returning\r\n a :class:`_engine.CursorResult`.\"\"\"\r\n\r\n branched = self\r\n if self.__branch_from:\r\n # if this is a \"branched\" connection, do everything in terms\r\n # of the \"root\" connection, *except* for .close(), which is\r\n # the only feature that branching provides\r\n self = self.__branch_from\r\n\r\n try:\r\n conn = self._dbapi_connection\r\n if conn is None:\r\n conn = self._revalidate_connection()\r\n\r\n context = constructor(\r\n dialect, self, conn, execution_options, *args, **kw\r\n )\r\n except (exc.PendingRollbackError, exc.ResourceClosedError):\r\n raise\r\n except BaseException as e:\r\n self._handle_dbapi_exception(\r\n e, util.text_type(statement), parameters, None, None\r\n )\r\n\r\n if (\r\n self._transaction\r\n and not self._transaction.is_active\r\n or (\r\n self._nested_transaction\r\n and not self._nested_transaction.is_active\r\n )\r\n ):\r\n self._invalid_transaction()\r\n\r\n elif self._trans_context_manager:\r\n TransactionalContext._trans_ctx_check(self)\r\n\r\n if self._is_future and self._transaction is None:\r\n self._autobegin()\r\n\r\n context.pre_exec()\r\n\r\n if dialect.use_setinputsizes:\r\n context._set_input_sizes()\r\n\r\n cursor, statement, parameters = (\r\n context.cursor,\r\n context.statement,\r\n context.parameters,\r\n )\r\n\r\n if not context.executemany:\r\n parameters = parameters[0]\r\n\r\n if self._has_events or self.engine._has_events:\r\n for fn in self.dispatch.before_cursor_execute:\r\n statement, parameters = fn(\r\n self,\r\n cursor,\r\n statement,\r\n parameters,\r\n context,\r\n context.executemany,\r\n )\r\n\r\n if self._echo:\r\n\r\n self._log_info(statement)\r\n\r\n stats = context._get_cache_stats()\r\n\r\n if not self.engine.hide_parameters:\r\n self._log_info(\r\n \"[%s] %r\",\r\n stats,\r\n sql_util._repr_params(\r\n parameters, batches=10, ismulti=context.executemany\r\n ),\r\n )\r\n else:\r\n self._log_info(\r\n \"[%s] [SQL parameters hidden due to hide_parameters=True]\"\r\n % (stats,)\r\n )\r\n\r\n evt_handled = False\r\n try:\r\n if context.executemany:\r\n if self.dialect._has_events:\r\n for fn in self.dialect.dispatch.do_executemany:\r\n if fn(cursor, statement, parameters, context):\r\n evt_handled = True\r\n break\r\n if not evt_handled:\r\n self.dialect.do_executemany(\r\n cursor, statement, parameters, context\r\n )\r\n elif not parameters and context.no_parameters:\r\n if self.dialect._has_events:\r\n for fn in self.dialect.dispatch.do_execute_no_params:\r\n if fn(cursor, statement, context):\r\n evt_handled = True\r\n break\r\n if not evt_handled:\r\n self.dialect.do_execute_no_params(\r\n cursor, statement, context\r\n )\r\n else:\r\n if self.dialect._has_events:\r\n for fn in self.dialect.dispatch.do_execute:\r\n if fn(cursor, statement, parameters, context):\r\n evt_handled = True\r\n break\r\n if not evt_handled:\r\n> self.dialect.do_execute(\r\n cursor, statement, parameters, context\r\n )\r\n\r\n/Users/brapaport/Library/Caches/pypoetry/virtualenvs/app-wQsFoDFt-py3.9/lib/python3.9/site-packages/sqlalchemy/engine/base.py:1799:\r\n_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _\r\n\r\nself = \u003csqlalchemy.dialects.postgresql.psycopg2.PGDialect_psycopg2 object at 0x1044cebe0>\r\ncursor = \u003ccursor object at 0x1043069a0; closed: -1>\r\nstatement = '\\nCREATE TABLE identity (\\n\\ttax_id_type taxidtype, \\n\\tfunding_source fundingsource[], \\n\\tgiven_name VARCHAR NOT NU...T, \\n\\tid UUID NOT NULL, \\n\\tuser_id UUID, \\n\\tPRIMARY KEY (id), \\n\\tFOREIGN KEY(user_id) REFERENCES users (id)\\n)\\n\\n'\r\nparameters = {}, context = \u003csqlalchemy.dialects.postgresql.psycopg2.PGExecutionContext_psycopg2 object at 0x10452e2e0>\r\n\r\n def do_execute(self, cursor, statement, parameters, context=None):\r\n> cursor.execute(statement, parameters)\r\nE psycopg2.errors.UndefinedObject: type \"taxidtype\" does not exist\r\nE LINE 3: tax_id_type taxidtype,\r\nE ^\r\n\r\n/Users/brapaport/Library/Caches/pypoetry/virtualenvs/app-wQsFoDFt-py3.9/lib/python3.9/site-packages/sqlalchemy/engine/default.py:717: UndefinedObject\r\n\r\nThe above exception was the direct cause of the following exception:\r\n\r\npostgresql = \u003cconnection object at 0x104333eb0; dsn: 'user=postgres password=xxx dbname=tests host=127.0.0.1 port=17942 options=''', closed: 0>\r\n\r\n @pytest.fixture(name=\"session\")\r\n def session_fixture(postgresql: connection):\r\n engine = create_engine(\r\n \"postgresql+psycopg2://\",\r\n connect_args=postgresql.get_dsn_parameters(),\r\n pool_pre_ping=True,\r\n )\r\n\r\n> SQLModel.metadata.create_all(engine)\r\n\r\ntests/utilities/test_db.py:14:\r\n```\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.9.7\n\n### Additional Context\n\n_No response_","author":{"url":"https://github.com/br-follow","@type":"Person","name":"br-follow"},"datePublished":"2021-10-14T21:24:16Z","url":"https://github.com/fastapi/sqlmodel/issues/131"}
| 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:86b74189-3127-ce2f-34fc-fa56435e965c |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | B05C:ADA14:446D70:6030AE:6AFE0744 |
| html-safe-nonce | 1b5ab844ad9787c3f1a70d3491c83ed8c0cc64da97ed7654a6ef0b68911500a6 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCMDVDOkFEQTE0OjQ0NkQ3MDo2MDMwQUU6NkFGRTA3NDQiLCJ2aXNpdG9yX2lkIjoiMTg3NjEzNjE1ODcyMzcwNDY0NCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | 009ce5040c9a54dcbd8f311000fdb9b6b0ba6437e6d763786c45d350f5cadc90 |
| hovercard-subject-tag | issue:1026835776 |
| 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/131/issue_layout |
| twitter:image | https://opengraph.githubassets.com/c1b601ba9f398825ed80b1098d1c482858b302f412402357127ea7cd3e6f62ef/fastapi/sqlmodel/issues/131 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/c1b601ba9f398825ed80b1098d1c482858b302f412402357127ea7cd3e6f62ef/fastapi/sqlmodel/issues/131 |
| 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 | br-follow |
| hostname | github.com |
| expected-hostname | github.com |
| None | 86d46ece7c3d9b0562692f81a135cb55ad6a1c82c93ab1ac874d2f1b46b28958 |
| 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 | 5c18e6799976b7bc2f21178024289bb98edbcc85 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width