Guest User

Untitled

a guest
Aug 19th, 2018
208
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. DynamicField names from SQL value
  2. <dynamicField name="*_s" type="string" indexed="true" stored="true" />
  3.  
  4. <dataConfig>
  5. <dataSource type="JdbcDataSource"
  6. driver="com.mysql.jdbc.Driver"
  7. url="jdbc:mysql://localhost/MY_DB"
  8. user="MYUSER"
  9. password="MYPASS"
  10. batchSize="-1"/>
  11.  
  12. <document>
  13. <entity name="article" query="SELECT id, custom_key, custom_value FROM mytable">
  14. <field column="id" name="id"/>
  15. <field column="custom_value" name=":::WHAT TO PUT HERE?:::_s"/>
  16. </entity>
  17. </document>
  18.  
  19. <dataConfig>
  20. <script><![CDATA[
  21. function insertVariants(row) {
  22. row.put(row.get('custom_key') + '_custom', row.get('custom_value'));
  23. return row;
  24. }
  25. ]]></script>
  26.  
  27. <dataSource type="JdbcDataSource"
  28. driver="com.mysql.jdbc.Driver"
  29. url="jdbc:mysql://localhost/MY_DB"
  30. user="MYUSER"
  31. password="MYPASS"
  32. batchSize="-1"/>
  33.  
  34. <document>
  35. <entity name="article" query="SELECT id, custom_key, custom_value FROM mytable" transformer="script:insertVariants">
  36. <field column="id" name="id"/>
  37. </entity>
  38. </document>
  39.  
  40. </dataConfig>
Add Comment
Please, Sign In to add comment