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.
I would like to add an option to process all files in the CSV directory.
Fixes [Issue #31] [Issue #3] Added a command line argument "all" for processing all the files, exist in the ./csv folder. Example: npm start all --- for processing all the...
Hi, To improve readability, I have added empty line between import statement and function, added ';' after import statement, removed extra space in import statement, etc. This is my first...
The tests in my PR (#68) write test files to the filesystem and remove them after tests are complete. I am sure there is a way to do this using...
- Implements fix for createIfNot from earlier PR - Implements testing for two main fns readCSV and writeSQL (develops #63)
Issue #19 Eliminated code duplication. The logic for constructing the SQL statement is encapsulated in the constructSQLStatement function, reducing code duplication and making your code more modular.
1. Used fs/promises for promise-based file operations. 2. Improved the construction of the beginSQLInsert statement. 3. Extracted the validation logic into a separate function (validateRow). 4. Refactored file existence check...
Instruction is incomplete without examples. Adding an example that clarifies the command. The issue for reference: https://github.com/gitdagray/csv-to-sql-insert/issues/66 **No code change.**
Just a quick fix. There is a message in the usage section of the README.md file. This statement (point 4 in the above image) does not specify what file name...
- Updating path in createIfNot resolves the bug to create sql folder in root directory if not exists - Allow multiple file names to be input in npm start command...
