Skip to content

Latest commit

 

History

History
 
 

queries

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
src
src
 
 
README.md
README.md
 
 
decrementFreeTemplatesRemaining.ts
decrementFreeTemplatesRemaining.ts
 
 
getActiveMeetingSeries.ts
getActiveMeetingSeries.ts
 
 
getAtlassianAuthByUserIdTeamId.ts
getAtlassianAuthByUserIdTeamId.ts
 
 
getAtlassianAuthsByUserId.ts
getAtlassianAuthsByUserId.ts
 
 
getAtlassianAuthsToUpdate.ts
getAtlassianAuthsToUpdate.ts
 
 
getAzureDevOpsDimensionFieldMaps.ts
getAzureDevOpsDimensionFieldMaps.ts
 
 
getBestTeamIntegrationAuth.ts
getBestTeamIntegrationAuth.ts
 
 
getDiscussionsByIds.ts
getDiscussionsByIds.ts
 
 
getDomainJoinRequestsByIds.ts
getDomainJoinRequestsByIds.ts
 
 
getGitHubAuthByUserIdTeamId.ts
getGitHubAuthByUserIdTeamId.ts
 
 
getGitHubDimensionFieldMaps.ts
getGitHubDimensionFieldMaps.ts
 
 
getGitLabDimensionFieldMaps.ts
getGitLabDimensionFieldMaps.ts
 
 
getIntegrationProvidersByIds.ts
getIntegrationProvidersByIds.ts
 
 
getJiraDimensionFieldMap.ts
getJiraDimensionFieldMap.ts
 
 
getJiraServerDimensionFieldMap.ts
getJiraServerDimensionFieldMap.ts
 
 
getLatestIntegrationSearchQueries.ts
getLatestIntegrationSearchQueries.ts
 
 
getLatestTaskEstimates.ts
getLatestTaskEstimates.ts
 
 
getMeetingSeriesByIds.ts
getMeetingSeriesByIds.ts
 
 
getMeetingTaskEstimates.ts
getMeetingTaskEstimates.ts
 
 
getMeetingTemplatesByIds.ts
getMeetingTemplatesByIds.ts
 
 
getPollOptionsByPollIds.ts
getPollOptionsByPollIds.ts
 
 
getPollsByDiscussionIds.ts
getPollsByDiscussionIds.ts
 
 
getPollsByIds.ts
getPollsByIds.ts
 
 
getSimilarTaskEstimate.ts
getSimilarTaskEstimate.ts
 
 
getTeamIdsByOrgIds.ts
getTeamIdsByOrgIds.ts
 
 
getTeamPromptResponsesByMeetingIds.ts
getTeamPromptResponsesByMeetingIds.ts
 
 
getTemplateRefsByIds.ts
getTemplateRefsByIds.ts
 
 
getUsersByDomain.ts
getUsersByDomain.ts
 
 
getUsersByEmails.ts
getUsersByEmails.ts
 
 
getUsersByIds.ts
getUsersByIds.ts
 
 
insertMeetingSeries.ts
insertMeetingSeries.ts
 
 
insertPollWithOptions.ts
insertPollWithOptions.ts
 
 
insertStripeQuantityMismatchLogging.ts
insertStripeQuantityMismatchLogging.ts
 
 
insertTaskEstimate.ts
insertTaskEstimate.ts
 
 
removeAtlassianAuth.ts
removeAtlassianAuth.ts
 
 
removeGitHubAuth.ts
removeGitHubAuth.ts
 
 
removeIntegrationProvider.ts
removeIntegrationProvider.ts
 
 
removeIntegrationSearchQuery.ts
removeIntegrationSearchQuery.ts
 
 
removeMeetingTaskEstimates.ts
removeMeetingTaskEstimates.ts
 
 
removeMeetingTemplatesForTeam.ts
removeMeetingTemplatesForTeam.ts
 
 
removeTeamMemberIntegrationAuth.ts
removeTeamMemberIntegrationAuth.ts
 
 
restartMeetingSeries.ts
restartMeetingSeries.ts
 
 
updateDiscussions.ts
updateDiscussions.ts
 
 
updateGitHubSearchQueries.ts
updateGitHubSearchQueries.ts
 
 
updateJiraDimensionFieldMap.ts
updateJiraDimensionFieldMap.ts
 
 
updateJiraSearchQueries.ts
updateJiraSearchQueries.ts
 
 
updateMeetingTemplateFreeStatusById.ts
updateMeetingTemplateFreeStatusById.ts
 
 
updateMeetingTemplateFreeStatusByName.ts
updateMeetingTemplateFreeStatusByName.ts
 
 
updateMeetingTemplateLastUsedAt.ts
updateMeetingTemplateLastUsedAt.ts
 
 
updateMeetingTemplateName.ts
updateMeetingTemplateName.ts
 
 
updateTeamByOrgId.ts
updateTeamByOrgId.ts
 
 
updateTeamByTeamId.ts
updateTeamByTeamId.ts
 
 
updateUser.ts
updateUser.ts
 
 
updateUserEmailDomainsToPG.ts
updateUserEmailDomainsToPG.ts
 
 
upsertAtlassianAuths.ts
upsertAtlassianAuths.ts
 
 
upsertAzureDevOpsDimensionFieldMap.ts
upsertAzureDevOpsDimensionFieldMap.ts
 
 
upsertGitHubAuth.ts
upsertGitHubAuth.ts
 
 
upsertGitHubDimensionFieldMap.ts
upsertGitHubDimensionFieldMap.ts
 
 
upsertGitLabDimensionFieldMap.ts
upsertGitLabDimensionFieldMap.ts
 
 
upsertIntegrationProvider.ts
upsertIntegrationProvider.ts
 
 
upsertIntegrationSearchQuery.ts
upsertIntegrationSearchQuery.ts
 
 
upsertJiraDimensionFieldMap.ts
upsertJiraDimensionFieldMap.ts
 
 
upsertJiraServerDimensionFieldMap.ts
upsertJiraServerDimensionFieldMap.ts
 
 
upsertTeamMemberIntegrationAuth.ts
upsertTeamMemberIntegrationAuth.ts
 
 
upsertTeamPromptResponses.ts
upsertTeamPromptResponses.ts
 
 

README.md

README

Each file in this directory is a helper function that calls a generated query. The helper functions are useful because they make code easier to manage:

  • Add stricter types that PGtyped fails to generate
  • Only take query params, they get the client pool themselves
  • Return the first object when the query is guaranteed to only return 1 row

/generated

The contents of this folder are created by running yarn pg:build from the project root. It includes the raw SQL ASTs that are passed to PG as well as some rough typings.

/src

These are all the annotated SQL files used by pgtyped to create the SQL ASTs. PG typed handles all object & array expansion so things like inserting multiple rows is easy.