Ok here it goes:
"
<?xml version="1.0"?>
<dataConfig>
<dataSource type="JdbcDataSource" name="dbA"
driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/dbA?zeroDateTimeBehavior=convertToNull"
user="root" password=""/>
<document>
<entity name="dbA.project" dataSource="dbA"
transformer="TemplateTransformer" query="select *, 'dbA.project' from
project">
<!-- dbA.project , start -->
<field column="id"
template="${dbA.project.dbA.project},id:${dbA.project.id}"/>
<field column="id" name="db_id"/>
<field column="def" template="${dbA.project.dbA.project}"/>
<entity name="sys_types" dataSource="dbA" query="select stext from
sys_types where ftype=2 and sid='${dbA.project.type}' ">
<field column="stext" name="type"/>
</entity>
<field column="name" name="name"/>
<entity name="new_comment" dataSource="dbA" query="select cm_text from
new_comment where ftype=2 and fid='${dbA.project.id}' ">
<field column="cm_text" name="comment"/>
</entity>
<field column="deadline" name="deadline"
dateTimeFormat="yyyy-MM-dd'T'hh:mm:ss"/>
<field column="completion" name="completion"
dateTimeFormat="yyyy-MM-dd'T'hh:mm:ss"/>
<entity name="user" dataSource="dbA" query="select username from
ci_user where userid='${dbA.project.created_by}' ">
<field column="username" name="created_by"/>
</entity>
<entity name="sys_stati" dataSource="dbA" query="select stext from
sys_stati where ftype=2 and sid='${dbA.project.state}' ">
<field column="stext" name="state"/>
</entity>
<!-- 'phrase'-entity not found in table dbA.project -->
<!-- dbA.project , end -->
</entity>
</document>
</dataConfig>
"
The name of the database is "dbA" and the table name is "project".
Everything works out fine except the comment part highlighted (bold). That
works to as I stated If I change the phrase to:
"
<entity name="new_comment" dataSource="dbA" query="select cm_text from
new_comment where ftype=2 and fid='${dbA.project.comment}' ">
<field column="cm_text" name="comment"/>
</entity>
"
so that I don´t use my primary key "id" twice but the problem is I need to
use "id" for the comment part too.
kind regards, Sebastian
Noble Paul നോബിള് नोब्ळ्-2 wrote:
>
> On Tue, Jun 9, 2009 at 12:41 AM, gateway0<reiterwo...@yahoo.de> wrote:
>>
>> Thanks for your answer.
>>
>> "${db.tableA.id}" that specifies the sql query that the Dataimporthandler
>> should Use the sql field "id" in table "tableA" located in Database "db".
>
> The naming convention does not work like that.
>
> if the entity name is 'tableA' then the field 'id' is addressed as
> 'tableA.id'
>
> As I said earlier, if you could privide mw with the entire
> data-config.xml it would be more helpful
>
>>
>> like in the example from the Solr Wiki:
>> "
>> <entity name="item_category" query="select CATEGORY_ID from item_category
>> where item_id='${item.ID}'">
>> "
>>
>> It´s strange I know but when I use something other than "id" as the
>> foreign
>> key for the query everything works!
>>
>> like:
>> "${db.tableA.anotherid}"
>>
>>
>>
>> Noble Paul നോബിള് नोब्ळ्-2 wrote:
>>>
>>> what is ${db.tableA.id} ?
>>>
>>> I think there is something extra in that
>>>
>>> can you paste the whole data-config.xml?
>>>
>>> can you paste
>>>
>>> On Sun, Jun 7, 2009 at 1:09 AM, gateway0<reiterwo...@yahoo.de> wrote:
>>>>
>>>> Hi,
>>>>
>>>> I tried to do the following:
>>>>
>>>> "
>>>> <field column="id" name="db_id"/>
>>>>
>>>> <entity name="comment" dataSource="db" query="select com_text from
>>>> comment
>>>> where ftype=1 and fid='${db.tableA.id}' ">
>>>> <field column="com_text" name="comment"/>
>>>> </entity>
>>>> "
>>>>
>>>> So I use the SQL Table Field "id" twice once for "db_id" in my index
>>>> and
>>>> for
>>>> the sql query as "fid=id".
>>>>
>>>> That doesn´t work!
>>>>
>>>> But when I change the query from "fid=id" to like "fid=otherkey" it
>>>> does
>>>> work!
>>>> Like:
>>>> "
>>>> <field column="id" name="db_id"/>
>>>>
>>>> <entity name="comment" dataSource="db" query="select com_text from
>>>> comment
>>>> where ftype=1 and fid='${db.tableA.otherkey}' ">
>>>> <field column="com_text" name="comment"/>
>>>> </entity>
>>>> "
>>>>
>>>> Is there any other kind of a workaround so I can use the SQL Field "id"
>>>> twice as I wanted to? Thanks
>>>>
>>>> kind regards, Sebastian
>>>> --
>>>> View this message in context:
>>>> http://www.nabble.com/Use-the-same-SQL-Field-in-Dataimporthandler-twice--tp23904968p23904968.html
>>>> Sent from the Solr - User mailing list archive at Nabble.com.
>>>>
>>>>
>>>
>>>
>>>
>>> --
>>> -----------------------------------------------------
>>> Noble Paul | Principal Engineer| AOL | http://aol.com
>>>
>>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Use-the-same-SQL-Field-in-Dataimporthandler-twice--tp23904968p23930286.html
>> Sent from the Solr - User mailing list archive at Nabble.com.
>>
>>
>
>
>
> --
> -----------------------------------------------------
> Noble Paul | Principal Engineer| AOL | http://aol.com
>
>
--
View this message in context:
http://www.nabble.com/Use-the-same-SQL-Field-in-Dataimporthandler-twice--tp23904968p23938282.html
Sent from the Solr - User mailing list archive at Nabble.com.
