[Babase] The order in which sexual cycle tables load
kfenn
kfenn at princeton.edu
Fri Sep 22 11:23:54 EDT 2006
Hi Karl,
I had line command nightmares all last night....I hope you're happy.
Anyway, I'm recovering. Thanks for the conversion sequence. I've found
it very helpful. I have some follow-up questions:
What about other female reproductive tables....where do they fit in?
The cycles table, a primary source table, didn't appear in you list.
When does that get loaded?
Also what about the analyzed tables (repstats, cycstats, cycgapdays, mm
and md intervals)? Are they auto-generated as part of this conversion
process or does that happen after we get the bugs with the primary
source tables worked out?
Finally, I'm curious about the "other stuff happens here" part of your
email. I don't need to know much about the specifics, but very
generally what types of "other stuff" are happening?
Tabby
Karl O. Pinc wrote:
> Tabby asked me for a document showing the order
> in which sexual cycle related tables and data
> loads. This is that:
>
> biograph, except for Pid
> (other stuff happens here)
> maturedates
> (other stuff happens here.)
> cycgaps, (from real_gaps, the real gaps we want)
> (The latest conversion errors
> are from starting the coversion with the
> loading of cycgaps. Errors from earlier
> do not show up (and are not checked.))
> cycpoints
> sexskins
> cycgaps, (fake gaps (fake_gaps), so we can put in pregs)
> pregs, except for Resume
> biograph, the Pids are put in and biograph is now complete
> cycgaps, (undo_fake_gaps) the fake gaps are removed.
> When the fake gaps are removed the pregs.Resume
> is automatically set by the triggers.
> This leaves pregs complete.
>
>
>
> 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