Esempi in Python per Column

Esempio n. 1

File: model.py Progetto: FaBrand/python_display

class Builds(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    # state = db.Column('state', db.Enum(ResultStateEnum))
    jobs_id = db.Column(db.Integer, db.ForeignKey("jobs.id"))
    jobs = db.relationship("Jobs", back_populates="builds")

    changes_id = db.Column(db.Integer, db.ForeignKey("changes.id"))
    changes = db.relationship("Changes", back_populates="builds")

Esempio n. 2

File: model.py Progetto: FaBrand/python_display

class PrettyJobs(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    pretty_name = db.Column(db.String(255), nullable=False)
    jobs = db.relationship("Jobs", back_populates="pretty_name")
    jobs_id = db.Column(db.Integer, db.ForeignKey('jobs.id'), unique=True)

    def __repr__(self):
        return '<PrettyJobs {}>'.format(self.pretty_name)

Esempio n. 3

File: model.py Progetto: FaBrand/python_display

class Jobs(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(255), index=True, unique=True, nullable=False)
    desciption = db.Column(db.Text, nullable=True)
    pretty_name = db.relationship("PrettyJobs",
                                  back_populates="jobs",
                                  uselist=False)
    builds = db.relationship("Builds", back_populates="jobs", uselist=False)

    def __repr__(self):
        return '<Jobs {}, {}>'.format(self.name, self.desciption)

Esempio n. 4

File: model.py Progetto: FaBrand/python_display

class Changes(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    builds = db.relationship("Builds", back_populates="changes", uselist=False)

Esempio n. 5

File: model.py Progetto: FaBrand/python_display

class Monitors(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(255), index=True, unique=True)
    jobs = db.relationship('Jobs', secondary=required_jobs)

Esempio n. 6

File: model.py Progetto: FaBrand/python_display

import enum
from display import db
from random import randint
from datetime import datetime, timedelta
import pytz

required_jobs = db.Table(
    'required_jobs',
    db.Column('monitor_id', db.Integer, db.ForeignKey('monitor.id')),
    db.Column('jobs_id', db.Integer, db.ForeignKey('jobs.id')))


class Jobs(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(255), index=True, unique=True, nullable=False)
    desciption = db.Column(db.Text, nullable=True)
    pretty_name = db.relationship("PrettyJobs",
                                  back_populates="jobs",
                                  uselist=False)
    builds = db.relationship("Builds", back_populates="jobs", uselist=False)

    def __repr__(self):
        return '<Jobs {}, {}>'.format(self.name, self.desciption)


class PrettyJobs(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    pretty_name = db.Column(db.String(255), nullable=False)
    jobs = db.relationship("Jobs", back_populates="pretty_name")
    jobs_id = db.Column(db.Integer, db.ForeignKey('jobs.id'), unique=True)