- Database supported : PostGres
- Langague : java
- build : Maven based pom xml . Keep it simple . We want to generate artifact and support unit test.
- Libraries : Keep the code simple . Use native code whereever possible and choose external libraries where we need to write lot of boiler plate code.
- csv files : in resources folder
- Database connection configuration should be present in resources
- Should exist like any standard java project with
srcandtestfolder
- Table names match CSV filenames (employee.csv → employee table)
- First row contains column names
- Next row contains data
- Use parameterized queries for SQL injection protection