starlite sql alchemy plugin example

1_models.py

from sqlalchemy import Column, Float, Integer, String
from sqlalchemy.orm import declarative_base

Base = declarative_base()

class Company(Base):
    id = Column(Integer, primary_key=True)
    name = Column(String)
    worth = Column(Float)

2_endpoints.py

from starlite import post, get

from models import Company

@post(path="/companies")
def create_company(data: Company) -> Company:
    ...


@get(path="/companies")
def get_companies() -> List[Company]:
    ...

3_main.py

from starlite import Starlite, SQLAlchemyPlugin

from endpoints import create_company, get_companies

app = Starlite(route_handlers=[create_company, get_companies], plugins=[SQLAlchemyPlugin()])