[jira] Issue Comment Edited: (SOLR-469) Data Import RequestHandler

["Noble Paul (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SOLR-469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12615516#action_12615516 ] 

noble.paul edited comment on SOLR-469 at 7/21/08 10:14 PM:
-----------------------------------------------------------

* Added a method _destroy()_ to _EntityProcessor_ . This coupled with _init()_ can be used for pre/post actions
* _JdbcDataSource_ uses _Statement#execute()_  instead of _Statement#executeQuery()_ . So users can execute DDL/DML using _JdbcDataSource_
* _Context_ has a new method _getSolrCore()_ which returns the _SolrCore_ instance

      was (Author: noble.paul):
    * Added a method _destroy()_ to _EntityProcessor_ . This coupled with init() can be used for pre/post actions
* _JdbcDataSource_ uses _Statement#execute()_  instead of _Statement#executeQuery()_ . So users can execute DDL/DML using _JdbcDataSource_
  
> Data Import RequestHandler
> --------------------------
>
>                 Key: SOLR-469
>                 URL: https://issues.apache.org/jira/browse/SOLR-469
>             Project: Solr
>          Issue Type: New Feature
>          Components: update
>    Affects Versions: 1.3
>            Reporter: Noble Paul
>            Assignee: Grant Ingersoll
>             Fix For: 1.3
>
>         Attachments: SOLR-469-contrib.patch, SOLR-469-contrib.patch, SOLR-469-contrib.patch, SOLR-469-contrib.patch, SOLR-469-contrib.patch, SOLR-469-contrib.patch, SOLR-469-contrib.patch, SOLR-469-contrib.patch, SOLR-469.patch, SOLR-469.patch, SOLR-469.patch, SOLR-469.patch, SOLR-469.patch, SOLR-469.patch, SOLR-469.patch, SOLR-469.patch, SOLR-469.patch
>
>
> We need a RequestHandler Which can import data from a DB or other dataSources into the Solr index .Think of it as an advanced form of SqlUpload Plugin (SOLR-103).
> The way it works is as follows.
>     * Provide a configuration file (xml) to the Handler which takes in the necessary SQL queries and mappings to a solr schema
>           - It also takes in a properties file for the data source configuraution
>     * Given the configuration it can also generate the solr schema.xml
>     * It is registered as a RequestHandler which can take two commands do-full-import, do-delta-import
>           -  do-full-import - dumps all the data from the Database into the index (based on the SQL query in configuration)
>           - do-delta-import - dumps all the data that has changed since last import. (We assume a modified-timestamp column in tables)
>     * It provides a admin page
>           - where we can schedule it to be run automatically at regular intervals
>           - It shows the status of the Handler (idle, full-import, delta-import)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.