sqlmodel Questions

Postgresql – sqlmodel query with a subselect self join

April 25, 2024
user1931485
2 Answers

Trying to do a self join on a model but am getting confused how to do so in sqlmodel ORM. Something equivalent to the use of following SQL in Postgresql. SELECT tt.id, ttp.parent_name, tt.name FROM target_table tt, (select DISTINCT bb.parent_id,…

VIEW QUESTION

How to create table fields using char(N) instead of varchar using sqlmodel in python/postgresql

April 16, 2024
Wellington Almeida dos Santos
2 Answers

Defining the class: from sqlmodel import Field, SQLModel, create_engine, Session, select, Column,String class person(SQLModel, table=True): id: Optional[int] = Field(default=None, primary_key=True) name: str = Field(max_length=100) nickname: str = Field(max_length=30) sqlmodel creates the table person: CREATE TABLE person( id SERIAL NOT NULL,…

VIEW QUESTION