def getGenreByName(name):
name = name.lower()
try:
genre = session.query(Genre).filter_by(name=name).one()
except:
genre = Genre(name=name)
session.add(genre)
session.commit()
return genre
def newGenre():
"""
newGenre(): creates a Genre
Args:
None
Returns:
redirects to the method that shows the
list of genres
"""
if 'username' not in login_session:
return redirect('/login')
if request.method == 'POST':
newGenre = Genre(name=request.form['name'],
description=request.form['description'],
user_id=login_session['user_id'])
session.add(newGenre)
session.commit()
flash('Genre was successfully added to the catalog')
return redirect(url_for('showGenres'))
else:
return render_template('newGenre.html')
from sqlalchemy.orm import sessionmaker
from db_setup import Base, Genre, Movies, User
# Create database and create a shortcut for easier to update database
engine = create_engine('sqlite:///movies_catalogs.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
# Create dummy user
User1 = User(name="im Robot", email="*****@*****.**")
session.add(User1)
session.commit()
# Create category of Action Films
category1 = Genre(user_id=1, name="Action Films")
session.add(category1)
session.commit()
# Create category of Adventure Films
category2 = Genre(user_id=1, name="Adventure Films")
session.add(category2)
session.commit()
# Create category of Comedy Films
category3 = Genre(user_id=1, name="Comedy Films")
session.add(category3)
session.commit()
# Create category of Crime & Gangster Films
category4 = Genre(user_id=1, name="Crime & Gangster Films")
session = DBSession()
# the first user
User1 = User(
name="Assiya Kh",
email="*****@*****.**",
picture=
'https://upload.wikimedia.org/wikipedia/commons/thumb/1/12/User_icon_2.svg/220px-User_icon_2.svg.png'
)
session.add(User1)
session.commit()
# Poetry Books
genre1 = Genre(
user_id=1,
name="Poetry",
description=
"Poetry is an art form in which human language is used for its aesthetic qualities in addition to, or instead of, its notional and semantic content."
)
session.add(genre1)
session.commit()
book = BookItem(
user_id=1,
name="Where the Sidewalk Ends",
description=
"Children\'s poetry collection written and illustrated by Shel Silverstein. Published by Harper and Row Publishers.",
type="eBook",
price="$2.50",
author="Shel Silverstein",
genre=genre1)
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from db_setup import User, Genre, Base, BookItem
engine = create_engine('sqlite:///new_book_catalog.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
# the first user
User1 = User(
name="Assiya Kh",
email="*****@*****.**",
picture=
'https://upload.wikimedia.org/wikipedia/commons/thumb/1/12/User_icon_2.svg/220px-User_icon_2.svg.png'
)
session.add(User1)
session.commit()
# Poetry Books
genre1 = Genre(user_id=1, name="food", description="sea food")
session.add(genre1)
session.commit()
print "DB is populated"
session = DBSession()
# the first user
User1 = User(
name="Kiran Ch",
email="*****@*****.**",
picture=
'https://upload.wikimedia.org/wikipedia/commons/thumb/1/12/User_icon_2.svg/220px-User_icon_2.svg.png'
)
session.add(User1)
session.commit()
# Poetry Books
genre1 = Genre(
user_id=1,
name="Poetry",
description=
"Poetry is an art form in which human language is used for its aesthetic qualities in addition to, or instead of, its notional and semantic content."
)
session.add(genre1)
session.commit()
book = BookItem(
user_id=1,
name="Where the Sidewalk Ends",
description=
"Children\'s poetry collection written and illustrated by Shel Silverstein. Published by Harper and Row Publishers.",
type="eBook",
price="$2.50",
author="Shel Silverstein",
genre=genre1)
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from db_setup import Base, User, Genre, Songs
"""
Used to populate, the genre table.
"""
engine = create_engine('sqlite:///MusicDatabase.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
genres = ['Folk', 'Patriotic', 'Ghazal', 'Classical', 'Western', 'Filmi']
for name in genres:
genreList = session.query(Genre).filter_by(name = name).one_or_none()
if not genreList:
genre = Genre(name = name)
session.add(genre)
session.commit()
print name + " Added to Database!"
else:
print name + " Already in Database!"
session = DBSession()
# the first user
User1 = User(
name="Kiran Ch",
email="*****@*****.**",
picture=
'https://upload.wikimedia.org/wikipedia/commons/thumb/1/12/User_icon_2.svg/220px-User_icon_2.svg.png'
)
session.add(User1)
session.commit()
# Poetry Books
genre1 = Genre(
user_id=1,
name="Poetry",
description=
"Poetry is an art form in which human language is used for its aesthetic qualities in addition to, or instead of, its notional and semantic content."
)
session.add(genre1)
session.commit()
book = BookItem(
user_id=1,
name="Where the Sidewalk Ends",
description=
"Children\'s poetry collection written and illustrated by Shel Silverstein. Published by Harper and Row Publishers.",
type="eBook",
price="$2.50",
author="Shel Silverstein",
genre=genre1)