MSSQL_with_PythonGUI

Database build with MSSQL connected with python using tkinter user Interface

Members

• David Gonzalez Tamayo
• Hobarlan Uparela Arroyo
• Juan Esteban Castro Garcia
• Andres Leonardo Rojas Peña
• Daniel Pineda Velez

Setup

Install python

to run this code please install python from Install python

once you install python please install these dependencies search the file requirements.txt and run pip install -r requirements.txt

MSSQL

To install Microsoft SQL Server please follow the instructions provide by Microsoft Team SQL Server installation guide

Tables

One you install microsoft SQL SERVER run the file /DatabaseSetup/TableCreator.sql to create all the required tables and relationships for the project, once the operation is done please run /DatabaseSetup/ALL_INSERTS.sql to add default values provied by the teacher

Connect with python

Go to /GUI/Database/conexion.py and edit this line:

connection = pyodbc.connect('DRIVER={SQL Server};SERVER=<SERVERCONNNECTION>;DATABASE=<SERVERCONNNECTION>;Trusted_Connection=yes;')

The database is the SERVERCONNNECTION created for this project and the SERVERCONNNECTION select your database and click on propierties and copy the user.

Run the application

There is two ways to run your application

Python Virtualenv

Follow the guide on Python Virtual Environments: A Primer

once the Virtualenv is finally done run:

pip install -r requirements.txt
python main.py

Python without Virtualenv

for this option only run

pip install -r requirements.txt
python main.py