Re: SQL UpdatePlugin?

2007-01-12 Thread Bertrand Delacretaz
On 1/12/07, Ryan McKinley [EMAIL PROTECTED] wrote: ...What is the best way to post unfinished code and ask for review? Should i make a JIRA issue and post a patch with a not ready for prime time note? ... Yes, this would work. Our personal NotReadyForPrimeTime detectors would flag it

Re: SQL UpdatePlugin?

2007-01-12 Thread Yonik Seeley
On 1/12/07, Ryan McKinley [EMAIL PROTECTED] wrote: For now, it extends SolrRequestHandler (not UpdateHandler) because the request plugin framework seems more stable. There is no framework for pluggable update handlers yet... Solr's current UpdateHandler classes (DirectUpdateHandler2) are a bit

Re: SQL UpdatePlugin?

2007-01-12 Thread Ryan McKinley
or a 'contrib' package/project/source folder? If it is in the main tree: the unit tests require mysql-connector.jar and assume you have a database at: jdbc:mysql://localhost/solrtestsql with user=solr and password=solr. Any suggestions on how this should be handled or structured. I'm

Re: SQL UpdatePlugin?

2007-01-11 Thread Thorsten Scherler
On Wed, 2007-01-10 at 22:32 -0800, Ryan McKinley wrote: I'd like to be able to add/update documents from an SQL query. Perhaps: addFromSQL mode=add or replace fields connection=jdbc:mysql://localhost/nblmc?username=xxxpassword=xxx driver=com.mysql.jdbc.Driver

Re: SQL UpdatePlugin?

2007-01-11 Thread Yonik Seeley
On 1/11/07, Ryan McKinley [EMAIL PROTECTED] wrote: I'd like to be able to add/update documents from an SQL query. Me too... it's been on the todo list a long time. A lot of people have data in databases, and it's a shame to require code to index their data if it can be expressed in SQL. If it

Re: SQL UpdatePlugin?

2007-01-11 Thread Ryan McKinley
On 1/11/07, Yonik Seeley [EMAIL PROTECTED] wrote: On 1/11/07, Ryan McKinley [EMAIL PROTECTED] wrote: I'd like to be able to add/update documents from an SQL query. Me too... it's been on the todo list a long time. A lot of people have data in databases, and it's a shame to require code to

Re: SQL UpdatePlugin?

2007-01-11 Thread Yonik Seeley
On 1/11/07, Ryan McKinley [EMAIL PROTECTED] wrote: On 1/11/07, Yonik Seeley [EMAIL PROTECTED] wrote: On 1/11/07, Ryan McKinley [EMAIL PROTECTED] wrote: I'd like to be able to add/update documents from an SQL query. Me too... it's been on the todo list a long time. A lot of people have data

Re: SQL UpdatePlugin?

2007-01-11 Thread Chris Hostetter
[EMAIL PROTECTED] : Reply-To: solr-dev@lucene.apache.org : To: solr-dev@lucene.apache.org : Subject: SQL UpdatePlugin? : : I'd like to be able to add/update documents from an SQL query. Perhaps: : : addFromSQL : mode=add or replace fields : connection=jdbc:mysql://localhost/nblmc?username

Re: SQL UpdatePlugin?

2007-01-11 Thread Ryan McKinley
I have written a first pass of an SQLUpdateHandler based on this discussion. It is working well for simple cases and has not tried anything complex yet. For now, it extends SolrRequestHandler (not UpdateHandler) because the request plugin framework seems more stable. What is the best way to

SQL UpdatePlugin?

2007-01-10 Thread Ryan McKinley
I'd like to be able to add/update documents from an SQL query. Perhaps: addFromSQL mode=add or replace fields connection=jdbc:mysql://localhost/nblmc?username=xxxpassword=xxx driver=com.mysql.jdbc.Driver multifieldSeperator=\n SELECT * FROM my_stats_table /addFromSQL This would use the