From 2370a13b7f6512147550e5eec8a773e69d49119b Mon Sep 17 00:00:00 2001 From: lvw Date: Fri, 28 May 2004 15:30:48 +0000 Subject: Merged and added import scripts git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/trunk/muggle-plugin@99 e10066b5-e1e2-0310-b819-94efdf66514b --- scripts/make-empty-db | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100755 scripts/make-empty-db (limited to 'scripts/make-empty-db') diff --git a/scripts/make-empty-db b/scripts/make-empty-db new file mode 100755 index 0000000..7157539 --- /dev/null +++ b/scripts/make-empty-db @@ -0,0 +1,24 @@ +#!/bin/sh + +export SCRIPTDIR=/home/andi/muggle/import +cd $SCRIPTDIR + +echo "creating db" +mysql < createdb.mysql + +echo "creating tables" +mysql < $SCRIPTDIR/createtables.mysql + +echo "reading genres" +echo " use GiantDisc; load data local infile '$SCRIPTDIR/genres.txt' into table genre;"| mysql --local-infile=1 + + +echo "reading languages" +echo "use GiantDisc; load data local infile '$SCRIPTDIR/languages.txt' into table language;" | mysql --local-infile=1 + +echo "reading musictypes" +echo "use GiantDisc; load data local infile '$SCRIPTDIR/musictypes.txt' into table language;" | mysql --local-infile=1 + + +echo "reading sources" +echo "use GiantDisc; load data local infile '$SCRIPTDIR/sources.txt' into table language;" | mysql --local-infile=1 -- cgit v1.2.3 From 622c22ea45654d4741a900fa078bafa947b24177 Mon Sep 17 00:00:00 2001 From: lvw Date: Mon, 23 Aug 2004 06:36:25 +0000 Subject: Initial version of an import module added git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/trunk/muggle-plugin@114 e10066b5-e1e2-0310-b819-94efdf66514b --- scripts/make-empty-db | 16 +++++++--------- 1 file changed, 7 insertions(+), 9 deletions(-) (limited to 'scripts/make-empty-db') diff --git a/scripts/make-empty-db b/scripts/make-empty-db index 7157539..59d2c21 100755 --- a/scripts/make-empty-db +++ b/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 -- cgit v1.2.3 From 27a9843da016ffb5d2d36f03b3ae20776528989b Mon Sep 17 00:00:00 2001 From: lvw Date: Sun, 29 Aug 2004 14:07:53 +0000 Subject: Cleaned up input helper scripts git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/trunk/muggle-plugin@126 e10066b5-e1e2-0310-b819-94efdf66514b --- scripts/make-empty-db | 13 +++++-------- 1 file changed, 5 insertions(+), 8 deletions(-) (limited to 'scripts/make-empty-db') diff --git a/scripts/make-empty-db b/scripts/make-empty-db index 59d2c21..3acb512 100755 --- a/scripts/make-empty-db +++ b/scripts/make-empty-db @@ -1,22 +1,19 @@ #!/bin/sh -export SCRIPTDIR=/home/lvw/Development/muggle-plugin/scripts -cd $SCRIPTDIR - echo "creating db" mysql -u root < createdb.mysql echo "creating tables" -mysql -u root < $SCRIPTDIR/createtables.mysql +mysql -u root < createtables.mysql echo "reading genres" -echo " use GiantDisc; load data local infile '$SCRIPTDIR/genres.txt' into table genre;"| mysql -u root --local-infile=1 +echo " use GiantDisc; load data local infile '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 -u root --local-infile=1 +echo "use GiantDisc; load data local infile '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 -u root --local-infile=1 +echo "use GiantDisc; load data local infile '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 -u root --local-infile=1 +echo "use GiantDisc; load data local infile 'sources.txt' into table language;" | mysql -u root --local-infile=1 -- cgit v1.2.3 From 19b5fbe6f03d263ab8e427022156ed7d2bfcaea1 Mon Sep 17 00:00:00 2001 From: wr61 Date: Fri, 4 Feb 2005 17:08:13 +0000 Subject: fix import of sourc and musictype tables git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/trunk/muggle-plugin@435 e10066b5-e1e2-0310-b819-94efdf66514b --- scripts/make-empty-db | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'scripts/make-empty-db') diff --git a/scripts/make-empty-db b/scripts/make-empty-db index 3acb512..92ccf75 100755 --- a/scripts/make-empty-db +++ b/scripts/make-empty-db @@ -13,7 +13,7 @@ echo "reading languages" echo "use GiantDisc; load data local infile 'languages.txt' into table language;" | mysql -u root --local-infile=1 echo "reading musictypes" -echo "use GiantDisc; load data local infile 'musictypes.txt' into table language;" | mysql -u root --local-infile=1 +echo "use GiantDisc; load data local infile 'musictypes.txt' into table musictype;" | mysql -u root --local-infile=1 echo "reading sources" -echo "use GiantDisc; load data local infile 'sources.txt' into table language;" | mysql -u root --local-infile=1 +echo "use GiantDisc; load data local infile 'sources.txt' into table source;" | mysql -u root --local-infile=1 -- cgit v1.2.3