[PYTHON/SQLMODEL] metadata 변수 : create_all 메소드를 사용해 모든 테이블 생성하기

■ metadata 변수의 create_all 메소드를 사용해 모든 테이블을 생성하는 방법을 보여준다.

※ 테이블이 생성되어 있으면 테이블 생성을 하지 않는다.

▶ 예제 코드 (PY)


from sqlmodel import SQLModel, JSON, Field, Column, create_engine
from typing   import List

class Event(SQLModel, table = True):
    id          : int | None = Field(default = None, primary_key = True)
    title       : str
    image       : str
    description : str
    location    : str
    tagList     : List[str] = Field(sa_column = Column(JSON))

databaseFilePath             = "test.db"
databaseURL                  =  f"sqlite:///{databaseFilePath}"
connectionArgumentDictionary = {"check_same_thread" : False}

engine = create_engine(databaseURL, echo = False, connect_args = connectionArgumentDictionary)

SQLModel.metadata.create_all(engine)

from sqlmodel import SQLModel, JSON, Field, Column, create_engine

from typing import List

class Event(SQLModel, table = True):

id : int | None = Field(default = None, primary_key = True)

title : str

image : str

description : str

location : str

tagList : List[str] = Field(sa_column = Column(JSON))

databaseFilePath = "test.db"

databaseURL = f"sqlite:///{databaseFilePath}"

connectionArgumentDictionary = {"check_same_thread" : False}

engine = create_engine(databaseURL, echo = False, connect_args = connectionArgumentDictionary)

SQLModel.metadata.create_all(engine)