Exemplos de Column em Python

Exemplo n.º 1

Arquivo: user.py Projeto: iagovcosta/flask-architeture

class User(db.Model, FlaskSerializeMixin):
    __tablename__ = 'users'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    name = db.Column(db.String(200), unique=True, nullable=False)
    email = db.Column(db.String(200), unique=True, nullable=False)
    password = db.Column(db.String(200))
    files = db.relationship('File', backref='users_id')

    def __init__(self, name, email, password):
        self.name = name
        self.email = email
        self.password = password

Exemplo n.º 2

class Entity(db.Model):
    __tablename__ = 'entities'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    name = db.Column(db.String(200), unique=True, nullable=False)
    email = db.Column(db.String(200), unique=True, nullable=False)
    password = db.Column(db.String(200))

    # entity = db.relationship('Entity', backref='users_id')

    def __init__(self, name, email, password):
        self.name = name
        self.email = email
        self.password = password

Exemplo n.º 3

Arquivo: file.py Projeto: Wilson3g/flask-architeture

class File(db.Model):
    __tablename__ = 'files'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    name = db.Column(db.String(255), nullable=False)
    path_file = db.Column(db.String(255), nullable=False)
    # user_id = db.Column(db.Integer(), db.ForeignKey('users.id'), nullable=False)
    created_at = db.Column(db.DateTime, default=datetime.datetime.utcnow)
    updated_at = db.Column(db.DateTime, default=datetime.datetime.utcnow, server_onupdate=db.func.now())

    def __init__(self, name, path_file):
        self.name = name
        self.path_file = path_file
        # self.user_id = user_id

Exemplo n.º 4

Arquivo: file.py Projeto: iagovcosta/flask-architeture

class File(db.Model, FlaskSerializeMixin):
    __tablename__ = 'files'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    name = db.Column(db.String(255), nullable=False)
    path_file = db.Column(db.String(255), nullable=False)
    user_id = db.Column(db.Integer(),
                        db.ForeignKey('users.id'),
                        nullable=False)
    created_at = db.Column(db.DateTime, default=datetime.datetime.utcnow)
    updated_at = db.Column(db.DateTime,
                           default=datetime.datetime.utcnow,
                           server_onupdate=db.func.now())
    deleted = db.Column(db.Boolean(), default=False)

    query_class = QueryWithSoftDelete

    def __init__(self, name, path_file, user_id):
        self.name = name
        self.path_file = path_file
        self.user_id = user_id

Exemplo n.º 5

Arquivo: user.py Projeto: Wilson3g/flask-architeture

class User(db.Model):
    __tablename__ = 'users'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    name = db.Column(db.String(200), nullable=False)
    email = db.Column(db.String(200), unique=True, nullable=False)
    password = db.Column(db.String(200))
    created_at = db.Column(db.DateTime, default=datetime.datetime.utcnow)
    updated_at = db.Column(db.DateTime,
                           default=datetime.datetime.utcnow,
                           server_onupdate=db.func.now())

    # entity = db.relationship('Entity', backref='users_id')

    def __init__(self, name, email, password):
        self.name = name
        self.email = email
        self.password = password