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!"