java复制代码@Override public String getSuppliercode(string orderNo, string productId, string channelId){ 
 // 根据orderNo查询多个List结果 
 //如不存记录，suppliercode = orderNo
 //如存在productId和channelId都相同的记录，则返回此suppliercode 
 //如不存在productId和channelId都相同的记录，则返回uuid
}
以上需求表对象为OrderDetail，请用Mybatis Plus补充以上解释代码，使用LambdaQueryWrapper查询数据，另外注意代码严谨需要预判OrderDetail获取属性时是否需要判空

java复制代码@Autowired  
private OrderDetailMapper orderDetailMapper; 

@Override
public String getSuppliercode(String orderNo, String productId, String channelId) {
    // 根据orderNo查询多个List结果
    LambdaQueryWrapper<OrderDetail> queryWrapper = new LambdaQueryWrapper<>();
    queryWrapper.eq(OrderDetail::getOrderNo, orderNo);
    List<OrderDetail> orderDetailList = orderDetailMapper.selectList(queryWrapper);

    // 如果不存在记录，返回orderNo作为suppliercode
    if (orderDetailList.isEmpty()) {
        return orderNo;
    }

    // 遍历查询结果，查找是否存在productId和channelId都相同的记录
    for (OrderDetail orderDetail : orderDetailList) {
        if (orderDetail.getProductId() != null && orderDetail.getChannelId() != null) {
            if (orderDetail.getProductId().equals(productId) && orderDetail.getChannelId().equals(channelId)) {
                return orderDetail.getSuppliercode();
            }
        }
    }

    // 如果不存在productId和channelId都相同的记录，则返回uuid
    return UUID.randomUUID().toString();
}

java复制代码@Autowired  
private OrderDetailMapper orderDetailMapper; 

@Override
public String getSuppliercode(String orderNo, String productId, String channelId) {

    // 预判输入参数是否为空
    if (StringUtils.isAnyBlank(orderNo, productId, channelId)) {
        throw new IllegalArgumentException("orderNo, productId, and channelId must not be blank");
    }

    // 根据orderNo查询多个OrderDetail记录
    LambdaQueryWrapper<OrderDetail> queryWrapper = new LambdaQueryWrapper<>();
    queryWrapper.eq(OrderDetail::getOrderNo, orderNo);

    List<OrderDetail> orderDetailList = orderDetailMapper.selectList(queryWrapper);

    // 处理查询结果
    if (orderDetailList.isEmpty()) {
        return orderNo; // 如不存在记录，返回orderNo作为suppliercode
    } else {
        for (OrderDetail orderDetail : orderDetailList) {
            if (StringUtils.equals(orderDetail.getProductId(), productId)
                    && StringUtils.equals(orderDetail.getChannelId(), channelId)) {
                return orderDetail.getSuppliercode(); // 如存在productId和channelId都相同的记录，返回此suppliercode
            }
        }
    }

    // 如不存在productId和channelId都相同的记录，生成并返回UUID作为suppliercode
    return UUID.randomUUID().toString();
}

java复制代码
@Autowired  
private OrderDetailMapper orderDetailMapper; 

public String getSuppliercode(String orderNo, String productId, String channelId) {  
        // 创建LambdaQueryWrapper进行条件查询  
        LambdaQueryWrapper<OrderDetail> queryWrapper = Wrappers.<OrderDetail>lambdaQuery()  
                .eq(OrderDetail::getOrderNo, orderNo); // 根据orderNo查询  
  
        // 查询满足条件的所有记录  
        List<OrderDetail> orderDetailList = orderDetailMapper.selectList(queryWrapper);  
  
        // 如果没有记录，返回orderNo作为suppliercode  
        if (orderDetailList == null || orderDetailList.isEmpty()) {  
            return orderNo;  
        }  
  
        // 尝试找到productId和channelId都相同的记录  
        Optional<OrderDetail> optionalOrderDetail = orderDetailList.stream()  
                .filter(orderDetail -> orderDetail.getProductId().equals(productId) && orderDetail.getChannelId().equals(channelId))  
                .findFirst();  
  
        // 如果找到了符合条件的记录，返回其suppliercode  
        if (optionalOrderDetail.isPresent()) {  
            OrderDetail matchedOrderDetail = optionalOrderDetail.get();  
            // 预判suppliercode属性是否需要判空，如果suppliercode字段在数据库中允许为null，则需要进行判空  
            return matchedOrderDetail.getSuppliercode() != null ? matchedOrderDetail.getSuppliercode() : orderNo; // 或者选择其他默认值  
        }  
  
        // 如果没有找到符合条件的记录，生成UUID并返回  
        return UUID.randomUUID().toString();  
    }

java复制代码@Override  
public String getSuppliercode(String orderNo, String warehouseld, String binld) {  
    // 根据orderNo查询多个List结果  
    LambdaQueryWrapper<OrderDetail> queryWrapper = new LambdaQueryWrapper<>();  
    queryWrapper.eq(OrderDetail::getOrderNo, orderNo);  
    queryWrapper.eq(OrderDetail::getProductId, productId);  
    queryWrapper.eq(OrderDetail::getChannelId, channelId);  
    List<OrderDetail> orderDetailList = getList(queryWrapper);  

    // 如不存在记录，suppliercode=orderNo  
    if (orderDetailList.isEmpty()) {  
        return orderNo;  
    }  

    // 如存在productId和channelId都相同的记录，则返回此suppliercode  
    for (OrderDetail orderDetail : orderDetailList) {  
     if (orderDetail.getProductId() != null && orderDetail.getChannelId() != null) { 
            return orderDetail.getSuppliercode();  
        }  
    }  

    // 如不存在warehouselD和binld都相同的记录，则返回uuid  
    return UUID.randomUUID().toString();  
}

git复制代码// feature branch
git add .
git commit
git checkout  master

// or
git stash
git checkout  master

shell复制代码mkdir worktree_test && cd worktree_test && mkdir master && cd master/ && git init

shell复制代码//master
vi rooi.txt
cat rooi.txt
master:add:rooi.txt     (#1)

git add rooi.txt
git commit -m "add:rooi.txt"

shell复制代码// new branch in master
git checkout -b feature

// feature
cat rooi.txt
master:add:rooi.txt   (#1)

vi rooi.txt           (#2)
cat rooi.txt
master:add:rooi.txt
feature:modify rooi.txt

git add rooi.txt      (#3)
git commit -m "dev:modify"
[feature 4d300fb] dev:modify
 1 file changed, 1 insertion(+)

touch a.temp          (#4)

git status            (#5)
Untracked files:
a.temp

shell复制代码// d:\work\worktree_test\master  in feature
git worktree add ../bugfix master (#1)
// to dir : d:\work\worktree_test
cd ..

// d:\work\worktree_test
ls
bugfix/ master/

cd bugfix
cat rooi.txt
master:add:rooi.txt

vi rooi.txt
cat rooi.txt
master:add:rooi.txt
bugfix:fix bug

git add rooi.txt      (#3)
git commit -m "bugfix:fix bug"

shell复制代码// in bugfix dir master
// d:\work\worktree_test\bugfix
cd ..
cd master                       (#1)

shell复制代码// feature
git merge master

bash复制代码/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"

bash复制代码echo 'export PATH="/usr/local/bin:$PATH"' >> ~/.bash_profile（如果使用 bash shell）
echo 'export PATH="/usr/local/bin:$PATH"' >> ~/.zshrc（如果使用 zsh shell）

bash复制代码...
Installation successful!

==> Homebrew has enabled anonymous aggregate formulae and cask analytics.
Read the analytics documentation (and how to opt-out) here:
  https://docs.brew.sh/Analytics
No analytics data has been sent yet (nor will any be during this install run).

==> Homebrew is run entirely by unpaid volunteers. Please consider donating:
  https://github.com/Homebrew/brew#donations

==> Next steps:
- Run these two commands in your terminal to add Homebrew to your PATH:
    (echo; echo 'eval "$(/opt/homebrew/bin/brew shellenv)"') >> /Users/10583/.bash_profile
    eval "$(/opt/homebrew/bin/brew shellenv)"
- Run brew help to get started
- Further documentation:
    https://docs.brew.sh
...

bash复制代码(echo; echo 'eval "$(/opt/homebrew/bin/brew shellenv)"') >> /Users/10583/.bash_profile
    eval "$(/opt/homebrew/bin/brew shellenv)"

bash复制代码cd /usr/local/Homebrew/Library/Taps/
mkdir homebrew
cd homebrew
git clone https://mirrors.ustc.edu.cn/homebrew-core.git
或 git clone https://mirrors.ustc.edu.cn/homebrew-cask.git (哪个卡住 Clone 哪个)
brew update

bash复制代码# Flutter
# Flutter SDK位置
export PATH=$HOME/fvm/default/bin:$PATH
# Flutter 网络代理
export PUB_HOSTED_URL=https://pub.flutter-io.cn
export FLUTTER_STORAGE_BASE_URL=https://storage.flutter-io.cn

sql复制代码CREATE TABLE `test_lab` (
`id` int unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `test2lab` (
`id` int unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

sql复制代码CREATE TABLE `log_lab` (
`changed_table` varchar(50) NOT NULL,
`id` int unsigned NOT NULL,
PRIMARY KEY (`changed_table`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

sql复制代码DELIMITER //

CREATE TRIGGER `test_lab_trigger_INS` AFTER INSERT ON `test_lab`

FOR EACH ROW BEGIN
INSERT INTO log_lab (`changed_table`,`id`) VALUES ('test_lab', NEW.id) ;
END
//

CREATE TRIGGER `test2lab_trigger_INS` AFTER INSERT ON `test2lab`

FOR EACH ROW BEGIN
INSERT INTO log_lab (`changed_table`,`id`) VALUES ('test2lab', NEW.id) ;
END
//
DELIMITER ;

sql复制代码mysql> insert into `test_lab` values (8) ;
Query OK, 1 row affected (0.00 sec)

mysql> insert into `test2lab` values (2) ;
Query OK, 1 row affected (0.01 sec)

mysql> select * from log_lab ;
+---------------+----+
| changed_table | id |
+---------------+----+
| test_lab      |  8 |
| test2lab      |  2 |
+---------------+----+
2 rows in set (0.00 sec)

sql复制代码mysql> SHOW TRIGGERS LIKE 'test2lab';
+----------------------+--------+----------+------------------------------------------------------------------------------------+--------+------------------------+-----------------------------------------------------------------------------------------------------------------------+--------------------+----------------------+----------------------+--------------------+
| Trigger | Event | Table | Statement | Timing | Created | sql_mode | Definer | character_set_client | collation_connection | Database Collation |
+----------------------+--------+----------+------------------------------------------------------------------------------------+--------+------------------------+-----------------------------------------------------------------------------------------------------------------------+--------------------+----------------------+----------------------+--------------------+
| test2lab_trigger_INS | INSERT | test2lab | BEGIN
INSERT INTO log_lab (`changed_table`,`id`) VALUES ('test2lab', NEW.id) ;
END | AFTER | 2024-04-13 10:35:45.29 | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION | msandbox@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci |
+----------------------+--------+----------+------------------------------------------------------------------------------------+--------+------------------------+-----------------------------------------------------------------------------------------------------------------------+--------------------+----------------------+----------------------+--------------------+
1 row in set (0.00 sec)

sql复制代码mysql> SHOW TRIGGERS LIKE 'test_lab' ;
+----------------------+--------+----------+------------------------------------------------------------------------------------+--------+------------------------+-----------------------------------------------------------------------------------------------------------------------+--------------------+----------------------+----------------------+--------------------+
| Trigger | Event | Table | Statement | Timing | Created | sql_mode | Definer | character_set_client | collation_connection | Database Collation |
+----------------------+--------+----------+------------------------------------------------------------------------------------+--------+------------------------+-----------------------------------------------------------------------------------------------------------------------+--------------------+----------------------+----------------------+--------------------+
| test2lab_trigger_INS | INSERT | test2lab | BEGIN
INSERT INTO log_lab (`changed_table`,`id`) VALUES ('test2lab', NEW.id) ;
END | AFTER | 2024-04-13 10:35:45.29 | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION | msandbox@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci |
| test_lab_trigger_INS | INSERT | test_lab | BEGIN
INSERT INTO log_lab (`changed_table`,`id`) VALUES ('test_lab', NEW.id) ;
END | AFTER | 2024-04-13 10:35:45.29 | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION | msandbox@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci |
+----------------------+--------+----------+------------------------------------------------------------------------------------+--------+------------------------+-----------------------------------------------------------------------------------------------------------------------+--------------------+----------------------+----------------------+--------------------+
2 rows in set (0.00 sec)

sql复制代码mysql> SHOW TRIGGERS WHERE `Table` = 'test2lab';
+----------------------+--------+----------+------------------------------------------------------------------------------------+--------+------------------------+-----------------------------------------------------------------------------------------------------------------------+--------------------+----------------------+----------------------+--------------------+
| Trigger | Event | Table | Statement | Timing | Created | sql_mode | Definer | character_set_client | collation_connection | Database Collation |
+----------------------+--------+----------+------------------------------------------------------------------------------------+--------+------------------------+-----------------------------------------------------------------------------------------------------------------------+--------------------+----------------------+----------------------+--------------------+
| test2lab_trigger_INS | INSERT | test2lab | BEGIN
INSERT INTO log_lab (`changed_table`,`id`) VALUES ('test2lab', NEW.id) ;
END | AFTER | 2024-04-13 10:35:45.29 | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION | msandbox@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci |
+----------------------+--------+----------+------------------------------------------------------------------------------------+--------+------------------------+-----------------------------------------------------------------------------------------------------------------------+--------------------+----------------------+----------------------+--------------------+
1 row in set (0.01 sec)

mysql> SHOW TRIGGERS WHERE `Table` = 'test_lab';
+----------------------+--------+----------+------------------------------------------------------------------------------------+--------+------------------------+-----------------------------------------------------------------------------------------------------------------------+--------------------+----------------------+----------------------+--------------------+
| Trigger | Event | Table | Statement | Timing | Created | sql_mode | Definer | character_set_client | collation_connection | Database Collation |
+----------------------+--------+----------+------------------------------------------------------------------------------------+--------+------------------------+-----------------------------------------------------------------------------------------------------------------------+--------------------+----------------------+----------------------+--------------------+
| test_lab_trigger_INS | INSERT | test_lab | BEGIN
INSERT INTO log_lab (`changed_table`,`id`) VALUES ('test_lab', NEW.id) ;
END | AFTER | 2024-04-13 10:35:45.29 | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION | msandbox@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci |
+----------------------+--------+----------+------------------------------------------------------------------------------------+--------+------------------------+-----------------------------------------------------------------------------------------------------------------------+--------------------+----------------------+----------------------+--------------------+
1 row in set (0.00 sec)

python复制代码environment = gym_super_mario_bros.make('SuperMarioBros-v0',render_mode = "human")

bash复制代码pip install nes-py
pip install gym-super-mario-bros==7.3.0
pip install setuptools==65.5.0 "wheel<0.40.0"
pip install gym==0.21.0
pip install stable-baselines3[extra]==1.6.0

python复制代码pip install baselines3==1.6.0

python复制代码pip install cloudpickle==3.0.0

py复制代码pip install nes-py
pip install gym-super-mario-bros==7.3.0
pip install setuptools==65.5.0 "wheel<0.40.0"
pip install gym==0.21.0
pip install stable-baselines3==1.6.0
pip install cloudpickle==3.0.0

c复制代码ale-py                     0.8.1
atari-py                   0.2.6
cloudpickle                3.0.0
gym                        0.21.0
gym-notices                0.0.8
gym-super-mario-bros       7.3.0
gymnasium                  0.28.1
importlib-metadata         4.13.0
importlib_resources        6.4.0
MarkupSafe                 2.1.3
matplotlib                 3.8.2
matplotlib-inline          0.1.6
nes-py                     8.2.1
numpy                      1.26.0
opencv-contrib-python      4.9.0.80
opencv-python              4.9.0.80
pip                        24.0
pygame                     2.5.2
setuptools                 65.5.0
Shimmy                     1.3.0
tensorboard                2.16.2
tensorboard-data-server    0.7.2
tensorboardX               2.6.2.2
torch                      2.1.2+cu118
torchaudio                 2.1.2+cu118
torchvision                0.16.2+cu118
wheel                      0.38.4

swift复制代码actor BankAccount {
    
    private var balance = 1000
    
    func withdraw(_ amount: Int) async {
        
        print("🤓 Check balance for withdrawal: (amount)")
        
        guard canWithdraw(amount) else {
            print("🚫 Not enough balance to withdraw: (amount)")
            return
        }
        
        guard await authorizeTransaction() else {
            return
        }
        
        print("✅ Transaction authorized: (amount)")
        
        balance -= amount
        
        print("💰 Account balance: (balance)")
    }
    
    private func canWithdraw(_ amount: Int) -> Bool {
        return amount <= balance
    }
    
    private func authorizeTransaction() async -> Bool {
        
        // Wait for 1 second
        try? await Task.sleep(nanoseconds: 1 * 1000000000)
        
        return true
    }
}

let account = BankAccount()

Task {
    await account.withdraw(800)
}

Task {
    await account.withdraw(500)
}

yaml复制代码🤓 Check balance for withdrawal: 800
🤓 Check balance for withdrawal: 500
✅ Transaction authorized: 800
💰 Account balance: 200
✅ Transaction authorized: 500
💰 Account balance: -300

swift复制代码func withdraw(_ amount: Int) async {
    
    // Perform authorization before check balance
    guard await authorizeTransaction() else {
        return
    }
    print("✅ Transaction authorized: (amount)")
    
    print("🤓 Check balance for withdrawal: (amount)")
    guard canWithdraw(amount) else {
        print("🚫 Not enough balance to withdraw: (amount)")
        return
    }
    
    balance -= amount
    
    print("💰 Account balance: (balance)")
    
}

swift复制代码func withdraw(_ amount: Int) async {
    
    print("🤓 Check balance for withdrawal: (amount)")
    guard canWithdraw(amount) else {
        print("🚫 Not enough balance to withdraw: (amount)")
        return
    }
    
    guard await authorizeTransaction() else {
        return
    }
    print("✅ Transaction authorized: (amount)")
    
    // Check balance again after the authorization process
    guard canWithdraw(amount) else {
        print("⛔️ Not enough balance to withdraw: (amount) (authorized)")
        return
    }

    balance -= amount
    
    print("💰 Account balance: (balance)")
    
}

objectivec复制代码// 问题：以下代码是在主线程执行的，会不会产生死锁？
NSLog(@"执行任务1");
dispatch_queue_t queue = dispatch_get_main_queue();
dispatch_sync(queue, ^{
   NSLog(@"执行任务2");
});
NSLog(@"执行任务3");

objectivec复制代码- (void)interview02 {
    // 问题：interview01中的sync，改成 async。会不会产生死锁？不会！
    /* 打印日志：
        执行任务1
        执行任务3
        执行任务2
     */
    NSLog(@"执行任务1");
    dispatch_queue_t queue = dispatch_get_main_queue();
    dispatch_async(queue, ^{
        NSLog(@"执行任务2");
    });
    NSLog(@"执行任务3");
}

objectivec复制代码- (void)interview03 {
    // 会不会产生死锁？会！
    /*
     分析：
     执行任务2 后，同步等待任务2 执行，但是因为queue是串行的，所以会相互等待
     */
    NSLog(@"执行任务1");
    dispatch_queue_t queue = dispatch_queue_create("myqueue", DISPATCH_QUEUE_SERIAL);
    dispatch_async(queue, ^{
        NSLog(@"执行任务2");
        dispatch_sync(queue, ^{
            NSLog(@"执行任务3");
        });
        NSLog(@"执行任务4");
    });
    NSLog(@"执行任务5");
}

objectivec复制代码- (void)interview04 {
    // interview03改为并发队列（DISPATCH_QUEUE_CONCURRENT），会不会死锁？不会！
    NSLog(@"执行任务1");
    dispatch_queue_t queue = dispatch_queue_create("myqueue", DISPATCH_QUEUE_CONCURRENT);
    dispatch_async(queue, ^{
        NSLog(@"执行任务2");
        dispatch_sync(queue, ^{
            NSLog(@"执行任务3");
        });
        NSLog(@"执行任务4");
    });
    NSLog(@"执行任务5");
}

objectivec复制代码- (void)test {
    NSLog(@"2");
}

- (void)touchesBegan:(NSSet<UITouch *> *)touches withEvent:(UIEvent *)event {
    dispatch_queue_t queue = dispatch_get_global_queue(0, 0);
    dispatch_async(queue, ^{
        NSLog(@"1");
        [self performSelector:@selector(test) withObject:nil afterDelay:0];
        NSLog(@"3");
    });
}

objectivec复制代码- (void)touchesBegan:(NSSet<UITouch *> *)touches withEvent:(UIEvent *)event {
    NSLog(@"1");
    [self performSelector:@selector(test) withObject:nil afterDelay:0];
    NSLog(@"3");
}

objectivec复制代码- (void)touchesBegan:(NSSet<UITouch *> *)touches withEvent:(UIEvent *)event {
    dispatch_queue_t queue = dispatch_get_global_queue(0, 0);
    dispatch_async(queue, ^{
        NSLog(@"1");
        [self performSelector:@selector(test) withObject:nil];
        NSLog(@"3");
    });
}

objectivec复制代码dispatch_async(queue, ^{
    NSLog(@"1");
    [self performSelector:@selector(test) withObject:nil afterDelay:0];
    NSLog(@"3");
    
    [[NSRunLoop currentRunLoop] addPort:[[NSPort alloc]init] forMode:NSDefaultRunLoopMode];
    [[NSRunLoop currentRunLoop] runMode:NSDefaultRunLoopMode beforeDate:[NSDate distantFuture]];
});