This repository contains a Python-based suite designed to automate and streamline various tasks in database management. The suite offers multiple functionalities such as data entry, query management, and file handling automation.
The aim of this project is to provide an all-in-one Python interface for database operations, benefiting database administrators and users who handle significant amounts of data. The suite features multiple tabs, each catering to specific database management needs:
- Query Executor: Utilizes
close_job_search.pyto perform fuzzy searches within a Microsoft Access database. - Data Entry: Powered by
file_entry.py, this allows direct data entries into the database. - Report Generator: Uses
intake_sheet.pyto generate reports and send them via email. - Data Search: Facilitated by
website_search.py, it automates searches for data across various websites. - File Management:
cad_opener.pyanddwg_file_opener.pyfacilitate the management and opening of various file types.
The suite leverages various helper modules like data_collection.py, encryption_manager.py, and settings_manager.py to provide a seamless user experience.
To utilize the suite, follow these steps:
-
Clone the repository and navigate to its root directory.
git clone https://github.com/pdiegel/DatabaseManagementHelper.git cd DatabaseManagementHelper -
Install the necessary dependencies.
pip install -r requirements.txt
-
Run the main script.
python -m DatabaseManager.main
Detailed usage for each tab can be found in their respective Python files.
Contributions are welcome. If you find any issues or have suggestions for improvements, feel free to open an issue or create a pull request.
This project is licensed under the MIT License. For more details, refer to the LICENSE.md file.
For inquiries or issues, please contact [email protected].