Auto SQL Checkers (In development)

This Checker program is intend to use for IT 3380. As a PLA, it is sometimes really time consuming while having to check multiple students with 10+ queries each. This program is design to make grading easier for myself by having the program auto execute and get the results from assignment files.

GOAL: the final version is aiming to compare the results and auto grade.

Program SetUp and Require Modules

!! HEADS UP !! This program is design to work with sql and python docker container from IT 3380.

Once turn on SQL and Python container in docker.

1. Log into python server and re-direct into app directory.
2. Install the following modules:

   pip install pandas
   pip install sqlalchemy
   pip install openpyxl
   

3. Once installed, re-direct into project folder and follow instruction based on the version below...

(Ver1) Results onto Excel sheets

This Version of SQL Checker is to read from given sql file and execute the results onto an Excel file name Result_Data.

Instruction:

1. Paste all the sql files you want to run in sqlFiles folder.

2. Get into Results-to-excel's project directory.

   In python container, run:

   python ExecuteQueries.py <sql file you want to execute>
   

3. Then it'll prompt user for database name:

   Available databases:
   ---------------
   module2
   classicmodels
   employees
   sakila
   project2
   
   What database are you using?
   

4. Once finish the above steps, the program will then execute the queries and output the results onto the Excel by sheets.

Resources used:

Creat SQLAlchemy engine

MySQL-Connector

Export SQL to file

Pandas Dataframe

Create an empty excel file

Guides for Openpyxl

Conditional Selections