diff options
| author | horchi <vdr@jwendel.de> | 2018-10-04 10:38:40 +0200 |
|---|---|---|
| committer | horchi <vdr@jwendel.de> | 2018-10-04 10:38:40 +0200 |
| commit | e075382d665b60f0456cf9c3a6f6de120809cb2b (patch) | |
| tree | b9b665c61339fe5289f0cbef33e0e1568ce52b85 /scripts | |
| parent | e8781e497a86af36db0aa595f8322f2947815fc3 (diff) | |
| download | vdr-epg-daemon-1.1.145.tar.gz vdr-epg-daemon-1.1.145.tar.bz2 | |
2018-10-04: version 1.1.145 (horchi)\n change: Optimized mysql password handling in epgd scripts\n\n1.1.145
Diffstat (limited to 'scripts')
| -rwxr-xr-x | scripts/epgd-conflictsof | 3 | ||||
| -rwxr-xr-x | scripts/epgd-dropall | 3 | ||||
| -rwxr-xr-x | scripts/epgd-import-epglv | 7 | ||||
| -rwxr-xr-x | scripts/epgd-showdones | 3 | ||||
| -rwxr-xr-x | scripts/epgd-showmerge | 3 | ||||
| -rwxr-xr-x | scripts/epgd-showtimer | 3 | ||||
| -rwxr-xr-x | scripts/epgd-showtimerat | 3 |
7 files changed, 15 insertions, 10 deletions
diff --git a/scripts/epgd-conflictsof b/scripts/epgd-conflictsof index e21c47f..5e427d1 100755 --- a/scripts/epgd-conflictsof +++ b/scripts/epgd-conflictsof @@ -1,6 +1,7 @@ #!/bin/bash -export MYSQL_PWD=epg +MYSQL_PWD=${MYSQL_PWD:-epg} +export MYSQL_PWD if [ -z $1 ]; then exit diff --git a/scripts/epgd-dropall b/scripts/epgd-dropall index 5ebfe47..65ef65b 100755 --- a/scripts/epgd-dropall +++ b/scripts/epgd-dropall @@ -1,6 +1,7 @@ #!/bin/bash -export MYSQL_PWD=epg +MYSQL_PWD=${MYSQL_PWD:-epg} +export MYSQL_PWD echo "------------------------" echo "-- Drop normal tables --" diff --git a/scripts/epgd-import-epglv b/scripts/epgd-import-epglv index 2d9df0c..27aeb1b 100755 --- a/scripts/epgd-import-epglv +++ b/scripts/epgd-import-epglv @@ -1,8 +1,7 @@ -#!/bin/bash +#!/bin/bash -if [ -z MYSQL_PWD ]; then - export MYSQL_PWD=epg -fi +MYSQL_PWD=${MYSQL_PWD:-epg} +export MYSQL_PWD mysql -u root -e "DROP FUNCTION IF EXISTS epglv;" mysql -u root -e "DROP FUNCTION IF EXISTS epglvr;" diff --git a/scripts/epgd-showdones b/scripts/epgd-showdones index 86cd7b4..2616dc5 100755 --- a/scripts/epgd-showdones +++ b/scripts/epgd-showdones @@ -1,6 +1,7 @@ #!/bin/bash -export MYSQL_PWD=epg +MYSQL_PWD=${MYSQL_PWD:-epg} +export MYSQL_PWD mysql -u epg2vdr -Depg2vdr -e " \ select from_unixtime(updsp, '%d.%m %H:%m') as upd, id, state as s, substr(title,1,35), shorttext, episodecompname, episodecomppartname, expression from timersdone where state != 'D';" diff --git a/scripts/epgd-showmerge b/scripts/epgd-showmerge index 5f06f71..e226308 100755 --- a/scripts/epgd-showmerge +++ b/scripts/epgd-showmerge @@ -1,6 +1,7 @@ #!/bin/bash -export MYSQL_PWD=epg +MYSQL_PWD=${MYSQL_PWD:-epg} +export MYSQL_PWD if [ "$1" == "-h" ]; then diff --git a/scripts/epgd-showtimer b/scripts/epgd-showtimer index 5425caf..207283f 100755 --- a/scripts/epgd-showtimer +++ b/scripts/epgd-showtimer @@ -1,6 +1,7 @@ #!/bin/bash -export MYSQL_PWD=epg +MYSQL_PWD=${MYSQL_PWD:-epg} +export MYSQL_PWD if [ -z $1 ]; then STATE="(t.state != 'D' or t.state is null)" diff --git a/scripts/epgd-showtimerat b/scripts/epgd-showtimerat index bdc6d1d..57c579c 100755 --- a/scripts/epgd-showtimerat +++ b/scripts/epgd-showtimerat @@ -1,6 +1,7 @@ #!/bin/bash -export MYSQL_PWD=epg +MYSQL_PWD=${MYSQL_PWD:-epg} +export MYSQL_PWD mysql -u epg2vdr -Depg2vdr -e " \ select t.id, SUBSTRING_INDEX(t.channelid, '-', 3) as transponder, v.name, t.source, t.channelid, t.state as S, \ |