Dmitriy Setrakyan created IGNITE-32:
---------------------------------------

             Summary: Need to create a utility for auto-schema loading from 
databases
                 Key: IGNITE-32
                 URL: https://issues.apache.org/jira/browse/IGNITE-32
             Project: Ignite
          Issue Type: Bug
          Components: UI
            Reporter: Dmitriy Setrakyan
            Priority: Critical
             Fix For: sprint-1


Need to create utility for auto-schema loading:
# Should be written in Java
# Preferably no additional dependencies should be added to the project. 

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

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

h3. Automatic {{GridCacheStore}} implementation
# 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.
# 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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to