SageTV database?

[steingra]

I was wondering if there is some type of database/schema that is running behind the scenes in sagetv.

I have a LOT of movies/shows...and it would be nice if I could connect to the sagetv database, and write queries against it. Like, for example, just making a simple report layout that shows me all the names of my shows.

I was hoping there is some interface to reach the sagetv data/database. I know there must be one. I just havent found out enough about it yet. Maybe its all internal private unpublished information? Or maybe if I use Studio, I can get access to it using the Studio programming?

Just curious.


Edit: I found this addin/utility. I might try it out. But I was wondering if there is something in SageTV I can query directly. Even if I have to write a program to it.
http://www.sage-community.org/index....gsXmlGenerator

[Opus4]

Originally Posted by steingra

I was wondering if there is some type of database/schema that is running behind the scenes in sagetv. ... Or maybe if I use Studio, I can get access to it using the Studio programming?

All of the internal SageTV database info stored in wiz.bin is accessible through Studio via the SageTV API. Nielm accesses the data for his web server by having java classes loaded with the SageTV process.

- Andy

[steingra]

Thats great! Guess its time I finally started using Studio. Just havent had a specific reason until now. I was hoping there was a way to dig into it.

Thanks.

[Narflex]

And expect more advanced query features as part of 5.1. (some of them have already been updated in the online API docs)

[dflachbart]

Originally Posted by Narflex

And expect more advanced query features as part of 5.1. (some of them have already been updated in the online API docs)

Drool ...

[Morgan111]

It would be great if you could also add an API that could retrieve the full filename of a picture library file. I was adding buttons below the picture/slideshow viewer for things like navigation,rotation,deletion but could not find any way to get the full name and extension of the picture.

[Opus4]

Check out:

• GetFileForSegment(MediaFile,SegmentNumber)
• GetSegmentsFiles(MediaFile)

The first one is really what you want, but the second one will return all the files for a MediaFile object.

- Andy

[GKusnick]

GetFileForSegment() should tell you everything you need to know about the physical file on disk (assuming you know how to access the methods of a java.io.File).

Edit: Once again, Andy's quicker on the draw.

[Morgan111]

Doh! I thought I had tried that one found a problem, but it works when I try it now. Thanks!

[alon24]

Since I do not see any "Since" param in the javadocs on the http://download.sage.tv/api/ api onsite.

How will I know which is 5 and which is 5.1??
I do not remember all the functions offhand, and I use it havily right now.

Can you add that field?

[nielm]

Originally Posted by alon24

Since I do not see any "Since" param in the javadocs on the http://download.sage.tv/api/ api onsite.

here's one

[alon24]

I stand corrected

[Morgan111]

Originally Posted by Opus4

Check out:

• GetFileForSegment(MediaFile,SegmentNumber)
• GetSegmentsFiles(MediaFile)

The first one is really what you want, but the second one will return all the files for a MediaFile object.

- Andy

That works perfectly. Now how about a way to force an image resource to be reloaded? I have tried passing in the filename to an image widget from GetFileForSegment, and GetImageAsBufferedImage and UnloadImage, Refresh()...
So once I Update the picture file I cannot get it to display anything but the cached image (and thumbnail) until enough other pictures are displayed or rescanning the database. Any easy solution? Thanks.

[nielm]

No, last time I heard (3/05), there is no way of getting around the image cache, and that unloadimage does not work and can not work in 3d mode...

[GKusnick]

If you're talking about tweaking an image in Photoshop or whatever during STV development, there are basically two strategies that work:

1. Use temporary filenames such as Temp1.png, Temp2.png, etc., bumping the number with each edit. Rename it to its permanent name only after you're done tweaking and are satisified with the appearance.

2. Implement an Exit & Restart command that launches a batch file or VBScript script just before exiting Sage. The script can then restart Sage after a short delay, thereby flushing the image cache.

On the other hand, if you're talking about writing code that actually overwrites image files dynamically at runtime, then you're going to be constantly butting heads with the image cache, and you'd best find another way to solve your problem that doesn't involve reusing the same filename for different images.

[lamanmi]

All,

I'm bringing back this old thread to see if there has been any progress on a method for having Sage re-load an image when the file itself has changed. I have tried "UnloadImage" but that does not seem to clear it out.

The only method that I have been able to get to work is to restart sage.

Any ideas greatly appreciated!