Create a cron job to expire legislators

[waldoj]

As a hedge against errors, find any legislator who has the same district ID as another one and expire the older of the two legislators, setting date_ended to the day prior to the new legislator's date_started.

[waldoj]

Something like this may do it. This gets a list of every legislator whose date_ended is null, whose record was created more than 10 days ago, and who shares a district ID with a legislator whose record was created less than 10 days ago.

SELECT r1.name, r1.id
FROM representatives AS r1
WHERE r1.date_ended IS NULL AND r1.date_created < NOW() - INTERVAL 10 DAY AND r1.district_id=
	(SELECT r2.district_id
     FROM representatives AS r2
     WHERE r2.district_id=r1.district_id
     AND date_created BETWEEN CURDATE() - INTERVAL 10 DAY AND CURDATE())