# Setup up the database from BasicModelApp import db, Puppy # Import db object and Puppy class db.create_all() # Create the tables in the database sam = Puppy('Sammy', 3) # Create new entries in the database frank = Puppy('Frankie', 4) print(sam.id) # Check ids (Not added to the database so should be None) print(frank.id) db.session.add_all([ sam, frank ]) # Ids will get created automatically once we add these entries to the DB # db.session.add(sam) # Alternative for individual additions # db.session.add(frank) db.session.commit() # Now save it to the database print(sam.id) # Check the ids print(frank.id)
# Now that the table has been created by running # BasicModelApp and SetUpDatabase we can play around with CRUD commands # This is just an overview, usually we won't run a single script like this # Our goal here is to just familiarize ourselves with CRUD commands from BasicModelApp import db,Puppy ########################### ###### CREATE ############ ######################### my_puppy = Puppy('Rufus',5) db.session.add(my_puppy) db.session.commit() ########################### ###### READ ############## ######################### # Note lots of ORM filter options here. # filter(), filter_by(), limit(), order_by(), group_by() # Also lots of executor options # all(), first(), get(), count(), paginate() all_puppies = Puppy.query.all() # list of all puppies in table print(all_puppies) print('\n') # Grab by id puppy_one = Puppy.query.get(1) print(puppy_one) print(puppy_one.age) print('\n') # Filters
############################################################################# ### NOTE!! If you run this script multiple times you will add ############## ### multiple puppies to the database. That is okay, just the ############## ### ids will be higher than 1, 2 on the subsequent runs ################## ######################################################################### # Import database info from BasicModelApp import db, Puppy # Create the tables in the database # (Usually won't do it this way!) # this should not be in script but in command line db.create_all() # Create new entries in the database sam = Puppy('Sammy', 3) frank = Puppy('Frankie', 4) # Check ids (haven't added sam and frank to database, so they should be None) print(sam.id) print(frank.id) # Ids will get created automatically once we add these entries to the DB db.session.add_all([sam, frank]) # Alternative for individual additions: # db.session.add(sam) # db.session.add(frank) # Now save it to the database db.session.commit()