首页 文章

通过Waterline(Sailsjs)传递布尔值?

提问于
浏览
0

我有一个问题案例测试HTML输入的真实性,然后通过ORM获取真或假案例:

open_to_public: (req.param('open_to_public') == 't' ? true: false),

Waterline文档说字符串将无法验证,因此我直接设置布尔值,如上所述 . 但是,模型无法验证这一点,结果如下:

{ [error: invalid input syntax for type boolean: ""]
name: 'error',
length: 83,
severity: 'ERROR',
code: '22P02',
detail: undefined,
hint: undefined,
position: undefined,
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
file: 'bool.c',
line: '153',
routine: 'boolin' }

我尝试过任意数量的大小写,文字或引用值的组合,并多次调整我的模型 . 后端是MySQL,列是boolean类型 . 列中的现有数据均表示为TRUE / FALSE .

这是当前匹配的模型定义(导致上面列出的错误):

open_to_public: {
  type: 'boolean',
  defaultsTo: 'false',
  boolean: true,
},

任何见解都表示感谢 .

编辑:按照Scott的要求:在LeaseController.js中

create: function(req,res,next) {

    if( req.param('client_id') == null || req.param('rental_type_id') == null ) {
        console.log( 'Minimum requirements missing' );
        return next();
    }

    var data = {
        client_id: req.param('client_id'),
        rental_type_id: req.param('rental_type_id'),
        clerk: req.session.user.login,
        site_contact_person: req.param('site_contact_person'),
        site_contact_phone: req.param('site_contact_phone'),
        open_to_public: (req.param('open_to_public') == 't' ? true: false),
        admission_fee: (req.param('admission_fee') ? req.param('admission_fee'): 0.00),
        rental_confirmation: req.param('rental_confirmation'),
        require_deposit: (req.param('require_deposit')?req.param('require_deposit'):0.00)
    };

    Lease.create( data ).done(function(err,lease){
        if( err ) {

    ///// THIS IS WHERE THE ERR IS THROWN //////
            console.log( err );
            console.log( data );
            return next();
        }
        if( ! lease ) {
            console.log( 'No lease object returned from create function' );
            return next();  
        }

        req.flash('success', 'Lease '+ lease.id + ' created');

        res.redirect( '/lease/'+lease.id, {data:lease} );
        return;
    });

}

1 回答

  • 0

    你可以分享连接设置吗?适配器只...

    尝试类似:open_to_public :( req.param('open_to_public')=='t'?'true':'false'),

相关问题