csv-to-sql-insert
csv-to-sql-insert copied to clipboard
gitdagray
Provide table data as a CSV (comma-separated values) file and output a SQL insert statement for a table with the same name as the file.
Issue #9 The integration of yargs also provides a clear interface for specifying and documenting expected command-line options, making your script more user-friendly. Using yargs makes your code more readable...
- Implement a structured error logging system using date-fns and uuid for reliable tracking. - Create log files for different events and errors - Error.txt(log all errors), fileSystemError.txt(log erros related...
Adding path module to concatenate file paths and added types to catch block
Instead of depending on `process.args` inside both `writeSQL` and `readCSV` functions, we can simply pass necessary CLI arguments as function parameters. This will make it easier to maintain and it...
Included the new syntax for batch insert `npm start YourFileName RowsPerInsert`
Fixes [Issue 36](https://github.com/gitdagray/csv-to-sql-insert/issues/36) Removed the index.js file from the root directory as it seems unnecessary. I removed it before but someone might have added it by mistake.
I can see one index file in the src directory and the other in the root directory. I am not sure why we have an index.js file in the root...
