Beispiel #1
0
class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    admin = db.Column(db.Integer)
    tutorial = db.Column(db.Integer)
    username = db.Column(db.String(64), index=True, unique=True)
    email = db.Column(db.String(120), index=True, unique=True)
    password = db.Column(db.String(128))
    color = db.Column(db.String(128))
    background_color = db.Column(db.String(128))

    @property
    def is_authenticated(self):
        return True

    @property
    def is_active(self):
        return True

    def as_dict(self):
        return {
            c.name: str(getattr(self, c.name))
            for c in self.__table__.columns
        }

    def get_id(self):
        try:
            return unicode(self.id)  # python 2
        except NameError:
            return str(self.id)  # python 3

    def __repr__(self):
        return '<User %r>' % (self.username)
Beispiel #2
0
class Buttons(db.Model):
    __tablename__ = 'buttons'

    id = db.Column(db.Integer, primary_key=True)
    user = db.Column(db.String(), nullable=False)
    buttonNumber = db.Column(db.String(), nullable=False)
    icon = db.Column(db.String(), nullable=False)
Beispiel #3
0
class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    admin = db.Column(db.Integer)
    tutorial = db.Column(db.Integer)
    username = db.Column(db.String(64), index=True, unique=True)
    email = db.Column(db.String(120), index=True, unique=True)
    password = db.Column(db.String(128))
    buttonColor = db.Column(db.String(128))

    @property
    def is_authenticated(self):
        return True

    @property
    def is_active(self):
        return True

    def get_id(self):
        try:
            return str(self.id)  # python 2
        except NameError:
            return str(self.id)  # python 3

    def __repr__(self):
        return '<User %r>' % (self.username)
Beispiel #4
0
class Navbar(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    user = db.Column(db.String(64))
    url = db.Column(db.String(64))
    tooltip = db.Column(db.String(64))
    pourcentage = db.Column(db.String(64))
    fa = db.Column(db.String(64))
Beispiel #5
0
class WeightModel(db.Model):
    __tablename__ = 'fitness_weight'

    id = db.Column(db.Integer, primary_key=True)
    user = db.Column(db.String())
    weight = db.Column(db.String())
    date = db.Column(db.String())
Beispiel #6
0
class Widget(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    color = db.Column(db.String(256))
    url = db.Column(db.String(256))
    user = db.Column(db.Integer())
    name = db.Column(db.String(256))
    see_more = db.Column(db.String(256))
    param = db.Column(db.String())
Beispiel #7
0
class Widgets(db.Model):
    __tablename__ = 'widgets'

    id = db.Column(db.Integer, primary_key=True)
    user = db.Column(db.String(), nullable=False)
    name = db.Column(db.String(), nullable=False)
    raw = db.Column(db.String(), nullable=False)
    type = db.Column(db.String(), nullable=False)
Beispiel #8
0
class Scenario(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(256))
    template = db.Column(db.String(256))
    active = db.Column(db.Integer())
    event = db.Column(db.String(256))
    action = db.Column(db.String(256))
    action_param = db.Column(db.String(256))
    user = db.Column(db.Integer())
Beispiel #9
0
class Notif(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(255))
    text = db.Column(db.String(255))
    link = db.Column(db.String(255))
    priority = db.Column(db.Integer())
    is_read = db.Column(db.Integer())
    icon = db.Column(db.String(64))
    icon_color = db.Column(db.String(64))
    user = db.Column(db.Integer())
Beispiel #10
0
class Notifications(db.Model):
    __tablename__ = 'notifications'

    id = db.Column(db.Integer, primary_key=True)
    seen = db.Column(db.Boolean(), nullable=False)
    user = db.Column(db.String(), nullable=False)
    title = db.Column(db.String(), nullable=False)
    content = db.Column(db.String())
    icon = db.Column(db.String())
    color = db.Column(db.String())
Beispiel #11
0
class Config(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    config = db.Column(db.String())
    value = db.Column(db.String())

    @property
    def is_active(self):
        return True

    def get_id_(self):
        try:
            return str(self.id)
        except NameError:
            return str(self.id)
Beispiel #12
0
class Room(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(256))
    house = db.Column(db.String(256))

    @property
    def is_active(self):
        return True

    def get_id_(self):
        try:
            return str(self.id)
        except NameError:
            return str(self.id)
Beispiel #13
0
class Navbar(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    idAccount = db.Column(db.String(64))
    url = db.Column(db.String(64))
    tooltip = db.Column(db.String(64))
    pourcentage = db.Column(db.String(64))
    fa = db.Column(db.String(64))

    @property
    def is_active(self):
        return True

    def get_id_(self):
        try:
            return str(self.id)
        except NameError:
            return str(self.id)
Beispiel #14
0
class Light(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(256))
    identifier = db.Column(db.String(256))
    color = db.Column(db.String(256))
    protocol = db.Column(db.Integer())
    room = db.Column(db.String(256))
    state = db.Column(db.String(256))

    @property
    def is_active(self):
        return True

    def get_id_(self):
        try:
            return unicode(self.id)
        except NameError:
            return str(self.id)
Beispiel #15
0
class Widget(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    color = db.Column(db.String(256))
    url = db.Column(db.String(256))
    user = db.Column(db.Integer())
    name = db.Column(db.String(256))
    see_more = db.Column(db.String(256))
    param = db.Column(db.String())

    @property
    def is_active(self):
        return True

    def get_id_(self):
        try:
            return str(self.id)
        except NameError:
            return str(self.id)
Beispiel #16
0
class Calendar(db.Model):
    __tablename__ = 'calendar'
    
    id = db.Column(db.Integer, primary_key=True)
    user = db.Column(db.String(), nullable=False)
    title = db.Column(db.String(64))
    place = db.Column(db.String(255))
    note = db.Column(db.String(255))
    start = db.Column(db.String(64))
    end = db.Column(db.String(64))
    color = db.Column(db.String(64))
    allday = db.Column(db.String(64))
Beispiel #17
0
class Scenario(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(256))
    template = db.Column(db.String(256))
    active = db.Column(db.Integer())
    event = db.Column(db.String(256))
    action = db.Column(db.String(256))
    action_param = db.Column(db.String(256))
    user = db.Column(db.Integer())

    @property
    def is_active(self):
        return True

    def get_id_(self):
        try:
            return str(self.id)
        except NameError:
            return str(self.id)
Beispiel #18
0
class House(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(256))
    address = db.Column(db.String(256))
    city = db.Column(db.String(256))
    postal = db.Column(db.String(256))
    country = db.Column(db.String(256))
    latitude = db.Column(db.String(256))
    longitude = db.Column(db.String(256))
Beispiel #19
0
class User(db.Model):
    __tablename__ = 'users'

    id = db.Column(db.Integer, primary_key=True)
    account_type = db.Column(db.Integer)
    username = db.Column(db.String(100), nullable=False, unique=True)
    firstname = db.Column(db.String(100), nullable=False)
    lastname = db.Column(db.String(100), nullable=False)
    password = db.Column(db.String(200), nullable=False)
    email = db.Column(db.String(100), nullable=False, unique=True)
    language = db.Column(db.String(10), nullable=False)
    mode = db.Column(db.String())
    color = db.Column(db.String(100))
Beispiel #20
0
class Notif(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(255))
    text = db.Column(db.String(255))
    link = db.Column(db.String(255))
    priority = db.Column(db.Integer())
    is_read = db.Column(db.Integer())
    icon = db.Column(db.String(64))
    icon_color = db.Column(db.String(64))
    user = db.Column(db.Integer())

    @property
    def is_active(self):
        return True

    def get_id_(self):
        try:
            return str(self.id)
        except NameError:
            return str(self.id)
Beispiel #21
0
class RevokedToken(db.Model):
    __tablename__ = 'revoked_tokens'
    id = db.Column(db.Integer, primary_key=True)
    jti = db.Column(db.String(120))

    def add(self):
        db.session.add(self)
        db.session.commit()

    @classmethod
    def is_jti_blacklisted(cls, jti):
        query = cls.query.filter_by(jti=jti).first()
        return bool(query)
Beispiel #22
0
class Screen(db.Model):
    __tablename__ = 'screen'

    id = db.Column(db.Integer, primary_key=True)
    user = db.Column(db.String(), nullable=False)
    name = db.Column(db.String(), nullable=False)
    raw = db.Column(db.String(), nullable=False)
    type = db.Column(db.String(), nullable=False)
    beautifulName = db.Column(db.String(), nullable=False)
    defaultLayout = db.Column(db.String())
Beispiel #23
0
class Nav(db.Model):
    __tablename__ = 'nav'
    
    id = db.Column(db.Integer, primary_key=True)
    user = db.Column(db.String(), nullable=False)
    position = db.Column(db.String(), nullable=False)
    buttonNumber = db.Column(db.String(), nullable=False)
    url = db.Column(db.String(), nullable=False)
    icon = db.Column(db.String(), nullable=False)
    color = db.Column(db.String(), nullable=False)
Beispiel #24
0
class ConfigModel(db.Model):
    __tablename__ = 'spotify_config'

    id = db.Column(db.Integer, primary_key=True)
    user = db.Column(db.String())
    client_id = db.Column(db.String())
    client_secret = db.Column(db.String())
    redirect_uri = db.Column(db.String())
    access_token = db.Column(db.String())
    refresh_token = db.Column(db.String())
Beispiel #25
0
class Calendar(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    user = db.Column(db.String(64))
    title = db.Column(db.String(64))
    lieu = db.Column(db.String(255))
    notes = db.Column(db.String(255))
    start = db.Column(db.String(64))
    end = db.Column(db.String(64))
    color = db.Column(db.String(64))
    allday = db.Column(db.String(64))


    @property
    def is_active(self):
        return True

    def get_id_(self):
        try:
            return str(self.id)
        except NameError:
            return str(self.id)
Beispiel #26
0
class House(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(256))
    address = db.Column(db.String(256))
    city = db.Column(db.String(256))
    postal = db.Column(db.String(256))
    country = db.Column(db.String(256))
    latitude = db.Column(db.String(256))
    longitude = db.Column(db.String(256))

    @property
    def is_active(self):
        return True

    def get_id_(self):
        try:
            return str(self.id)
        except NameError:
            return str(self.id)
Beispiel #27
0
class ScreenLayouts(db.Model):
    __tablename__ = 'screen_layouts'

    id = db.Column(db.Integer, primary_key=True)
    user = db.Column(db.String(), nullable=False)
    layouts = db.Column(db.String(), nullable=False)
Beispiel #28
0
class Room(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(256))
    house = db.Column(db.String(256))
Beispiel #29
0
class Token(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(120))
    token = db.Column(db.String())
Beispiel #30
0
class WeatherConfig(db.Model):
    __tablename__ = 'weather_config'

    id = db.Column(db.Integer, primary_key=True)
    type = db.Column(db.String())
    value = db.Column(db.String())