Differences between revisions 1 and 9 (spanning 8 versions)
⇤ ← Revision 1 as of 2011-01-19 11:35:34 →
Size: 680
Editor: jrg
Comment:
← Revision 9 as of 2011-01-19 14:17:10 → ⇥
Size: 999
Editor: jrg
Comment:
Deletions are marked like this. Additions are marked like this.
Line 5: Line 5:
On a machine that is allowed read access to STAGE, do:{{{
ssh -f develro@carme -L 7880:carme:7880 -N
wget -q -O - http://carme:7880/fedora/risearch?type=tuples&lang=iTQL&format=count&query=select%20%24object%0Afrom%20%3C%23ri%3E%0Awhere%20%24object%20%3Cfedora-model%3AhasModel%3E%20%3Cinfo%3Afedora%2Fdoms%3AContentModel_Program%3E%0Aand%20%24object%20%3Cfedora-model%3Astate%3E%20%3Cfedora-model%3AActive%3E%0A		 On a machine that is allowed read access to STAGE, first do:{{{
ssh -f develro@carme -L 7880:carme:7880 -N}}}
Then (after inserting the correct password below) do:{{{
echo `wget -q --user=fedoraReadOnlyAdmin --password=<INSERT_PASSWORD_HERE> -O - 'http://carme:7880/fedora/risearch?type=tuples&lang=iTQL&format=count&query=select%20$object%0Afrom%20%3C%23ri%3E%0Awhere%20$object%20%3Cfedora-model:hasModel%3E%20%3Cinfo:fedora/doms:ContentModel_Program%3E%0Aand%20$object%20%3Cfedora-model:state%3E%20%3Cfedora-model:Active%3E%0A'`
Line 9: Line 10:
The number of published Radio/TV program objects will be printed to standard out. The number of published Radio/TV program objects will be printed to standard out. 0 or more. If password is incorrect, nothing will be printed.

Then kill the ssh process:{{{
ps -o pid,command ax | grep ssh\ \-f\ develro\@carme | grep -v grep | sed -e 's|\ .*||' | xargs kill}}}

How to count published Radio/TV program objects in Fedora

This explains how to get the number of published Radio/TV program objects in the Fedora installed in STAGE.

On a machine that is allowed read access to STAGE, first do:

ssh -f develro@carme -L 7880:carme:7880 -N

Then (after inserting the correct password below) do:

echo `wget -q --user=fedoraReadOnlyAdmin --password=<INSERT_PASSWORD_HERE> -O - 'http://carme:7880/fedora/risearch?type=tuples&lang=iTQL&format=count&query=select%20$object%0Afrom%20%3C%23ri%3E%0Awhere%20$object%20%3Cfedora-model:hasModel%3E%20%3Cinfo:fedora/doms:ContentModel_Program%3E%0Aand%20$object%20%3Cfedora-model:state%3E%20%3Cfedora-model:Active%3E%0A'`

The number of published Radio/TV program objects will be printed to standard out. 0 or more. If password is incorrect, nothing will be printed.

Then kill the ssh process:

ps -o pid,command ax | grep ssh\ \-f\ develro\@carme | grep -v grep | sed -e 's|\ .*||' | xargs kill

HowToCountPublishedRadioTVProgramObjectsInFedora (last edited 2011-01-20 14:30:46 by abr)