#! /usr/bin/env python3

import sys
import pymysql

sys.path.insert(0, '../Mittwoch')
from utilities import hide_exception


# Zum Testen in der Shell
# mysql -h notebook14 -u python -pvilla inventory
def db_connect(credentials: dict):
    connection = pymysql.connect(**credentials)

    return connection


def main():
    db = db_connect(credentials)

    # Verbindung sauber trennen
    db.close()


# Bitte aus Konfigurationsdatei lesen
credentials = dict(host='notebook14',
                   user='python',
                   password='villa',
                   database='inventory')

hide_exception(main)
