sqlalchemy-crash-course

Overview

Welcome to the SQLAlchemy crash course! This crash course will provide you with a comprehensive introduction to SQLAlchemy, a powerful SQL toolkit and Object-Relational Mapping (ORM) library for Python.

Prerequisites

Before starting this crash course, you should have a basic understanding of Python programming and SQL.

Feature

• Department Info:
  • Retrieve all the departments.
• Employee Info:
  • Retrieve all the employees.

Note: This docs will update for adding new features soon.

Installation

1. Clone this repository to your local machine:

   git clone https://github.com/YoussufShakweh/sqlalchemy-crash-course.git
   cd sqlalchemy-crash-course
   

2. Create a Virtual Environment and acitivate it:

   virtualenv venv
   source venv/bin/activate
   

3. Install the necessary dependencies:

   pip install -r requirements.txt
   

Usage

1. Run the setup file in app folder (Only once) to generate data automatically:

   python3 setup.py
   

2. Run the main file in app folder:

   python3 main.py
   

   The Result of running it will be a beautiful table like this

Contributing

Contributions are welcome! if you are find any issues or want to enhance something, feel free to submit a pull request.