Maternal death
Brought to you by:
canajun2eh,
yalnifj
Menu
▾
▴
Christophe,
do you plan to add this to svn?
It will need some improvement. I tried and it timed out on my DB.
Not ready for SVN.
Just quick and dirty code to show how maternal death report could be done by reusing existing functions.
This sort of thing is much better done in SQL. Try the following query. It runs on my 10000 gedcom in a tenth of a second. This inlcudes both parents. Join in the pgv_individuals table and add i_sex='F' to restrict it to mothers.
SELECT birth.d_file, birth.d_gid
FROM pgv_dates birth
JOIN pgv_link famc ON (birth.d_file=famc.l_file AND birth.d_gid=famc.l_from AND famc.l_type='FAMC')
JOIN pgv_link fams ON (fams.l_file=famc.l_file AND fams.l_to=famc.l_to AND fams.l_type='FAMS')
JOIN pgv_dates death ON (death.d_file=fams.l_file AND death.d_gid=fams.l_from)
WHERE birth.d_fact IN ('BIRT', 'CHR', 'BAPM')
AND death.d_fact IN ('DEAT', 'CREM', 'BURI')
AND death.d_julianday1 < birth.d_julianday2 + 90