[Treebase-guts] [ treebase-Bugs-2846456 ] Need PhyloWS API search by date-time-stamp

[SourceForge.net <no...@so...>]

Bugs item #2846456, was opened at 2009-08-28 19:28
Message generated for change (Settings changed) made by rvos
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1126676&aid=2846456&group_id=248804

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: data
Group: None
>Status: Closed
Priority: 6
Private: No
Submitted By: William Piel (sfrgpiel)
Assigned to: Rutger Vos (rvos)
Summary: Need PhyloWS API search by date-time-stamp

Initial Comment:
We need to be sure that our API can search using data-time-stamps. i.e. "find all studies that were modified since Jan 23, 2010." (and separately, "find all studies that were made public after Jan 23, 2010"). This may require investigating how and where TreeBASE2 is currently tracking modification stamps. If it does not do so yet, we should probably add modification stamp fields on some key tables -- and it's probably easier to do this with a postgresql-level trigger or part of the schema. At any rate, any of the following modifications should stamped and searchable by the API: modifications to the citation, matrix metadata (including row-segment additions/subtractions), tree metadata (including re-rooting a tree), taxon labels, and mapping between taxon labels and taxon variants, and mapping between taxon variants and taxa. i.e., if a study contains a matrix for which a taxon label gets re-mapped to a different taxon variant or taxon at time/date x, then the whole study should be considered changed at time/date x. 

----------------------------------------------------------------------

>Comment By: Rutger Vos (rvos)
Date: 2011-05-12 16:13

Message:
The PhyloWS API is extended so that studies can now be searched on creation
date, modification date and publication date. Whether modification dates
for studies are updated correctly when some contained object changes, I
don't know. If they aren't, perhaps that should be filed as a bug that's
not related to the PhyloWS API per se.

----------------------------------------------------------------------

Comment By: Rutger Vos (rvos)
Date: 2010-06-16 15:51

Message:
"If it does not do so yet, we should probably add modification stamp fields
on some key tables -- and it's probably easier to do this with a
postgresql-level trigger or part of the schema."

I have no idea how to do this.

----------------------------------------------------------------------

Comment By: Rutger Vos (rvos)
Date: 2010-06-16 15:51

Message:
Thanks for reporting this bug.  We'll look into it as soon as possible.


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1126676&aid=2846456&group_id=248804