NodeJS+Cassandra:无法检索布尔数据和整数数据

Question

'id uuid PRIMARY KEY,' +
'model varchar,' +
'price int,' +
'isAvailable boolean,' + 
'profit int,' + 
'lastSaleDate timestamp'

我能成功地创造一个记录。我正在使用准备好的语句插入。

当我检索时，虽然我获得了记录，但我无法获得uuid和varchar数据类型（即id&model)以外的任何值

console.log返回以下内容：

id: '5210d4ea-9f57-4159-aee4-026a256841ee',
model: 'carModel1',
price: undefined,
isAvailable: undefined,
profit: undefined,
lastSaleDate: undefined

client.execute('CREATE TABLE IF NOT EXISTS franchise.cars (' +
                'id uuid PRIMARY KEY,' +
                'model varchar,' +
                'price int,' +
                'isAvailable boolean,' + 'profit int,' + 'lastSaleDate timestamp' +
                ');',
                next);

添加记录：

var upsertCars = 'INSERT INTO franchise.cars (id, model, price, isAvailable, profit, lastSaleDate)  '
    + 'VALUES(?, ?, ?, ?, ?, ?);';

var id = null;
if ( ! req.body.hasOwnProperty('id')) {
    id = cassandra.types.uuid();
} else {
    id = req.body.id;
}

var date_as_timestamp=new Date(req.body.lastSaleDate).getTime();

client.execute(upsertCars,
        [id, req.body.model, req.body.price, req.body.isAvailable, req.body.profit, date_as_timestamp],{prepare:true},
        afterExecution('Error: ', 'Car ' + req.body.model + ' upserted.', res));

获取记录：

var getCars = 'SELECT *FROM franchise.cars';

var cars=[];

    client.execute(getCars,{prepare:true}, function(err, result) {
        if (err) {
            res.status(404).send({ msg : 'Car not found.' });
        } else {
for(var i=0; i<result.rows.length;i++){
console.log(result.rows[i].isAvailable);
machines.push({id : result.rows[i].id, model : result.rows[i].model, price : result.rows[i].price, isAvailable : result.rows[i].isAvailable, profit : result.rows[i].profit, lastSaleDate : result.rows[i]. lastSaleDate});
}

Answer 1

虽然插入需要伴随正确大小写的属性，但获取数据时应该使用小写的属性名

IE.

var upsertCars = 'INSERT INTO franchise.cars (id, model, price, isAvailable, profit, lastSaleDate)  '
    + 'VALUES(?, ?, ?, ?, ?, ?);';

对于插入很好，但是在获取时：

var getCars = 'SELECT *FROM franchise.cars';

var cars=[];

    client.execute(getCars,{prepare:true}, function(err, result) {
        if (err) {
            res.status(404).send({ msg : 'Car not found.' });
        } else {
for(var i=0; i<result.rows.length;i++){
console.log(result.rows[i].isAvailable);
machines.push({id : result.rows[i].id, model : result.rows[i].model, price : result.rows[i].price, isAvailable : result.rows[i].isAvailable, profit : result.rows[i].profit, lastSaleDate : result.rows[i]. lastSaleDate});
}

var getCars = 'SELECT *FROM franchise.cars';

var cars=[];

    client.execute(getCars,{prepare:true}, function(err, result) {
        if (err) {
            res.status(404).send({ msg : 'Car not found.' });
        } else {
for(var i=0; i<result.rows.length;i++){
console.log(result.rows[i].**isavailable**);
machines.push({id : result.rows[i].id, model : result.rows[i].model, price : result.rows[i].price, isAvailable : result.rows[i].**isavailable**, profit : result.rows[i].profit, lastSaleDate : result.rows[i]. **lastsaledate**});
}