Esempio n. 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)
Esempio n. 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)
Esempio n. 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)
Esempio n. 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))
Esempio n. 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())
Esempio n. 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())
Esempio n. 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)
Esempio n. 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())
Esempio n. 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())
Esempio n. 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())
Esempio n. 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)
Esempio n. 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)
Esempio n. 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)
Esempio n. 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)
Esempio n. 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)
Esempio n. 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))
Esempio n. 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)
Esempio n. 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))
Esempio n. 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))
Esempio n. 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)
Esempio n. 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)
Esempio n. 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())
Esempio n. 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)
Esempio n. 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())
Esempio n. 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)
Esempio n. 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)
Esempio n. 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)
Esempio n. 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))
Esempio n. 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())
Esempio n. 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())