Beginning with SQLAlchemy Python
Ok I have been doing Python for a while now and Python is amazing. So thought of writing a blog about it in my new blog. Leaving the chitchat.
We will be performing database operations (CRUD ) in SQLite database. This is a simple database that many programming language support and recommended for beginning database programming for most of them. We will be building a simple todo application to begin with. For further practice, you can create Restaurant Menu App, Remainder App, whatever you like. Be creative. 😎😎😎
We have few steps that we will be following. Importing libraries, connecting to database (*.db) and creating session interface for performing operations.
We will be using SQLAlchemy python module to begin.
Importing dependencies
import sys from sqlalchemy import Column, ForeignKey, Integer, String from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.orm import relationship from sqlalchemy import create_engine
These are the dependencies that we will be using for begin with.