Buckets:

download
raw
1.81 kB
"""
Example usage of deepsel SQLAlchemy DatabaseManager
This example demonstrates how to use the DatabaseManager to automatically
manage database schema migrations for your SQLAlchemy models.
"""
from sqlalchemy import (
Column,
Integer,
String,
ForeignKey,
Enum as SQLEnum,
)
from sqlalchemy.orm import declarative_base, relationship
import enum
from deepsel.sqlalchemy import DatabaseManager
Base = declarative_base()
class UserRole(enum.Enum):
ADMIN = "admin"
USER = "user"
GUEST = "guest"
class User(Base):
__tablename__ = "users"
id = Column(Integer, primary_key=True)
username = Column(String(50), unique=True, nullable=False)
email = Column(String(100), unique=True, nullable=False)
role = Column(SQLEnum(UserRole), default=UserRole.USER, nullable=False)
posts = relationship("Post", back_populates="author")
class Post(Base):
__tablename__ = "posts"
id = Column(Integer, primary_key=True)
title = Column(String(200), nullable=False)
content = Column(String, nullable=True)
author_id = Column(Integer, ForeignKey("users.id"), nullable=False)
author = relationship("User", back_populates="posts")
def main():
models_pool = {
"users": User,
"posts": Post,
}
db_manager = DatabaseManager(
sqlalchemy_declarative_base=Base,
db_url="postgresql://user:password@localhost/mydb",
models_pool=models_pool,
)
print("Database schema migration completed!")
with db_manager._get_session() as db:
new_user = User(
username="john_doe", email="john@example.com", role=UserRole.ADMIN
)
db.add(new_user)
db.commit()
print(f"Created user: {new_user.username}")
if __name__ == "__main__":
main()

Xet Storage Details

Size:
1.81 kB
·
Xet hash:
f36013795061d0a557e78a5fbc47fc2625a080cefbb65d52bcf23c2513f96e9b

Xet efficiently stores files, intelligently splitting them into unique chunks and accelerating uploads and downloads. More info.