如何合并批号/序列号

CREATE TABLE BatchSerial (
    BatchID INT PRIMARY KEY,
    SerialNumbers VARCHAR(MAX)
);

-- 示例插入数据
INSERT INTO BatchSerial (BatchID, SerialNumbers)
VALUES (1, 'SN001,SN002,SN003');

def merge_batches(batch_list, threshold):
    merged_batches = []
    current_batch = []
    
    for batch in batch_list:
        if len(current_batch) + len(batch) <= threshold:
            current_batch.extend(batch)
        else:
            merged_batches.append(current_batch)
            current_batch = batch
    
    if current_batch:
        merged_batches.append(current_batch)
    
    return merged_batches

# 示例使用
batches = [['SN001', 'SN002'], ['SN003', 'SN004', 'SN005'], ['SN006']]
merged = merge_batches(batches, 3)
print(merged)  # 输出: [['SN001', 'SN002', 'SN003'], ['SN004', 'SN005', 'SN006']]