[Babase] ranker again

Leah Gerber lgerber at duke.edu
Mon Oct 9 09:11:15 EDT 2006


Hi Susan,

I was actually hoping Tabby would know a bit more than me. You are 
correct I have never ACTUALLY used ranker.  Just played with it a little 
and then we entered ranks by hand. I also did not understand all of the 
emails. If you feel that this is something you want me to devote some of 
my last weeks to then I will.  Maybe a conference call is in order 
seeing as Tabby and I don't seem to understand what exactly is needed, 
therefore don't know how to proceed.

Leah
kfenn wrote:
> 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
>



More information about the Babase mailing list