Package querybuilder is a small package which provides a single type for building sql queries.

AssignIdentityToGroups updates the identity's group membership relations based on the provider user's groups and returns the identity's current groups after the update has persisted them.

ClaimPasswordResetToken deletes the password reset token, and returns the user ID that was associated with the token.

CreateOrganization creates a new organization, and initializes it with settings, an infra provider, a connector user, and a grant for the connector.

TODO: accept only id instead of options struct.

GetAccessKey by any unique field.

GetAccessKeyByKeyID using the keyID.

GrantsMaxUpdateIndex returns the maximum update_index all the grants that match the query.

InfraConnectorIdentity returns the connector identity for the organization set in the db context.

InfraProvider returns the infra provider for the organization set in the tx.

ListenForNotify starts listening for notification on one or more postgres channels for notifications that a grant has changed.

NewDB creates a new database connection and runs any required database migrations before returning the connection.

ProvisionProviderUser directly creates a provider user and an identity (if the identity does not exist already) This is used exclusively for SCIM provisioning and initial sign-up.

RemoveUsersFromGroup removes any user ID listed in idsToRemove from the group with ID groupID.

UpdateDestinationLastSeenAt sets dest.LastSeenAt to now and then updates the row in the database.

UpdateIdentityLastSeenAt sets user.LastSeenAt to now and then updates the user row in the database.

TODO: move this to access package?.

DB wraps the underlying database and provides access to the default org, and settings.

Internal Pagination Data.

Transaction is a database transaction with metadata about the request that was given this transaction.

ReadTxn can perform read queries and contains metadata about the request.

WriteTxn extends ReadTxn by adding write queries.

StdlibTxn is a transaction that uses only the methods from the database/sql package.