On Wed, Nov 26, 2014 at 1:48 PM, Richard Hipp <d...@sqlite.org> wrote:
>
>
> On Wed, Nov 26, 2014 at 1:46 PM, Stephan Beal <sgb...@googlemail.com>
> wrote:
>
>>
>> Now that you mention it... i also have a small schema wish: i want the
>> full list of files for a given checkin. i've banged my head over SQL-only
>> solutions, and don't see how to get it without parsing the manifest. It
>> would be easy to add during crosslinking, but there's currently no place
>> for it (and i'm not quite certain where it would fit best).
>>
>>
>>
>
> For a typical repo, that would involve thousands of new rows for each
> checkin, which would cause excess growth of the repo file, I think.
>
> Perhaps a better solution is a virtual table that parses the manifest?
>
>
Such a virtual table is now on trunk:
CREATE VIRTUAL TABLE temp.x USING files_of_checkin;
SELECT * FROM x WHERE checkinID=?;
The checkinID is the numeric "RID" of the checkin for which you want a
listing of files. A WHERE clause term of the form checkinID=? is required.
Take heed to make your virtual table in TEMP lest it persist in the schema
of the repository.
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
fossil-dev mailing list
fossil-dev@lists.fossil-scm.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/fossil-dev
