Page 1 of 1

List of profiles from cmd line?

Posted: Tue Jul 26, 2005 12:07 pm
by rob133
Hi, what's the best way to get a list of all existing webinator profiles from the command line? RH Linux. I'm planning to refresh all of my profiles from my own cron script instead of the built-in scheduler, and I would like to be able to automatically get a list of all profiles to run through rather than having to add each profile name to my script by hand.

My best guess at this point is to just get a list of directories in INSTALLDIR/texis, excluding "script"... but that doesn't seem reliable to me (there could be other non-profile dirs in there??)

What do you suggest?

Thanks very much,
Rob

List of profiles from cmd line?

Posted: Tue Jul 26, 2005 1:14 pm
by mark
Assuming standard unix installation path:

/usr/local/morph3/bin/texis -d /usr/local/morph3/texis/testdb -s "select Profile from options where Name='SS_dataspace'"

List of profiles from cmd line?

Posted: Tue Jul 26, 2005 4:36 pm
by rob133
Perfect, thanks!

List of profiles from cmd line?

Posted: Tue Jul 26, 2005 5:30 pm
by rob133
oops, one more thing: what sql would I use to pull the "last complete walk" time for a given profile? (I thought it was SYSSCHEDULE, but that's only if I'm using the internal scheduler, which I'm not).

Thanks

List of profiles from cmd line?

Posted: Tue Jul 26, 2005 5:37 pm
by rob133
Sorry to bother, I figured it out.

select Profile,String from options where Name='SSc_walked'