Plugin: SJQv4

[phelme]

does anyone know if the Test Script and Executable log files have any impact on heap space? Ditto the size of the SJQ database? I know that SJQ keeps this information around, the amount of days kept being configurable.

I'm trying to figure out where the heck all my Java memory goes and figure this might be worth looking into.

[graywolf]

Anyone have Slugger's SJQ4 scripts?

Was wanting to try a few things and my foggy memory thinks that Slugger had an example in his old svn location on googlecode which is no more.

Anyone have the old collection or know of a link to it that works?

[Slugger]

The svn repo seems to be gone forever, but I happened to still have a very old vm image kicking around so I booted it up and sure enough I had the svn repo checked out on it. I've attached a zip of what I had on the vm. Looks to be from around 2011. Don't know if it's the latest & greatest (probably not), but looks like most, if not all, of the examples I wrote way back when are in there in one form or another. Always a laugh to read your own code that's 6+ years old. Do with it what you will.

It's too bad Google just decided to toast all their hosted repos. Hate to imagine how much code just went poof because of it.

[Slugger]

Originally Posted by phelme

does anyone know if the Test Script and Executable log files have any impact on heap space? Ditto the size of the SJQ database? I know that SJQ keeps this information around, the amount of days kept being configurable.

I'm trying to figure out where the heck all my Java memory goes and figure this might be worth looking into.

Shouldn't. The only thing of SJQ that would consume Sage's heap would be the plugin code itself. All that data is stored in a separate database. So just the jar of plugin code + the jar for the database driver. Obviously I'd never claim perfection, but if there were any major leaks from SJQ, they would have likely been reported during its prime usage back in the day. Anecdotal, I know, but I ran the SJQ server and client for months on end without issue. There were some quirks with the H2 database driver that some people hit and I never could reproduce reliably, iirc. But I don't think any of that stuff affected Sage's heap, but it's been so many years now that it's mostly a blur at this point.

[razrsharpe]

I have 2 orphaned tasks and 1 orphaned client that i cant remove/delete/kill in the sjq ui (the client that was processing these tasks doesn't exist anymore). Is there any way to manually kill them?

[Taddeusz]

It's been a while since I've done any kind of SageTV API stuff. I record the news every evening but it's annoying to have to manually delete them every morning if I fall asleep before the news is over. I want to make a script that finds all the "KOCO" news recordings and deletes them every night.

[Taddeusz]

I'm trying to get SJQ working on my SageTV Docker running on unRAID. Does this work on that platform? Will it run with Java 8 or does it need 7?

[wayner]

I have it running fine on unRAID with Java 8. I can't remember if I had any issues when first trying to get it set up, but I don't think there were any major issues.

[Taddeusz]

I got it working I think. I figured out that I needed to "chmod +x" the scripts. After that my test script with just "return 0;" ran successfully. At this point I think it's just the syntax of the script I really want to run.

[Taddeusz]

Trying to figure out why my simple script doesn't seem to be working:

MediaFileAPI.GetMediaFiles("T").each { mediaFile ->
    if(MediaFileAPI.GetMediaTitle(mediaFile) ==~ /KOCO News/) {
        println("Deleting media file: " + MediaFileAPI.GetMediaFileID(mediaFile));
        // MediaFileAPI.DeleteFile(mediaFile);
    }
}
return 0;

It's failing with the error:

/opt/sagetv/server/sjq_scripts/del_koco_news.groovy:
 1: /opt/sagetv/server/del_koco_news.groovy: Syntax error: word unexpected (expecting ")")

[stuckless]

The text you posted seems fine (I even put it into an IDE that validates groovy and no errors). Is that the entire script?

Originally Posted by Taddeusz

Trying to figure out why my simple script doesn't seem to be working:

MediaFileAPI.GetMediaFiles("T").each { mediaFile ->
    if(MediaFileAPI.GetMediaTitle(mediaFile) ==~ /KOCO News/) {
        println("Deleting media file: " + MediaFileAPI.GetMediaFileID(mediaFile));
        // MediaFileAPI.DeleteFile(mediaFile);
    }
}
return 0;

It's failing with the error:

/opt/sagetv/server/sjq_scripts/del_koco_news.groovy:
 1: /opt/sagetv/server/del_koco_news.groovy: Syntax error: word unexpected (expecting ")")

[wayner]

Weird - could it even be DOS v Unix line break issue or something silly like that? Or maybe it doesn't like using / as string delimiters? Or maybe it doesn't like the ==~ operator.

Maybe try:
if(MediaFileAPI.GetMediaTitle(mediaFile).contains("KOCO News") {

[Taddeusz]

It seems like it's not loading some standard libraries or something like that. I changed it to this and now I'm getting "def: not found" for line 1.

def mediaMask = "T"

MediaFileAPI.GetMediaFiles(mediaMask).each { mediaFile ->
    if(MediaFileAPI.GetMediaTitle(mediaFile) ==~ /KOCO News/) {
        println("Deleting media file: " + MediaFileAPI.GetMediaFileID(mediaFile));
        // MediaFileAPI.DeleteFile(mediaFile);
    }
}
return 0;

[Taddeusz]

I've basically removed all the plugins and libraries from my SageTV installation and started from scratch. Did everything except delete my Sage.properties file. Even deleted any extraneous jar files that shouldn't be there in a clean installation. Then I reinstalled everything. It still gets the same "def: not found" error.

Any ideas?

[Taddeusz]

BTW, there are no extraneous white space characters in there. I've tried with both LF & CRLF line endings and get the same results.

[KarylFStein]

Do you need any imports? I don't know, but maybe try these:

import com.google.code.sagetvaddons.metadata.Factory
import org.apache.commons.io.FileUtils

(I'm just looking at some scripts I cobbled together from other people's scripts. I don't really know anything about Groovy.)

Also, should that ==~ just be =~?

[Taddeusz]

Originally Posted by KarylFStein

Do you need any imports? I don't know, but maybe try these:

import com.google.code.sagetvaddons.metadata.Factory
import org.apache.commons.io.FileUtils

(I'm just looking at some scripts I cobbled together from other people's scripts. I don't really know anything about Groovy.)

Also, should that ==~ just be =~?

Something fundamental is just not working on my system. If I put an import line in it then says "import: not found".

[wayner]

Are you doing all of this from within SJQ or are you also trying from a bash prompt within the Docker container? One of the drawbacks of a Docker is that it isn't as easy to install other apps like a Groovy DE and have that persist after upgrades, etc.

One of the other things you can do is to run the SJQ code on remote clients, including a VM on your unRAID box.

[Taddeusz]

Originally Posted by wayner

Are you doing all of this from within SJQ or are you also trying from a bash prompt within the Docker container? One of the drawbacks of a Docker is that it isn't as easy to install other apps like a Groovy DE and have that persist after upgrades, etc.

One of the other things you can do is to run the SJQ code on remote clients, including a VM on your unRAID box.

I'm running this from within SJQ.

[wayner]

Let me check some of my stuff tonight when I am at home. I don't use SJQ a lot these days on my server but I know that I do run a daily SJQ job just after midnight that emails me a list of the next day's recordings. And I am pretty sure that I adapted some of my jobs from Windows to Linux which was mainly a case of changing files paths to my Linux server and changing \s to /s, etc.