Python Column Beispiele

Beispiel #1

class AssetModel(db.Model):
    __tablename__ = 'asset'

    uuid = db.Column(db.String(64), primary_key=True)
    is_attachment = db.Column(db.Boolean, default=False, nullable=False)
    filename = db.Column(db.String(120), nullable=False)
    data = db.Column(db.Binary, nullable=False)

Beispiel #2

Datei: web_page_model.py Projekt: marco79423/mysite

class WebPageModel(db.Model):
    __tablename__ = 'web_page'

    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    app = db.Column(db.String(32), nullable=False)
    slug = db.Column(db.String(128), nullable=False, unique=True)
    title = db.Column(db.String(128), nullable=False, unique=True)
    content = db.Column(db.Text, nullable=False)

Beispiel #3

Datei: article_model.py Projekt: marco79423/mysite

class ArticleModel(db.Model):
    __tablename__ = 'article'

    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    slug = db.Column(db.String(128), nullable=False, unique=True)
    title = db.Column(db.String(128), nullable=False, unique=True)
    date = db.Column(db.Date, nullable=False)
    modified_date = db.Column(db.Date, nullable=True)
    categories = db.relationship(CategoryModel, secondary=categories)
    chicken_count = db.Column(db.Integer, nullable=False)
    content = db.Column(db.Text, nullable=False)
    summary = db.Column(db.Text, nullable=False)
    raw_summary = db.Column(db.Text, nullable=False)

Beispiel #4

Datei: article_model.py Projekt: marco79423/mysite

from imports.infrastructure.domains.blog.model import db
from imports.infrastructure.domains.blog.model.category_model import CategoryModel

categories = db.Table(
    'categories',
    db.Column('article_id',
              db.Integer,
              db.ForeignKey('article.id'),
              primary_key=True),
    db.Column('category_id',
              db.Integer,
              db.ForeignKey('category.id'),
              primary_key=True))


class ArticleModel(db.Model):
    __tablename__ = 'article'

    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    slug = db.Column(db.String(128), nullable=False, unique=True)
    title = db.Column(db.String(128), nullable=False, unique=True)
    date = db.Column(db.Date, nullable=False)
    modified_date = db.Column(db.Date, nullable=True)
    categories = db.relationship(CategoryModel, secondary=categories)
    chicken_count = db.Column(db.Integer, nullable=False)
    content = db.Column(db.Text, nullable=False)
    summary = db.Column(db.Text, nullable=False)
    raw_summary = db.Column(db.Text, nullable=False)

Beispiel #5

Datei: category_model.py Projekt: marco79423/mysite

class CategoryModel(db.Model):
    __tablename__ = 'category'

    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    slug = db.Column(db.String(128), nullable=False, unique=True)
    name = db.Column(db.String(128), nullable=False, unique=True)

Beispiel #6

class SiteInfoModel(db.Model):
    __tablename__ = 'site_info'

    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    updated_time = db.Column(db.DateTime(timezone=True), nullable=False)
    repo_version = db.Column(db.String(128), nullable=False)