Drupal 数据库 API 查询 - row.update 如果存在，否则为 row.insert [英] Drupal database API query - row.update if exists, else row.insert

问题描述

我一直在尝试在 drupal 中运行一个查询，如果条目已经存在，它将更新条目，或者如果不存在则插入一个新条目.代码现在看起来像这样:

I've been trying to run a query in drupal that'll update entries if they already exists or insert a new entry if it doesnt. The code looks like this at the moment:

db_query("IF EXISTS (SELECT %d FROM {uc_posten_packages.pid})
UPDATE {uc_posten_packages} SET title = '%s', label = '%s', cost = '%d', length = '%d', width ='%d', height = '%d', weight = '%d'  WHERE pid = %d
ELSE
INSERT INTO {uc_posten_packages} VALUES ('%d', '%s', '%s', '%d', '%d', '%d', '%d', '%d')",$id, $title, $label, $rate, $length, $width, $height, $weight, $id, $id, $title, $label, $rate, $length, $width, $height, $weight);

我不明白为什么该查询会引发错误.错误中的所有数字都是正确的

I can't see why that query throws me an error. All the numbers in the error are correct

...near 'IF EXISTS (SELECT 1 FROM uc_posten_packages.pid) UPDATE uc_posten_packages ' at line 1 query:
IF EXISTS (SELECT 1 FROM uc_posten_packages.pid) UPDATE uc_posten_packages SET title = 'vfbv', label = 'bbv', cost = '22', length = '232', width ='22', height = '22', weight = '22' WHERE pid = 1 ELSE INSERT INTO uc_posten_packages VALUES ('1', 'vfbv', 'bbv', '22', '232', '22', '22', '22')

这个查询是否应该有效和/或在 drupal 中是否有更好的方法来处理这个问题?

Should this query work and/or is there some better way dealing with this in drupal?

推荐答案

您正在寻找的东西被亲切地称为upsert"(更新否则插入)，并且有一个专门用于此的 drupal 函数:db_merge.这里写得很好:http://drupal.org/node/310085

What you're looking for is cordially called an "upsert" (update otherwise insert), and there is a drupal function for just this: db_merge. Good write-up here: http://drupal.org/node/310085

drupal_write_record() 不会自动执行更新插入".它始终仅根据您传入的内容插入或更新，但不能同时插入或更新.

drupal_write_record() does not automatically perform an "upsert." It always either inserts or updates based on what you pass in only, but not both.

这篇关于Drupal 数据库 API 查询 - row.update 如果存在，否则为 row.insert的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！