This is python built application, is for connecting MySQL database with flask without using SQLAlchemy.

1. Introduction

1.1 How to use this application

2. Application Requirements and Installations

2.1 Python 3.7.4

2.2 flask 1.1.1

2.2.1 Installation

2.2.2. flask-mysqldb

2.2.3. flask-wtf

2.2.4 flask-forms

2.3 .yaml file

2.4 8.0.12 MySQL Community Server - GPL

2.5 Git and GitHub

3. References

This a simple application for learners, those who just started learning python. In this application you may learn about "Routing" which is a decorator related topic in python language, "MySQl Database-CRUD operations" , "HTML Templates", "Jinja2 template Engine and blocks ", "flask" which is a micro framework used to develop a python application and some other modules like flask-wtf, flask-forms and flask-mysqldb. This is the about the tools used to develop this app.

The main purpose of this application is to maintain a Database for the employees working in an organization. This application is for the person who is assign to maintain particulars (i.e Name,Designation,Address and Phone) of each employee. Data can be searched from the Database, inserted, fetch back and can be modified based on the requirement.

To check availability of python in your System(Windows), go to command prompt and type python, if a message pops up saying the below message then python is not available in your system,

'python' is not recognized as an internal or external command, operable program or batch file.

Installing Python-

click on "Python 3.7.4" heading to land on the official website if Python, based on your 'OS' select the options and download it and install it. In the installation setup you will see pip, which will be used to install python packages.

NOTE: Type python in command prompt and python interpreter will open or type python --version, the version installed will be displayed.

This is a micro framework which will sitting upon on your python application.

Installing flask

pip install flask

NOTE: Type flask --version in command prompt and, the version installed will be displayed or, open python interpreter and use help() to see the install package and modules.

2.2.2 flask-mysqldb

Installing flask-mysqldb

pip install flask-mysqldb

This package will be used to establish connection between your MySQL Database and flask

2.2.3 flask-wtf

Installing flask-wtf

pip install flask-wtf

This package will be used for form classes validations in this application development.

2.2.3 flask-forms

Installing flask-forms

pip install flask-forms

This package will be used create form classes in this application development.

Installing 'yaml' or 'Pyyaml'

pip install Pyyaml -> Python 3.6.x and above

[Please refer the Documentation for more information on 'yaml files']

OR

pip install yaml -> Python 2.x.x

For this application, Python 3.7.4 is being used. In this application ".yaml files" is used to config Database URL, User, Password, secret key( for CSRF) and Database Created in the MySQL server 8.0, and stored as file with .yaml extension .

To store data a database is required and with that a bridge can be built to perform CRUD operations. In this application MySQL Databases is used to store incoming employee data.

https://git-scm.com/download/win is the link to install Git on your System(Windows).

This is used to create a repository on a System, in which your project will be saved and modifications on the project can be monitored and can be linked up with GitHub.