[Babase] Updating RNKTYPES.Query
Karl O. Pinc
kop at meme.com
Fri Nov 3 18:43:28 EST 2006
On 11/03/2006 03:31:37 PM, kfenn wrote:
> Karl,
>
> This pertains to the fact that ranks will have to reference
> new/different tables in the new system, correct?
> We (you, me, Leah) discussed the components of the current select
> statements and how they might change with the new tables. I haven't
> done anything beyond that.
Ok. I guess you're the person to manually update the column
each time after a conversion is run. If it gets to be too much
of a pain I can automate it.
>
> The gaps for the stillbirths are fixed. I've uploaded them as
> fake_cycgapstf and undo_fake_cycgapstf. I'm reviewing the decisions
> Jeanne made about the matured dates. Some of the fixes will require
> changing real gaps too so I'll call you on Monday to get a less on
> how to do that.
The real cycgaps are easy. There's a file "real_cycgaps" with
stuff that looks like this:
INSERT INTO cycgaps VALUES (1085, 'ALF', 'E', '1989-12-31', NULL);
INSERT INTO cycgaps VALUES (1086, 'ALF', 'P', '1991-07-15', 'D');
INSERT INTO cycgaps VALUES (1087, 'ALF', 'P', '1992-05-24', 'S');
INSERT INTO cycgaps VALUES (1088, 'ALF', 'P', '1992-07-05', 'D');
INSERT INTO cycgaps VALUES (1089, 'ALF', 'P', '1993-08-18', 'S');
INSERT INTO cycgaps VALUES (1090, 'ALF', 'P', '1993-11-19', 'D');
(That's an end of observation followed by 5 point observations.
Observation never starts again for this individual.)
It's just like putting stuff into the cycgaps table manually.
If you're going to make lots of changes then we probably want to
omit the cgid column entirely and allow the system to assign it
to _all_ rows.
> Have a good weekend.
>
> Tabby
>
> Karl O. Pinc wrote:
>> Tabby (?),
>>
>> Do we have a procedure in place to update the RNKTYPES
>> table with the appropriate queries for selecting
>> the individuals to be ranked? We talked about making
>> the changes, but they've not been made. Or maybe they
>> were made, but got overridden when we did another
>> conversion. (That'd be my bet.)
>>
>>
>> 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)
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
>
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