solr mysql 配置文件_solr 数据库配置文件 db-data-config.xml

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}'"

>