René's URL Explorer Experiment


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

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@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-profiling0
react-import-mapreact,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-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:86b74189-3127-ce2f-34fc-fa56435e965c
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idB05C:ADA14:446D70:6030AE:6AFE0744
html-safe-nonce1b5ab844ad9787c3f1a70d3491c83ed8c0cc64da97ed7654a6ef0b68911500a6
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCMDVDOkFEQTE0OjQ0NkQ3MDo2MDMwQUU6NkFGRTA3NDQiLCJ2aXNpdG9yX2lkIjoiMTg3NjEzNjE1ODcyMzcwNDY0NCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac009ce5040c9a54dcbd8f311000fdb9b6b0ba6437e6d763786c45d350f5cadc90
hovercard-subject-tagissue:1026835776
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/fastapi/sqlmodel/131/issue_layout
twitter:imagehttps://opengraph.githubassets.com/c1b601ba9f398825ed80b1098d1c482858b302f412402357127ea7cd3e6f62ef/fastapi/sqlmodel/issues/131
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/c1b601ba9f398825ed80b1098d1c482858b302f412402357127ea7cd3e6f62ef/fastapi/sqlmodel/issues/131
og:image:altFirst 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:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamebr-follow
hostnamegithub.com
expected-hostnamegithub.com
None86d46ece7c3d9b0562692f81a135cb55ad6a1c82c93ab1ac874d2f1b46b28958
turbo-cache-controlno-preview
go-importgithub.com/fastapi/sqlmodel git https://github.com/fastapi/sqlmodel.git
octolytics-dimension-user_id156354296
octolytics-dimension-user_loginfastapi
octolytics-dimension-repository_id399495186
octolytics-dimension-repository_nwofastapi/sqlmodel
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id399495186
octolytics-dimension-repository_network_root_nwofastapi/sqlmodel
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release5c18e6799976b7bc2f21178024289bb98edbcc85
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/fastapi/sqlmodel/issues/131#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ffastapi%2Fsqlmodel%2Fissues%2F131
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ffastapi%2Fsqlmodel%2Fissues%2F131
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=fastapi%2Fsqlmodel
Reloadhttps://github.com/fastapi/sqlmodel/issues/131
Reloadhttps://github.com/fastapi/sqlmodel/issues/131
Reloadhttps://github.com/fastapi/sqlmodel/issues/131
fastapihttps://github.com/fastapi
sqlmodelhttps://github.com/fastapi/sqlmodel
Codehttps://github.com/fastapi/sqlmodel
Issues1 (1)https://github.com/fastapi/sqlmodel/issues
Pull requests53 (53)https://github.com/fastapi/sqlmodel/pulls
Discussionshttps://github.com/fastapi/sqlmodel/discussions
Actionshttps://github.com/fastapi/sqlmodel/actions
Projectshttps://github.com/fastapi/sqlmodel/projects
Security and qualityhttps://github.com/fastapi/sqlmodel/security
Insightshttps://github.com/fastapi/sqlmodel/insights
https://github.com/fastapi/sqlmodel
New issuehttps://github.com/login?return_to=https://github.com/fastapi/sqlmodel/issues/131
New issuehttps://github.com/login?return_to=https://github.com/fastapi/sqlmodel/issues/131
psycopg2.errors.UndefinedObject: type MY_ENUM does not existhttps://github.com/fastapi/sqlmodel/issues/131#top
questionFurther information is requestedhttps://github.com/fastapi/sqlmodel/issues?q=state%3Aopen%20label%3A%22question%22
https://github.com/br-follow
br-followhttps://github.com/br-follow
on Oct 14, 2021https://github.com/fastapi/sqlmodel/issues/131#issue-1026835776
Pydantichttps://github.com/samuelcolvin/pydantic
SQLAlchemyhttps://github.com/sqlalchemy/sqlalchemy
pytest_postgresqlhttps://pypi.org/project/pytest-postgresql/
br-followhttps://github.com/br-follow
questionFurther information is requestedhttps://github.com/fastapi/sqlmodel/issues?q=state%3Aopen%20label%3A%22question%22
on Oct 14, 2021https://github.com/fastapi/sqlmodel/issues/131#event-5466460938
https://github.com/yasamoka
yasamokahttps://github.com/yasamoka
on Oct 14, 2021https://github.com/fastapi/sqlmodel/issues/131#issuecomment-943758205
br-followhttps://github.com/br-follow
completedhttps://github.com/fastapi/sqlmodel/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Oct 15, 2021https://github.com/fastapi/sqlmodel/issues/131#event-5471500536
https://github.com/invokermain
invokermainhttps://github.com/invokermain
on Apr 11, 2022https://github.com/fastapi/sqlmodel/issues/131#issuecomment-1095157378
#164https://github.com/fastapi/sqlmodel/issues/164
https://github.com/olafdeleeuw
olafdeleeuwhttps://github.com/olafdeleeuw
on Jun 22, 2022https://github.com/fastapi/sqlmodel/issues/131#issuecomment-1162749873
#164https://github.com/fastapi/sqlmodel/issues/164
https://github.com/olafdeleeuw
olafdeleeuwhttps://github.com/olafdeleeuw
on Jun 23, 2022https://github.com/fastapi/sqlmodel/issues/131#issuecomment-1164005895
Sign up for freehttps://github.com/signup?return_to=https://github.com/fastapi/sqlmodel/issues/131
Sign in to commenthttps://github.com/login?return_to=https://github.com/fastapi/sqlmodel/issues/131
questionFurther information is requestedhttps://github.com/fastapi/sqlmodel/issues?q=state%3Aopen%20label%3A%22question%22
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.