[Python] [Flask] notes 4 Database SQLAlchemy

pip install flask-sqlalchemy

>>> load data into database

from flaskblog import db
db.create_all()
from flaskblog import User, Post
user_1 = User(username='Corey', email='C@demo.com', password='password')
db.session.add(user_1)
user_2 = User(username='Corey2', email='C2@demo.com', password='password')
db.session.add(user_2)
db.session.commit()
User.query.all()
User.query.first()
User.query.filter_by(username='Corey').first()
user = User.query.filter_by(username='Corey').first()
user
user.id
user = User.query.get(1)
user
user.posts
post_1 = Post(title='Blog 1', content = 'First Post Content', user_id=user.id)
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

for post in user.posts:
...     print(post.title)
...

post = Post.query.first()
post
post.user_id
post.author

>>> Clear all the data, and confirm clean

db.drop_all()
db.create_all()
User.query.all()
Post.query.all()

Data Management:

Terminal>

sqlite3
.open site.db  //Open a database
.database //Show which database you are in

DELETE FROM post WHERE id>5;
SELECT * FROM post;

NB: “；” , no need “commit()”

recommandation: SQLiteStudio

end