import datetime
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from table_def import Album, Artist
engine = create_engine('sqlite:///mymusic.db', echo=True)
# create a session
Session = sessionmaker(bind=engine)
session = Session()
# create an artist
new_artist = Artist(name="Newsboys")
new_artist.albums = [
Album(title="Read All About It",
release_date=datetime.date(1988, 12, 1),
publisher="Refuge",
media_type="CD")
]
# add more albums
more_albums = [
Album(title="Hell Is for Wimps",
release_date=datetime.date(1990, 7, 31),
publisher="Star Song",
media_type="CD"),
Album(title="Love Liberty Disco",
release_date=datetime.date(1999, 11, 16),
publisher="Sparrow",
media_type="CD"),
Album(title="Thrive",
import datetime
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from table_def import Album, Artist
engine = create_engine('sqlite:///mymusic.db', echo=True)
# create a Session
Session = sessionmaker(bind=engine)
session = Session()
# Create an artist
new_artist = Artist("Newsboys")
new_artist.albums = [
Album("Read All About It", datetime.date(1988, 12, 01), "Refuge", "CD")
]
# add more albums
more_albums = [
Album("Hell Is for Wimps", datetime.date(1990, 07, 31), "Star Song", "CD"),
Album("Love Liberty Disco", datetime.date(1999, 11, 16), "Sparrow", "CD"),
Album("Thrive", datetime.date(2002, 03, 26), "Sparrow", "CD")
]
new_artist.albums.extend(more_albums)
# Add the record to the session object
session.add(new_artist)
# commit the record the database
session.commit()
# Add several artists
'''
import datetime
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from table_def import Album, Artist
engine = create_engine('sqlite:///mymusic.db', echo=True)
#create a Session
#Our handle to the database and let's us interact with it.
Session = sessionmaker(bind=engine)
session = Session()
#Create an artist
new_artist = Artist(name="Bone Thugs and Harmony")
new_artist.albums = [
Album(title="E.1999 Eternal",
release_date=datetime.datetime.now(),
publisher="Ruthless Records",
media_type="CD")
]
#add more albums
more_albums = [
Album(title="The Crossroads",
release_date=datetime.datetime.now(),
publisher="Ruthless Records",
media_type="CD")
]
