Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

missing "type" and "meta" columns #102

Closed
a-wf opened this issue Dec 10, 2018 · 0 comments · May be fixed by #107
Closed

missing "type" and "meta" columns #102

a-wf opened this issue Dec 10, 2018 · 0 comments · May be fixed by #107

Comments

@a-wf
Copy link

a-wf commented Dec 10, 2018 •
edited
Loading

I am working with a postgreSQL database, I simply tried a Get request on 0.0.0.0/my_table and I get

sequelize:pool connection acquired +3s
  sequelize:sql:pg executing(default) : SELECT count(*) AS "count" FROM "my_table" AS "my_table"; +3s
  sequelize:sql:pg executed(default) : SELECT count(*) AS "count" FROM "my_table" AS "my_table"; +2ms
  sequelize:pool connection released +2ms
  sequelize:pool connection acquired +2ms
  sequelize:sql:pg executing(default) : SELECT "id", "type", "meta", "name", "mobilenumber" FROM "my_table" AS "my_table"; +2ms
  sequelize:pool connection released +2ms
  sequelize:pool connection drain due to process exit +3s
  sequelize:pool connection destroy +1ms
...
...
  jagql:requestCounter 0 GET /my_table +0ms
  jagql:validation:input {"type":"my_table"} +0ms
  jagql:handler:search {"type":"my_table","page":{"offset":0,"limit":50}} [{"status":"500","code":"EUNKNOWN","title":"An unknown error has occured","detail":"Something broke when connecting to the database - column \"meta\" does not exist"},null,null] +0ms
  jagql:errors GET /my_table {"status":"500","code":"EUNKNOWN","title":"An unknown error has occured","detail":"Something broke when connecting to the database - column \"type\" does not exist"} +0ms

However there is no "type", and "meta" column in my_table.

ps: I also tested the jagql module, and I have the missed "meta" issues...

I read the #53 issue ticket, however I don't know if it is fixed.. It is not clear in the ticket 😞 😢
justinr1234 added a commit to justinr1234/jsonapi-store-relationaldb that referenced this issue Nov 29, 2019
@justinr1234
Mark meta attribute as virtual
0188558 
Fixes holidayextras#102
@justinr1234 justinr1234 mentioned this issue Nov 29, 2019
Open
@a-wf a-wf closed this as completed Dec 7, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Mark meta attribute as virtual justinr1234/jsonapi-store-relationaldb
1 participant
@a-wf