Skip to content

Convert existing SQLAlchemy ORM to SQLModel ORMΒ #182

@havok2063

Description

@havok2063

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 SQLModel" and didn't find any information.
  • I already read and followed all the tutorial in the docs and didn't find an answer.
  • I already checked if it is not related to SQLModel but to Pydantic.
  • I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

  • I commit to help with one of those options πŸ‘†

Example Code

# example potential pseudo-code of desired functionality

# import existing SQLAlchemy ORM Table
from project.sqlalchemy.models import Table

# convert SQLA Table ORM to SQLModel Table
SQLM_Table = SQLModel.convert(Table)

# or batch convert a set of SQLAlchemy ORMs
from project.sqlalchemy import models
SQLM_models = sqlmodel_batch_convert(models)

Description

In your docs, you only describe creating a db, tables and SQLModel ORM from scratch. If you already have a set of defined SQLAlchemy ORMs for an existing db, is there a mechanism for converting existing SQLAlchemy ORMs into SQLModel ORMs? I looked through the docs but couldn't find anything related to that. I provide some desired functionality as pseudocode, but maybe this functionality already exists?

Operating System

macOS

Operating System Details

No response

SQLModel Version

latest

Python Version

3.8

Additional Context

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    questionFurther information is requested

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions