[Babase] Agonism, Grooming, and Samples tables updated
Karl O. Pinc
kop at meme.com
Sun May 6 23:01:51 EDT 2007
On 05/06/2007 06:24:50 PM, Leah Gerber wrote:
>
> Hello Karl,
>
> I managed to make the update statements work with the following code.
Sorry to make you fight with foxpro about this. I swear I've
solved this same kind of problem several times already. I may have
even sent something to the list about it, I think I sent several
wrong UPDATE statements before I got it right. The STR() rings
a bell.
> I
> changed all of the grooming and agonisms that you wanted on the first
> of
> the month. My question is whether you want the datetime field changed
> as
> well for these records. They do not match the date now.
The conversion program is not using the date part of the datetime
columns -- at least according to the documentation I've imbedded
in the code. We'll see if the comparision of the foxpro/postgres
data turns up any problems...
However, I still think it might be a good idea to keep the
two columns sychronized. (Or, then again, maybe it's handy
to have a "old v.s. new" right in the data should somebody
need to go back and look when they get around to using
exact dates rather than the first of the month?) My gut
feeling is to sychronize the Date and Datetime columns,
but it could require more poking at foxpro with foxpro
specific stuff (like STR() above). So, I'll leave the
decision up to the deciders. (In fact, I'll leave
the decision as to who's a decider up to the deciders. :)
>
> UPDATE interact;
> SET date = CTOD('1/' + STR(MONTH(date),2) + '/' + STR(YEAR(date),4));
> WHERE DAY(date) != 1;
> AND (act = "A" OR act = "AS" OR act = "OS" OR act = "DS");
> AND YEAR(date) < 1995;
> AND sid=0;
<snip>
> I also updated the Samples table by changing the SETUP_JUL13 back to
> SETUP_JUL03.
I imagine that'll get rid of some errors, and a lot more cascading
errors.
> New versions of this data are on papio as well as the dump files.
> These
> changes have been recorded in the babasechangelog which is also on
> papio
> now.
(Offtopic: Is the babase change log in the wiki?)
>
> Please let me know if I should change the datetime field. Could we run
> a
> new conversion now?
I'm running a new conversion into the babase_test database,
and also copying the foxpro data (mostly) unchecked into
the babase database. The new error results are in:
/biology/groups/babase/errors/errors_v14
/biology/groups/babase/errors/loadscript_v14
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