Initial version of an import module added

git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/trunk@114 e10066b5-e1e2-0310-b819-94efdf66514b

3 files changed, 10 insertions, 11 deletions

diff --git a/muggle-plugin/scripts/gdgentools.pm b/muggle-plugin/scripts/gdgentools.pm
index 3522302..aadc5c7 100755
--- a/muggle-plugin/scripts/gdgentools.pm
+++ b/muggle-plugin/scripts/gdgentools.pm
@@ -12,7 +12,7 @@ package gdgentools;
 
 ### General tool routines
 
-use lib '/home/andi/muggle/import';
+use lib '/home/lvw/Development/muggle-import/scripts';
 use gdparams;
 use IO::Socket;
 
diff --git a/muggle-plugin/scripts/gdimport.pl b/muggle-plugin/scripts/gdimport.pl
index 6c8f548..438b07c 100755
--- a/muggle-plugin/scripts/gdimport.pl
+++ b/muggle-plugin/scripts/gdimport.pl
@@ -16,7 +16,8 @@
 # inclusion of mp3 tracks and a proper update of the database.
 
 
-use lib '/home/andi/muggle/import';
+use lib '/home/lvw/Development/muggle-plugin/scripts';
+#use lib '/home/andi/muggle/import';
 use gdparams;
 use gdgentools;
 use gddb;
diff --git a/muggle-plugin/scripts/make-empty-db b/muggle-plugin/scripts/make-empty-db
index 7157539..59d2c21 100755
--- a/muggle-plugin/scripts/make-empty-db
+++ b/muggle-plugin/scripts/make-empty-db
@@ -1,24 +1,22 @@
 #!/bin/sh
 
-export SCRIPTDIR=/home/andi/muggle/import
+export SCRIPTDIR=/home/lvw/Development/muggle-plugin/scripts
 cd $SCRIPTDIR
 
 echo "creating db"
-mysql < createdb.mysql
+mysql -u root < createdb.mysql
  
 echo "creating tables"
-mysql < $SCRIPTDIR/createtables.mysql
+mysql -u root < $SCRIPTDIR/createtables.mysql
 
 echo "reading genres"
-echo " use GiantDisc; load data local infile '$SCRIPTDIR/genres.txt' into table genre;"| mysql --local-infile=1 
-
+echo " use GiantDisc; load data local infile '$SCRIPTDIR/genres.txt' into table genre;"| mysql -u root --local-infile=1 
 
 echo "reading languages"
-echo "use GiantDisc; load data local infile '$SCRIPTDIR/languages.txt' into table language;" | mysql --local-infile=1
+echo "use GiantDisc; load data local infile '$SCRIPTDIR/languages.txt' into table language;" | mysql -u root --local-infile=1
 
 echo "reading musictypes"
-echo "use GiantDisc; load data local infile '$SCRIPTDIR/musictypes.txt' into table language;" | mysql --local-infile=1
-
+echo "use GiantDisc; load data local infile '$SCRIPTDIR/musictypes.txt' into table language;" | mysql -u root --local-infile=1
 
 echo "reading sources"
-echo "use GiantDisc; load data local infile '$SCRIPTDIR/sources.txt' into table language;" | mysql --local-infile=1
+echo "use GiantDisc; load data local infile '$SCRIPTDIR/sources.txt' into table language;" | mysql -u root --local-infile=1