2022-10-12

1.中断时钟

#include <stdio.h>
#include <time.h>
#include <unistd.h>
#include <stdlib.h>
#include <pthread.h>
void *callback(void *arg)
{
    char *flag = (char *)arg;
    time_t tim = time(NULL);
    while('q' != *flag)
    {
        system("clear");
        time(&tim);
        struct tm *now = localtime(&tim);
        printf("时间:%02d:%02d:%02d\n" \
                    ,now->tm_hour \
                    ,now->tm_min \
                    ,now->tm_sec);
        sleep(1);
    }
}
int main(int argc,const char *argv[])
{
    char flag = ' ';
    pthread_t tid;
    if(0 != pthread_create(&tid,NULL,callback,&flag))
    {   
        perror("pthread");
        return -1;
    }
    while('q' != getchar());
   return 0;
}

2.僵尸进程

#include <stdio.h>
#include <time.h>
#include <unistd.h>
#include <stdlib.h>
#include <pthread.h>

int main(int argc,const char *argv[])
{
    pid_t pid = fork();
    if(0 > pid)
    {
        perror("fork");
        return -1;
    }
    else if(0 == pid)
    {
        printf("子进程结束\n");
    }
    else
    {
        while(1)
        {
            printf("主进程运行中\n");
            sleep(1);
        }
        printf("主进程结束\n");
    }
    
   return 0;
}

3.孤儿进程

#include <stdio.h>
#include <time.h>
#include <unistd.h>
#include <stdlib.h>
#include <pthread.h>

int main(int argc,const char *argv[])
{
    pid_t pid = fork();
    if(0 > pid)
    {
        perror("fork");
        return -1;
    }
    else if(0 == pid)
    {
        while(1)
        {
            printf("子进程结束\n");
        }
    }
    else
    {
        printf("主进程结束\n");
    }
    
   return 0;
}

3.守卫进程

#include <stdio.h>
#include <time.h>
#include <unistd.h>
#include <stdlib.h>
#include <pthread.h>
#include <unistd.h>
#include <sys/types.h>
#include <sys/stat.h>
int main(int argc,const char *argv[])
{
    pid_t pid = fork();
    if(0 > pid)
    {
        perror("fork");
        return -1;
    }
    else if(0 == pid)
    {
        setsid();
        chdir("/");
        umask(0);
        for(int i = 0;i < 1024;i++)
        {
            close(i);
        }
        while(1)
        {
            printf("--------\n");
        }
    }
    else
    {
        printf("子进程pid = %d\n",pid);
        printf("主进程结束\n");
    }
    
   return 0;
}

优化代码,并提供新脚本SELECT SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' AND is_new_customer = 1 THEN 1 ELSE 0 END) AS new_customer_count, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' AND is_new_customer = 0 THEN 1 ELSE 0 END) AS old_customer_count, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' AND is_new_customer = 1 THEN payment_amount ELSE 0 END) AS new_customer_payment_amount, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' AND is_new_customer = 0 THEN payment_amount ELSE 0 END) AS old_customer_payment_amount, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' THEN CASE WHEN category = 'A' THEN 1 ELSE 0 END ELSE 0 END) AS category_A_customer_count, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' THEN CASE WHEN category = 'A' THEN payment_amount ELSE 0 END ELSE 0 END) AS category_A_payment_amount, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' THEN CASE WHEN category = 'B' THEN 1 ELSE 0 END ELSE 0 END) AS category_B_customer_count, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' THEN CASE WHEN category = 'B' THEN payment_amount ELSE 0 END ELSE 0 END) AS category_B_payment_amount, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' THEN CASE WHEN product_id = 'P1' THEN 1 ELSE 0 END ELSE 0 END) AS product_P1_customer_count, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' THEN CASE WHEN product_id = 'P1' THEN payment_amount ELSE 0 END ELSE 0 END) AS product_P1_payment_amount FROM orders WHERE (order_date BETWEEN '2022-10-31' AND '2022-11-11') OR (order_date BETWEEN '2021-10-31' AND '2022-10-30' AND order_date NOT IN (SELECT order_date FROM orders WHERE order_date BETWEEN '2022-10-31' AND '2022-11-11')) OR (order_date BETWEEN '2021-11-12' AND '2022-10-30' AND order_date IN (SELECT order_date FROM orders WHERE order_date BETWEEN '2022-10-31' AND '2022-11-11'))
05-25
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值