X-Git-Url: http://git.tuebingen.mpg.de/?p=paraslash.git;a=blobdiff_plain;f=convert_0.2-0.3.sh;h=19003931056dbdc187da40f303d5ef48197ba458;hp=73b52028b074c7531f3da49adcdbbedaf327f24a;hb=b7b300141c42f1c9c3a60c4a18f804176fb14883;hpb=a8509af9116e9a045ace70ff312e40569c5ace16 diff --git a/convert_0.2-0.3.sh b/convert_0.2-0.3.sh index 73b52028..19003931 100755 --- a/convert_0.2-0.3.sh +++ b/convert_0.2-0.3.sh @@ -29,7 +29,7 @@ host02=localhost # How to connect to para_server 0.3.x. client03=./para_client -port03=2990 +port03=2991 host03=localhost # Unset this to deactivate messages @@ -70,7 +70,7 @@ convert_attribute_table() convert_attributes() { local att atts current_atts cmd query="select dir.dir, dir.name" - exec_client02_cmd laa name dir + exec_client02_cmd laa atts="$result" for att in $atts; do query="$query, data.$att" @@ -138,8 +138,8 @@ Usage: $0 command command is one of the following: - attrbibute_table: create attributes - attrbibutes: convert attributes for each audio file + attribute_table: create attributes + attributes: convert attributes for each audio file lastplayed_numplayed: convert numplayed and lastplayed data of each audio file image_table: retrieve images from mysql and add them to the database @@ -157,10 +157,10 @@ if test $# -ne 1; then fi case "$1" in -attrbibute_table) +attribute_table) convert_attribute_table ;; -attrbibutes) +attributes) convert_attributes ;; lastplayed_numplayed) @@ -178,6 +178,7 @@ all) convert_lastplayed_numplayed convert_image_table convert_image_ids + ;; *) usage exit 1