solr 数据库配置文件 db-data-config.xml
<dataConfig>
<dataSource driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://192.168.0.48;DatabaseName=web" user="sa" password="123456789" /><!--数据库字符串的配置-->
<document><!--
transformer 格式转换:HTMLStripTransformer 索引中忽略HTML标签
query:完全索引查询语句
deltaQuery:增量索引查询主键ID
deltaImportQuery:增量索引查询导入数据
deletedPkQuery:增量索引删除主键ID查询
-->
<entity transformer="HTMLStripTransformer" name="Act" query="
SELECT top 100 'Act' + CONVERT(VARCHAR(128), aa.ActID)[id],
aa.ActID ,
aa.Act_Name ,
REPLACE(dbo.levels(aa.Act_Level), ';', ' ') [Act_Level],
aa.Pub_Date,
aa.Sta_Date,
aa.End_Date,
REPLACE(aa.Dept_Name, ';', ' ') [Dept_Name],
REPLACE(aa.FileNumber, ';', ' ') [FileNumber],
REPLACE(aa.Act_Subject, ';', ' ') [Act_Subject],
REPLACE(aa.Act_Special, ';', ' ') [Act_Special],
REPLACE(aa.ActLevelCode, ';', ' ') [ActLevelCode],
REPLACE(aa.ActInLevel, ';', ' ') [ActInLevel],
dbo.fn_SolrJoinActClassid(aa.ActID, ' ') AS SpecialClassID ,
dbo.fn_SolrJoinActSpecialID(aa.ActID, ' ') AS SpecialID ,
dbo.fn_SolrHaseActTrunk(aa.ActID) Trunk ,
dbo.fn_SolrJoinActTrunkID(aa.ActID, ' ') TrunkID ,
aa.Effect,
aa.IsGov,
aa.ActRelated,
aa.ActEnglish,
aa.ClassID,
aa.Act_Order,
ISNULL(( SELECT class / 100 + orders / 100000 FROM dbo.Act_SpecialOrder WHERE ActID = a.actid),0) Act_SpecialOrder,
(SELECT COUNT(*) FROM dbo.Act_Items ai WHERE ai.ActID=aa.actid)ItemCount,
a.Content
FROM dbo.ActAll aa inner join Act a ON aa.ActID=a.ActID"
deltaQuery="
SELECT aa.ActID id
FROM dbo.Actall aa
INNER JOIN dbo.Act a ON aa.ActID = a.ActID
WHERE aa.op_date>'${dataimporter.Act.last_index_time}'
"
deltaImportQuery="
SELECT 'Act' + CONVERT(VARCHAR(128), aa.ActID)[id],
aa.ActID ,
aa.Act_Name ,
REPLACE(dbo.levels(aa.Act_Level), ';', ' ') [Act_Level],
aa.Pub_Date,
aa.Sta_Date,
aa.End_Date,
REPLACE(aa.Dept_Name, ';', ' ') [Dept_Name],
REPLACE(aa.FileNumber, ';', ' ') [FileNumber],
REPLACE(aa.Act_Subject, ';', ' ') [Act_Subject],
REPLACE(aa.Act_Special, ';', ' ') [Act_Special],
REPLACE(aa.ActLevelCode, ';', ' ') [ActLevelCode],
REPLACE(aa.ActInLevel, ';', ' ') [ActInLevel],
dbo.fn_SolrJoinActClassid(aa.ActID, ' ') AS SpecialClassID ,
dbo.fn_SolrJoinActSpecialID(aa.ActID, ' ') AS SpecialID ,
dbo.fn_SolrHaseActTrunk(aa.ActID) Trunk ,
dbo.fn_SolrJoinActTrunkID(aa.ActID, ' ') TrunkID ,
aa.Effect,
aa.IsGov,
aa.ActRelated,
aa.ActEnglish,
aa.ClassID,
aa.Act_Order,
ISNULL(( SELECT class / 100 + orders / 100000 FROM dbo.Act_SpecialOrder WHERE ActID = a.actid),0) Act_SpecialOrder,
(SELECT COUNT(*) FROM dbo.Act_Items ai WHERE ai.ActID=aa.actid)ItemCount,
a.Content
FROM dbo.ActAll aa inner join Act a ON aa.ActID=a.ActID where a.Actid=${dataimporter.delta.id}"
deletedPkQuery="SELECT DISTINCT 'Act' + CONVERT(VARCHAR(16), actid) id FROM dbo.act_Delete_Log WHERE OpDate>'${dataimporter.Act.last_index_time}'"
>
<field column="id" name="id" />
<field column="ActID" name="ActID" />
<field column="Act_Name" name="Act_Name" stripHTML="true"/><!--查询字段名,配置字段名,是否使用格式化-->
<field column="Act_Level" name="Act_Level" />
<field column="Pub_Date" name="Pub_Date" />
<field column="Sta_Date" name="Sta_Date" />
<field column="End_Date" name="End_Date" />
<field column="Dept_Name" name="Dept_Name" />
<field column="FileNumber" name="FileNumber" />
<field column="Act_Subject" name="Act_Subject" />
<field column="Act_Special" name="Act_Special" />
<field column="ActLevelCode" name="ActLevelCode" />
<field column="ActInLevel" name="ActInLevel" />
<field column="SpecialClassID" name="SpecialClassID" />
<field column="SpecialID" name="SpecialID" />
<field column="Trunk" name="Trunk" />
<field column="TrunkID" name="TrunkID" />
<field column="Effect" name="Effect" />
<field column="IsGov" name="IsGov" />
<field column="ActRelated" name="ActRelated" />
<field column="ActEnglish" name="ActEnglish" />
<field column="ClassID" name="ClassID" />
<field column="Act_Order" name="Act_Order" />
<field column="Act_SpecialOrder" name="Act_SpecialOrder" />
<field column="ItemCount" name="ItemCount" />
<field column="Content" name="Content" stripHTML="true"/>
</entity>
</document>
</dataConfig>