summaryrefslogtreecommitdiff
path: root/f1elo/model.py
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2016-11-30 14:26:35 +0100
committeremkael <emkael@tlen.pl>2016-11-30 14:26:35 +0100
commit1b8f84941c3ca28fc6590ccc907228b8afded8c6 (patch)
tree4758f87c29ba6076a7f2f3831e7dffa46d8aa48d /f1elo/model.py
parentcd1810a441230188b58d834e68cd15975a58cdb4 (diff)
* coding standards and formatting
Diffstat (limited to 'f1elo/model.py')
-rw-r--r--f1elo/model.py57
1 files changed, 36 insertions, 21 deletions
diff --git a/f1elo/model.py b/f1elo/model.py
index c450353..b42cc08 100644
--- a/f1elo/model.py
+++ b/f1elo/model.py
@@ -1,13 +1,14 @@
+import sys
+from functools import total_ordering
+
from sqlalchemy import Column, ForeignKey, Table
from sqlalchemy.ext.declarative import declarative_base
-from sqlalchemy.orm import backref, relationship, sessionmaker
+from sqlalchemy.orm import relationship
from sqlalchemy.types import Boolean, Date, Float, Integer, String
-from functools import total_ordering
-import sys
-
Base = declarative_base()
+
class Country(Base):
__tablename__ = 'countries'
@@ -29,6 +30,7 @@ class Country(Base):
session.add(country)
return country
+
class Driver(Base):
__tablename__ = 'drivers'
@@ -74,21 +76,22 @@ class Driver(Base):
session.add(driver)
return driver
+
driver_entry = Table('driver_entries', Base.metadata,
Column(
- '_driver',
- Integer,
- ForeignKey(
- 'drivers.id',
- onupdate="CASCADE",
- ondelete="CASCADE")),
+ '_driver',
+ Integer,
+ ForeignKey(
+ 'drivers.id',
+ onupdate="CASCADE",
+ ondelete="CASCADE")),
Column(
- '_entry',
- Integer,
- ForeignKey(
- 'entries.id',
- onupdate="CASCADE",
- ondelete="CASCADE")),
+ '_entry',
+ Integer,
+ ForeignKey(
+ 'entries.id',
+ onupdate="CASCADE",
+ ondelete="CASCADE")),
Column('id', Integer, primary_key=True))
@@ -119,7 +122,12 @@ class Entry(Base):
passive_deletes=True)
def __repr__(self):
- return ('#%s (%s) %s[%d]' % (self.car_no, ', '.join([driver.__repr__().decode('utf8') for driver in self.drivers]), self.result, self.result_group)).encode('utf8')
+ return ('#%s (%s) %s[%d]' % (
+ self.car_no,
+ ', '.join([driver.__repr__().decode('utf8')
+ for driver in self.drivers]),
+ self.result,
+ self.result_group)).encode('utf8')
def __eq__(self, other):
return self.id == other.id
@@ -141,13 +149,17 @@ class Entry(Base):
else:
return self_result < other_result
+
class Race(Base):
__tablename__ = 'races'
id = Column(Integer, primary_key=True)
race = Column(String(1024))
date = Column(Date, index=True)
- ranked = Column(Boolean, nullable=False, server_default='0', default=False, index=True)
+ ranked = Column(Boolean,
+ nullable=False,
+ server_default='0', default=False,
+ index=True)
_type = Column(
Integer,
@@ -204,9 +216,12 @@ class Ranking(Base):
driver = relationship(
'Driver',
back_populates='rankings',
- order_by=rank_date)
+ order_by=rank_date)
def __repr__(self):
- return ("%s: %0.2f (%s)" % (self.driver.__repr__().decode('utf8'), self.ranking, self. rank_date)).encode('utf8')
+ return ("%s: %0.2f (%s)" % (
+ self.driver.__repr__().decode('utf8'),
+ self.ranking, self. rank_date)).encode('utf8')
+
-__all__ = ['Country', 'Driver', 'Entry', 'Ranking', 'Race', 'RaceType']
+__all__ = ('Country', 'Driver', 'Entry', 'Ranking', 'Race', 'RaceType')