Activity

1. faris404

   added

   questionFurther information is requestedFurther information is requested

   on Sep 1, 2021
2. obassett commented on Sep 1, 2021

   

   obassett

   on Sep 1, 2021

   More actions

   To use unique you need to add the sa_column field bits and implement like SQL Alchemy does.

   from typing import Optional
   import datetime
   from sqlmodel import SQLModel, Field, Column, VARCHAR
   from pydantic import EmailStr
   
   class UserBase(SQLModel):
       username: EmailStr = Field(sa_column=Column("username", VARCHAR, unique=True))
       full_name: Optional[str] = None
       disabled: Optional[bool] = None
       lastLoggedInUTC: Optional[datetime.datetime] = None
       userCreationDateUTC: datetime.datetime = datetime.datetime.utcnow()

   So in my case I wanted username to be a unique email address - so set it to a field set the column name, data type and added unique=True.

   Reacted by Camillo Visini, Mikkel Mondrup Kristensen, Saeed Esmaili, Victor, João Flávio Santos and Manoj Kumar A
3. faris404 commented on Sep 2, 2021

   

   faris404

   on Sep 2, 2021

   Author

   More actions

   @obassett It Works!! Thank you for your valuable time😊
4. faris404

   closed this as completedon Sep 2, 2021
5. raulolteanu-sudo commented on Sep 2, 2021

   

   raulolteanu-sudo

   on Sep 2, 2021

   More actions

   Related to this, how can you add Table Level Constraints to SQL Model ?
   The equivalent of this in SQLModel:

   students = Table(
           'students', meta,
            Column('id', Integer, primary_key=True, autoincrement=False),
            CheckConstraint('id > 2', name='check1'),            <----- this bit
       ) ```

   Reacted by Steve Marin, Andrey Romanov, Dan Lipsitt and Christian Holland
6. rochacbruno commented on Sep 13, 2021

   

   rochacbruno

   on Sep 13, 2021

   More actions

   There is an easy way

   Field(sa_column_kwargs={"unique": True})

   Reacted by Daniel Braun, chentt, Simon Wienhöfer, John Paul Calvo, John Rezk, northtree, Dimas Putra, astroboy and LeonardoGentile
7. rochacbruno commented on Sep 13, 2021

   

   rochacbruno

   on Sep 13, 2021

   More actions

   @raulolteanu-sudo you can write your custom data type with the validation as in https://pydantic-docs.helpmanual.io/usage/types/#custom-data-types

   But note that this works in the programming level and not on SQL level.
8. danielbraun89 commented on Sep 13, 2021

   

   danielbraun89

   on Sep 13, 2021

   More actions

   There is an easy way

   Field(sa_column_kwargs={"unique": True})

   sa_column_kwargs is amazing, havnt seen it anywhere in the docs. Thanks!

   Reacted by Bruno Rocha, Ramzi Sabra, Simon Wienhöfer, Evan Thomas, astroboy, LeonardoGentile and Zaffer
9. falkben commented on Nov 19, 2021

   

   falkben

   on Nov 19, 2021

   More actions

   There is an easy way

   Field(sa_column_kwargs={"unique": True})

   Just wanted to report that for me this did not work until I explicitly set index=False for the column. E.g.:

   Field(index=False, sa_column_kwargs={"unique": True})

   The other option in which you create the Column by hand with the sa_column param works, as did specifying __table_args__ = (UniqueConstraint("appid"),) as a class attribute for the table.

   I think there's some logic in SQLAlchemy that dictates that when a column has an index the index actually gains the unique constraint. Can see more in the sqlalchemy Column docstring

   Since all columns currently are created with an index by default in sqlmodel (see #11), we have to disable the index to see the unique constraint applied directly to the column.

   Reacted by Bruno Rocha and daniel_shtel