Python ORM for PostgreSQL

This project is a Python script that serves as an Object-Relational Mapping (ORM) for PostgreSQL. It allows you to interact with a PostgreSQL database using Python objects and provides functionality to perform common database operations.

Prerequisites:-
Python 3
PostgreSQL

Libraries Used:-
Alembic
SQLAlchemy
Psycopg2

Installation:-
To install the required external modules, run:
pip install alembic
pip install sqlalchemy psycopg2-binary

Database Configuration:-
Before running the script, you need to set up a PostgreSQL database. Follow these steps:

Install PostgreSQL if you haven't already. 
Create a new PostgreSQL database and user. You can use the following SQL commands as an example:
CREATE DATABASE testdb;
CREATE USER postgres WITH PASSWORD '1234';
Update the database configuration in server.py. You'll need to provide the database name, username, password, and host. Here's an example:

# Database configuration
DATABASE_NAME = 'testdb'
DATABASE_USER = 'postgres'
DATABASE_PASSWORD = '1234'
DATABASE_HOST = 'localhost'  # or your PostgreSQL host address
DATABASE_PORT = '5432'  # or your PostgreSQL port
How to Run the Script

Execute the following command:
python server.py
The server will run on port 8000 by default.