Remaker

sqlite에서 양력정보와 음력정보 // 음력 정보인 경우 양력 정보로 나타내기 SELECT _id, cust_id, event_type, CASE event_flag WHEN '2' THEN SUBSTR(event_date, 0, 6)||'05-04' ELSE event_date END as event_date, event_flag, event_label FROM event_info WHERE event_type = '3' AND ( (SUBSTR(event_date, 6, 5) >= '05-04' /* 양력 날짜  */ AND event_flag =  1  ) OR (SUBSTR(event_date, 6, 5) >= '03-14' /* 음력 날짜  */ AND event_flag =  2  ) )

tomcat httpd memory check shell echo "# httpd" ps -eo pmem,pcpu,rss,vsize,args | sort -k 1 -r| grep httpd| awk 'BEGIN{sum=0; print"-Memory:";}{sum+=$1}END{print sum"%"}' echo "# tomcat" ps -eo pmem,pcpu,rss,vsize,args | sort -k 1 -r| grep tomcat | awk 'BEGIN{sum=0; print"-Memory:";}{sum+=$1}END{print sum"%"}'