Title: Deserilization to type String · Issue #4 · oatpp/example-postgresql · GitHub
Open Graph Title: Deserilization to type String · Issue #4 · oatpp/example-postgresql
X Title: Deserilization to type String · Issue #4 · oatpp/example-postgresql
Description: I have added the column 'created' to the table 'AppUser' in the example-postgresql CREATE TABLE IF NOT EXISTS AppUser ( id varchar (256) PRIMARY KEY, username varchar (256) NOT NULL, email varchar (256) NOT NULL, password varchar (256) N...
Open Graph Description: I have added the column 'created' to the table 'AppUser' in the example-postgresql CREATE TABLE IF NOT EXISTS AppUser ( id varchar (256) PRIMARY KEY, username varchar (256) NOT NULL, email varchar ...
X Description: I have added the column 'created' to the table 'AppUser' in the example-postgresql CREATE TABLE IF NOT EXISTS AppUser ( id varchar (256) PRIMARY KEY, username varchar (256) NOT NULL...
Opengraph URL: https://github.com/oatpp/example-postgresql/issues/4
X: @github
Domain: patch-diff.githubusercontent.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Deserilization to type String","articleBody":"I have added the column 'created' to the table 'AppUser' in the example-postgresql\r\n\r\n```\r\nCREATE TABLE IF NOT EXISTS AppUser (\r\n id varchar (256) PRIMARY KEY,\r\n username varchar (256) NOT NULL,\r\n email varchar (256) NOT NULL,\r\n password varchar (256) NOT NULL,\r\n role varchar (256) NULL,\r\n created timestamp DEFAULT now(), -- NEW COLUMN --\r\n CONSTRAINT UK_APPUSER_USERNAME UNIQUE (username),\r\n CONSTRAINT UK_APPUSER_EMAIL UNIQUE (email)\r\n);\r\n```\r\nI have modified 'UserDto.hpp' to add the field as String ` DTO_FIELD(String, created, \"created\");`\r\n\r\nbut when I try to test the endpoint of getUserById to select some user, I get the following error\r\n```\r\n{\r\n \"status\": \"ERROR\",\r\n \"code\": 500,\r\n \"message\": \"[oatpp::postgresql::mapping::Deserializer::deserializeString()]: Error. Unknown OID.\"\r\n}\r\n```\r\nas I understand from the error message I have to perform a conversion type to take the timestamp value to string \r\n\r\nHow can I do this?\r\n","author":{"url":"https://github.com/quijos12","@type":"Person","name":"quijos12"},"datePublished":"2022-02-07T15:17:14.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/4/example-postgresql/issues/4"}
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:b5787f94-4621-d3fb-aa50-83a5684cb09a |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | CF64:37CF59:73D16E9:9BE1CDA:698CCD56 |
| html-safe-nonce | 574aae310576022cfc4f627c4ded759522483d8df66bc1f08d07c126b7bb8899 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDRjY0OjM3Q0Y1OTo3M0QxNkU5OjlCRTFDREE6Njk4Q0NENTYiLCJ2aXNpdG9yX2lkIjoiODE2NTM1Njk2MzIyOTM4ODExOCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | c63513232a5df3db11970ca1cdbaa9a2c6152fce01e02cbc6fcd1f08fb9e39e4 |
| hovercard-subject-tag | issue:1126129980 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/oatpp/example-postgresql/4/issue_layout |
| twitter:image | https://opengraph.githubassets.com/eb32776c95e158db8b0dd993433fb49fa97fd0e72b15104174c3208151ae1fbd/oatpp/example-postgresql/issues/4 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/eb32776c95e158db8b0dd993433fb49fa97fd0e72b15104174c3208151ae1fbd/oatpp/example-postgresql/issues/4 |
| og:image:alt | I have added the column 'created' to the table 'AppUser' in the example-postgresql CREATE TABLE IF NOT EXISTS AppUser ( id varchar (256) PRIMARY KEY, username varchar (256) NOT NULL, email varchar ... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | quijos12 |
| hostname | github.com |
| expected-hostname | github.com |
| None | 640eeb7b6ff4d8d106235d228c0c286e82592d4d2403227b5b2b4fc5832297a4 |
| turbo-cache-control | no-preview |
| go-import | github.com/oatpp/example-postgresql git https://github.com/oatpp/example-postgresql.git |
| octolytics-dimension-user_id | 37167448 |
| octolytics-dimension-user_login | oatpp |
| octolytics-dimension-repository_id | 170488350 |
| octolytics-dimension-repository_nwo | oatpp/example-postgresql |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 170488350 |
| octolytics-dimension-repository_network_root_nwo | oatpp/example-postgresql |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 3d444f0a47beeeac94cddbb51c91ab408befe8d4 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width