1. #!/bin/bash
2. #========================================
3. #           Global Variables            
4. #========================================
5. APG_HOME=/opt/APG
6.  
7. #==================
8. # MYSQL Variables
9. #==================
10. MYSQL_DIR="${APG_HOME}/Databases/MySQL/Default"
11. #==================
12. MYSQL_EXEC="${MYSQL_DIR}/bin/mysql"  
13. MYSQL_HOST="127.0.0.1"  # Can be changed via options
14. MYSQL_PORT="53306"      # Can be changed via options
15. MYSQL_USER="root"       # Can be changed via options
16. MYSQL_PASS="watch4net"  # Can be changed via options
17. MYSQL_DATA="apg"        # Can be changed via options
18. MYSQL_QUERY_EXEC="${MYSQL_EXEC} -P${MYSQL_PORT} -h ${MYSQL_HOST} -N -u ${MYSQL_USER} -p${MYSQL_PASS} -D ${MYSQL_DATA} -se "
19. CG_AGGREGATE=900
20.  
21. function get_cache_table(){
22.  
23.   DB="$1"
24.   AG="$2"
25.  
26.   cecho "--> BEGIN function get_cache_table"
27.   cecho "  DB=${DB}"  
28.   cecho "  AG=${AG}"  
29.  
30.   if ! [[ "${AG}" == "0" ||
31.           "${AG}" == "600" ||
32.           "${AG}" == "3600" ||
33.           "${AG}" == "86400" ||
34.           "${AG}" == "604800" ]] ; then
35.     AG="0"
36.   fi  
37.   cecho "  AG(finale)=${AG}"    
38.   CACHE_TABLES=($(${MYSQL_QUERY_EXEC} "SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA='${DB}' AND TABLE_NAME like 'cache_group_${AG}%';"))    
39.  
40.   cecho "<-- END function get_cache_table"
41. }
42.  
43. "${MYSQL_DATA}" "${CG_AGGREGATE}"