CSV-DB Manager is a tool that facilitates interaction with data in CSV format and Oracle databases, offering features to clean tables, insert new data, and perform combined operations.
- Table cleaning in the database 🧹
- Insertion of new data from CSV files 📊
- Combined cleaning and insertion 🔄
-
Setup: Make sure you have Python and the necessary dependencies installed. If you don't, follow the instructions on Python and install the project's dependencies with the following command:
-
Execution: In the terminal, navigate to the project folder and execute the
main.pyfile: -
Options: Choose one of the menu options to interact with the database tables.
-
Data Input: Provide the table name and, in some options, the path to the CSV file.
-
Operations: Perform the desired operation, whether it's cleaning the table, inserting new data, or performing combined cleaning and insertion.
-
Results: The program will provide feedback on the progress and results of the operations.
Suppose you want to clean a table named TB_VEICULO_MOVIMENTACAO and then insert new data from a CSV file. Follow the program's instructions and input the table name and the path to the CSV file.
This project is licensed under the MIT License - see the LICENSE file for more details.
Made with 💪 by Anderson Monteiro💻