diff options
author | Assim <assim@localhost.localdomain> | 2008-08-13 15:07:46 (GMT) |
---|---|---|
committer | Assim <assim@localhost.localdomain> | 2008-08-13 15:07:46 (GMT) |
commit | 6522cb7a7362f88af476b24e0dbc584c8fb4e792 (patch) | |
tree | aafbb24ddb2603a1564e0e559d2d9aab6a3f2e59 /conv.sh | |
parent | 3dc8eadf78593a060edb120ba4b82e2548e762a6 (diff) |
fixed:restoring speech configuration
Diffstat (limited to 'conv.sh')
-rwxr-xr-x | conv.sh | 43 |
1 files changed, 0 insertions, 43 deletions
diff --git a/conv.sh b/conv.sh deleted file mode 100755 index 55f1874..0000000 --- a/conv.sh +++ /dev/null @@ -1,43 +0,0 @@ - #!/bin/sh - - if [ "x$1" == "x" ]; then - echo "Usage: $0 <dbname>" - exit - fi - - if [ -e "$1.db" ]; then - echo "$1.db already exists. I will overwrite it in 15 seconds if you do not press CTRL-C." - rm $1.db - fi - - mysqldump -h 192.168.145.1 -u AI -p --compact --compatible=ansi --default-character-set=binary $1 | - grep -v ' KEY "' | - grep -v ' UNIQUE KEY "' | - grep -v ' PRIMARY KEY ' | - sed 's/ unsigned / /g' | - sed 's/ auto_increment/ primary key autoincrement/gi' | - sed 's/ smallint([0-9]*) / integer /gi' | - sed 's/ tinyint([0-9]*) / integer /gi' | - sed 's/ int([0-9]*) / integer /gi' | - sed 's/ character set [^ ]* / /gi' | - sed 's/ enum([^)]*) / varchar(255) /gi' | - sed 's/ on update [^,]*//gi' | - perl -e 'local $/;$_=<>;s/,\n\)/\n\)/gs;print "begin;\n";print;print "commit;\n"' | - perl -pe ' - if (/^(INSERT.+?)\(/) { - $a=$1; - s/\\'\''/'\'\''/g; - s/\\n/\n/g; - s/\),\(/\);\n$a\(/g; - } - ' > $1.sql - cat $1.sql | sqlite3 $1.db > $1.err - ERRORS=`cat $1.err | wc -l` - if [ "$ERRORS" == "0" ]; then - echo "Conversion completed without error. Output file: $1.db" - rm $1.sql - rm $1.err - else - echo "There were errors during conversion. Please review $1.err and $1.sql for details." - fi - |