[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