-
Notifications
You must be signed in to change notification settings - Fork 0
/
models.py
58 lines (48 loc) · 2.29 KB
/
models.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
from app import db
#----------------------------------------------------------------------------#
# Models.
#----------------------------------------------------------------------------#
class Venue(db.Model):
__tablename__ = 'Venue'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String)
city = db.Column(db.String(120))
state = db.Column(db.String(120))
address = db.Column(db.String(120))
phone = db.Column(db.String(120))
image_link = db.Column(db.String(500))
genres = db.Column(db.ARRAY(db.String()))
facebook_link = db.Column(db.String(120))
seeking_talent = db.Column(db.Boolean,default=False)
seeking_description = db.Column(db.String(700))
website = db.Column(db.String(120))
shows = db.relationship('Show', backref="venue", passive_deletes='all')
def __repr__(self):
return '<Venue {}, {} , {}>'.format(self.name,self.city,self.state)
# TODO: implement any missing fields, as a database migration using Flask-Migrate
class Artist(db.Model):
__tablename__ = 'Artist'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String)
city = db.Column(db.String(120))
state = db.Column(db.String(120))
phone = db.Column(db.String(120))
genres = db.Column(db.ARRAY(db.String()))
image_link = db.Column(db.String(500))
facebook_link = db.Column(db.String(120))
seeking_venue = db.Column(db.Boolean, default=False)
seeking_description = db.Column(db.String(700))
website = db.Column(db.String(120))
shows = db.relationship('Show', backref="artist", passive_deletes='all')
def __repr__(self):
return '<Artist {}, {}>'.format(self.name,self.city)
# TODO: implement any missing fields, as a database migration using Flask-Migrate
# TODO Implement Show and Artist models, and complete all model relationships and properties, as a database migration.
class Show(db.Model):
__tablename__='Show'
id = db.Column(db.Integer,primary_key=True)
artist_id = db.Column(db.Integer,db.ForeignKey('Artist.id',ondelete='CASCADE'),nullable=False)
venue_id = db.Column(db.Integer,db.ForeignKey('Venue.id',ondelete='CASCADE'),nullable=False)
start_time = db.Column(db.DateTime,nullable=False)
def __repr__(self):
return '<Show {}{}>'.format(self.artist_id, self.venue_id)