>>> db.create_all()
>>> from app import User, Post
>>> user_1 = User(username='genzorg', email='[email protected]', password='password')
>>> db.session.add(user_1) # This will not add the user until the session is commited
>>> user_2 = User(username='JohnDoe', email='[email protected]', password='password')
>>> db.session.add(user_2)
>>> db.session.commit()
>>> User.query.all() # Get all users
[User('genzorg', '[email protected]', 'default.jpg'), User('JohnDoe', '[email protected]', 'default.jpg')]
>>> User.query.first() # Get first user
User('genzorg', '[email protected]', 'default.jpg')
>>> User.query.filter_by(username='genzorg').all() # Get all users with username genzorg
[User('genzorg', '[email protected]', 'default.jpg')]
>>> User.query.filter_by(username='genzorg').first() Get first users with username genzorg
User('genzorg', '[email protected]', 'default.jpg')
>>> user = User.query.get(1) # Query by id
>>> user.posts # The user currently has no posts
[]
>>> post_1 = Post(title='Blog 1', content='First post content!', user_id=user.id)
>>> post_1
Post('Blog 1', 'None')
>>> post_1.date_posted # This will be created when the Post is commited
>>> post_2 = Post(title='Blog 2', content='Second post content!', user_id=user.id)
>>> db.session.add(post_1)
>>> db.session.add(post_2)
>>> db.session.commit()
>>> user.posts # Now the user has two posts
[Post('Blog 1', '2018-10-26 20:53:43.989531'), Post('Blog 2', '2018-10-26 20:53:43.990123')]
>>> post = Post.query.first() # Get the first post
>>> post.user_id # Get the user_id of the User that made the post.
1
>>> post.author # This uses the backref configured in the Model to retrive the related user I.E the user that made this post.
User('genzorg', '[email protected]', 'default.jpg')
>>> 

>>> db.drop_all() # Delete everything in the DB
>>> db.create_all() # Recreate the DB structure.
>>> User.query.all() # The data is no longer availible
[]
>>> Post.query.all() # The data is no longer availible
[]