On Mon, Mar 17, 2014 at 5:22 PM, <ma...@include-once.org> wrote:
> It's nowhere near finished, but here's a github-simulating layout:
>
> http://fossil.include-once.org/hybrid7/
>
>
Exceedingly cool :)
> Barely holds together, and it's not yet working in Firefox.
Nor Chrome - the labels on the menus on the right disappear when i click on
one.
> Btw, maybe someone can lend some insight with following:
>
> SELECT
> name, comment, uuid, mtime
> FROM filename
> JOIN mlink ON filename.fnid=mlink.fnid
> JOIN event ON mlink.mid=event.objid
> JOIN blob ON blob.rid=event.objid
>
> (The fossil DB is still mostly a blackbox to me). Here `event.objid` gives
> me the checkin artifact hash.
It gives you the "rid", which is "right next to" the hash. event.objid ==>
blob.rid.
> What I'm actually trying to retrieve is the
> file version uuid however.
>
For that... i've got a similar query... just a moment...
rc = fsl_db_prepare_cached(db, &st,
"SELECT bf.uuid, filename.name fname,
bf.size "
"FROM mlink, filename, "
"blob bf, -- FILE blob\n"
"blob bm -- MANIFEST/checkin blob\n"
"WHERE "
"bm.uuid = ? "
"AND filename.fnid=mlink.fnid "
"AND bf.rid=mlink.fid "
"AND bm.rid=mlink.mid "
"ORDER BY filename.name %s",
fsl_cx_filename_collation(f));
then you've got both via bm (the checkin) and bf (the file). So you'll need
to change your query to something like...
qlite> select f.name, coalesce(ev.ecomment, ev.comment), bm.uuid, bf.uuid,
ev.mtime from event ev, blob bm, blob bf, mlink ml, filename f where
ev.objid=bm.rid AND f.fnid=ml.fnid AND ml.fid=bf.rid AND ml.mid=bm.rid AND
bm.rid=4893;
(4893 == my local trunk version)
name|coalesce(ev.ecomment, ev.comment)|uuid|uuid|mtime
f-apps/f_checkin.java|rename java namespace, and (ongoing) go a little bit
further in actually doing
something.|8625a31eff708dea93b16582e4ec5d583794d1af|3ea41d892c435668aaba3dc40fad1af962e30493|2456734.14432735
src/fsl_jni.c|rename java namespace, and (ongoing) go a little bit further
in actually doing
something.|8625a31eff708dea93b16582e4ec5d583794d1af|76cb4b682c03a2de112698c08197696fd7284800|2456734.14432735
src/org/fossil_scm/libfossil/Checkout.java|rename java namespace, and
(ongoing) go a little bit further in actually doing
something.|8625a31eff708dea93b16582e4ec5d583794d1af|6e58a47089d3f4911c9386c25bac36c8e98d4d21|2456734.14432735
okay, that only gets us the files which changed in that version. i'll see
if i can get the whole list (but so far i only know how to do that from C
code, either using multiple queries or (easier) loading the manifest).
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
_______________________________________________
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
