use LogTransformer to see if the value is indeed set <entity name="post" transformer="script:DeleteRow, RegexTransformer,LogTransformer" logTemplate="${post}" query=" select Id, a, b, c, IndexingStatus from prod_table where (IndexingStatus = 1 or IndexingStatus = 4) ">
this should print out the entire row after the transformations On Fri, Oct 16, 2009 at 3:04 AM, William Pierce <evalsi...@hotmail.com> wrote: > Thanks for your reply! I tried your suggestion. No luck. I have verified > that I have version 1.6.0_05-b13 of java installed. I am running with the > nightly bits of October 7. I am pretty much out of ideas at the present > time....I'd appreciate any tips/pointers. > > Thanks, > > - Bill > > -------------------------------------------------- > From: "Shalin Shekhar Mangar" <shalinman...@gmail.com> > Sent: Thursday, October 15, 2009 1:42 PM > To: <solr-user@lucene.apache.org> > Subject: Re: Using DIH's special commands....Help needed > >> On Fri, Oct 16, 2009 at 12:46 AM, William Pierce >> <evalsi...@hotmail.com>wrote: >> >>> Thanks for your help. Here is my DIH config file....I'd appreciate any >>> help/pointers you may give me. No matter what I do the documents are not >>> getting deleted from the index. My db has rows whose 'IndexingStatus' >>> field >>> has values of either 1 (which means add it to solr), or 4 (which means >>> delete the document with the primary key from SOLR index). I have two >>> transformers running. Not sure what I am doing wrong. >>> >>> <dataConfig> >>> <script><![CDATA[ >>> function DeleteRow(row) { >>> var jis = row.get('IndexingStatus'); >>> var jid = row.get('Id'); >>> if ( jis == 4 ) { >>> row.put('$deleteDocById', jid); >>> } >>> return row; >>> } >>> ]]></script> >>> >>> <dataSource type="JdbcDataSource" >>> driver="com.mysql.jdbc.Driver" >>> url="jdbc:mysql://localhost/db" >>> user="******" >>> password="*******"/> >>> <document> >>> <entity name="post" transformer="script:DeleteRow, RegexTransformer" >>> query=" select Id, a, b, c, IndexingStatus from prod_table >>> where (IndexingStatus = 1 or IndexingStatus = 4) "> >>> <field column="ptype" splitBy="," sourceColName="a" /> >>> <field column="wauth" splitBy="," sourceColName="b" /> >>> <field column="miles" splitBy="," sourceColName="c" /> >>> </entity> >>> </document> >>> </dataConfig> >>> >>> >> One thing I'd try is to use '4' for comparison rather than the number 4 >> (the >> type would depend on the sql type). Also, for javascript transformers to >> work, you must use JDK 6 which has javascript support. Rest looks fine to >> me. >> >> -- >> Regards, >> Shalin Shekhar Mangar. >> > -- ----------------------------------------------------- Noble Paul | Principal Engineer| AOL | http://aol.com