Хранилища Subversion apt-scan

import sqlalchemy.orm
import sqlalchemy.ext
import sqlalchemy.ext.declarative
import sqlite3

from sqlalchemy import Column, Integer, String, ForeignKey, create_engine, UniqueConstraint
from sqlalchemy.orm import relation, backref
from sqlalchemy.ext.declarative import declarative_base

DB_STRING = "sqlite:///repo.db"
Base = declarative_base(bind = create_engine(DB_STRING, module = sqlite3.dbapi2, echo = False))

class Distr(Base):
    __tablename__= 'distr'
    id = Column("d_id", Integer, primary_key=True)
    caption = Column("d_caption", String(50), nullable=False, unique=True)

    codenames = relation("Codename", primaryjoin="Distr.id == Codename.distr_id", order_by="Codename.distr_id", backref="distr")

    def __init__(self, caption):
        self.caption = caption
    def __repr__(self):
        return "<Distr('%s')>" % (self.caption)

class Codename(Base):
    __tablename__ = "codename"
    id = Column("cn_id", Integer, primary_key=True)
    distr_id = Column("d_id", Integer, ForeignKey("distr.d_id"), nullable=False)
    caption = Column("cn_caption", String(50), nullable=False)
    UniqueConstraint("distr_id", "caption")
 
    suites = relation("Suite", primaryjoin="Codename.id == Suite.codename_id", order_by="Suite.codename_id", backref="suite")

    def __init__(self, caption):
        self.caption = caption
    def __repr__(self):
        return "<Codename('%s')>" % (self.caption)


class Suite(Base):
    __tablename__ = "suite"
    id = Column("st_id", Integer, primary_key=True)
    codename_id = Column ("cn_id", Integer, ForeignKey("codename.cn_id"), nullable=False)
    caption = Column ("st_caption", String(50), nullable=False)
    UniqueConstraint ("cn_id", "st_caption")

    pathes = relation("Path", primaryjoin="Suite.id == Path.suite_id", order_by="Path.suite_id", backref="suite")
 
    def __init__(self, caption):
        self.caption = caption
    def __repr__(self):
        return "<Suite('%s')>" % (self.caption)

class Path(Base):
    __tablename__ = "path"
    suite_id = Column("st_id", Integer, ForeignKey("suite.st_id"), primary_key=True)
    path = Column ("st_caption", String(50), primary_key=True)

    def __init__(self, path):
        self.path = path
    def __repr__(self):
        return "<Path('%s')>" % (self.path)