A framework is a code library that makes a developer’s life easier when building web applications by providing reusable code for common operations. There are a number of frameworks for Python, including Flask, Tornado, Pyramid, and Django. Flask is a lightweight web application framework. It is classified as a micro-framework because it does not require particular tools or libraries. Side tabs are used for single page web applications or to display different contents.
Knowledge of Python, MySQL Workbench and basics of Flask Framework. Python and MySQL Workbench should be installed in the system. Visual studio code or Spyder or any code editor to work on the application. Technologies used in the project: Flask framework, MySQL Workbench.
Step-1: Install MySQL workbench.
Link to install : https://dev.mysql.com/downloads/workbench/
Know more about it : https://www.mysql.com/products/workbench/
Step-2: Install ‘mysqlbd’ module in your venv.
Step-3: Open MySQL workbench.
Step-4: Write the following code. The above SQL statement will create our database geekprofile with the table accounts.
Step-5: Execute below queries one by one.
create database geekprofile;
SELECT * FROM accounts;
create table if not exists accounts(
id int(11) not null auto_increment,
username varchar(50) not null,
password varchar(255) not null,
email varchar(100) not null,
organisation varchar(100) not null,
address varchar(100) not null,
city varchar(100) not null,
state varchar(100) not null,
country varchar(100) not null,
postalcode varchar(100) not null,
primary key (id)
) engine=InnoDB auto_increment=1 default char set=utf8;