23/03/2024, 06:27 Flask Cheatsheet | CodeWithHarry
My Work With Login
</> CodeWithHarry Home Courses Tutorial Blog Notes Contact
Gear Us Signup
HTML CSS JS C C++ JAVA PYTHON PHP REACT JS
Flask Cheatsheet
Haris Ali Khan · July 1, 2022 · 2 min read
Importing Flask
from flask import Flask
Most used import functions
These are some of the most used import functions by flask developers
from flask import Flask, render_template, redirect, url_for, request
Boilerplate code
https://www.codewithharry.com/blogpost/flask-cheatsheet/ 1/10
23/03/2024, 06:27 Flask Cheatsheet | CodeWithHarry
This is the basic template or barebone structure of a Flask app
from flask import Flask
app = Flask(__name__)
@app.route("/")
def hello_world():
return "<p>Hello, World!</p>"
app.run()
Creating a route
This is to make different endpoints in our flask app.
@app.route("/")
Setting Allowed methods
Used to specify which methods are allowed for a request. Allowing get and post requests on an
endpoint.
methods = ['GET', 'POST']
Re-run while coding
https://www.codewithharry.com/blogpost/flask-cheatsheet/ 2/10
23/03/2024, 06:27 Flask Cheatsheet | CodeWithHarry
This is used to automatically rerun the program when the file is saved.
app.run(debug=True)
Change host
This is used to change the host.
app.run(host='0.0.0.0')
Change port
This is used to change the port.
app.run(port=80)
Importing SQLAlchemy
from flask_sqlalchemy import SQLAlchemy
Database URI
This is the database's address.
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://username:password@localhost/db
https://www.codewithharry.com/blogpost/flask-cheatsheet/ 3/10
23/03/2024, 06:27 Flask Cheatsheet | CodeWithHarry
or
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///test.db'
Initialization
This is used to initialize SQLAlchemy.
db = SQLAlchemy(app)
Creating a Model
Class used to get data from the database and to send data to the database.
class TableName(db.Model):
column_1 = db.Column(db.Integer, primary_key=True)
column_2 = db.Column(db.String(80), nullable=False)
column_3 = db.Column(db.String(12), nullable=False)
Get all data - all() method
This is used to get all the data from the database.
data = ClassName.query.filter_by().all()
Filtered data - first() method
https://www.codewithharry.com/blogpost/flask-cheatsheet/ 4/10
23/03/2024, 06:27 Flask Cheatsheet | CodeWithHarry
This is used to get the first dataset from the list returned by the filter_by function. You can get
targetted data by this.
data = ClassName.query.filter_by().first()
Send/add data to database
This is used to send/add data to the database.
data_to_send = ClassName(column_1=dataset1, column_2=dataset2, column_3=dataset3
db.session.add(data_to_send)
db.session.commit()
Delete data from the database
This is used to delete data from the database.
data_to_send = ClassName(column_1=dataset1, column_2=dataset2, column_3=dataset3
db.session.delete(data_to_send)
db.session.commit()
Request method
This is used to know what request is made (get/post).
request.method
https://www.codewithharry.com/blogpost/flask-cheatsheet/ 5/10
23/03/2024, 06:27 Flask Cheatsheet | CodeWithHarry
Render Template
This is used to pass and render an html file directly.
render_template("file.html")
Solving FSADeprecationWarning
SQLALCHEMY_TRACK_MODIFICATIONS allows you to disable the modification tracking system using
this line:
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
Creating Database files
This is used to create database files
from yourapplicationname import db
db.create_all()
exit()
Method to return database items
This is used to return database items.
def __repr__(self) -> str:
return f"{self.item}"
https://www.codewithharry.com/blogpost/flask-cheatsheet/ 6/10
23/03/2024, 06:27 Flask Cheatsheet | CodeWithHarry
Printing returned content from the method
This is used to print returned database items.
data = ClassNameWithMethod.query.all()
print(data)
Flask Documentation
Visit the Flask documentation here
Flask SQLAlchemy Documentation
Visit the Flask SQLAlchemy documentation here
Download this Cheatsheet
https://www.codewithharry.com/blogpost/flask-cheatsheet/ 7/10
23/03/2024, 06:27 Flask Cheatsheet | CodeWithHarry
Add a new comment
Type Your Comment
Post Comment
Comments (8)
yasharthmishra2000_gm 2023-06-29
Bhai flask alchemy chal nhi raha hai pip install karne ke baad bhi no
such module dikha raha hai kya karu plz help...
VIEW ALL REPLIES
REPLY
sahilchanna14_gm 2023-02-07
bhai cheatsheet acchi hai but numpy aur pandas ki bhi nikaldo naa
REPLY
https://www.codewithharry.com/blogpost/flask-cheatsheet/ 8/10
23/03/2024, 06:27 Flask Cheatsheet | CodeWithHarry
ishantgarg.2020_gm 2022-12-17
Hi.. In your YT video of flask you used heroku for deployment flask app.
But there free version is no more. Can you make another one video
regarding deployment of flask app free. Thanks
VIEW ALL REPLIES
REPLY
forvideoderapp_gm 2022-12-16
nice
REPLY
anuragintensenagar1999 2022-07-19
thanks bhai
REPLY
alihaider00760 2022-07-15
The SuperMan of Programming. Harry bhia Zindaaaabaaaad
VIEW ALL REPLIES
REPLY
https://www.codewithharry.com/blogpost/flask-cheatsheet/ 9/10
23/03/2024, 06:27 Flask Cheatsheet | CodeWithHarry
vt7588976_gm 2022-07-11
This is very helpful for us. Thank you Harry Bhai.
REPLY
himanshukumark74_gm 2022-07-09
Nice sir thanku
REPLY
CodeWithHarry Copyright © 2024 CodeWithHarry.com
https://www.codewithharry.com/blogpost/flask-cheatsheet/ 10/10
