[Babase] Agonism, Grooming, and Samples tables updated

Lacey Maryott lacey.maryott at duke.edu
Wed May 9 13:34:47 EDT 2007


See below about decision on datetime column as per susan!
Cheers,
Lacey

Karl O. Pinc wrote:
>
> 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. :)
>
** *I spoke with Susan about this and she said that there seems no point 
in messing with the date-time column, and that it can just be left 
alone. Do all G&A samples get a datetime assigned... or is this only on 
Psion data.  If it is only with Psion data, this shouldn't be affected 
by what we changed anyway, right? *
>>
>> 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
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
>

-- 
Lacey Maryott
Alberts Lab
Department of Biology
Duke University
ph: 919-660-7306
fax: 919-660-7293
Lacey.Maryott at duke.edu 



More information about the Babase mailing list