17 lines
460 B
Python
17 lines
460 B
Python
from sqlalchemy import Column, Integer, String
|
|
from sqlalchemy.orm import Session
|
|
|
|
from database.database import Base
|
|
|
|
|
|
class Profile(Base):
|
|
__tablename__ = "profiles"
|
|
|
|
id = Column(Integer, primary_key=True, autoincrement=True)
|
|
name = Column(String, nullable=False, unique=True)
|
|
|
|
@classmethod
|
|
def getAll(cls, db: Session) -> list[dict]:
|
|
profiles = db.query(cls).all()
|
|
return [{"id": p.id, "name": p.name} for p in profiles]
|