Python Column示例

示例#1

文件： WeightModel.py 项目： OnyxAI/fitness_neuron

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())

示例#2

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)

示例#3

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)

示例#4

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)

示例#5

文件： UserModel.py 项目： OnyxAI/onyx

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))

示例#6

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())

示例#7

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)

示例#8

文件： ConfigModel.py 项目： Python3pkg/Onyx

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)

示例#9

文件： UsersModel.py 项目： OnyxAI/onyx_v1

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)

示例#10

文件： CalendarModel.py 项目： OnyxAI/calendar_neuron

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))

示例#11

文件： ScenarioModel.py 项目： OnyxAI/onyx_v1

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())

示例#12

文件： HouseModel.py 项目： OnyxAI/onyx_v1

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))

示例#13

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)

示例#14

文件： WidgetsModel.py 项目： OnyxAI/onyx_v1

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())

示例#15

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())

示例#16

文件： SpotifyModel.py 项目： Onyx-Skills/spotify_skill

class Spotify(db.Model):
    id = db.Column(db.Integer, primary_key=True)

    @property
    def is_active(self):
        return True

    def get_id_(self):
        try:
            return unicode(self.id)
        except NameError:
            return str(self.id)

示例#17

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())

示例#18

文件： NavModel.py 项目： OnyxAI/onyx

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)

示例#19

文件： ConfigModel.py 项目： OnyxAI/spotify_neuron

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())

示例#20

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))

示例#21

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)

示例#22

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)

示例#23

文件： HouseModel.py 项目： Python3pkg/Onyx

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)

示例#24

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)

示例#25

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)

示例#26

文件： LightModel.py 项目： Onyx-Skills/milight_skill

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)

示例#27

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)

示例#28

文件： RoomModel.py 项目： OnyxAI/onyx_v1

class Room(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(256))
    house = db.Column(db.String(256))

示例#29

文件： TokenModel.py 项目： OnyxAI/onyx_v1

class Token(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(120))
    token = db.Column(db.String())

示例#30

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())