环回邮API错误

Question

我只是了解回环从StrongLoop创建一个简单的API。

我得到了一些麻烦，使API作品。

这里是我的配置：

model.js 
-------- 
'use strict'; 

module.exports = function(Account) { 

}; 

这是我model.json：

{ 
    "name": "Account", 
    "base": "PersistedModel", 
    "idInjection": false, 
    "options": { 
    "validateUpsert": true 
    }, 
    "properties": { 
    "id": { 
     "type": "string", 
     "required": true, 
     "defaultFn": "uuidv4", 
     "postgresql": { 
     "columnName": "id", 
     "dataType": "uuid" 
     } 
    }, 
    "code": { 
     "type": "string", 
     "required": true, 
     "postgresql": { 
     "columnName": "code", 
     "dataType": "character varying", 
     "dataLength": "50" 
     } 
    }, 
    "name": { 
     "type": "string", 
     "required": true, 
     "postgresql": { 
     "columnName": "name", 
     "dataType": "text" 
     } 
    }, 
    "type": { 
     "type": "string", 
     "required": true, 
     "postgresql": { 
     "columnName": "type", 
     "dataType": "character varying", 
     "dataLength": "50" 
     } 
    }, 
    "isActive": { 
     "type": "boolean", 
     "required": true, 
     "default": true 
    }, 
    "isDelete": { 
     "type": "boolean", 
     "required": true, 
     "default": false 
    }, 
    "createdBy": { 
     "type": "string", 
     "required": true, 
     "defaultFn": "uuidv4", 
     "postgresql": { 
     "columnName": "createdBy", 
     "dataType": "uuid" 
     } 
    }, 
    "updatedBy": { 
     "type": "string", 
     "required": true, 
     "defaultFn": "uuidv4", 
     "postgresql": { 
     "columnName": "updatedBy", 
     "dataType": "uuid" 
     } 
    }, 
    "createdAt": { 
     "type": "date", 
     "required": true, 
     "defaultFn": "now" 
    }, 
    "updatedAt": { 
     "type": "date", 
     "required": true, 
     "defaultFn": "now" 
    } 
    }, 
    "validations": [], 
    "relations": {}, 
    "acls": [], 
    "methods": {} 
} 

下面的模型已迁移全成，我使用PostgreSQL为我的分贝。

问题是，当回环创建CRUD标准API，该API POST似乎当我尝试POST方法将无法正常工作。下面是我的JSON字符串，当我试图把对API的探险家：

{ 
    "id": "123e4567-e89b-12d3-a456-426655440000", 
    "code": "1000", 
    "name": "Cash and Bank", 
    "type": "Assets", 
    "isActive": true, 
    "isDelete": false, 
    "createdBy": "123e4567-e89b-12d3-a456-426655440000", 
    "updatedBy": "123e4567-e89b-12d3-a456-426655440000", 
    "createdAt": "2017-09-01T17:00:00.000Z", 
    "updatedAt": "2017-09-01T17:00:00.000Z" 
    } 

但它抛出一个错误，这里是响应正文：

{ 
    "error": { 
    "statusCode": 500, 
    "name": "error", 
    "message": "syntax error at end of input", 
    "length": 92, 
    "severity": "ERROR", 
    "code": "42601", 
    "position": "230", 
    "file": "scan.l", 
    "line": "1078", 
    "routine": "scanner_yyerror", 
    "stack": "error: syntax error at end of input\n at Connection.parseE (/media/andylpjr/EA7C669F7C6665F3/Project/kpost/kpost-api/node_modules/pg/lib/connection.js:567:11)\n at Connection.parseMessage (/media/andylpjr/EA7C669F7C6665F3/Project/kpost/kpost-api/node_modules/pg/lib/connection.js:391:17)\n at Socket.<anonymous> (/media/andylpjr/EA7C669F7C6665F3/Project/kpost/kpost-api/node_modules/pg/lib/connection.js:129:22)\n at emitOne (events.js:96:13)\n at Socket.emit (events.js:191:7)\n at readableAddChunk (_stream_readable.js:178:18)\n at Socket.Readable.push (_stream_readable.js:136:10)\n at TCP.onread (net.js:561:20)" 
    } 
} 

对于笔记时，我从尝试pgadmin使用SQL查询插入到表中。例如“插入帐户值（bla bla bla）”。我知道这可能只是一个常见的错误，请帮助。对不起英语不好。

Answer 1

好结案，看来我丢失了主键我的模型定义，真可惜..谢谢你们。