#flask #10 Flask_sqlalchemy Part-b

Flask_sqlalchemy is a popular extension for Flask that adds support for SQLAlchemy, a powerful SQL toolkit and Object-Relational Mapping (ORM) library. In this article, we will be discussing the usage of flask_sqlalchemy in creating and managing database tables.

#db.create_all() | yangi jadvalni joylashtirish.

One of the common tasks when working with Flask and SQLAlchemy is creating database tables. To create a new table in the database using Flask_sqlalchemy, you can use the following code snippet:

        
            from flask_sqlalchemy import SQLAlchemy
            from flask import Flask

            app = Flask(__name__)
            app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///database.db'
            db = SQLAlchemy(app)

            # Define a model for the new table
            class User(db.Model):
                id = db.Column(db.Integer, primary_key=True)
                username = db.Column(db.String(50), unique=True, nullable=False)
                email = db.Column(db.String(120), unique=True, nullable=False)
            
            # Create the new table
            db.create_all()
        
    

In this code snippet, we first import the necessary modules and create a Flask app object. We then define a model class for the new table ‘User’ with columns for id, username, and email. Finally, we call the db.create_all() method to create the new table in the database.

@basomiddin

If you have any questions or need further assistance with using Flask_sqlalchemy to create and manage database tables, feel free to reach out to @basomiddin for help and guidance.