woopyMysql 0.1

Simple class to manage multiple Mysql Db with mysql-connector-python

WoopyMysqlAuth Class

Overview

The WoopyMysqlAuth class is designed to manage and validate the authentication credentials needed to connect to a MySQL database. It supports loading credentials from an environment file or directly from a dictionary. The class ensures that all required credentials are provided and valid before establishing a database connection.

Features

• Load database credentials from a .env file or a provided dictionary.
• Validate the presence of all necessary credentials.
• Establish a connection to the MySQL database.

Usage

Initialization

The class can be initialized in two ways:

1. Using a dictionary containing the authentication credentials.
2. Loading credentials from a .env file.

Example 1: Initializing with a Dictionary

WoopyAuth = {
    "woopy_db_host_ip": "127.0.0.1",
    "woopy_db_name": "example_db",
    "woopy_db_user_name": "root",
    "woopy_db_user_password": "password",
    "woopy_db_table_prefix": "wp_"
}

auth = WoopyMysqlAuth(WoopyAuth=WoopyAuth)

Example 2: Initializing with an Environment File

auth = WoopyMysqlAuth(WoopyEnv='.env')

Websites using 'woopy' library:

• OffertaLampo.net
• PriceErrors.net
• Cpaff.net
• Promozioni.net
• buoni.net
• Polignano.net
• Trullit.com
• wppy.net