我有一张表 - Lead.Metadata- 其中有一个名为metaJSON 类型的列和一个生成的列：
cycle VARCHAR(255) AS (JSON_UNQUOTE(meta->"$.cycle"))
问题是当我这样做时UPDATE Lead.Metadata SET cycle = 'MONTHLY'出现此错误：
错误代码：3105。表“元数据”中生成的列“cycle”指定的值是不允许的。
我不明白。循环是一个VARCHAR(255)并且'MONTHLY'应该适合那里。
有什么想法吗？
（此外，请注意，代码库是遗留代码库；数据库结构不是最优的，但修复这个问题是一个更大的项目）
下面的代码可用于将一个单元格添加!到一个或多个单元格选择中，但是如何添加一个后续单元格然后!删除!!呢？
有两个序列：
shift1<回到shift1!<shift1!!<shift1<shift1<^回到shift1!<^shift1!!<^shift1<^ 'successfully adds ! to any selection of blank cells or after any string
'example: from "blank cell" to "!" or from "shift1" to "shift1!"
If InStr(ActiveCell.Value, "!") = 0 And InStr(ActiveCell.Value, "^") = 0 Then
If InStr(ActiveCell.Value, "<") = 0 And InStr(ActiveCell.Value, ">") = 0 _
And InStr(ActiveCell.Value, "^") = 0 Then
For Each c In Selection.Cells
c.Value = c.Value & "!"
Next c
'successfully adds ! in between shift string and < if ! is not present
'example: from "shift1<" to "shift1!<"
ElseIf InStr(ActiveCell.Value, "!") = 0 Then
Selection.Cells.Replace "<", "!<"
'does not add another ! in between shift string and < if one ! is present
'example: from "shift1!<" to "shift1!!<"
ElseIf InStr(ActiveCell.Value, "!") = 1 Then
Selection.Cells.Replace "!<", "!!<"
'does not remove !! in between shift string and < if two ! are present
'example: from "shift1!!<" to "shift1<"
ElseIf InStr(ActiveCell.Value, "!") = 2 Then
Selection.Cells.Replace "!!<", "<"
End If
'successfully adds ! in between shift string and <^
'example: from "shift1<^" to "shift1!<^"
ElseIf InStr(ActiveCell.Value, "<") > 0 And InStr(ActiveCell.Value, "^") > 0 _
And InStr(ActiveCell.Value, "!") = 0 Then
Selection.Cells.Replace "<^", "!<^"
'does not add another ! in between shift string and <^
'example: from "shift1!<^" to "shift1!!<^"
ElseIf InStr(ActiveCell.Value, "<") > 0 And InStr(ActiveCell.Value, "^") > 0 _
And InStr(ActiveCell.Value, "!") = 1 Then
Selection.Cells.Replace "!<^", "!!<^"
'does not remove !! in between shift string and < if two ! are present
'example: from "shift1!!<^" to "shift1<^"
ElseIf InStr(ActiveCell.Value, "<") > 0 And InStr(ActiveCell.Value, "^") > 0 _
And InStr(ActiveCell.Value, "!") = 2 Then
Selection.Cells.Replace "!!<^", "<^"
End If
我想用 C# 创建一个类，在调用数据库后需要设置一些属性。下面是一个粗略的示例：
最好的方法是什么？创建该类的代码是否应该事先进行调用？通过 Builder？或者构造函数应该执行异步调用：
protected IProduct? _product;
public IProduct? Product {
get { return _product; }
private set { _product = value; }
}
public double Size? { get; private set; } = null;
public Shipping(IProduct? product) {
Product = product;
InitializeAsync().ConfigureAwait(false);
}
private async Task InitializeAsync() {
if (_product != null) {
Size = await dbService.GetProductSize(_product.ProductReference);
}
}
我认为这不是好事，因为我们无法知道 Size 是否已有效设置。为这种情况创建一个完整的构建器似乎有点过分，但我没有看到一个干净的解决方案可以直接做到这一点。如果对象要更改，则 Shipping 对象无论如何都有责任相应地更新 Size，因此似乎它仍然需要对如何设置 Size 负责。让我知道你的想法！
我有一个 Next.js 15.2.3 服务器 api 路由，它接收monitorId并在数据库中返回结果。
Next.js 15.2.3 服务器 api 路由路径为
app/(private)/monitors/[monitorId]/api-get-monitor/route.ts。
// app/(private)/monitors/[monitorId]/api-get-monitor/route.ts
import { NextRequest, NextResponse } from "next/server";
import { sql } from "@/app/lib/db";
import { loginIsRequiredServer } from "@/app/lib/loginIsRequiredServer";
import { getServerSession } from "next-auth";
import { authConfig } from "@/app/lib/auth";
// Use the built-in RequestContext type
export async function GET(request: NextRequest, context: { params?: { monitorId?: string } }) {
// Ensure params exist
if (!context.params?.monitorId) {
return NextResponse.json({ message: "Missing monitor ID" }, { status: 400 });
}
const { monitorId } = context.params;
console.error(`api-get-monitor · Get Monitor: ${monitorId}`);
// Session check
await loginIsRequiredServer();
const session = await getServerSession(authConfig);
if (!session) {
return NextResponse.json({ message: "Unauthorized" }, { status: 401 });
}
try {
// Query the database for monitor details using the monitorId
const res = await sql(
`SELECT monitor_id, title, what_to_monitor, url_to_monitor, escalation_email_on,
escalation_email_to, check_frequency, last_checked_timestamp, is_offline, offline_datetime
FROM u_monitors_index WHERE monitor_id = $1`,
[monitorId]
);
if (res.rows.length === 0) {
return NextResponse.json({ message: "Monitor not found" }, { status: 404 });
}
return NextResponse.json({ data: res.rows[0] });
} catch (error) {
console.error("get-monitor · Error getting:", error);
return NextResponse.json({ message: "Error getting monitor" }, { status: 500 });
}
}
这在本地有效，但当我将其部署到 Google Cloud Run 时出现以下错误
Linting and checking validity of types ...
Failed to compile.
app/(private)/monitors/[monitorId]/api-get-monitor/route.ts
Type error: Route "app/(private)/monitors/[monitorId]/api-get-monitor/route.ts" has an invalid "GET" export:
Type "{ params?: { monitorId?: string | undefined; } | undefined; }" is not a valid type for the function's second argument.
Expected "Promise<any>", got "{ monitorId?: string | undefined; } | undefined".
Expected "Promise<any>", got "undefined".
Next.js build worker exited with code: 1 and signal: null
这不params就是 Next.js 传递的一个对象吗，不是一个异步操作吗？我不明白这里的错误。
这是一道 Python 3 问题，使用 for 循环
为什么 print(num-1) 仍在范围 4 处执行？在我看来，当范围为 4 时，它应该跳过 print(num-1) 并直接转到 else：print(num)。
for num in range(4):
print(num - 1)
else:
print(num)
正确的输出是：-1 0 1 2 3 我的问题是为什么不应该是：-1 0 1 2 4
谢谢。
我尝试使用：
num = 0
while num != 4:
print(num - 1)
num += 1
else:
print(num)
我得到了我期望的结果：-1 0 1 2 4
我正在构建一个简单的 React 应用，其中有一只宠物，它有饥饿、无聊和精力等属性。我想以不同的间隔更新这些属性（每 5 秒更新一次饥饿，每 8 秒更新一次无聊，每 10 秒更新一次精力）。
但是，虽然饥饿值可以正确更新，但无聊值和精力值却不能。我曾经setInterval更新过这些值，但似乎只有饥饿值在更新。
相关代码如下：
import { useEffect, useState } from "react";
import { Pet } from "./types/pet";
function App() {
const [pet, setPet] = useState<Pet | null>(null);
useEffect(() => {
// Load pet from localStorage or create a new pet
const savedPet = localStorage.getItem("pet");
if (savedPet) {
try {
const parsedPet = JSON.parse(savedPet) as Pet;
setPet(parsedPet);
} catch (error) {
console.error("Error parsing saved pet:", error);
createNewPet();
}
} else {
createNewPet();
}
}, []);
const updatePet = (updateFn: (currentPet: Pet) => Partial<Pet>) => {
setPet((prevPet) => {
if (!prevPet) return null;
const updatedPet = { ...prevPet, ...updateFn(prevPet) };
localStorage.setItem("pet", JSON.stringify(updatedPet));
return updatedPet;
});
};
useEffect(() => {
if (!pet) return;
const hungerInterval = setInterval(() => {
updatePet((pet) => ({ hunger: Math.min(pet.hunger + 1, 100) }));
}, 5000);
const boredomInterval = setInterval(() => {
updatePet((pet) => ({ boredom: Math.min(pet.boredom + 1, 100) }));
}, 8000);
const energyInterval = setInterval(() => {
updatePet((pet) => ({ energy: Math.max(pet.energy - 1, 0) }));
}, 10000);
return () => {
clearInterval(hungerInterval);
clearInterval(boredomInterval);
clearInterval(energyInterval);
};
}, [pet]);
return (
<div>
<p>Hunger: {pet.hunger}%</p>
<p>Boredom: {pet.boredom}%</p>
<p>Energy: {pet.energy}%</p>
</div>
);
}
export default App;
我的经历：
我尝试过的：
有人知道为什么只有饥饿状态在更新，以及我该怎么做才能解决这个问题？
[HttpGet("{id}/client-history-sw01-module")]
[Authorize(AuthenticationSchemes = "AdminSchema")]
public async Task<ActionResult<object>> GetClientHistoriesSw01Module(
long id,
[FromServices] IMapper mapper,
string? name,
DateTime? startDate,
DateTime? endDate,
int page = 1,
int pageSize = 10)
{
var sw01Module = await _context.Sw01Modules
.Include(d => d.ClientHistoriesSw01Module)
.FirstOrDefaultAsync(d => d.Id == id);
if (sw01Module == null)
{
return StatusCode(404, new { message = "Equipamento não encontrado" });
}
if (sw01Module.ClientHistoriesSw01Module == null || !sw01Module.ClientHistoriesSw01Module.Any())
{
return StatusCode(404, new { message = "Sem histórico" });
}
var clientHistoriesSw01Module = sw01Module.ClientHistoriesSw01Module.AsQueryable();
if (!string.IsNullOrEmpty(name))
{
clientHistoriesSw01Module = clientHistoriesSw01Module
.Where(um => um.ClientName != null && um.ClientName.Contains(name, StringComparison.OrdinalIgnoreCase));
}
if (startDate.HasValue)
{
clientHistoriesSw01Module = clientHistoriesSw01Module
.Where(um => um.CreatedAt >= startDate.Value);
}
if (endDate.HasValue)
{
clientHistoriesSw01Module = clientHistoriesSw01Module
.Where(um => um.CreatedAt <= endDate.Value);
}
clientHistoriesSw01Module = clientHistoriesSw01Module
.OrderByDescending(um => um.CreatedAt);
var totalItems = clientHistoriesSw01Module.Count();
var totalPages = (int)Math.Ceiling((double)totalItems / pageSize);
var paginatedClientHistoriesSw01Module = clientHistoriesSw01Module
.Skip((page - 1) * pageSize)
.Take(pageSize);
var clientHistoriesSw01ModuleGetDTO = mapper.Map<IEnumerable<ClientHistorySw01ModuleGetDTO>>(paginatedClientHistoriesSw01Module);
var result = new
{
Page = page,
PageSize = pageSize,
TotalPages = totalPages,
TotalItems = totalItems,
Items = clientHistoriesSw01ModuleGetDTO.ToList()
};
return result;
}
我遇到了 API 端点的性能问题，即从数据库检索数据的查询需要很长时间才能完成。尽管应用了过滤器和分页，但请求仍然需要很长时间才能返回结果。
API 端点从 Sw01Module 实体检索客户历史数据。它应用各种过滤器（名称、开始日期、结束日期）并实现分页，但请求执行速度较慢。
我有如下格式化的图像：测试用例
我希望能够检测出有多少“岩石”，以及它们代表多少个像素。我尝试使用开放式 cv，但它总是勾勒出岩石以外的其他东西。有没有更适合这个的实现？
我已尝试过：
import cv2
import numpy as np
import matplotlib.pyplot as plt
image_path = "medium.png"
original_image = cv2.imread(image_path)
gray_image = cv2.cvtColor(original_image, cv2.COLOR_BGR2GRAY)
binary_image = cv2.adaptiveThreshold(gray_image, 255, cv2.ADAPTIVE_THRESH_GAUSSIAN_C,
cv2.THRESH_BINARY_INV, 11, 2)
_, binary_image2 = cv2.threshold(gray_image, 230, 255, cv2.THRESH_BINARY_INV)
combined_binary = cv2.bitwise_or(binary_image, binary_image2)
kernel = np.ones((2, 2), np.uint8)
cleaned_binary = cv2.morphologyEx(combined_binary, cv2.MORPH_OPEN, kernel, iterations=1)
contours, _ = cv2.findContours(cleaned_binary, cv2.RETR_EXTERNAL, cv2.CHAIN_APPROX_SIMPLE)
output_image = np.ones_like(original_image) * 255
np.random.seed(42)
hues = np.linspace(0, 179, len(contours), dtype=np.uint8)
np.random.shuffle(hues)
colors = []
for hue in hues:
hsv = np.array([[[hue, 255, 255]]], dtype=np.uint8)
rgb = cv2.cvtColor(hsv, cv2.COLOR_HSV2BGR)[0][0]
colors.append(rgb.tolist())
min_area_threshold = 10
valid_particles = 0
for i, contour in enumerate(contours):
area = cv2.contourArea(contour)
if area >= min_area_threshold:
valid_particles += 1
cv2.drawContours(output_image, [contour], -1, colors[i % len(colors)], -1)
cv2.drawContours(output_image, [contour], -1, (0, 0, 0), 1)
cv2.imwrite('binary_image.png', binary_image)
cv2.imwrite('binary_image2.png', binary_image2)
cv2.imwrite('combined_binary.png', combined_binary)
cv2.imwrite('cleaned_binary.png', cleaned_binary)
plt.figure(figsize=(12, 10))
plt.imshow(cv2.cvtColor(output_image, cv2.COLOR_BGR2RGB))
plt.title(f'Total Particles Detected: {valid_particles}')
plt.axis('off')
plt.tight_layout()
plt.show()
print(f"Total number of actual particles detected: {valid_particles}")
cv2.imwrite('colored_particles_improved.png', output_image)
但我仍然留下了如下图所示的块我的预处理
有没有办法更好地分离块？
我有一张 Hadoop 表，其中有一个名为“state”的属性（列）。有些值显示“Work in Progress”，有些显示“Work In Progress”，因此按“state”分组时，它们显示为两个不同的组。我如何将流程中的所有“Work In Progress”更新为“Work in Progress”？
我尝试了流程中的清理步骤，但没有看到任何我期望的更新功能。
