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 |
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 |
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 |
|
} |