postgresql - 带有 PostgreSQL 数据库的环回用户模型
问题描述
我在通过 api explorer 使用环回在 postgresql 数据库上发布我的代码时遇到错误。下面是我的 consumer.json
{
"name": "consumer",
"plural": "consumers",
"base": "User",
"idInjection": false,
"options": {
"validateUpsert": true
},
"properties": {
"id":{
"type":"number",
"required":true,
"id":true
}
},
"validations": [],
"relations": {},
"acls": [],
"methods": {}
}
我的模型-config.json
{
"_meta": {
"sources": [
"loopback/common/models",
"loopback/server/models",
"../common/models",
"./models"
],
"mixins": [
"loopback/common/mixins",
"loopback/server/mixins",
"../common/mixins",
"./mixins"
]
},
"User": {
"dataSource": "practise"
},
"AccessToken": {
"dataSource": "practise",
"public": false,
"relations": {
"user": {
"type": "belongsTo",
"model": "person",
"foreignKey": "id"
}
}
},
"ACL": {
"dataSource": "practise",
"public": false
},
"RoleMapping": {
"dataSource": "practise",
"public": false,
"options": {
"strictObjectIDCoercion": true
}
},
"Role": {
"dataSource": "practise",
"public": false
},
"person": {
"dataSource": "practise",
"public": true
},
"customer": {
"dataSource": "practise",
"public": true
},
"customuser": {
"dataSource": "practise",
"public": true
},
"consumer": {
"dataSource": "practise",
"public": true
},
"priority": {
"dataSource": "practise",
"public": true
}
}
以下是错误:
{ "error": {
"statusCode": 500,
"name": "error",
"message": "column \"id\" does not exist",
"length": 164,
"severity": "ERROR",
"code": "42703",
"position": "8",
"file": "d:\\pginstaller_12.auto\\postgres.windows-x64\\src\\backend\\parser\\parse_relation.c",
"line": "3359",
"routine": "errorMissingColumn",
"stack": "error: column \"id\" does not exist\n at Connection.parseE (D:\\Users\\Yesha.Bhatt\\Documents\\authpractise\\node_modules\\pg\\lib\\connection.js:614:13)\n at Connection.parseMessage (D:\\Users\\Yesha.Bhatt\\Documents\\authpractise\\node_modules\\pg\\lib\\connection.js:413:19)\n at Socket.<anonymous> (D:\\Users\\Yesha.Bhatt\\Documents\\authpractise\\node_modules\\pg\\lib\\connection.js:129:22)\n at Socket.emit (events.js:311:20)\n at addChunk (_stream_readable.js:294:12)\n at readableAddChunk (_stream_readable.js:275:11)\n at Socket.Readable.push (_stream_readable.js:209:10)\n at TCP.onStreamRead (internal/stream_base_commons.js:186:23)" } }
我也将 id 作为我的 PostgreSQL DB 中的列。错误不断变化,但我无法使用 PostgreSQL 在数据库上发布数据。
解决方案
从代码中,您正在使用 loopbackv3,您的架构可能有问题,您曾经交叉检查架构,或者您可以将其粘贴到此处。
推荐阅读
- html - Angular 模板驱动形式:重置值和状态(原始、脏、触摸、无效)
- javascript - 提交表单使用 turbolinks 重新加载页面
- node.js - dispatch wont trigger inside a component with switch
- google-chrome - Not able to preview 50MB image in Chrome using FileReader()
- angular - What is the best way to send calls in Angular to an API?
- visual-studio - Visual Studio 报告 System.Reflection.MissingMetadataException 编译时使用 .net 本机工具链
- netsuite - formulatext filter in search - SuiteScript 2.0
- python - How to return a data path using class in python
- ios - Is there any way to put a segmented picker into a scrollview in SwiftUI?
- sql - 在滚动两周内查找唯一计数