Introduction Welcome to the world of Flask, a lightweight yet powerful web framework for Python enthusiasts. In today's post, we're diving into Flask-SQLAlchemy, an extension that makes it easier and more efficient to interact with databases using SQLAlchemy, the popular ORM (Object-Relational Mapping) tool for Python. Setting up the Stage Installation: First things first, let's set up our environment. Assuming you have Flask installed, you need to install Flask-SQLAlchemy: pip install Flask - SQLAlchemy Why Virtual Environments? It's always a good idea to work in a virtual environment to keep your project dependencies organized and isolated. SQLAlchemy Basics ORM in a Nutshell: SQLAlchemy as an ORM allows us to interact with our database using Python classes and objects, rather than writing SQL queries directly. The Benefits: This approach not only makes the code more readable but also simplifies database operations and maintenance. Configuring Flask-SQLAlchemy Ki...
In this tutorial, we are going to use flask login library for our app user authentication. So let's get started, How to use this. First, create a project folder and in this folder make a virtual environment for our project. Here I am using pipenv for virtual environment. Now install required python packages for our project. flask pip install Flask flask-login pip install Flask-Login flask-SQLalchemy pip install Flask-SQLAlchemy Now create a file models.py for database model. from flask_sqlalchemy import SQLAlchemy from werkzeug.security import generate_password_hash, check_password_hash from flask_login import UserMixin db = SQLAlchemy() class UserModel (UserMixin, db . Model): __tablename__ = 'users' id = db . Column(db . Integer, primary_key = True ) email = db . Column(db . String( 80 ), unique = True ) username = db . Column(db . String( 100 )) password_hash = db . Column(db . String()) def set_password ( self ,pas...