SQL-Database-Interface

Project information

DatabaseManager

Overview The DatabaseManager module is designed to simplify interactions with a MySQL database. It provides functionality for creating tables, inserting data, updating data, and deleting entries with single or multiple conditions. This module is particularly useful for managing machine-related data in industrial or IoT environments. It integrates a custom logging interface to monitor database operations effectively.

Features

Establishes connections to a MySQL database. Supports table creation for machine data storage. Enables insertion of new entries and updating existing ones. Provides options to delete entries with single or multiple conditions. Retrieves column names or entire tables, with optional ordering. Integrated logging for error tracking and debugging.

mssql-database Python