}) db.session.add(a1) db.session.add(a2) db.session.add(a3) db.session.add(a4) db.session.commit() #---------------------------------# # Add Shows #---------------------------------# from datetime import datetime show1 = Show(start_time=datetime(2020, 5, 21, 21, 30, 0)) show1.artist = a3 show1.venue = v1 show2 = Show(start_time=datetime(2022, 6, 15, 23)) show2.artist = a3 show2.venue = v1 show3 = Show(start_time=datetime(2019, 5, 1, 21, 30)) show3.artist = a1 show3.venue = v2 show4 = Show(start_time=datetime(2021, 10, 1, 21, 30)) show4.artist = a2 show4.venue = v1 show5 = Show(start_time=datetime(2019, 12, 31, 21, 30)) show5.artist = a2
from app import Venue, Artist, Show, db show1 = Show(start_time="2019-05-21T21:30:00.000Z") show1.venue = 1 show1.artist = 1 show2 = Show(start_time="2035-04-01T20:00:00.000Z") show2.venue = 3 show2.artist = 2 show3 = Show(start_time="2035-04-08T20:00:00.000Z") show3.venue = 3 show3.artist = 3 show4 = Show(start_time="2035-04-15T20:00:00.000Z") show4.venue = 3 show4.artist = 3 db.session.add(show1) db.session.add(show2) db.session.add(show3) db.session.add(show4) db.session.commit()