Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Struggling with learning solr
- <dataConfig>
- <dataSource driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/xxx" user="xxx" password="xxx" />
- <document>
- <entity name="manufacturer" transformer="TemplateTransformer" pk="manNum"
- query="SELECT manNum, manName FROM manufacturer
- WHERE active = 1">
- <field column="id" name="id" template="MAN-${manNum}" />
- <field column="type" template="manufacturer" name="type"/>
- <field column="manName" name="text"/>
- <field column="manNum" name="manNum"/>
- </entity>
- <entity name="product" transformer="TemplateTransformer"
- query="SELECT products.prodNum, products.prodName as text, m.manName FROM products JOIN man m USING (manNum)
- WHERE products.active = 1
- AND (hideWeb = 0 or hideWeb IS NULL)">
- <field column="id" template="PROD-${products.prodNum}" name="id"/>
- <field column="type" template="product" name="type"/>
- <field column="text" name="text"/>
- <field column="manName" name="manName"/>
- </entity>
- <entity name="ingredients" transformer="TemplateTransformer" pk="id"
- query="SELECT id, text FROM inglist WHERE sort != ''">
- <field column="id" name="id" template="ING-${inglist.id}"/>
- <field column="type" template="ingredient" name="type"/>
- <field column="text" name="text" />
- </entity>
- <entity name="uses" transformer="TemplateTransformer" pk="id"
- query="SELECT id, text FROM useslist">
- <field column="id" name="id" template="USE-${id}"/>
- <field column="type" template="use" name="type"/>
- <field column="text" name="text"/>
- </entity>
- <entity name="categories" transformer="TemplateTransformer" pk="id"
- query="SELECT id, textShow as text FROM categorylist">
- <field column="id" name="id" template="CATEGORY-${id}"/>
- <field column="type" template="category" name="type"/>
- <field column="text" name="text"/>
- </entity>
- </document>
- </dataConfig>
- <fields>
- <field name="id" type="string" indexed="true" stored="true"/>
- <field name="text" indexed="true" stored="true" type="text"/>
- <field name="type" type="string" indexed="false" stored="true"/>
- <field name="manName" type="text" indexed="false" stored="true"/>
- <field name="manNum" type="string" indexed="false" stored="false"/>
- </fields>
- select
- concat('b',cast(b.id as char)) as id,
- ...
- <entity name="GG-Boryslaw-1939-Phonebook"
- transformer="TemplateTransformer,DateFormatTransformer"
- pk="id"
- query="SELECT * FROM boryslaw_1939_phonebook">
- <field column="record_id" template="GG-Boryslaw-1939-Phonebook-${GG-Boryslaw-1939-Phonebook.id}" />
- <field column="record_type" template="phonebook" />
- <field column="record_source" template="Boryslaw Phonebook (1939)" />
- <field column="record_date" template="${GG-Boryslaw-1939-Phonebook.Year}" dateTimeFormat="yyyy" />
- ...etc...
- </entity>
Add Comment
Please, Sign In to add comment