Description
The initial release of CSV-mySQL-Converter that solves the complication of converting CSV files into executable MySQL statements
General notes
- This version has been written by: Hamad
- Future enhancements and updates are planned and counted for
Known Issues
- The process of data type conversion may not be consistent
E.x. Data types such as 'Integer', might get converted to BIGINT and that may cause errors while executing the SQL statement to the database. - Column names might include signs such as '$%#@!&*()', which may cause errors while executing the SQL statement to the database
- Table_name parameter at model.py > function 'export_as_sql' won't filter inputs that include (spaces, special characters, etc)
- Exporting data frames that include Na or null values using model.py > function 'export_as_sql' will result in an error that indicate the data frame still includes Na/null values
Disclaimer
This project is developed by an early-stage developer, and it represents one of my initial projects. As such, it may contain bugs, errors, or unexpected behavior. While I have made efforts to ensure the functionality and reliability of the convertor class, there may still be areas that require improvement or refinement. The accuracy, completeness, or reliability of the information provided cannot be guaranteed. Users are encouraged to verify any information independently and consult with appropriate professionals for specific advice related to their circumstances. The creators of this project disclaim any liability for any loss or damage resulting from reliance on the information presented.