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 ：
That's all Flask The basic method of creating database tables , Readers who have questions can leave footprints on private bloggers or comments .
author[Active smiling face],Please bring the original link to reprint, thank you.
The sidebar is recommended
- Spring IOC container loading process
- [thinking] the difference between singleton mode and static method - object-oriented programming
- Hadoop environment setup (MySQL environment configuration)
- 10 minutes, using node JS creates a real-time early warning system for bad weather!
- Git tool
- Force deduction algorithm - 92 Reverse linked list II
- What is the sub problem of dynamic programming?
- C / C + +: static keyword summary
- Idea does not have the artifacts option when configuring Tomcat
- Anaconda can't open it
guess what you like
I don't know how to start this
Matlab simulation of transportation optimization algorithm based on PSO
MySQL slow log optimization
[Vue] as the window is stretched (larger, smaller, wider and higher), the text will not be displayed
Popular Linux distributions for embedded computing
Suzhou computer research
After installing SSL Certificate in Windows + tomcat, the domain name request is not successful. Please answer!!
Implementation time output and greetings of jQuery instance
The 72 year old uncle became popular. Wu Jing and Guo fan made his story into a film, which made countless dreamers blush
How to save computer research
- Springboot implements excel import and export, which is easy to use, and poi can be thrown away
- The final examination subjects of a class are mathematical programming, and the scores are sorted and output from high to low
- Two pronged approach, Tsinghua Professor Pro code JDK and hotspot source code notes, one-time learning to understand
- C + + recursive knapsack problem
- The use of GIT and GitHub and the latest git tutorial are easy to understand -- Video notes of crazy God speaking
- PostgreSQL statement query
- Ignition database test
- Context didn't understand why he got a high salary?, Nginxfair principle
- Bootstrap switch switch control user's guide, springcloud actual combat video
- A list that contains only strings. What other search methods can be used except sequential search
- [matlab path planning] multi ant colony algorithm grid map path planning [including GUI source code 650]
- [matlab path planning] improved genetic algorithm grid map path planning [including source code phase 525]
- Iinternet network path management system
- Appium settings app is not running after 5000ms
- Reactnative foundation - 07 (background image, status bar, statusbar)
- Reactnative foundation - 04 (custom rpx)
- If you want an embedded database (H2, hsql or Derby), please put it on the classpath
- When using stm32g070 Hal library, if you want to write to flash, you must perform an erase. If you don't let it, you can't write continuously.
- Linux checks where the software is installed and what files are installed
- SQL statement fuzzy query and time interval filtering
- 69. Sqrt (x) (c + + problem solving version with vs runnable source program)
- Fresh students are about to graduate. Do you choose Java development or big data?
- Java project: OA management system (java + SSM + bootstrap + MySQL + JSP)
- Titanic passenger survival prediction
- Vectorization of deep learning formula
- Configuration and use of private image warehouse of microservice architect docker
- For someone, delete return 1 and return 0
- How does Java dynamically obtain what type of data is passed? It is used to judge whether the data is the same, dynamic data type
- How does the database cow optimize SQL?
- [data structure] chain structure of binary tree (pre order traversal) (middle order traversal) (post order traversal) (sequence traversal)
- Webpack packaging optimization solution
- 5. Operation element
- Detailed explanation of red and black trees
- redhat7. 9 install database 19C
- Blue Bridge Cup notes: (the given elements are not repeated) complete arrangement (arrangement cannot be repeated, arrangement can be repeated)
- Detailed explanation of springboot default package scanning mechanism and @ componentscan specified scanning path
- How to solve the run-time exception of test times
- Detailed explanation of k8s management tool kubectl
- Android system view memory command