[Babase] Questions re. maturity in ranker
Jun Yang
junyang at gmail.com
Thu Sep 28 14:47:31 EDT 2006
1. The current definition of "adult famales" (for ranking) in the rnktypes table
compares a matured (date) column with the ranking period to see if the
famale is an adult. Here is the SQL query in rnktypes.query:
SELECT DISTINCT biograph.sname FROM biograph, members WHERE
biograph.sname = members.sname AND members.date >= %s AND members.date
<= %f AND members.grp = %g AND biograph.sex = "F" AND
NOT(EMPTY(matured)) AND matured <= %f
However, this matured date information now resides in a different table,
correct? So we should go ahead and revise the query?
2. The ranker code (probably based on the old schema too) also reads
out a matured
column in biograph table. However, it seems that this information is
not used anywhere
in the code. Instead, there are rules for assigning default ranks to
famales depending on
whether they are older than 3 or not. Should we (1) just ignore
matured (just in code,
not in the SQL query in rnktypes), or (2) use matured instead of the
3-year-old threshold
to in the rules for assigning default ranks to females?
--- Jun Y.
More information about the Babase
mailing list