else:
app.debug = False
app.config['SQLALCHEMY_DATABASE_URI'] = ''
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db = SQLAlchemy(app)
# Tables #
# tracks handles many-to-many relationship between Track and Playlist
pl_tracks = db.Table(
'pl_tracks', db.Column('rID', db.Integer),
db.Column('tPosition', db.Integer), db.Column('pName', db.String),
db.Column('uUsername', db.String),
db.ForeignKeyConstraint(['pName', 'uUsername'],
['playlist.pName', 'playlist.uUsername']),
db.ForeignKeyConstraint(['tPosition', 'rID'],
['track.tPosition', 'track.rID']),
db.PrimaryKeyConstraint('tPosition',
'pName',
'uUsername',
'rID',
name='tracks_pk_constraint'))
class Playlist(db.Model):
__tablename__ = 'playlist'
__table_args__ = (db.ForeignKeyConstraint(['uUsername'],
['users.uUsername']),
db.PrimaryKeyConstraint('pName',
'uUsername',
{%- if elem.fk %}, db.ForeignKey('{{elem.fk_target}}'){% endif %}
{%- if elem.pk %}, primary_key=True{% endif %}
{%- if elem.nullable %}, nullable=True{% endif %})
{%- else %}
{{elem.name}} = relationship('{{elem.target_ent.name}}',
{%- if elem.target_ent == entity %} remote_side=[{{entity|pk_attrs|map(attribute='name')|join(", ")}}],{% endif -%}
{% if elem.fk_columns %} foreign_keys=[{{- elem.fk_columns|map(attribute='name')|join(', ')}}]{% endif %}, backref='{{elem.backref}}')
{%- endif %}
{%- endfor %}
{%- if fk_constraints %}
__table_args__ = (
{%- for fkc in fk_constraints %}
db.ForeignKeyConstraint([{{fkc.fk_columns|map(attribute='dbname')|map('quote')|join(", ")}}],
[{{fkc.fk_columns|map(attribute='fk_target')|map('quote')|join(", ")}}],
name='{{fkc.name}}'),
{%- endfor %}
)
{%- endif -%}
{%- if entity|display %}
def __str__(self):
{%- set self_list = entity|display|format_list("self.{}") %}
if {{self_list|join(" and ")}}:
{%- set sp = joiner(' ') %}
return "{% for i in self_list %}{{sp()}}{}{% endfor %}".format({{entity|display|format_list("self.{}")|join(', ')}})
else:
return super({{entity.name}}, self).__str__()
{%- endif %}
t_attorney_case = db.Table(
'attorney_case',
db.Column('attorney', db.ForeignKey(u'person.id'), primary_key=True, nullable=False),
db.Column('case', db.ForeignKey(u'case.id'), primary_key=True, nullable=False, index=True)
)
t_attorney_case_hearing = db.Table(
'attorney_case_hearing',
db.Column('attorney', db.ForeignKey(u'person.id'), primary_key=True, nullable=False),
db.Column('case_hearing_case', db.Integer, primary_key=True, nullable=False),
db.Column('case_hearing_hearingtype', db.Integer, primary_key=True, nullable=False),
db.Column('case_hearing_hearing_date', db.DateTime, primary_key=True, nullable=False),
db.ForeignKeyConstraint(['case_hearing_case', 'case_hearing_hearingtype', 'case_hearing_hearing_date'], [u'case_hearing.case', u'case_hearing.hearingtype', u'case_hearing.hearing_date']),
db.Index('idx_attorney_case_hearing', 'case_hearing_case', 'case_hearing_hearingtype', 'case_hearing_hearing_date')
)
class Bail(db.Model):
__tablename__ = 'bail'
case = db.Column(db.ForeignKey(u'case.id'), primary_key=True, nullable=False)
defendant = db.Column(db.ForeignKey(u'person.id'), primary_key=True, nullable=False, index=True)
amount = db.Column(db.Float(53), nullable=False)
surety_count = db.Column(db.Integer, nullable=False)
paid = db.Column(db.Boolean, nullable=False)
paid_date = db.Column(db.Date, nullable=False)
receipt_number = db.Column(db.Text, nullable=False)
