current position:Home>Flash -- create database table

Flash -- create database table

2022-01-27 03:01:14 Active smiling face

Basic instructions for creating database tables :

    #  Clear all data in the database ,  Use caution 
    db.drop_all()

    #  Create all tables 
    db.create_all()

The complete code is as follows :

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)

class Config(object):
    """ Configuration parameters """
    # sqlalchemy Configuration parameters for 
    SQLALCHEMY_DATABASE_URI = "mysql://root:[email protected]:3306/db_python"

    #  Set up sqlalchemy Automatically update tracking database 
    SQLALCHEMY_TRACK_MODIFICATIONS = True

#  Connect to database 
app.config.from_object(Config)

#  Create database aqlalchemy Tool object 
db = SQLAlchemy(app)

#  Create a database model class 
class Role(db.Model):
    """ User roles / Identity table """
    __tablename__ = "tbl_roles"

    id = db.Column(db.Integer, primary_key=True)  #  Integer primary key , It will be set to auto increment primary key by default 
    name = db.Column(db.String(32), unique=True)
    users = db.relationship("User", backref="role")  #  When role.users Invocation time , Indicates that the call is User Model class of ;brakrefk Can be used to push back , When user.role when , Print the upper object 


#  Create a database model class 
class User(db.Model):
    """ User table """
    __tablename__ = "tbl_users"  #  Indicates the table name of the database 

    id = db.Column(db.Integer, primary_key=True)  #  Integer primary key , It will be set to auto increment primary key by default 
    name = db.Column(db.String(64), unique=True)
    email = db.Column(db.String(128), unique=True)
    passward = db.Column(db.String(128))
    role_id = db.Column(db.Integer, db.ForeignKey("tbl_roles.id"))  #  send Role Classes and User Class 

@app.route("/")
def start():
    return "This is the beginning"

if __name__ == '__main__':
    # app.run(host="127.0.0.1", port=8000, debug=True)

    #  Clear all data in the database ,  Use caution 
    db.drop_all()

    #  Create all tables 
    db.create_all()

    #  Create objects 
    role1 = Role(name="admin")
    # session Record object task 
    db.session.add(role1)
    #  Submit the task to the database 
    db.session.commit()

    #  Create objects 
    role2 = Role(name="stuff")
    # session Record object task 
    db.session.add(role2)
    #  Submit the task to the database 
    db.session.commit()

    #  Add data 
    user_1 = User(name="zhangsan", email="[email protected]", passward="123", role_id=role1.id)
    user_2 = User(name="lisi", email="[email protected]", passward="234", role_id=role1.id)
    user_3 = User(name="wangwu", email="[email protected]", passward="345", role_id=role2.id)
    user_4 = User(name="zhaoliu", email="[email protected]", passward="456", role_id=role2.id)

    #  Save multiple pieces of data at one time in the form of a list 
    db.session.add_all([user_1, user_2, user_3, user_4])
    db.session.commit()

To view the created database table, open cmd window , Enter the following command ”

"""  View the created database instructions : net start mysql  start-up MySQL mysql -u root -p  Get into MySQL Enter password: 123456  Input MySQL command  mysql> show databases;  Display database  mysql> use db_python;  Connect to database  mysql> show tables;  Show database tables  mysql> desc tbl_roles;  Show tbl_roles Table parameters  mysql> desc tbl_users;  Show tbl_users Table parameters  mysql> select * from tbl_roles;  Query all tbl_roles That's ok  mysql> select * from tbl_users;  Query all tbl_users That's ok  """

The end result is as follows : Insert picture description here
 Insert picture description here
That's all Flask The basic method of creating database tables , Readers who have questions can leave footprints on private bloggers or comments .

copyright notice
author[Active smiling face],Please bring the original link to reprint, thank you.
https://en.cdmana.com/2022/01/202201270301125273.html

Random recommended