[Babase] ranker again
Karl O. Pinc
kop at meme.com
Fri Oct 6 14:09:09 EDT 2006
On 10/06/2006 11:56:07 AM, Susan Alberts wrote:
> Karl, should you update the rnktypes table with the new types and
> remove FYM or can Leah/Tabby do this at this point? I think that you
> need to update the definition queries? I am not sure what these are.
Leah/Tabby can do it, and they can update the queries after
each conversion run too, although I could do it also if you want me
to for some reason.
By way of example, here's the old and new RNKTYPES.Query for ALF:
Old:
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
New:
SELECT DISTINCT biograph.sname
FROM biograph, members, maturedates
WHERE biograph.sname = members.sname
AND members.date >= '%s'
AND members.date <= '%f'
AND members.grp = %g
AND biograph.sex = 'F'
AND maturedates.sname = biograph.sname
AND maturedates.matured <= '%f';
(Note that I have gone ahead and put some of the %
substitutions inside single quotes because I believe
this makes more sense and is simpler for the ranker
program to deal with because it won't have to think
about what datatype things are and whether or not
it needs to put quotes around things. The final
design is up to Jun and Dongdong.)
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list