Return render_template('index.html', rows=rows) Now I am going to create a main.py file that will have the required function defined for fetching data from MySQL database.Ĭursor = conn.cursor() Mysql.init_app(app) Fetch Data from MySQL from app import appĪpp.config = 'root'Īpp.config = 'roytuts'Īpp.config = 'localhost' Make sure to change the database configuration values according to your database setup. I have created the below db.py Python script to setup the MySQL database configuration for connecting to database and fetching user information from user table under roytuts database.Īs I need to configure database connection with flask module and that’s why I have imported app module and setup the MySQL configuration with flask module. In the above code I have imported the required module for flask instantiation.
The following configuration is written into a file app.py: from flask import Flask insert into user values(1, 'Soumitra', '43256789', 'Earth') Configure Flask I am inserting a row in the table so that I can test the application right away. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci Phone VARCHAR(15) COLLATE utf8mb4_unicode_ci NOT NULL,Īddress VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL, Name VARCHAR(50) COLLATE utf8mb4_unicode_ci NOT NULL,Įmail VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL, Id INT unsigned COLLATE utf8mb4_unicode_ci AUTO_INCREMENT PRIMARY KEY, The following user table under roytuts database will be used for this tutorial’s example. I may not mention the project’s root directory name in the subsequent sections, but I will assume that I am creating files with respect to the project’s root directory. Project DirectoryĬreate a project root directory called flask-reload-changes-without-server-restart as per your chosen location. To install any Python based module, use command pip install, for example, pip install Flask-Caching.
0 kommentar(er)
