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_20060908/alxconfig-ng/functions/mysqlfunctions revision 543 by niro, Wed Feb 4 19:51:39 2009 UTC
    # Line 6  Line 6 
    6  #  #
    7  # Niels Rogalla <niro@magellan-linux.de>  # Niels Rogalla <niro@magellan-linux.de>
    8  #  #
    9  # $Header: /home/cvsd/alx-cvs/alx-src/alxconfig-ng/functions/mysqlfunctions,v 1.3 2005-04-12 20:45:55 niro Exp $  # $Header: /home/cvsd/alx-cvs/alx-src/alxconfig-ng/functions/mysqlfunctions,v 1.8 2005-10-09 21:32:33 niro Exp $
    10    
    11  mysql_command(){  mysql_command()
    12    {
    13    
    14   local SQL_USER   local SQL_USER
    15   local SQL_PASS   local SQL_PASS
    # Line 49  mysql_command(){ Line 50  mysql_command(){
    50   return 0   return 0
    51  }  }
    52    
    53  mysql_enum_colums(){  mysql_enum_colums()
    54    {
    55   local SQL_USER   local SQL_USER
    56   local SQL_PASS   local SQL_PASS
    57   local SQL_HOST   local SQL_HOST
    # Line 104  $(mysql_command ${SQL_USER} ${SQL_PASS} Line 106  $(mysql_command ${SQL_USER} ${SQL_PASS}
    106  EOF  EOF
    107   [ "${SHOWTABLES}" == true ] || echo "${i}"   [ "${SHOWTABLES}" == true ] || echo "${i}"
    108  }  }
    109    
    110    beep3x()
    111    {
    112     echo -en "\a"
    113     sleep 0.7
    114     echo -en "\a"
    115     sleep 0.7
    116     echo -en "\a"
    117    }
    118    
    119    reach_mysql_server()
    120    {
    121     # set connection timeout to 20 secs
    122     mysql --connect_timeout=20 \
    123     --user="${SQL_USER}" \
    124     --password="${SQL_PASS}" \
    125     --host="${SQL_HOST}" \
    126     --database="${SQL_DB}" \
    127     --batch \
    128     --execute="" &> /dev/null && return 0 || \
    129     (
    130     echo -e ${COLRED}
    131     echo "Cannot reach a mysql-server at '${SQL_HOST}'."
    132     echo "None of the current settings of this client will be touched."
    133     echo "Please inform your system-administrator."
    134     echo -e ${COLDEFAULT}
    135     beep3x
    136     sleep 5
    137     return 1
    138     )
    139    }
    140    
    141    mysqldo()
    142    {
    143     mysql_command \
    144     "${SQL_USER}" \
    145     "${SQL_PASS}" \
    146     "${SQL_HOST}" \
    147     "${SQL_DB}" \
    148     "$@" \
    149     && return 0 || return 1
    150    }
    Legend:
    Removed from v.239  
    changed lines
      Added in v.543