How rgsharma745/csv-to-db works
This command-line Spring Boot utility migrates CSV files into PostgreSQL: startup invokes a loader, which discovers CSV files, parses headers and records, recreates a text-column table for each file, and batch-inserts its rows. The loader also normalizes table and column names through a shared utility. PostgreSQL is the durable destination; CSV and database are external to the repository. The README documents the migration capabilities, while the excerpts show their implementation concentrated in one loader class; no separate error-handling subsystem is evident.
Main entry points: CsvToDbTable.java CSV loader · CsvToDbApplication.java Application entry · Utils.java Name normalizer
Components 7
Application runtime
- Application entry
src/main/java/com/rgsharma745/CsvToDbApplication.java
CSV migration
- CSV loader
src/main/java/com/rgsharma745/CsvToDbTable.java - CSV files
- CSV parser
- Name normalizer
src/main/java/com/rgsharma745/Utils.java
Database storage
- PostgreSQL
Other components
- Operator
Connections 8
- Operator → Application entry: starts
src/main/java/com/rgsharma745/CsvToDbApplication.java - Application entry → CSV loader: invokes loading
src/main/java/com/rgsharma745/CsvToDbApplication.java - CSV files → CSV loader: reads files
src/main/java/com/rgsharma745/CsvToDbTable.java - CSV loader → CSV parser: parses CSV
src/main/java/com/rgsharma745/CsvToDbTable.java - CSV loader → Name normalizer: normalizes names
src/main/java/com/rgsharma745/CsvToDbTable.java - CSV loader → PostgreSQL: drops tables
src/main/java/com/rgsharma745/CsvToDbTable.java - CSV loader → PostgreSQL: creates tables
src/main/java/com/rgsharma745/CsvToDbTable.java - CSV loader → PostgreSQL: batch inserts
src/main/java/com/rgsharma745/CsvToDbTable.java