Пример #1
0
#!/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'])
Пример #2
0
#!/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'])
Пример #3
0
__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'])
Пример #4
0
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'])