CountOrganizations returns the number of organizations currently in the database.

CountUsers returns the number of users currently in the database.

DeleteAPIKey by ID restricted to the organization ID supplied.

Delete an invitation from the database by the token.

Fetch the project detail along with the status for the given project/organization.

GetAPIKey by Client ID.

Fetch all eligible API key permissions from the database.

GetUser by ID.

GetUser by delete confirmation token by doing a join with the organization_users table.

GetUser by verification token by executing a read-only transaction against the database.

GetUser by Email.

Get an invitation from the database by the token.

IdentifySubject is a helper tool to check the database to determine if the specified subject from authentication claims refers to a user or to an apikey.

ListAllOrgs returns a paginated collection of all organizations in the database.

ListAllUsers returns a paginated collection of all users in the database.

ListAPIKeys returns a paginated collection of APIKeys from the database filtered by the orgID and optionally by the projectID.

ListOrgUsers returns a paginated collection of users filtered by the orgID.

List the projects for the specified organization along with their key counts.

ListUserOrgs returns a paginated collection of organizations filtered by the userID.

RetrieveAPIKey by ID.

APIKey is a model that represents a row in the api_keys table and provides database functionality for interacting with api key data.

APIKeyPermission is a model representing a many-to-many mapping between api keys and permissions.

The Base model provides model audit functionality for setting created and modified timestamps in the database so we can track how rows are being modified over time.

ConstraintError attempts to parse a sqlite3.ErrConstraint error into a model error.

Organization is a model that represents a row in the organizations table and provides database functionality for interacting with an organizations's data.

OrganizationProject is a model representing the many-to-one mapping between projects and organizations.

OrganizationUser is a model representing a many-to-many mapping between users and organizations and describes the role each user has in their organization.

Permission is a model that represents a row in the permissions table and provides database functionality for interacting with permission data.

Project is a read-only model that is used to fetch project statistics from the organization projects mapping table, the apikeys table, and the revoked apikeys table.

Role is a model that represents a row in the roles table and provides database functionality for interacting with role data.

RolePermission is a model representing a many-to-many mapping between roles and permissions.

User is a model that represents a row in the users table and provides database functionality for interacting with a user's data.

User invitations are used to invite users to organizations.

Scanner is an interface for *sql.Rows and *sql.Row so that models can implement how they scan fields into their struct without having to specify every field every time.