[IGNITE-32] Need to create a utility for auto-schema loading from databases

• Type: Task
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: sprint-1
• Component/s: UI
• Assignee: Unassigned
• Reporter: Dmitriy Setrakyan
• Created: 01/Dec/14 17:46
• Updated: 12/Feb/15 10:13
• Resolved: 11/Feb/15 10:59

Description

Need to create utility for auto-schema loading:

1. Should be written in Java
2. Preferably no additional dependencies should be added to the project.

The process is composed of 2 parts, schema mapping and automatic data loading.

Schema Mapping

1. Should be a standalone GUI utility
2. Users should select schemas, then tables from schemas, then fields from tables, and automatically generate Spring XML for SQL Query metadata configuration.
3. Should also optionally automatically generate POJO classes.
4. Should automatically map SQL table names to Java standard allowing users to provide customer Regex.
5. By default, every table should be mapped to a separate Cache, but user should be able to override this in any possible way.

Automatic GridCacheStore implementation

1. The new GridCacheStore implementation should read the XML configuration generated by Schema Mapping step and automatically implement all CRUD and TX operations out of the box.
2. The implementation of the loadCache(...) method should accept SQL for loading (or where clause) as a parameter. Users should be able to preload a portion of the table based on some search criteria on startup or at any point after.