X-Git-Url: http://git.tuebingen.mpg.de/?p=paraslash.git;a=blobdiff_plain;f=mysql_selector.cmd;h=df88a2203ee96724d31e5e1a0c80addf507972f3;hp=ec58ef1eae95793a6b71892b21a938551a0d671c;hb=1b46ae4193cddb7d589b0f2f7d8158b84f7e9f6d;hpb=7eb8cd4eb71610700e7a7f3fdd877c0b38a8863c diff --git a/mysql_selector.cmd b/mysql_selector.cmd index ec58ef1e..df88a220 100644 --- a/mysql_selector.cmd +++ b/mysql_selector.cmd @@ -3,18 +3,19 @@ HC: prototypes for the commands of the mysql audio file selector CC: array of commands for the mysql audio file selector AT: server_command IN: server user_list +SN: list of mysql selector commands --- N: cam P: DB_READ | DB_WRITE D: copy all metadata -S: cam source dest1 [dest2 ...] +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 D: create database -S: cdb [name] +U: cdb [name] H: H: Create database name containing the initial columns for basic H: interoperation with server. This command has to be used only once @@ -25,7 +26,7 @@ H: The optional name defaults to 'paraslash' if not given. N: clean P: DB_READ | DB_WRITE D: nuke invalid entries in database -S: clean +U: clean H: If the vrfy command shows you any invalid entries in your database, H: you can get rid of them with clean. Always run 'upd' and 'vrfy' H: before running this command. Use with caution! @@ -33,59 +34,59 @@ H: before running this command. Use with caution! N: cs P: VSS_WRITE | DB_READ | DB_WRITE D: change stream -S: cs [s] +U: cs [s] H: Selects stream s or prints current stream when s was not given. --- N: csp P: VSS_WRITE | DB_READ D: change stream and play -S: csp s +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 D: drop attribute from database -S: da att +U: da att H: Use with caution. All info on attribute att will be lost. --- N: hist P: DB_READ D: print history -S: hist +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 D: print database info -S: info [af] +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 D: list attributes -S: la [af] +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 D: list available attributes -S: laa +U: laa H: print list of all attributes defined in the database --- N: last P: DB_READ D: print list of audio files, ordered by lastplayed time -S: last [n] +U: last [n] H: The optional number n defaults to 10 if not specified. --- N: ls P: DB_READ D: list all audio files that match a LIKE pattern -S: ls [pattern] +U: ls [pattern] H: If pattern was not given, print list of all audio files known H: to the mysql selector. See the documentation of mysql H: for the definition of LIKE patterns. @@ -93,7 +94,7 @@ H: for the definition of LIKE patterns. N: mbox P: DB_READ D: dump audio file list in mbox format -S: mbox [p] +U: mbox [p] H: Dump list of audio files in mbox format (email) to stdout. If H: the optional pattern p is given, only those audio files, H: whose basename match p are going to be included. Otherwise, @@ -121,7 +122,7 @@ H: these files are admissable or does whatever thou wilt. N: mv P: DB_READ | DB_WRITE D: rename entry in database -S: mv oldname newname +U: mv oldname newname H: Rename oldname to newname. This updates the data table to reflect H: the new name. All internal data (numplayed, lastplayed, picid,..) H: is kept. If newname is a full path, the dir table is updated as @@ -130,7 +131,7 @@ H: well. N: na P: DB_READ | DB_WRITE D: add new attribute to database -S: na att +U: na att H: This adds a column named att to your mysql database. att should H: only contain letters and numbers, in paricular, '+' and '-' are H: not allowed. @@ -138,7 +139,7 @@ H: not allowed. N: ne P: DB_READ | DB_WRITE D: add new database entries -S: ne file1 [file2 [...]] +U: ne file1 [file2 [...]] H: Add the given filename(s) to the database, where file1,... must H: be full path names. This command might be much faster than 'upd' H: if the number of given files is small. @@ -146,13 +147,13 @@ H: if the number of given files is small. N: ns P: VSS_WRITE | DB_READ | DB_WRITE D: change to next stream -S: ns +U: ns H: Cycle forwards through stream list. --- N: pic P: DB_READ D: get picture by name or by identifier -S: pic [name] +U: pic [name] H: Dump jpg image that is associated to given audio file (current H: audio file if not specified) to stdout. If name starts with H: '#' it is interpreted as an identifier instead and the picture @@ -165,7 +166,7 @@ H: para_client pic '#123' > pic123.jpg N: picadd P: DB_READ | DB_WRITE D: add picture to database -S: picadd [picname] +U: picadd [picname] H: Read jpeg file from stdin and store it as picname in database. H: H: EXAMPLE @@ -175,44 +176,44 @@ H: para_client picadd foo.jpg < foo.jpg N: picass P: DB_READ | DB_WRITE D: associate a picture to file(s) -S: picass pic_id file1 [file2...] +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 D: change name of picture -S: picch id new_name +U: picch id new_name H: Asign new_name to picture with identifier id. --- N: picdel P: DB_READ | DB_WRITE D: delete picture from database -S: picdel id1 [id2...] +U: picdel id1 [id2...] H: Delete each given picture from database. --- N: piclist P: DB_READ D: print list of pictures -S: piclist +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 D: change to previous stream -S: ps +U: ps H: Cycle backwards through stream list. --- N: rm P: DB_READ | DB_WRITE D: remove entries from database -S: rm name1 [name2 [...]] +U: rm name1 [name2 [...]] H: Remove name1, name2, ... from the data table. Use with caution. --- N: sa P: DB_READ | DB_WRITE D: set/unset attributes -S: sa at1<'+' | '-'> [at2<'+' | '-'> ] [af1 ...] +U: sa at1<'+' | '-'> [at2<'+' | '-'> ] [af1 ...] H: Set ('+') or unset ('-') attribute at1, at2 etc. for given list of H: audio files. If no audio files were given the current audio file is H: used. Example: @@ -225,7 +226,7 @@ H: attribute. N: skip P: DB_READ | DB_WRITE D: skip subsequent audio files(s) -S: skip n [s] +U: skip n [s] H: Skip the next n audio files of stream s. This is equivalent to the H: command 'sl n s', followed by 'us name' for each name the output of H: sl. @@ -233,7 +234,7 @@ H: sl. N: sl P: DB_READ D: print score list -S: sl n [s] +U: sl n [s] H: Print sorted list of maximal n lines. Each line is an admissible H: entry with respect to stream s. The list is sorted by score-value H: which is given by the definition of s. If s is not given, the @@ -246,14 +247,14 @@ H: shows you the audio file the server would select right now. N: snp P: DB_READ | DB_WRITE D: set numplayed -S: snp number af1 [af2 ...] +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 D: add stream -S: stradd s +U: stradd s H: Add stream s to the list of available streams. The stream H: definition for s is read from stdin and is then sent to H: para_server. Example: @@ -267,34 +268,34 @@ H: does not contain the string 'Madonna'. N: strdel P: DB_READ | DB_WRITE D: delete stream -S: strdel s +U: strdel s H: Remove stream s from database. --- N: streams P: DB_READ D: list streams -S: streams +U: streams H: Print list of available streams. Use 'cs' to switch to any of H: these. --- N: strq P: DB_READ D: query stream definition -S: strq [s] +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 D: list attributes -S: summary +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 D: update database -S: upd +U: upd H: This command uses the --audio_file_dir option of para_server to H: locate your audio files. New files are then added to the mysql H: database. Use this command if you got new files or if you have @@ -303,20 +304,20 @@ H: moved some files around. N: us P: DB_READ | DB_WRITE D: update lastplayed time -S: us name +U: us name H: Update lastplayed time without actually playing the thing. --- N: verb P: DB_READ | DB_WRITE D: send verbatim sql query -S: verb cmd +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 D: list invalid entries in database -S: vrfy +U: vrfy H: Show what clean would delete. Run 'upd' before this command to make H: sure your database is up to date. ---