rag-gateway/app/models/resource_model.py

from datetime import datetime
from sqlalchemy import Column, Integer, String, DateTime, Table, ForeignKey
from sqlalchemy.orm import relationship, backref

from app.models.base_model import Base

class ResourceModel(Base):
    __tablename__ = 'resource'
    id = Column(String(36), primary_key=True, index=True)
    created_at = Column(DateTime, default=datetime.now())
    updated_at = Column(DateTime, default=datetime.now(), onupdate=datetime.now())
    name = Column(String(128))
    url = Column(String(200))
    path = Column(String(200))
    perms = Column(String(150))
    description = Column(String(200))
    icon = Column(String(100))
    seq = Column(Integer)
    target = Column(String(100))
    canbdeeleted = Column(Integer)
    resource_type_id = Column(String(36), ForeignKey('resource_type.id'))
    resource_id = Column(String(36), ForeignKey('resource.id'))
    parent = relationship('ResourceModel', remote_side=[id], backref='resources', uselist=False)
    children = relationship('ResourceModel')
    status = Column(String(10))
    hidden = Column(Integer, default=0)
    def get_id(self):
        return str(self.ID)

    def to_json(self):
        return {
            'menuId': self.id,
            'createTime': self.created_at,
            'updateTime': self.updated_at,
            'menuName': self.name,
            'component': self.url,
            'description': self.description,
            'icon': self.icon,
            'orderNum': self.seq,
            'target': self.target,
            'parentId': self.get_pid(),
            'parentName': self.get_pName(),
            'syresourcetype': self.get_type_json(),
            'status': self.status,
            'path': self.path,
            'perms': self.perms,
            # 类型（0目录 1菜单 2按钮）
            'menuType': self.resource_type_id,
        }

    def to_tree_select_json(self):
        return {
            'menuId': self.id,
            'menuName': self.name,
            'menuType': self.resource_type_id,
            'children': [res.to_tree_select_json() for res in self.children]
        }

    def to_router_json(self):
        router = {
            'name': self.path.capitalize() if self.path else '',
            'path': self.path,
            'hidden': bool(self.hidden),
            'redirect': 'noRedirect',
            'component': self.url,
            'alwaysShow': True,
            'meta': {
                'title': self.name,
                'icon': self.icon,
                'noCache': False,
                'link': ''
            },
            'children': [
                res.to_router_json() for res in self.children if res.type.id == '3' or res.type.id == '0'
            ]
        }

        if not router['children']:
            del router['children']
            del router['redirect']
            del router['alwaysShow']
        if not router['component']:
            router['component'] = 'Layout'

        return router

    def to_menu_json(self):
        return {
            'id': self.id,
            'iconCls': self.icon,
            'pid': self.get_pid(),
            'state': 'open',
            'checked': False,
            'attributes': {
                'target': self.target,
                'url': self.url
            },
            'text': self.name
        }

    def get_pid(self):
        if self.parent:
            return self.parent.id
        return ''

    def get_pName(self):
        if self.parent:
            return self.parent.name
        return ''

    def get_type_json(self):
        if self.type:
            return self.type.to_json()
        return {}

    def __repr__(self):
        return '<ResourceModel name:%r url:%r>\n' % (self.NAME, self.URL)


class ResourceTypeModel(Base):
    __tablename__ = 'resource_type'
    id = Column(String(36), primary_key=True)
    created_at = Column(DateTime, default=datetime.now())
    updated_at = Column(DateTime, default=datetime.now(), onupdate=datetime.now())
    name = Column(String(128))
    description = Column(String(255))

    resources = relationship('ResourceModel', backref='type', lazy='dynamic')

    def to_json(self):
        return {
            'id': self.id,
            'createdatetime': self.created_at,
            'updatedatetime': self.updated_at,
            'name': self.name,
            'description': self.description
        }

    def __repr__(self):
        return '<ResourceTypeModel %r>\n' %(self.name)