[Therion] Therion database web interface (Bruce)

[Dave Clucas]

I’ve looked at the sql output in the past and haven’t been able to use much of the data, parts of it such as maps seem to be undocumented.
Your request has caused me to look again. I’m not sure you’ll be able to do the things you want.

I have a cave system (Whiterock in Mulu) which has 123 surveys listed in the database. Each survey has a unique id and a name apart from the first record which has an id of 1 and no name. All the surveys have a parent id of 1 apart from the first record which has a parent id of 0.

If I look at the maps table there are 120 records and all are referenced to survey id 1 which is obviously the top level survey so I can’t identify which survey each map belongs to. I’ve tried creating a container survey to contain all the sub surveys but, when I do, all maps are referenced to that container survey

Similarly, if I look at the scraps table, all the scraps are referenced to the master survey.

My index file has a map for plans and a map for elevations. Each of the maps contains all the scraps for that elevation.
In addition all surveys have their own plan and elevation maps so that I can print out each survey map separately.

I then  created a master map which contained each of the individual survey maps but all the individual maps are still referenced to the master survey.

What I’ve not tried to do is create a sql output for each survey. I’m sure that wouldn’t work anyway as the sql creates new tables and doesn’t append records. This means you would have to create a separate database for each survey and there would be no easy way of linking them.

I have done some work on Andrews code and when I’m satisfied with the results I’ll post on the Wiki.

Dave Clucas
daveclucas.com
sarawak-caves.com
dave.clucas at icloud.com

Exploring the World - One cave at a time


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.speleo.sk/pipermail/therion/attachments/20140709/59f5ce16/attachment.htm>