:hedgehog: PostHog is the leading platform for building self-driving products. Our developer tools – AI observability, analytics, session replay, flags, experiments, error tracking, logs, and more – capture all the context agents need to diagnose problems, uncover opportunities, and ship fixes. Steer it all from Slack, web, desktop, or the MCP.
Python ab-testingai-analyticsanalyticscdpdata-warehouseexperimentsfeature-flagsjavascriptproduct-analyticspythonreactsession-replaysurveystypescriptweb-analytics
import { IntegrationType } from '~/cdp/types'
import { EncryptedFields } from '~/cdp/utils/encryption-utils'
import { PostgresRouter, PostgresUse } from '~/common/utils/db/postgres'
import { DEFAULT_LOADER_RETRY, LazyLoader } from '~/common/utils/lazy-loader'
import { logger } from '~/common/utils/logger'
import { PubSub } from '~/common/utils/pubsub'
export class IntegrationManagerService {
private lazyLoader: LazyLoader<IntegrationType>
constructor(
private pubSub: PubSub,
private postgres: PostgresRouter,
private encryptedFields: EncryptedFields
) {
this.lazyLoader = new LazyLoader({
name: 'integration_manager',
loader: async (ids) => await this.fetchIntegrations(ids),
loaderRetry: DEFAULT_LOADER_RETRY,
})
this.pubSub.on<{ integrationIds: IntegrationType['id'][] }>('reload-integrations', (message) => {
logger.debug('⚡', '[PubSub] Reloading integrations!', { integrationIds: message.integrationIds })
this.onIntegrationsReloaded(message.integrationIds)
})
}
public async get(id: IntegrationType['id']): Promise<IntegrationType | null> {
return (await this.lazyLoader.get(id.toString())) ?? null
}
public async getMany(ids: IntegrationType['id'][]): Promise<Record<IntegrationType['id'], IntegrationType | null>> {
return await this.lazyLoader.getMany(ids.map((id) => id.toString()))
}
private onIntegrationsReloaded(integrationIds: IntegrationType['id'][]): void {
this.lazyLoader.markForRefresh(integrationIds.map((id) => id.toString()))
}
private async fetchIntegrations(ids: string[]): Promise<Record<string, IntegrationType | undefined>> {
logger.info('[IntegrationManager]', 'Fetching integrations', { ids })
const response = await this.postgres.query<IntegrationType>(
PostgresUse.COMMON_READ,
`SELECT id, team_id, kind, config, sensitive_config FROM posthog_integration WHERE id = ANY($1)`,
[ids],
'fetchIntegrations'
)
const items = response.rows
return items.reduce<Record<string, IntegrationType | undefined>>((acc, item) => {
const sensitiveConfig = this.encryptedFields.decryptObject(item.sensitive_config || {}, {
ignoreDecryptionErrors: true,
})
acc[item.id] = {
...item,
sensitive_config: sensitiveConfig,
}
return acc
}, {})
}
}