#!/usr/bin/env python # -*- coding: utf-8 -*- __author__ = 'mr.S' from kernel.db import Base from entities.entity import Entity from sqlalchemy import Column, Integer, String, Text, desc from bottle import request from kernel.translator import translatable class Content(Base, Entity): __tablename__ = 's_content' id = Column(Integer, primary_key=True) alias = Column(String(255)) name = Column(String(255)) text = Column(Text()) @staticmethod def list_all(conn): return conn.query(Content).all() @classmethod def get_by_id(cls, conn, id): return conn.query(Content).filter(Content.id == id).first() @staticmethod def get_by_alias(conn, alias): return conn.query(Content).filter(Content.alias == alias).first() translatable(Content, ['name', 'text'])
#!/usr/bin/env python # -*- coding: utf-8 -*- __author__ = 'mr.S' from entities.entity import Entity from kernel.db import Base from kernel.translator import translatable from sqlalchemy import Column, Integer, String, Text, Boolean, DateTime import datetime class News(Base, Entity): __tablename__ = 's_news' id = Column(Integer, primary_key=True) title = Column(String(255)) text = Column(Text()) datetime = Column(DateTime(), default=datetime.datetime.now()) visible = Column(Boolean(create_constraint=False), default=True) @staticmethod def get_all(conn): return conn.query(News).order_by(News.datetime.desc()).all() @staticmethod def get_visible(conn): return conn.query(News).filter(News.visible == True).order_by(News.datetime.desc()).all() translatable(News, ['title', 'text'])
__author__ = 'mr.S' from kernel.db import Base from sqlalchemy import Column, Integer, String, Text from entities.entity import Entity from kernel.translator import translatable class Dictionary(Base, Entity): __tablename__ = 's_dictionary' id = Column(Integer, primary_key=True) code = Column(String(255)) text = Column(Text()) @staticmethod def get_by_code(conn, code): return conn.query(Dictionary).filter(Dictionary.code == code).first() @staticmethod def list_by_code(conn, code): if type(code) is not list: code = [code] return conn.query(Dictionary).filter(Dictionary.code.in_(code)).all() @staticmethod def list_all(conn): return conn.query(Dictionary).order_by(Dictionary.code).all() translatable(Dictionary, ['text'])
from kernel.translator import translatable class Contacts(Base, Entity): __tablename__ = 's_contacts' cnt_id = Column(Integer, primary_key=True) cnt_type = Column(String(255)) cnt_value = Column(Text()) @staticmethod def list_all(conn): return conn.query(Contacts).all() @staticmethod def get_by_id(conn, id): return conn.query(Contacts).filter(Contacts.cnt_id == id).first() @staticmethod def list_by_type(conn, type): return conn.query(Contacts).filter(Contacts.cnt_type == type).all() @staticmethod def list_all_by_type(conn): _contacts = Contacts.list_all(conn) contacts = {} for contact in _contacts: if contact.cnt_type not in contacts.keys(): contacts[contact.cnt_type] = [] contacts[contact.cnt_type].append(contact) return contacts translatable(Contacts, ['cnt_value'])