SQLAlchemy Test Application

This is a sample application demonstrating the use of SQLAlchemy ORM in Python. The application sets up a SQLite database, adds sample data, and queries the database.

Features

  • Connect to sqlite databases using SQLAlchemy
  • Perform CRUD operations
  • Use ORM to map database tables to Python classes

Installation

  1. Clone the repository:
    > git clone https://github.com/darrenleeyx/sqlalchemy-test.git
    > cd sqlalchemy-test
  2. Create and activate a virtual environment
    > python -m venv venv
    > venv/bin/activate
  3. Install the required packages:
    > pip install -r requirements.txt

Usage

  1. Configure your database settings in config.py.
  2. Run the application:
    > python main.py