[Babase] ranker again

kfenn kfenn at princeton.edu
Mon Oct 9 08:24:42 EDT 2006


Hi Susan,

I'll go with whatever Leah says.  I've worked with ranker exactly once 
and have never considered the rules behind it and am only understanding 
about 1/4 of these emails.  If she thinks it's fine, then I'm sure I can 
learn whatever I need to learn, but I really don't know enough about 
this to give a real answer.  Sorry!


Tabby

Karl O. Pinc wrote:
>
> 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
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase

-- 
Tabby Fenn
Research Assistant

Dept of Ecology and Evolutionary Biology
401 Guyot Hall
Princeton University
Princeton, NJ  08544

609 258-6898 (Ph)
609 258-2712 (Fx)



More information about the Babase mailing list