X-Git-Url: http://git.tuebingen.mpg.de/?p=paraslash.git;a=blobdiff_plain;f=mysql_selector.cmd;h=6cabd4f104d9472da08964cd218a21e6c9172026;hp=df88a2203ee96724d31e5e1a0c80addf507972f3;hb=cd4b294da6f6802d9918c8fe5bcecb8a2a2363c3;hpb=1446f99e3adc59d868726382a2ac7cec105372a7 diff --git a/mysql_selector.cmd b/mysql_selector.cmd index df88a220..6cabd4f1 100644 --- a/mysql_selector.cmd +++ b/mysql_selector.cmd @@ -1,4 +1,5 @@ -FN: mysql_selector_command_list +OF: mysql_selector_command_list +SF: mysql_selector.c HC: prototypes for the commands of the mysql audio file selector CC: array of commands for the mysql audio file selector AT: server_command @@ -6,14 +7,14 @@ IN: server user_list SN: list of mysql selector commands --- N: cam -P: DB_READ | DB_WRITE +P: AFS_READ | AFS_WRITE D: copy all metadata U: cam source dest1 [dest2 ...] H: Copy attributes and other meta data from source file to destination H: file(s). Useful for files that have been renamed. --- N: cdb -P: DB_READ | DB_WRITE +P: AFS_READ | AFS_WRITE D: create database U: cdb [name] H: @@ -24,7 +25,7 @@ H: H: The optional name defaults to 'paraslash' if not given. --- N: clean -P: DB_READ | DB_WRITE +P: AFS_READ | AFS_WRITE D: nuke invalid entries in database U: clean H: If the vrfy command shows you any invalid entries in your database, @@ -32,59 +33,59 @@ H: you can get rid of them with clean. Always run 'upd' and 'vrfy' H: before running this command. Use with caution! --- N: cs -P: VSS_WRITE | DB_READ | DB_WRITE +P: VSS_WRITE | AFS_READ | AFS_WRITE D: change stream U: cs [s] H: Selects stream s or prints current stream when s was not given. --- N: csp -P: VSS_WRITE | DB_READ +P: VSS_WRITE | AFS_READ D: change stream and play U: csp s H: Select stream s and start playing. If this results in a H: stream-change, skip rest of current audio file. --- N: da -P: DB_READ | DB_WRITE +P: AFS_READ | AFS_WRITE D: drop attribute from database U: da att H: Use with caution. All info on attribute att will be lost. --- N: hist -P: DB_READ +P: AFS_READ D: print history U: hist H: Print list of all audio files together with number of days since H: each file was last played. --- N: info -P: DB_READ +P: AFS_READ D: print database info U: info [af] H: print database informations for audio file af. Current audio file H: is used if af is not given. --- N: la -P: DB_READ +P: AFS_READ D: list attributes U: la [af] H: List attributes of audio file af or of current audio file when H: invoked without arguments. --- N: laa -P: DB_READ +P: AFS_READ D: list available attributes U: laa H: print list of all attributes defined in the database --- N: last -P: DB_READ +P: AFS_READ D: print list of audio files, ordered by lastplayed time U: last [n] H: The optional number n defaults to 10 if not specified. --- N: ls -P: DB_READ +P: AFS_READ D: list all audio files that match a LIKE pattern U: ls [pattern] H: If pattern was not given, print list of all audio files known @@ -92,7 +93,7 @@ H: to the mysql selector. See the documentation of mysql H: for the definition of LIKE patterns. --- N: mbox -P: DB_READ +P: AFS_READ D: dump audio file list in mbox format U: mbox [p] H: Dump list of audio files in mbox format (email) to stdout. If @@ -120,7 +121,7 @@ H: suitable script which adds a paraslash stream where exactly H: these files are admissable or does whatever thou wilt. --- N: mv -P: DB_READ | DB_WRITE +P: AFS_READ | AFS_WRITE D: rename entry in database U: mv oldname newname H: Rename oldname to newname. This updates the data table to reflect @@ -129,7 +130,7 @@ H: is kept. If newname is a full path, the dir table is updated as H: well. --- N: na -P: DB_READ | DB_WRITE +P: AFS_READ | AFS_WRITE D: add new attribute to database U: na att H: This adds a column named att to your mysql database. att should @@ -137,7 +138,7 @@ H: only contain letters and numbers, in paricular, '+' and '-' are H: not allowed. --- N: ne -P: DB_READ | DB_WRITE +P: AFS_READ | AFS_WRITE D: add new database entries U: ne file1 [file2 [...]] H: Add the given filename(s) to the database, where file1,... must @@ -145,13 +146,13 @@ H: be full path names. This command might be much faster than 'upd' H: if the number of given files is small. --- N: ns -P: VSS_WRITE | DB_READ | DB_WRITE +P: VSS_WRITE | AFS_READ | AFS_WRITE D: change to next stream U: ns H: Cycle forwards through stream list. --- N: pic -P: DB_READ +P: AFS_READ D: get picture by name or by identifier U: pic [name] H: Dump jpg image that is associated to given audio file (current @@ -164,7 +165,7 @@ H: H: para_client pic '#123' > pic123.jpg --- N: picadd -P: DB_READ | DB_WRITE +P: AFS_READ | AFS_WRITE D: add picture to database U: picadd [picname] H: Read jpeg file from stdin and store it as picname in database. @@ -174,44 +175,44 @@ H: H: para_client picadd foo.jpg < foo.jpg --- N: picass -P: DB_READ | DB_WRITE +P: AFS_READ | AFS_WRITE D: associate a picture to file(s) U: picass pic_id file1 [file2...] H: Associate the picture given by pic_id to all given files. --- N: picch -P: DB_READ | DB_WRITE +P: AFS_READ | AFS_WRITE D: change name of picture U: picch id new_name H: Asign new_name to picture with identifier id. --- N: picdel -P: DB_READ | DB_WRITE +P: AFS_READ | AFS_WRITE D: delete picture from database U: picdel id1 [id2...] H: Delete each given picture from database. --- N: piclist -P: DB_READ +P: AFS_READ D: print list of pictures U: piclist H: Print id, name and length of each picture contained in the H: database. --- N: ps -P: VSS_WRITE | DB_READ | DB_WRITE +P: VSS_WRITE | AFS_READ | AFS_WRITE D: change to previous stream U: ps H: Cycle backwards through stream list. --- N: rm -P: DB_READ | DB_WRITE +P: AFS_READ | AFS_WRITE D: remove entries from database U: rm name1 [name2 [...]] H: Remove name1, name2, ... from the data table. Use with caution. --- N: sa -P: DB_READ | DB_WRITE +P: AFS_READ | AFS_WRITE D: set/unset attributes U: sa at1<'+' | '-'> [at2<'+' | '-'> ] [af1 ...] H: Set ('+') or unset ('-') attribute at1, at2 etc. for given list of @@ -224,7 +225,7 @@ H: sets the 'rock' and the 'punk' attribute but unsets the 'classic' H: attribute. --- N: skip -P: DB_READ | DB_WRITE +P: AFS_READ | AFS_WRITE D: skip subsequent audio files(s) U: skip n [s] H: Skip the next n audio files of stream s. This is equivalent to the @@ -232,7 +233,7 @@ H: command 'sl n s', followed by 'us name' for each name the output of H: sl. --- N: sl -P: DB_READ +P: AFS_READ D: print score list U: sl n [s] H: Print sorted list of maximal n lines. Each line is an admissible @@ -245,14 +246,14 @@ H: H: shows you the audio file the server would select right now. --- N: snp -P: DB_READ | DB_WRITE +P: AFS_READ | AFS_WRITE D: set numplayed U: snp number af1 [af2 ...] H: Update the numplayed field in the data table for all given audio H: files. --- N: stradd -P: DB_READ | DB_WRITE +P: AFS_READ | AFS_WRITE D: add stream U: stradd s H: Add stream s to the list of available streams. The stream @@ -266,34 +267,34 @@ H: A given audio file is admissible for this stream iff its basename H: does not contain the string 'Madonna'. --- N: strdel -P: DB_READ | DB_WRITE +P: AFS_READ | AFS_WRITE D: delete stream U: strdel s H: Remove stream s from database. --- N: streams -P: DB_READ +P: AFS_READ D: list streams U: streams H: Print list of available streams. Use 'cs' to switch to any of H: these. --- N: strq -P: DB_READ +P: AFS_READ D: query stream definition U: strq [s] H: Print definition of stream s to stdout. Use current stream if s was H: not given. --- N: summary -P: DB_READ +P: AFS_READ D: list attributes U: summary H: Print a list of attributes together with number of audio H: files having that attribute set. --- N: upd -P: DB_READ | DB_WRITE +P: AFS_READ | AFS_WRITE D: update database U: upd H: This command uses the --audio_file_dir option of para_server to @@ -302,20 +303,20 @@ H: database. Use this command if you got new files or if you have H: moved some files around. --- N: us -P: DB_READ | DB_WRITE +P: AFS_READ | AFS_WRITE D: update lastplayed time U: us name H: Update lastplayed time without actually playing the thing. --- N: verb -P: DB_READ | DB_WRITE +P: AFS_READ | AFS_WRITE D: send verbatim sql query U: verb cmd H: Send cmd to mysql server. For expert/debugging only. Note that cmd H: usually must be escaped. Use only if you know what you are doing! --- N: vrfy -P: DB_READ +P: AFS_READ D: list invalid entries in database U: vrfy H: Show what clean would delete. Run 'upd' before this command to make