Challenge Overview
Competition Task Overview
Client has some rules for how to price their products and get a quote based on a set of configurations/rules.
We'll provide a document describing the rules with some comments added.
For this challenge, we'd like to create a java-based parser that takes this file as input, and generates SQL scripts that could be used to create database tables and INSERT statements with some of the sample data in this file:
- Create a parser to create a data model for the following:
- table for SUPPLEMENTAL DATA CHARACTERISTICS
- table for ORDERABLE OPTIONS
- table for ORDERABLE OPTIONS RULES: we can create a table for the rules and have the rules represented in XML, please provide the XSD for the XML schema
- For database please use MySQL
- The parser should support command line parameter to pass in the input file path
- You can use traditional Java parsing techniques -http://cogitolearning.co.uk/?p=525 and/or regular expressions
- The tool needs to figure out how items in the text file may relate to each other to make sure that is enforced in the parsing. For example, in operable options, we have the first column an "ID" that is referenced later by rules. Searching document for "Q768AA" we see that it is one of the options that can be added, and later we see a rule where it can be assigned if the model is a certain one.
- We'll keep improving the tool and in the future we'll parse nested rules as well, so try to make the code flexible for such possible changes.
Technology Overview
- Java 1.6
- SQL
- MySQL
- Regular Expression
Documentation Provided
We'll provide the rules file in challenge forum.
Final Submission Guidelines
Submission Deliverables
- Complete code that covers all requriements
- A complete and detailed deployment documented explaining how to deploy the application including configuration information.
Final Submission
For each member, the final submission should be uploaded via the challenge detail page on topcoder.com