Python Column Examples

Example #1

File: models.py Project: ledufe/dashmachine

class DataSources(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String())
    platform = db.Column(db.String())
    args = db.relationship("DataSourcesArgs", backref="data_source")
    apps = db.relationship(
        "Apps",
        secondary=rel_app_data_source,
        backref=db.backref("data_sources", lazy="dynamic"),
    )

Example #2

File: models.py Project: LaunchedBerry07/DashMachine-SimpleDash

class Settings(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    theme = db.Column(db.String())
    accent = db.Column(db.String())
    background = db.Column(db.String())
    roles = db.Column(db.String())
    home_access_groups = db.Column(db.String())
    settings_access_groups = db.Column(db.String())
    custom_app_title = db.Column(db.String())
    sidebar_default = db.Column(db.String())
    tags_expanded = db.Column(db.String())

Example #3

File: models.py Project: ledufe/dashmachine

class Settings(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    theme = db.Column(db.String())
    accent = db.Column(db.String())
    background = db.Column(db.String())
    roles = db.Column(db.String())
    home_access_groups = db.Column(db.String())
    settings_access_groups = db.Column(db.String())
    home_view_mode = db.Column(db.String())
    custom_app_title = db.Column(db.String())

Example #4

File: models.py Project: LaunchedBerry07/DashMachine-SimpleDash

class User(db.Model, UserMixin):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(120), unique=True, nullable=False)
    password = db.Column(db.String(60), nullable=False)
    role = db.Column(db.String())
    theme = db.Column(db.String())
    background = db.Column(db.String())
    accent = db.Column(db.String())
    sidebar_default = db.Column(db.String())
    tags_expanded = db.Column(db.String())

Example #5

File: models.py Project: ledufe/dashmachine

class Files(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String())
    path = db.Column(db.String())
    external_path = db.Column(db.String())
    cache = db.Column(db.String())
    folder = db.Column(db.String())

Example #6

File: models.py Project: ledufe/dashmachine

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

Example #7

File: models.py Project: ledufe/dashmachine

class Groups(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String())
    roles = db.Column(db.String())

Example #8

File: models.py Project: ledufe/dashmachine

class DataSourcesArgs(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    key = db.Column(db.String())
    value = db.Column(db.String())
    data_source_id = db.Column(db.Integer, db.ForeignKey("data_sources.id"))

Example #9

File: models.py Project: ledufe/dashmachine

class Apps(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String())
    prefix = db.Column(db.String())
    url = db.Column(db.String())
    icon = db.Column(db.String())
    sidebar_icon = db.Column(db.String())
    description = db.Column(db.String())
    open_in = db.Column(db.String())
    data_template = db.Column(db.String())
    groups = db.Column(db.String())
    tags = db.Column(db.String())

Example #10

File: models.py Project: ledufe/dashmachine

from dashmachine import db

rel_app_data_source = db.Table(
    "rel_app_data_source",
    db.Column("data_source_id", db.Integer, db.ForeignKey("data_sources.id")),
    db.Column("app_id", db.Integer, db.ForeignKey("apps.id")),
)


class Files(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String())
    path = db.Column(db.String())
    external_path = db.Column(db.String())
    cache = db.Column(db.String())
    folder = db.Column(db.String())


class Apps(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String())
    prefix = db.Column(db.String())
    url = db.Column(db.String())
    icon = db.Column(db.String())
    sidebar_icon = db.Column(db.String())
    description = db.Column(db.String())
    open_in = db.Column(db.String())
    data_template = db.Column(db.String())
    groups = db.Column(db.String())
    tags = db.Column(db.String())