Magellan Linux

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

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

revision 2151 by niro, Tue May 17 10:54:35 2011 UTC revision 2152 by niro, Tue May 17 21:33:57 2011 UTC
# Line 157  evaluate_table() Line 157  evaluate_table()
157   where_statement="$2"   where_statement="$2"
158   fi   fi
159    
160   export eval $(mysql \   eval $(mysql \
161   --user="${SQL_USER}" \   --user="${SQL_USER}" \
162   --password="${SQL_PASS}" \   --password="${SQL_PASS}" \
163   --host="${SQL_HOST}" \   --host="${SQL_HOST}" \
# Line 165  evaluate_table() Line 165  evaluate_table()
165   --xml \   --xml \
166   --execute="select * from ${table} ${where_statement}" \   --execute="select * from ${table} ${where_statement}" \
167   | xml sel -T -t -m //row/field \   | xml sel -T -t -m //row/field \
168   -v "concat('${table}_', @name, '=', '\"' ,self::field, '\"')" -n)   -v "concat('${table}_', @name, '=', '\"', self::field, '\"')" -n)
169  }  }
170    
171  # runs a statement and evaluate the resulting columns  # runs a statement and evaluate the resulting columns
# Line 184  evaluate_statement() Line 184  evaluate_statement()
184   prefix="${prefix}_"   prefix="${prefix}_"
185   fi   fi
186    
187   export eval $(mysql \   eval $(mysql \
188   --user="${SQL_USER}" \   --user="${SQL_USER}" \
189   --password="${SQL_PASS}" \   --password="${SQL_PASS}" \
190   --host="${SQL_HOST}" \   --host="${SQL_HOST}" \

Legend:
Removed from v.2151  
changed lines
  Added in v.2152