Advertisement
Guest User

Untitled

a guest
May 14th, 2017
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 0.80 KB | None | 0 0
  1. <dataConfig>
  2.     <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/zzz" batchSize="-1" user="xxx" password="yyy"/>
  3.     <document>
  4.         <entity name="company_del" query="SELECT e.id AS `$deleteDocById` FROM entity AS e"/>
  5.         <entity name="entity" query="SELECT
  6.            e.id, e.type, CONCAT(COALESCE(p.firstname, ''), ' ', e.name) AS name,
  7.            e.telefon, e.city, e.street, e.zipcode, e.urlizedname,
  8.            (CASE WHEN p.is_private = 1 THEN 'true' ELSE 'false' END) AS is_private
  9.        FROM entity AS e
  10.            LEFT JOIN person AS p ON e.id = p.entity_id AND e.type = 'person'
  11.            WHERE ('${dataimporter.request.check_last_time}' = 'false' OR e.updated_at > '${dataimporter.last_index_time}')"/>
  12.     </document>
  13. </dataConfig>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement