lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Spadez <james_will...@hotmail.com>
Subject Re: SQL DIH - Can I have some guidance please?
Date Tue, 04 Dec 2012 12:48:42 GMT
Thank you so much for your help. Based on the same schema in my first post
and your help I created this, have I implemented it correctly based on your
suggestion? I tried to comment it: 

<dataConfig> 
 <dataSource name="app-ds" driver="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/wikipedia" user="wikipedia"
password="secret" />
 	<document> 

		
		<entity dataSource="app-ds" name="item" query="SELECT id, title,
description, date, link, location_id, source_id, company_id from item">

		
		<entity dataSource="app-ds" name="location" query="SELECT name, coordinate
from location where location_id=${item.location_id}"> 
		<entity dataSource="app-ds" name="source" query="SELECT name from source
where source_id=${item.source_id}">
		<entity dataSource="app-ds" name="company" query="SELECT name from company
where company_id=${item.company_id}"> 

			
			<field column="id" name="id" /> 
			<field column="title" name="title" />
			<field column="description" name="description" />			
			<field column="date" name="date" />
			<field column="link" name="link" />

			
			<field column="name" name="company_name" />
			<field column="name" name="source_name" /> 
			<field column="name" name="location_name" /> 
			<field column="coordinate" name="location_coordinates" />

		</entity> 
		</entity> 
	</document> 
</dataConfig>






--
View this message in context: http://lucene.472066.n3.nabble.com/SQL-DIH-Can-I-have-some-guidance-please-tp4024207p4024235.html
Sent from the Solr - User mailing list archive at Nabble.com.

Mime
View raw message