Magellan Linux

  • Back to homepage
    • /[alx-svn]/alx-src/branches/alxconf-060/functions/mysqlfunctions

    Diff of /alx-src/branches/alxconf-060/functions/mysqlfunctions

    Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

    alx-src/trunk/alxconfig-ng/functions/mysqlfunctions revision 239 by niro, Tue Apr 12 20:46:52 2005 UTC alx-src/branches/alxconf-060/functions/mysqlfunctions revision 2003 by niro, Mon May 9 14:52:38 2011 UTC
    # Line 1  Line 1 
    1  #!/bin/bash  # $Id$
    2    # mysql functions for bash
    3    
    4  #  mysql_command()
    5  # mysql functions for the bash  {
     # Version 0.1  
     #  
     # Niels Rogalla <niro@magellan-linux.de>  
     #  
     # $Header: /home/cvsd/alx-cvs/alx-src/alxconfig-ng/functions/mysqlfunctions,v 1.3 2005-04-12 20:45:55 niro Exp $  
       
     mysql_command(){  
    6    
    7   local SQL_USER   local SQL_USER
    8   local SQL_PASS   local SQL_PASS
    # Line 16  mysql_command(){ Line 10  mysql_command(){
    10   local SQL_DB   local SQL_DB
    11   local SQL_COMMAND   local SQL_COMMAND
    12    
    13   SQL_USER=$1   SQL_USER="$1"
    14   SQL_PASS=$2   SQL_PASS="$2"
    15   SQL_HOST=$3   SQL_HOST="$3"
    16   SQL_DB=$4   SQL_DB="$4"
    17   SQL_COMMAND=$5   SQL_COMMAND="$5"
    18    
    19   #fallback (SQL_OPTS not, they are optional )   # fallback (SQL_OPTS not, they are optional )
    20   if [ -z "${SQL_USER}" \   if [ -z "${SQL_USER}" \
    21   -o -z "${SQL_PASS}" \   -o -z "${SQL_PASS}" \
    22   -o -z "${SQL_HOST}" \   -o -z "${SQL_HOST}" \
    # Line 35  mysql_command(){ Line 29  mysql_command(){
    29   echo   echo
    30   return 1   return 1
    31   fi   fi
    32    
    33   mysql \   mysql \
    34   --user="${SQL_USER}" \   --user="${SQL_USER}" \
    35   --password="${SQL_PASS}" \   --password="${SQL_PASS}" \
    # Line 45  mysql_command(){ Line 39  mysql_command(){
    39   --skip-column-names \   --skip-column-names \
    40   --execute="${SQL_COMMAND}" \   --execute="${SQL_COMMAND}" \
    41   || return 1   || return 1
    42    
    43   return 0   return 0
    44  }  }
    45    
    46  mysql_enum_colums(){  mysql_enum_colums()
    47    {
    48   local SQL_USER   local SQL_USER
    49   local SQL_PASS   local SQL_PASS
    50   local SQL_HOST   local SQL_HOST
    # Line 65  mysql_enum_colums(){ Line 60  mysql_enum_colums(){
    60   local key   local key
    61   local default   local default
    62   local extra   local extra
    63    
    64   SQL_USER=$1   SQL_USER=$1
    65   SQL_PASS=$2   SQL_PASS=$2
    66   SQL_HOST=$3   SQL_HOST=$3
    67   SQL_DB=$4   SQL_DB=$4
    68   SQL_TABLE=$5   SQL_TABLE=$5
    69    
    70   #show the column names ?   # show the column names ?
    71   if [ -n "${6}" -a "${6}" == "show" ]   if [ -n "${6}" -a "${6}" == "show" ]
    72   then   then
    73   SHOWTABLES=true   SHOWTABLES=true
    # Line 80  mysql_enum_colums(){ Line 75  mysql_enum_colums(){
    75   SHOWTABLES=false   SHOWTABLES=false
    76   fi   fi
    77    
    78   #fallback (SQL_OPTS not, they are optional )   # fallback (SQL_OPTS not, they are optional )
    79   if [ -z "${SQL_USER}" \   if [ -z "${SQL_USER}" \
    80   -o -z "${SQL_PASS}" \   -o -z "${SQL_PASS}" \
    81   -o -z "${SQL_HOST}" \   -o -z "${SQL_HOST}" \
    # Line 104  $(mysql_command ${SQL_USER} ${SQL_PASS} Line 99  $(mysql_command ${SQL_USER} ${SQL_PASS}
    99  EOF  EOF
    100   [ "${SHOWTABLES}" == true ] || echo "${i}"   [ "${SHOWTABLES}" == true ] || echo "${i}"
    101  }  }
    102    
    103    beep3x()
    104    {
    105     echo -en "\a"
    106     sleep 0.7
    107     echo -en "\a"
    108     sleep 0.7
    109     echo -en "\a"
    110    }
    111    
    112    reach_mysql_server()
    113    {
    114     # set connection timeout to 20 secs
    115     mysql --connect_timeout=20 \
    116     --user="${SQL_USER}" \
    117     --password="${SQL_PASS}" \
    118     --host="${SQL_HOST}" \
    119     --database="${SQL_DB}" \
    120     --batch \
    121     --execute="" &> /dev/null && return 0 || \
    122     (
    123     echo -e ${COLRED}
    124     echo "Cannot reach a mysql-server at '${SQL_HOST}'."
    125     echo "None of the current settings of this client will be touched."
    126     echo "Please inform your system-administrator."
    127     echo -e ${COLDEFAULT}
    128     beep3x
    129     sleep 5
    130     return 1
    131     )
    132    }
    133    
    134    mysqldo()
    135    {
    136     mysql_command \
    137     "${SQL_USER}" \
    138     "${SQL_PASS}" \
    139     "${SQL_HOST}" \
    140     "${SQL_DB}" \
    141     "$@" \
    142     && return 0 || return 1
    143    }
    Legend:
    Removed from v.239  
    changed lines
      Added in v.2003