Differences between revisions 1 and 6 (spanning 5 versions)
⇤ ← Revision 1 as of 2011-01-19 11:35:34 →
Size: 680
Editor: jrg
Comment:
← Revision 6 as of 2011-01-19 12:50:49 → ⇥
Size: 944
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:{{{
wget -q -user=fedoraReadOnlyAdmin -password=<INSERT_PASSWORD_HERE> -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
Line 10: Line 11:

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:

wget -q -user=fedoraReadOnlyAdmin -password=<INSERT_PASSWORD_HERE> -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

The number of published Radio/TV program objects will be printed to standard out.

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)