I need to have an java program doing the below tasks, The following are the deliverables based on the logic
Database: Mysql tables and its structures
All Source code used
All Jar files required for running.
Bug Free, Well Documented code,
If we run Javadoc it should have the comments appropriately.
LOGIC:
1) There are seven differnt property types coming in a separate file, which means there are 7 files to handle each file will have 250 fields in a comma separated file.
2) Create a separate table called realtor_list table with seven to 8 fields, I will give the table struct seperately
3) For every record in step1 per file, You need to insert it to a table using the insertion logic listed in Step:4
4) Insertion:
Insert each of the file into a separate Mysql Table as the logic below,
a) Insert every record in the files into its own table, for file1 table 1, for file2 table2 etc, repeat for all 7 files
b) When you insert, You need to add the key from the realtor_list table, which means there will be one record per
realtor and we need to know for the given realtor we are maintaining the data in seven tables, this field will be
available in the mysql table, We are still coming up logic, there could be one more key depending upon the situation
c) This is daily update, so you need to use logic to insert, I will give the logic separately.
d) There should be logs maintained to ensure that how many record inserted today and how many successful and failed dated.
e) For failures you have to have a failure log which will tell the reason for failure clearly dated.
f) I dont want Threads, Simple code is good enough and we will run through our own scheduler jobs. So not an issue. Code should be JDK1.6 and above.
When done, generate a new CSV file
