Assign the task HDU - 3974 (dfs序+线段树)

本文介绍了一种用于解决公司员工任务分配问题的算法。在一个由N名员工构成的组织结构中,每名员工都有一个直接上级(除了公司领导)。当公司向某员工分配任务时,该任务将被传递给其所有下属,形成一种树状结构的任务传播方式。文章提供了一个基于DFS序和线段树的解决方案,通过区间修改和单点查询来快速确定员工当前正在执行的任务。

There is a company that has N employees(numbered from 1 to N),every employee in the company has a immediate boss (except for the leader of whole company).If you are the immediate boss of someone,that person is your subordinate, and all his subordinates are your subordinates as well. If you are nobody's boss, then you have no subordinates,the employee who has no immediate boss is the leader of whole company.So it means the N employees form a tree. 

The company usually assigns some tasks to some employees to finish.When a task is assigned to someone,He/She will assigned it to all his/her subordinates.In other words,the person and all his/her subordinates received a task in the same time. Furthermore,whenever a employee received a task,he/she will stop the current task(if he/she has) and start the new one. 

Write a program that will help in figuring out some employee’s current task after the company assign some tasks to some employee.

Input

The first line contains a single positive integer T( T <= 10 ), indicates the number of test cases. 

For each test case: 

The first line contains an integer N (N ≤ 50,000) , which is the number of the employees. 

The following N - 1 lines each contain two integers u and v, which means the employee v is the immediate boss of employee u(1<=u,v<=N). 

The next line contains an integer M (M ≤ 50,000). 

The following M lines each contain a message which is either 

"C x" which means an inquiry for the current task of employee x 

or 

"T x y"which means the company assign task y to employee x. 

(1<=x<=N,0<=y<=10^9)

Output

For each test case, print the test case number (beginning with 1) in the first line and then for every inquiry, output the correspond answer per line.

Sample Input

1 
5 
4 3 
3 2 
1 3 
5 2 
5 
C 3 
T 2 1
 C 3 
T 3 2 
C 3

Sample Output

Case #1:
-1 
1 
2

题意

给您一个数,两种操作(1) 查询x的颜色(2)把x节点即子节点染成y

思路

先用dfs序建立线段树,区间修改单点查询

#include <bits/stdc++.h>

using namespace std;
const int maxn = 5e4+7;
int n,m;
vector<int> adj[maxn];
int len[maxn],tree[maxn],lazy[maxn<<2],a[maxn];
bool vis[maxn];
int dfs(int u)
{
    tree[u]=++m;
    int res=1;
    for(int i=0;i<adj[u].size();i++)
    {
        int v = adj[u][i];
        if(vis[v]) continue;
        vis[v] = true;
        res += dfs(v);
    }
    return len[u] = res;
}
void push_down(int now)
{
    if(lazy[now] == -1) return ;
    lazy[now<<1] = lazy[now<<1|1] = lazy[now];
    lazy[now] = -1;
}
void updata(int now,int l,int r,int ul,int ur,int t)
{
    if(ul<=l&&ur>=r)
    {
        lazy[now] = t;
        return ;
    }
    push_down(now);
    int m = (l+r)>>1;
    if(ul <= m) updata(now<<1,l,m,ul,ur,t);
    if(ur > m) updata(now<<1|1,m+1,r,ul,ur,t);
}
int query(int now,int l,int r,int p)
{
    if(l==r) return lazy[now];
    int m = (l+r)>>1;
    push_down(now);
    if(p<=m) return query(now<<1,l,m,p);
    else return query(now<<1|1,m+1,r,p);
}

int main()
{
    int t,i,j;
    scanf("%d",&t);
    int ca=1;
    while(t--)
    {
        scanf("%d",&n);
        int u,v;
        for(i=1;i<=n;i++) adj[i].clear();
        memset(a,0,sizeof(a));
        memset(len,0,sizeof(len));
        for(i=1;i<n;i++)
        {
            scanf("%d%d",&u,&v);
            adj[v].push_back(u);
            a[u]++;
        }
        for(i=1;i<=n;i++)
        {
            if(!a[i])
            {
                m = 0;
                memset(vis,false,sizeof(vis));
                dfs(i);
                break;
            }
        }
        memset(lazy,-1,sizeof(lazy));
        scanf("%d",&m);
        char option[3];
        printf("Case #%d:\n",ca++);
        for(i=0;i<m;i++)
        {
            scanf("%s",option);
            if(option[0]=='C')
            {
                scanf("%d",&u);
                printf("%d\n",query(1,1,n,tree[u]));
            }
            else
            {
                scanf("%d%d",&u,&v);
                updata(1,1,n,tree[u],tree[u]+len[u]-1,v);
            }
        }
    }
    return 0;
}

 

要将 MySQL 的事件 `ev_auto_assign_sorting_batch` 的执行间隔从 **每10秒一次** 修改为 **每30秒一次**,你需要使用 `ALTER EVENT` 语句。 --- ### ✅ 修改为每 30 秒执行一次的 SQL 命令: ```sql ALTER EVENT gapinyc.ev_auto_assign_sorting_batch ON SCHEDULE EVERY 30 SECOND DO -- 这里需要填写原事件的 DO 子句内容(见下方说明) ; ``` > ⚠️ 注意:上面命令中 `DO` 后面的部分是你原来事件执行的具体操作。由于 `SHOW EVENTS` 不显示 `DO` 内容,你需要先查看原始定义。 --- ### 🔍 第一步:查看原事件的完整定义 运行以下命令查看事件的完整 SQL: ```sql SHOW CREATE EVENT gapinyc.ev_auto_assign_sorting_batch\G ``` 输出示例: ```text *************************** 1. row *************************** Event: ev_auto_assign_sorting_batch sql_mode: ... time_zone: SYSTEM Body: BEGIN INSERT INTO sorting_tasks (...) VALUES (...); END Definer: root@localhost Created: 2025-11-05 17:14:48 Last Altered: 2025-11-05 17:14:48 Last Executed: 2025-11-05 17:15:18 Starts: 2025-11-05 17:14:48 Ends: NULL Status: ENABLED Originator: 1 character_set_client: utf8mb4 collation_connection: utf8mb4_0900_ai_ci Database Collation: utf8mb4_unicode_ci ``` 记下 `Body` 中的内容(即 `BEGIN ... END` 部分)。 --- ### ✅ 第二步:完整修改事件(假设原逻辑是某个存储过程或 SQL) 比如原事件执行的是一个自动分配波次的任务,可能是这样: ```sql BEGIN CALL proc_assign_sorting_batch(); END ``` 那么完整的 `ALTER EVENT` 语句就是: ```sql ALTER EVENT gapinyc.ev_auto_assign_sorting_batch ON SCHEDULE EVERY 30 SECOND STARTS '2025-11-05 17:14:48' ON COMPLETION PRESERVE ENABLE DO BEGIN CALL proc_assign_sorting_batch(); END; ``` --- ### 🛠 参数解释: | 子句 | 说明 | |------|------| | `ON SCHEDULE EVERY 30 SECOND` | 每隔 30 秒执行一次 | | `STARTS '...'` | 保持与原事件相同的起始时间(可选) | | `ON COMPLETION PRESERVE` | 事件完成后保留定义(推荐) | | `ENABLE` | 确保事件处于启用状态 | | `DO BEGIN ... END` | 原来的事件逻辑 | --- ### ✅ 验证是否修改成功 ```sql SHOW EVENTS FROM gapinyc LIKE 'ev_auto_assign%'\G ``` 或者更详细地查看: ```sql SHOW CREATE EVENT gapinyc.ev_auto_assign_sorting_batch\G ``` 你应该看到: ```text Interval value: 30 Interval field: SECOND ``` --- ### 💡 补充建议 如果你不确定原来的 `DO` 内容,可以临时禁用事件并重建: ```sql -- 1. 禁用旧事件 ALTER EVENT gapinyc.ev_auto_assign_sorting_batch DISABLE; -- 2. 创建新事件(替换为你知道的逻辑) CREATE EVENT IF NOT EXISTS gapinyc.ev_auto_assign_sorting_batch ON SCHEDULE EVERY 30 SECOND STARTS NOW() ON COMPLETION PRESERVE ENABLE DO BEGIN -- 替换为实际要执行的逻辑,例如: CALL proc_assign_sorting_batch(); END; ``` ---
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值