Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <dataConfig>
- <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/zzz" batchSize="-1" user="xxx" password="yyy"/>
- <document>
- <entity name="company_del" query="SELECT e.id AS `$deleteDocById` FROM entity AS e"/>
- <entity name="entity" query="SELECT
- e.id, e.type, CONCAT(COALESCE(p.firstname, ''), ' ', e.name) AS name,
- e.telefon, e.city, e.street, e.zipcode, e.urlizedname,
- (CASE WHEN p.is_private = 1 THEN 'true' ELSE 'false' END) AS is_private
- FROM entity AS e
- LEFT JOIN person AS p ON e.id = p.entity_id AND e.type = 'person'
- WHERE ('${dataimporter.request.check_last_time}' = 'false' OR e.updated_at > '${dataimporter.last_index_time}')"/>
- </document>
- </dataConfig>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement