X-Git-Url: http://git.tuebingen.mpg.de/?p=paraslash.git;a=blobdiff_plain;f=convert_0.2-0.3.sh;h=24c937b9494188048ff61dea8a985d98744e281d;hp=73b52028b074c7531f3da49adcdbbedaf327f24a;hb=24e2b57dde50a6fe33deee034d34181eece09834;hpb=a8509af9116e9a045ace70ff312e40569c5ace16 diff --git a/convert_0.2-0.3.sh b/convert_0.2-0.3.sh index 73b52028..24c937b9 100755 --- a/convert_0.2-0.3.sh +++ b/convert_0.2-0.3.sh @@ -1,4 +1,4 @@ -#!/bin/bash +#!/usr/bin/env bash #------------------------------------------------------------------------------- ## Script to convert the database of paraslash 0.2.x to version 0.3.x. @@ -24,7 +24,7 @@ # How to connect to para_server 0.2.x. client02=/usr/local/bin/para_client -port02=2990 +port02=2991 host02=localhost # How to connect to para_server 0.3.x. @@ -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