4 ms·
Yup! I actually use that in my own node-postgres api. So the code itself with typescript is here: https://github.com/vramework/vramework/blob/main/backend-com
by yasserf 5y ago
Yup! I actually use that in my own node-postgres api.
So the code itself with typescript is here:
https://github.com/vramework/vramework/blob/main/backend-common/src/services/database/database-postgres-client.ts#L27 https://github.com/vramework/vramework/blob/main/backend-com...
But the general gist is we have generic crud operators that are away of what the table are and based on that know the types of what we are returned.
const {viewId } = await database.crudInsert<UserJournal>(
'user_journal',
{ viewId, userId, srcOgg: src[0], sprite: JSON.stringify(sprite), duration },
['viewId']
)
await database.crudUpdate<UserJournal>('user_journal', { srcOgg: src[0], sprite: JSON.stringify(sprite), duration }, { viewId })
const { srcOgg, sprite, duration } = await database.crudGet<UserJournal>(
'user_journal',
['srcOgg', 'sprite', 'duration'],
{ viewId, userId },
new UserJournalNotFoundError()
)