flask_sqlite_examples's Introduction

Flask_SQLite_Examples

Installation

Go to C:\Python37\Scripts\ (make sure that virtualenv is available or not, if it is not availble you have install the virtualenv using command => pip install virtualenv)
Go to D:\myfolder (Create new empty folder as myfolder in D drive then move into the myfolder )
cd myfolder (move inside the folder)
D:\myfolder\ virtualenv venv (install the supporting packages..)
D:\myfolder\ cd venv (move inside the venv folder)
D:\myfolder\ venv\ mkdir myapp (create new folder as myapp )
D:\myfolder\ venv\ cd myapp ( move inside the folder)
D:\myfolder\venv \myapp\ touch app.py (create python app file)
D:\myfolder\venv \myapp \cd.. (go back)
D:\myfolder\ venv\ cd Scripts (go into scripts)
D:\myfolder\ venv\ Scripts\ activate
D:\myfolder\ venv\ Scripts\ cd.. (go back)
D:\myfolder\ venv\ pip install flask
D:\myfolder\ venv\ cd myapp (move into the myapp folder)
D:\myfolder\ venv\ myapp\ python app.py (run the app)
Check in your browser: http://127.0.0.1:5000/
To Change IP Address: python -m flask run --host=172.16.3.64

Download Precompiled Binaries for Windows => https://www.sqlite.org/download.html
After downloading the zip and extact in a new folder and place in C drive
Add path in sytem env varibales
check: cmd=> sqlite3 (ctrl+c)
Create Database: sqlite3 test.db
Create Table: CREATE TABLE Employee(ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT NOT NULL, AGE INT NOT NULL, ADDRESS TEXT NOT NULL, SALARY REAL);
INSERT INTO Employee (NAME,AGE,ADDRESS,SALARY) VALUES ('Guhan', 32, 'India', 20000.00);
SELECT * FROM Employee;

Recommend Projects