diff options
| author | ShinDarth <borzifrancesco@gmail.com> | 2016-11-06 20:02:30 +0100 |
|---|---|---|
| committer | ShinDarth <borzifrancesco@gmail.com> | 2016-11-06 20:02:30 +0100 |
| commit | 5e8a68486b2bfb47280a82965e5b78a218bdbb0a (patch) | |
| tree | 40718f1efc5d72abac82218daa06a034914d116e | |
| parent | 58f24c8933fc76c1e73187b29d977abc92bc5ee2 (diff) | |
Bin/SQL-Generator: fixed macOS import + minor improvements
| -rwxr-xr-x | data/sql/updates/pending_db_auth/create_sql.sh | 12 | ||||
| -rwxr-xr-x | data/sql/updates/pending_db_characters/create_sql.sh | 12 | ||||
| -rwxr-xr-x | data/sql/updates/pending_db_world/create_sql.sh | 12 |
3 files changed, 30 insertions, 6 deletions
diff --git a/data/sql/updates/pending_db_auth/create_sql.sh b/data/sql/updates/pending_db_auth/create_sql.sh index e0ecec83bf..4cbfb18513 100755 --- a/data/sql/updates/pending_db_auth/create_sql.sh +++ b/data/sql/updates/pending_db_auth/create_sql.sh @@ -1,7 +1,15 @@ #!/usr/bin/env bash +unamestr=`uname` +if [[ "$unamestr" == 'Darwin' ]]; then + date='gdate' +else + date='date' +fi + CUR_PATH="$( cd "$( dirname "${BASH_SOURCE[0]}" )/" && pwd )"; -rev=$( date +%s%N ); +rev=$( $date +%s%N ); +filename=rev_"$rev".sql -echo "INSERT INTO version_db_auth(\`sql_rev\`) VALUES ('"$rev"');" > "$CUR_PATH/rev_"$rev".sql" && echo "File created"; +echo "INSERT INTO version_db_auth (\`sql_rev\`) VALUES ('"$rev"');" > "$CUR_PATH/$filename" && echo "File created: $filename"; diff --git a/data/sql/updates/pending_db_characters/create_sql.sh b/data/sql/updates/pending_db_characters/create_sql.sh index 94e9588d0f..e8abae26f2 100755 --- a/data/sql/updates/pending_db_characters/create_sql.sh +++ b/data/sql/updates/pending_db_characters/create_sql.sh @@ -1,7 +1,15 @@ #!/usr/bin/env bash +unamestr=`uname` +if [[ "$unamestr" == 'Darwin' ]]; then + date='gdate' +else + date='date' +fi + CUR_PATH="$( cd "$( dirname "${BASH_SOURCE[0]}" )/" && pwd )"; -rev=$( date +%s%N ); +rev=$( $date +%s%N ); +filename=rev_"$rev".sql -echo "INSERT INTO version_db_characters(\`sql_rev\`) VALUES ('"$rev"');" > "$CUR_PATH/rev_"$rev".sql" && echo "File created"; +echo "INSERT INTO version_db_characters (\`sql_rev\`) VALUES ('"$rev"');" > "$CUR_PATH/$filename" && echo "File created: $filename"; diff --git a/data/sql/updates/pending_db_world/create_sql.sh b/data/sql/updates/pending_db_world/create_sql.sh index 1ec4fae62b..7fcbbea704 100755 --- a/data/sql/updates/pending_db_world/create_sql.sh +++ b/data/sql/updates/pending_db_world/create_sql.sh @@ -1,7 +1,15 @@ #!/usr/bin/env bash +unamestr=`uname` +if [[ "$unamestr" == 'Darwin' ]]; then + date='gdate' +else + date='date' +fi + CUR_PATH="$( cd "$( dirname "${BASH_SOURCE[0]}" )/" && pwd )"; -rev=$( date +%s%N ); +rev=$( $date +%s%N ); +filename=rev_"$rev".sql -echo "INSERT INTO version_db_world(\`sql_rev\`) VALUES ('"$rev"');" > "$CUR_PATH/rev_"$rev".sql" && echo "File created"; +echo "INSERT INTO version_db_world (\`sql_rev\`) VALUES ('"$rev"');" > "$CUR_PATH/$filename" && echo "File created: $filename"; |