class ElectionCandidatePollingStationVote(db.Model):
id = db.Column(db.Integer, primary_key=True)
election_candidate_id = db.Column(db.Integer,
db.ForeignKey('election_candidate.id'))
polling_station_id = db.Column(db.Integer,
db.ForeignKey('polling_station.id'))
votes = db.Column(db.Integer)
polling_station = db.relationship('PollingStation',
backref=db.backref(
"ecpollingstationvotes",
cascade="all,delete-orphan"),
lazy='joined')
election_candidate = db.relationship('ElectionCandidate',
backref=db.backref(
"ecpollingstationvotes",
cascade="all,delete-orphan",
lazy='joined'))
def __repr__(self):
pass
def __json__(self):
return [self.polling_station_id, self.electioncandidate, self.votes]
class PollingStationRegister(db.Model):
id = db.Column(db.Integer, primary_key=True)
election_id = db.Column(db.Integer, db.ForeignKey('election.id'))
polling_station_id = db.Column(db.Integer,
db.ForeignKey('polling_station.id'))
number_of_registered_voters = db.Column(db.Integer)
polling_station = db.relationship('PollingStation',
backref=db.backref("elections_register"))
election = db.relationship('Election',
backref=db.backref('polling_stations_register',
lazy='joined'))
class ConstituencyRegister(db.Model):
id = db.Column(db.Integer, primary_key=True)
election_id = db.Column(db.Integer, db.ForeignKey('election.id'))
constituency_id = db.Column(db.Integer, db.ForeignKey('constituency.id'))
number_of_registered_voters = db.Column(db.Integer)
constituency = db.relationship('Constituency',
backref=db.backref('election_registers',
lazy='joined'))
election = db.relationship('Election',
backref=db.backref('constituencies_register',
lazy='joined'))
class ElectionType(db.Model):
id = db.Column(db.Integer, primary_key=True)
type = db.Column(db.String(20), unique=True)
elections = db.relationship('Election',
backref=db.backref('electiontype',
lazy="joined"),
lazy='dynamic')
def __repr__(self):
return " <ElectionType> %r" % self.type
class Incident(db.Model):
id = db.Column(db.Integer, primary_key=True)
description = db.Column(db.String(240))
election_polling_station_id = db.Column(
db.Integer, db.ForeignKey('election_polling_station.id'))
election_constituency_id = db.Column(
db.Integer, db.ForeignKey('election_constituency.id'))
status_type_id = db.Column(db.Integer, db.ForeignKey('incident_status.id'))
election_polling_station = db.relationship('ElectionPollingStation',
backref=db.backref(
'incidents', lazy="joined"))
election_constituency = db.relationship('ElectionConstituency',
backref=db.backref('incidents', ))
status = db.relationship('IncidentStatus', backref="incidents")
def __repr__(self):
return "<Incident> %r constituency: %r status: %r, " % (
self.description, self.election_constituency, self.status)
class ElectionCandidateConstituencyVote(db.Model):
id = db.Column(db.Integer, primary_key=True)
election_candidate_id = db.Column(db.Integer,
db.ForeignKey('election_candidate.id'))
constituency_id = db.Column(db.Integer, db.ForeignKey('constituency.id'))
votes = db.Column(db.Integer)
constituency = db.relationship('Constituency',
backref=db.backref(
"ecconstituencyvotes",
cascade="all,delete-orphan"))
election_candidate = db.relationship('ElectionCandidate',
backref=db.backref(
"ecconstituencyvotes",
cascade="all,delete-orphan"))
def __repr__(self):
return "Election: %r ,Candidate %r , Constituency %r votes %r" % (
self.election_candidate.election,
self.election_candidate.candidate, self.constituency, self.votes)
def __json__(self):
return [self.constituency, self.electioncandidate, self.votes]