如何仅在属性未设置时添加或更新值？含国家语言分配场景

1. 仅在属性未设置时更新/添加值 #

核心逻辑是先判断属性是否为空、未定义或不存在，再执行赋值操作，以下是几种常见场景的实现方式：

JavaScript 对象场景 #

const obj = { name: "China" };
// 仅当language属性未定义或为null/undefined时赋值
if (!obj.hasOwnProperty('language') || obj.language == null) {
  obj.language = "Chinese";
}

Python 字典/类实例场景 #

字典

country = {"name": "France"}
# 检查键是否不存在，或对应值为空
if "language" not in country or not country["language"]:
    country["language"] = "French"

类实例

class Country:
    def __init__(self, name):
        self.name = name

france = Country("France")
# 检查属性是否存在且非空
if not hasattr(france, "language") or not getattr(france, "language"):
    setattr(france, "language", "French")

SQL 数据库场景 #

假设表名为countries，包含id、name、language字段：

UPDATE countries
SET language = 'English'
WHERE language IS NULL OR language = '';

2. 为国家列表中未设置语言的分配语言 #

核心是遍历列表，对每个国家判断语言状态，仅处理未设置的项，以下是常见实现：

Python 列表处理 #

countries = [
    {"name": "China", "language": "Chinese"},
    {"name": "USA"},
    {"name": "Japan", "language": ""},
    {"name": "Germany"}
]
# 预设语言映射（可根据需求调整）
default_languages = {
    "USA": "English",
    "Japan": "Japanese",
    "Germany": "German"
}

for country in countries:
    # 判断语言是否未设置或为空
    if "language" not in country or not country["language"].strip():
        # 优先用预设映射，无映射则用默认值（比如English）
        country["language"] = default_languages.get(country["name"], "English")

JavaScript 数组处理 #

const countries = [
    { name: "China", language: "Chinese" },
    { name: "USA" },
    { name: "Japan", language: "" },
    { name: "Germany" }
];
const defaultLanguages = {
    "USA": "English",
    "Japan": "Japanese",
    "Germany": "German"
};

countries.forEach(country => {
    if (!country.language?.trim()) {
        country.language = defaultLanguages[country.name] || "English";
    }
});

SQL 批量更新 #

如果是数据库中的国家列表，直接用UPDATE语句过滤未设置语言的记录：

-- 按国家名称匹配默认语言
UPDATE countries
SET language = CASE
    WHEN name = 'USA' THEN 'English'
    WHEN name = 'Japan' THEN 'Japanese'
    WHEN name = 'Germany' THEN 'German'
    ELSE 'English' -- 其他国家默认English
END
WHERE language IS NULL OR language = '';

内容的提问来源于stack exchange，提问作者Taja Jan