Python Table Examples

Example #1

from lbrc_flask.database import db
from lbrc_flask.security import User as BaseUser

users_studies = db.Table(
    'users_studies',
    db.Column(
        'user_id',
        db.Integer(),
        db.ForeignKey('user.id'),
        primary_key=True,
    ),
    db.Column(
        'study_id',
        db.Integer(),
        db.ForeignKey('study.id'),
        primary_key=True,
    ),
)


class User(BaseUser):
    __table_args__ = {'extend_existing': True}

    studies = db.relationship("Study",
                              secondary=users_studies,
                              backref=db.backref("users", lazy="joined"))

    def __str__(self):
        return 'user'

Example #2

File: model.py Project: LCBRU/lbrc_services

import uuid
import pathlib
import re
from flask import current_app
from sqlalchemy.orm import backref
from werkzeug.utils import secure_filename
from lbrc_flask.database import db
from lbrc_flask.security import User as BaseUser, AuditMixin
from lbrc_flask.forms.dynamic import Field, FieldGroup
from lbrc_flask.model import CommonMixin

services_owners = db.Table(
    "services_owners",
    db.Column("service_id", db.Integer(), db.ForeignKey("service.id")),
    db.Column("user_id", db.Integer(), db.ForeignKey("user.id")),
)


class User(BaseUser):
    __table_args__ = {'extend_existing': True}

    owned_services = db.relationship("Service",
                                     lazy="joined",
                                     secondary=services_owners,
                                     backref='owners')

    @property
    def service_owner(self):
        return len(self.owned_services) > 0

Example #3

    is_updating = db.Column(db.Boolean)

    @property
    def pubmed_name(self):
        firstname, *_, lastname = self.name.split()
        return f'{lastname} {firstname[0]}'


academics_publications = db.Table(
    'academics_publications',
    db.Column(
        'academic_id',
        db.Integer(),
        db.ForeignKey('academic.id'),
        primary_key=True,
    ),
    db.Column(
        'publication_id',
        db.Integer(),
        db.ForeignKey('publication.id'),
        primary_key=True,
    ),
)


class Publication(AuditMixin, CommonMixin, db.Model):

    id = db.Column(db.Integer(), primary_key=True)
    pm_id = db.Column(db.Integer())
    journal = db.Column(db.String(200))
    published_date = db.Column(db.Date)

Example #4

    def get_type(type_name):
        return ParticipantIdentifierType.query.filter_by(
            name=type_name, ).one_or_none()

    @staticmethod
    def get_study_participant_id():
        return ParticipantIdentifierType.get_type(
            ParticipantIdentifierTypeName.STUDY_PARTICIPANT_ID)


participant_identifiers__participant_identifier_sources = db.Table(
    'participant_identifiers__participant_identifier_sources',
    db.Column('participant_identifier_source_id',
              db.Integer(),
              db.ForeignKey('participant_identifier_source.id'),
              primary_key=True),
    db.Column('participant_identifier_id',
              db.Integer(),
              db.ForeignKey('participant_identifier.id'),
              primary_key=True),
)


class ParticipantIdentifier(db.Model):
    __tablename__ = 'participant_identifier'

    id = db.Column(db.Integer, primary_key=True)
    identifier = db.Column(db.String(100), nullable=False)
    participant_identifier_type_id = db.Column(
        db.Integer, db.ForeignKey(ParticipantIdentifierType.id))
    participant_identifier_type = db.relationship(ParticipantIdentifierType)

Example #5

        number_portion = ""
        if self.number:
            number_portion = " ({})".format(self.number)
        return self.name + number_portion


class User(BaseUser):
    __table_args__ = {'extend_existing': True}

    site_id = db.Column(db.Integer, db.ForeignKey(Site.id))
    site = db.relationship(Site)


studies_owners = db.Table(
    "studies_owners",
    db.Column("study_id", db.Integer(), db.ForeignKey("study.id")),
    db.Column("user_id", db.Integer(), db.ForeignKey("user.id")),
)

studies_collaborators = db.Table(
    "studies_collaborators",
    db.Column("study_id", db.Integer(), db.ForeignKey("study.id")),
    db.Column("user_id", db.Integer(), db.ForeignKey(User.id)),
)


class Study(db.Model):

    id = db.Column(db.Integer(), primary_key=True)
    name = db.Column(db.String(100))
    date_created = db.Column(db.DateTime,