class Commit(db.Model):
"""
Table containing Git Commits.
Subclasses ``wptdash.app.db.Model``
"""
__tablename__ = 'commit'
sha = db.Column(db.String, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('github_user.id'))
user = db.relationship('GitHubUser', back_populates='commits')
class Product(db.Model):
"""
Table containing stability product targets (e.g. browsers/versions).
Subclasses ``wptdash.app.db.Model``
"""
__tablename__ = 'product'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255), nullable=False)
jobs = db.relationship('Job', back_populates='product')
class Build(db.Model):
"""
Table containing CI builds.
Subclasses ``wptdash.app.db.Model``
"""
__tablename__ = 'build'
id = db.Column(db.Integer, primary_key=True)
number = db.Column(db.Integer, nullable=False)
pull_request_id = db.Column(db.Integer, db.ForeignKey('pull_request.id'))
head_sha = db.Column(db.String, db.ForeignKey('commit.sha'))
base_sha = db.Column(db.String, db.ForeignKey('commit.sha'))
status = db.Column(db.Enum(BuildStatus), nullable=False)
started_at = db.Column(db.TIMESTAMP())
finished_at = db.Column(db.TIMESTAMP())
jobs = db.relationship('Job', back_populates='build')
pull_request = db.relationship('PullRequest', back_populates='builds')
head_commit = db.relationship('Commit',
foreign_keys=[head_sha],
backref='builds_as_head')
base_commit = db.relationship('Commit',
foreign_keys=[base_sha],
backref='builds_as_base')
class Repository(db.Model):
"""
Table containing references to repository sources of pull requests.
Subclasses ``wptdash.app.db.Model``
"""
__tablename__ = 'repository'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String, nullable=False)
owner_id = db.Column(db.Integer,
db.ForeignKey('github_user.id'),
nullable=False)
owner = db.relationship('GitHubUser', back_populates='repositories')
class Test(db.Model):
"""
Table containing stability tests and their sub/parent tests.
Makes use of the `Adjacency List Pattern <http://docs.sqlalchemy.org/en/latest/orm/self_referential.html>`_.
Subclasses ``wptdash.app.db.Model``
"""
__tablename__ = 'test'
id = db.Column(db.Text, primary_key=True)
parent_id = db.Column(db.Text, db.ForeignKey('test.id'))
subtests = db.relationship('Test',
backref=db.backref('parent', remote_side=[id]))
jobs = db.relationship('JobResult', back_populates='test')
class StabilityStatus(db.Model):
"""
Table containing stability statuses for tests in jobs
Subclasses ``wptdash.app.db.Model``
"""
__tablename__ = 'stability_status'
id = db.Column(db.Integer, primary_key=True)
job_id = db.Column(db.Integer, nullable=False)
test_id = db.Column(db.Text, nullable=False)
status = db.Column(db.Enum(TestStatus), nullable=False)
count = db.Column(db.Integer, nullable=False)
db.ForeignKeyConstraint(['job_id', 'test_id'],
['job_result.job_id', 'job_result.test_id'])
class GitHubUser(db.Model):
"""
Table containing GitHub Users.
Subclasses ``wptdash.app.db.Model``
"""
__tablename__ = 'github_user'
id = db.Column(db.Integer, primary_key=True)
login = db.Column(db.String, nullable=False)
prs_watching = db.relationship('PullRequest',
secondary=USER_PR,
back_populates='watchers')
repositories = db.relationship('Repository', back_populates='owner')
commits = db.relationship('Commit', back_populates='user')
class TestMirror(db.Model):
"""
Table containing pull request mirror URLs.
Separate 1-to-1 relationship table to present a discrete resource
for API endpoints.
Subclasses ``wptdash.app.db.Model``
"""
__tablename__ = "test_mirror"
pull_id = db.Column(db.Integer,
db.ForeignKey('pull_request.id'),
primary_key=True,
autoincrement=False)
url = db.Column(db.String, nullable=True)
pull_request = db.relationship(PullRequest,
back_populates='mirror',
uselist=False)
class JobResult(db.Model):
"""
Association Table joining ``Job`` and ``Test``.
See `SQLAlchemy Docs <http://docs.sqlalchemy.org/en/latest/orm/basic_relationships.html#association-object>` for more on this pattern.
Subclasses ``wptdash.app.db.Model``
"""
__tablename__ = 'job_result'
job_id = db.Column(db.Integer, db.ForeignKey('job.id'), primary_key=True)
test_id = db.Column(db.Text, db.ForeignKey('test.id'), primary_key=True)
iterations = db.Column(db.Integer, nullable=False)
messages = db.Column(db.Text)
consistent = db.Column(db.Boolean, nullable=False)
job = db.relationship('Job', back_populates='tests')
test = db.relationship('Test', back_populates='jobs')
statuses = db.relationship(
'StabilityStatus',
primaryjoin=
"and_(foreign(JobResult.job_id)==remote(StabilityStatus.job_id), foreign(JobResult.test_id)==remote(StabilityStatus.test_id))",
uselist=True)
class Job(db.Model):
"""
Table containing Travis build jobs.
Subclasses ``wptdash.app.db.Model``
"""
__tablename__ = 'job'
id = db.Column(db.Integer, primary_key=True)
number = db.Column(db.String)
build_id = db.Column(db.Integer, db.ForeignKey('build.id'), nullable=False)
product_id = db.Column(db.Integer,
db.ForeignKey('product.id'),
nullable=False)
state = db.Column(db.Enum(JobStatus))
message = db.Column(db.Text)
allow_failure = db.Column(db.Boolean, nullable=False)
started_at = db.Column(db.TIMESTAMP())
finished_at = db.Column(db.TIMESTAMP())
build = db.relationship('Build', back_populates='jobs')
product = db.relationship('Product', back_populates='jobs')
tests = db.relationship('JobResult', back_populates='job')
class PullRequest(db.Model):
"""
Table containing GitHub Pull Requests.
Subclasses ``wptdash.app.db.Model``
"""
__tablename__ = 'pull_request'
id = db.Column(db.Integer, primary_key=True)
number = db.Column(db.Integer, nullable=False)
title = db.Column(db.String, nullable=False)
state = db.Column(db.Enum(PRStatus), nullable=False)
head_sha = db.Column(db.String,
db.ForeignKey('commit.sha'),
nullable=False)
base_sha = db.Column(db.String,
db.ForeignKey('commit.sha'),
nullable=False)
head_repo_id = db.Column(db.Integer,
db.ForeignKey('repository.id'),
nullable=False)
base_repo_id = db.Column(db.Integer,
db.ForeignKey('repository.id'),
nullable=False)
head_branch = db.Column(db.String, nullable=False)
base_branch = db.Column(db.String, nullable=False)
created_by = db.Column(db.Integer, db.ForeignKey('github_user.id'))
created_at = db.Column(db.TIMESTAMP(), nullable=False)
merged = db.Column(db.Boolean, nullable=False)
merged_by = db.Column(db.Integer, db.ForeignKey('github_user.id'))
merged_at = db.Column(db.TIMESTAMP())
updated_at = db.Column(db.TIMESTAMP(), nullable=False)
closed_at = db.Column(db.TIMESTAMP())
comment_url = db.Column(db.String)
builds = db.relationship('Build', back_populates='pull_request')
creator = db.relationship('GitHubUser',
foreign_keys=[created_by],
backref='pulls')
merger = db.relationship('GitHubUser',
foreign_keys=[merged_by],
backref='merges')
head_commit = db.relationship('Commit',
foreign_keys=[head_sha],
backref='pull_requests')
base_commit = db.relationship('Commit', foreign_keys=[base_sha])
head_repository = db.relationship('Repository',
foreign_keys=[head_repo_id],
backref='pull_requests')
base_repository = db.relationship('Repository',
foreign_keys=[base_repo_id])
mirror = db.relationship('TestMirror',
back_populates='pull_request',
uselist=False,
cascade='all, delete-orphan')
watchers = db.relationship('GitHubUser',
secondary=USER_PR,
back_populates='prs_watching')
Convert input string to enum value.
Arguments:
status -- The string representing a status
Returns enum value corresponding to status string
"""
return getattr(cls, status.upper())
# Many to Many Table joining ``GitHubUser`` and ``PullRequest``
# SQLAlchemy auto-deletes from this table. See:
# http://docs.sqlalchemy.org/en/latest/orm/basic_relationships.html#deleting-rows-from-the-many-to-many-table
USER_PR = db.Table(
'user_pr', db.metadata,
db.Column('user_id', db.Integer, db.ForeignKey('github_user.id')),
db.Column('pull_id', db.Integer, db.ForeignKey('pull_request.id')))
class Build(db.Model):
"""
Table containing CI builds.
Subclasses ``wptdash.app.db.Model``
"""
__tablename__ = 'build'
id = db.Column(db.Integer, primary_key=True)
number = db.Column(db.Integer, nullable=False)
pull_request_id = db.Column(db.Integer, db.ForeignKey('pull_request.id'))
