solr data import config

2440

solr的dataimporthandler 配置， 全量和增量导入，


<?xml version="1.0" encoding="UTF-8" ?>
<dataConfig>
<dataSource  type="JdbcDataSource" driver="org.postgresql.Driver" url="jdbc:postgresql://localhost/postgres" user="xxxxxx" password="xxxxxx" encoding="UTF-8" />
<document>

<!--deletedPkQuery="select id from table" detetePkQuery这个查询把已经删除的id查询出来,表里面存有已经删除的id-->
<entity name="users" pk="id" query="select * from users"
deltaQuery="select id from users where last_modified > '${dataimporter.last_index_time}'"
deltaImportQuery="select id,name from users where ID=${dataimporter.delta.id}">
<field column="ID" name="id"/>
<field column="NAME" name="name" />
<!--一对多配置,-->
<entity name="userinfo"  pk="id"
query="select * from USERINFO where userid=${users.id}"
deltaQuery="select id,userid from USERINFO where last_modified > '${dataimporter.last_index_time}'"
parentDeltaQuery="select id from USERS where ID=${userinfo.userid}"
deltaImportQuery="select info from userinfo where ID=${dataimporter.delta.id}">
<field name="info" column="info" />
</entity>
</entity>
</document>
</dataConfig>


附上数据库建表语句

CREATE TABLE users
(
id integer NOT NULL,
name character(50),
last_modified timestamp without time zone,
CONSTRAINT users_pkey PRIMARY KEY (id)
)
WITHOUT OIDS;
ALTER TABLE users OWNER TO postgres;

drop table userinfo;
CREATE TABLE userinfo
(
id integer NOT NULL,
info character(50),
userid integer,
last_modified timestamp without time zone,
CONSTRAINT userinfo_pkey PRIMARY KEY (id),
CONSTRAINT userinfo_userid_fkey FOREIGN KEY (userid)
REFERENCES users (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)