Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Specifying SQL Server column data type, similar to dtype in pd.to_sql() #319

Open
8 tasks done
HansOlavMyklebust opened this issue Apr 29, 2022 · 1 comment
Open
8 tasks done
Labels
question Further information is requested

Comments

@HansOlavMyklebust
Copy link

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

from typing import Optional

from sqlmodel import Field, SQLModel
from sqlalchemy.typing import NVARCHAR

class Hero(SQLModel, table=True):
    id: str = Field(default=None, primary_key=True, dtype=NVARCHAR(32))
    name: str
    secret_name: str
    age: Optional[int] = None

Description

Create a SQLModel that contains a mapping between python type (e.g str) and SQL Server column type (e.g NVARCHAR(32)). This is possible to do when using pandas to_sql() by specifying the dtype-argument.

Operating System

Linux, Windows

Operating System Details

No response

SQLModel Version

0.0.6

Python Version

Python 3.9.7

Additional Context

No response

@JacobHayes
Copy link

I think this is supported now with sa_type.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Further information is requested
Projects
None yet
Development

No branches or pull requests

2 participants