[Babase] ranker again

Susan Alberts alberts at duke.edu
Sat Oct 7 17:22:37 EDT 2006


Leah and Tabby please confirm if you will follow up on this.
S

On Oct 6, 2006, at 2:09 PM, 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

-----------------------------------------------
Susan Alberts, Dept. Biology, Duke University, Durham NC 27708. Phone  
919-660-7272, Fax 919-660-7293. alberts at duke.edu





More information about the Babase mailing list