发布一个k8s部署视频:https://edu.csdn.net/course/detail/26967
课程内容:各种k8s部署方式。包括minikube部署,kubeadm部署,kubeasz部署,rancher部署,k3s部署。包括开发测试环境部署k8s,和生产环境部署k8s。
腾讯课堂连接地址https://ke.qq.com/course/478827?taid=4373109931462251&tuin=ba64518
第二个视频发布 https://edu.csdn.net/course/detail/27109
腾讯课堂连接地址https://ke.qq.com/course/484107?tuin=ba64518
介绍主要的k8s资源的使用配置和命令。包括configmap,pod,service,replicaset,namespace,deployment,daemonset,ingress,pv,pvc,sc,role,rolebinding,clusterrole,clusterrolebinding,secret,serviceaccount,statefulset,job,cronjob,podDisruptionbudget,podSecurityPolicy,networkPolicy,resourceQuota,limitrange,endpoint,event,conponentstatus,node,apiservice,controllerRevision等。
第三个视频发布:https://edu.csdn.net/course/detail/27574
详细介绍helm命令,学习helm chart语法,编写helm chart。深入分析各项目源码,学习编写helm插件
————————————————------------------------------------------------------------------------------------------------------------------
惊天写的sql语句
select '首次检查提醒' taskType,(a.sum+b.sum)as sum,(a.finishSum+b.finishsum)as finishSum,
(a.nonFinishSum+b.nonFinishSum)as nonFinishSum
from (select
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=1)sum,
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=1 and ct.status=5)finishSum,
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=1 and ct.status!=5)nonFinishSum
from dual)a,
(select
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=1)sum,
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=1 and ct.status=5)finishSum,
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=1 and ct.status!=5)nonFinishSum from dual)b
union
select '首次检查预警' taskType,(a.sum+b.sum)as sum,(a.finishSum+b.finishsum)as finishSum,
(a.nonFinishSum+b.nonFinishSum)as nonFinishSum
from (select
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=2)sum,
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=2 and ct.status=5)finishSum,
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=2 and ct.status!=5)nonFinishSum
from dual)a,
(select
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=2)sum,
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=2 and ct.status=5)finishSum,
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=2 and ct.status!=5)nonFinishSum from dual)b
union
select '定期检查' taskType,(a.sum+b.sum)as sum,(a.finishSum+b.finishsum)as finishSum,
(a.nonFinishSum+b.nonFinishSum)as nonFinishSum
from (select
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=3)sum,
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=3 and ct.status=5)finishSum,
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=3 and ct.status!=5)nonFinishSum
from dual)a,
(select
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=3)sum,
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=3 and ct.status=5)finishSum,
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=3 and ct.status!=5)nonFinishSum from dual)b
union
select '不定期检查' taskType,(a.sum+b.sum)as sum,(a.finishSum+b.finishsum)as finishSum,
(a.nonFinishSum+b.nonFinishSum)as nonFinishSum
from (select
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=4)sum,
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=4 and ct.status=5)finishSum,
(select count(*) from client_check_c_task ct where ct.checker_userid='00000000'
and ct.tasktype=4 and ct.status!=5)nonFinishSum
from dual)a,
(select
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=4)sum,
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=4 and ct.status=5)finishSum,
(select count(*) from client_check_p_task ct where ct.checker_userid='00000000'
and ct.tasktype=4 and ct.status!=5)nonFinishSum from dual)b