defaultFn is inserting empty string

17 views

Skip to first unread message

Rajkaran Chauhan

unread,

Jul 28, 2017, 2:28:09 PM7/28/17

to LoopbackJS

Below is my JSON:

{
  "name": "ftpProcessedLast",
  "base": "PersistedModel",
  "idInjection": false,
  "options": {
    "validateUpsert": true
  },
  "properties": {
      "id": {
        "type": "string",
        "id": true,
        "required": true,
        "defaultFn": "guid",
      },
    "fileName": {
      "type": "string"
    },
    "type": {
      "type": "string",
      "defaultFn": "uuid",
    },
    "fileDatetime": {
      "type": "date"
    },
    "createDatetime": {
      "type": "date"
    },
    "modifyDatetime": {
      "type": "date"
    }
  },
  "validations": [],
  "relations": {},
  "acls": [],
  "methods": {}
}

The query I am running:

FtpProcessedLast.create({
	fileName:'upserting one', fileDatetime:'2017-06-02 23:34:43',
	createDatetime: '2017-06-02 23:14:43', modifyDatetime:'2017-06-02 23:24:43'
}).$promise
.then(function(record){
	console.log('create a record', record)
})
.catch(function(err){
	console.log('eror in ctreating record', err)
});

My database table is:

CREAE TABLE `ftpProcessedLast` (
  `id` char(36) PRIMARY KEY NOT NULL ,
  `fileName` varchar(255) NOT NULL,
  `type` varchar(50),
  `fileDatetime` datetime NOT NULL,
  `createDatetime` datetime,
  `modifyDatetime` datetime
);