Python Column示例

示例#1

class Loja(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    titulo = db.Column(db.String(20))
    funcs = db.relationship('Funcionario', backref='loja', lazy='dynamic')

    def __init__(self, t):
        self.titulo = t

示例#2

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

    id_loja = db.Column(db.Integer, db.ForeignKey('loja.id'))

示例#3

class Disciplina(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    alunos = db.relationship('Aluno',
                             secondary=matriculas,
                             backref=db.backref('disciplina', lazy='dynamic'))

示例#4

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

示例#5

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

    id_telefone = db.Column(db.Integer, db.ForeignKey('telefone.id'))

    telefone = db.relationship('Telefone', backref='pessoa', uselist=False)

示例#6

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

    id_telefone = db.Column(db.Integer, db.ForeignKey('telefone.id'))

    telefone = db.relationship('Telefone', backref='pessoa', uselist=False)


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


matriculas = db.Table(
    'matriculas', db.Column('aluno_id', db.Integer, db.ForeignKey('aluno.id')),
    db.Column('disciplina_id', db.Integer, db.ForeignKey('disciplina.id')))


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

    disciplinas = db.relationship('Disciplina',
                                  secondary=matriculas,
                                  backref=db.backref('aluno', lazy='dynamic'))


class Disciplina(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    alunos = db.relationship('Aluno',
                             secondary=matriculas,