node.js - 列ID的未设置值无效

我想更新可能存在或不存在的记录。如果它不存在，那么什么也不会发生。



我正在为节点使用cassandra驱动程序，出现错误

UnhandledPromiseRejectionWarning: Unhandled promise rejection (rejection id: 1): ResponseError: Invalid unset value for column question_id

当尝试做类似的事情时

let question = {
  question_part: ['How many times has Leicester Tigers won the Heineken Cup?'],
  answer: ['2'],
  tags: ['competition', 'rugby'],
  title: 'Rugby pub quiz'
};

let query = 'update question set answer = ?, question_part = ?, tags = ?, title = ? where question_id = ?';
const params = [question.answer, question.question_part, question.tags, question.title, question.question_id];
cassandraClient.execute(query, params, {prepare: true});

在像这样的桌子上

CREATE TABLE question (
    question_id timeuuid PRIMARY KEY,
    answer list<text>,
    cakes int,
    created timestamp,
    creator_display_name text,
    creator_id text,
    difficults int,
    dislikes int,
    drops int,
    easies int,
    favorites int,
    impossibles int,
    last_activity timestamp,
    likes int,
    question_part list<text>,
    right_answers int,
    tags set<text>,
    title text,
    views int,
    wrong_answers int
)

最佳答案

更新您的问题定义以包含question_id。
更新查询以包括标题'更新问题集答案=？，question_part =？，标签=？，标题=？其中question_id =？

关于node.js - 列ID的未设置值无效，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/48091387/