Spaces:
Sleeping
Sleeping
File size: 2,245 Bytes
71b4454 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 | from sqlalchemy import Column, Integer, String, DateTime, Text, JSON, Boolean, ForeignKey
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship
from datetime import datetime
Base = declarative_base()
class Workspace(Base):
__tablename__ = "workspaces"
id = Column(Integer, primary_key=True)
workspace_id = Column(String(64), unique=True, nullable=False)
name = Column(String(128), nullable=False)
owner = Column(String(64), nullable=True)
created_at = Column(DateTime, default=datetime.utcnow)
updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
files = relationship("WorkspaceFile", back_populates="workspace")
class WorkspaceFile(Base):
__tablename__ = "workspace_files"
id = Column(Integer, primary_key=True)
file_id = Column(String(64), unique=True, nullable=False)
workspace_id = Column(Integer, ForeignKey("workspaces.id"))
path = Column(String(512), nullable=False) # relative path
content = Column(Text, nullable=True)
language = Column(String(32), nullable=True) # e.g., python, javascript, etc.
version = Column(Integer, default=1)
created_at = Column(DateTime, default=datetime.utcnow)
updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
workspace = relationship("Workspace", back_populates="files")
dependencies = relationship("FileDependency", foreign_keys="FileDependency.from_file_id", back_populates="from_file")
dependents = relationship("FileDependency", foreign_keys="FileDependency.to_file_id", back_populates="to_file")
class FileDependency(Base):
__tablename__ = "file_dependencies"
id = Column(Integer, primary_key=True)
from_file_id = Column(Integer, ForeignKey("workspace_files.id"))
to_file_id = Column(Integer, ForeignKey("workspace_files.id"))
dep_type = Column(String(32), default="import") # import, require, include, etc.
created_at = Column(DateTime, default=datetime.utcnow)
from_file = relationship("WorkspaceFile", foreign_keys=[from_file_id], back_populates="dependencies")
to_file = relationship("WorkspaceFile", foreign_keys=[to_file_id], back_populates="dependents")
|