Intro

starter files walkthrough

connect SQLite database to Flask

deploy app to development environment

preprocess database data

HTML template

Jinja2 templating

database entries as form options

database entries as checkbox elements

Flask Session (global data)

CSS styling

connect JavaScript to Flask

JavaScript client side interactions

testing the app

deploy app to production with Wayscript

challenge!

thanks for watching!

Intro

SQLite

Creating a database connection

Defining our product table

Rewriting the POST route

Rewriting the GET route

Testing everything with Postman

Moving your Data base

SQLite browser

Updating database connection (After moving file)

Recap & what’s next

Intro

Demo

Folder Structure

Configuring Flask

Import flask

Create a connection to the database

Creating table in sqlite

Execute SQL statements

Insert query

Testing the app

Intro

Install Flask

Create a Table

Visualize the database file

Import Flask

Create First Endpoint

Create a Cursor in SQLITE

Displaying the Query Results

Error: Unable to open database

Conclusion

Import the Necessary Modules

Update User

The Flask Routes

Form Submissions

Backend Processing

Data Integrity

Run the Code

Activate Your Virtual Environment

Db Browser

Execute a Connection with the Database

Catch Your Errors

Results

Update

Update Users

Delete

Introduction to Flask-SQLite, python flask tutorials for beginners

Install DB browser SQLite

Import SQLite3

Establish a connection for SQLite3

What is the initial step to write python flask script

How to create home page login page registration form page?

SQLite3.connect('user1.db')

To obtain cursor write c=con.cursor()

To save data write con.commit() and to close

Intro

Creating the database

Creating fixtures

Creating the registration function

Testing everything out

Recap

Creating Our Database

Creating a Database

Initializing Our Database

Initialize the Sql Alchemy Class

Create a Models Dot Py File

Creating of a Database

Import the User

Add a User

Query Our Database

Login Function

Sqlite database browser

Create our sqlite database

Create a new database

Create a new table

Use Sqlite

Connection to the sqlite database

Database Cursor

A cursor object

String Interpolation

Insert into the Database

Intro

Install Flask-SQLAlchemy

Create a database model

Deleting Data

Create a Function to Return a String

Create a Friends Page

Handling GET vs POST requests

Adding Data to a Table

Querying the Database

Updating Data

Intro

Inserting data

Manually inserting a user with a custom date

Adding an object to the database

Updating data in the database

Flask-SQLAlchemy Course

Deleting data from the database

Conclusion

Introduction: What We’re Going to Build

Tools We'll Use: Flask and SQLite Overview

What You'll Learn in This Episode

Organizing the Project Files and Folder Structure

Creating a Virtual Environment

Activating the Virtual Environment on Windows

Installing Flask Using pip

Creating Required Files and Folders

What is Flask? (Beginner Explanation)

What is SQLite and Why It’s Perfect for This App

Creating the SQLite Database File

Visual Overview of the Project Structure

Creating Your First Flask App (Hello World)

Bug Fixing and Running the Flask App

Writing Database Logic in db.py (Connect, Create Table, Check)

Committing Changes and Closing the Database Connection

Recap: Everything We’ve Done So Far

What We'll Build in the Next Episode

Like, Share & Subscribe – Stay Tuned for Episode 2!

Intro

What is SQLAlchemy?

Create submit button

Store data in a session

Flash messages

Configure SQLAlchemy

SQLAlchemy Basics

Unique Identifiers

Adding columns

Create the database

Configure the String for the Sql Database

Run File

Create the Database Tables

Create a New Database Instance

Flask Db Migrate

Mysql

Route Details