: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
//! Deletes one team's rows from the Postgres person graph and the personhog
//! writer's temp tables, so a run starts from a clean slate.
use anyhow::{Context, Result};
use sqlx::postgres::PgPoolOptions;
use sqlx::{Executor, PgPool};
/// So a wedged delete fails the step instead of hanging it.
const STATEMENT_TIMEOUT_MS: u64 = 300_000;
pub struct ResetConfig {
pub database_url: String,
pub team_id: i64,
pub tmp_person_table: String,
pub tmp_pdi_table: String,
}
pub async fn reset_team(cfg: &ResetConfig) -> Result<()> {
let pool = PgPoolOptions::new()
.max_connections(1)
.after_connect(|conn, _meta| {
Box::pin(async move {
conn.execute(format!("SET statement_timeout = {STATEMENT_TIMEOUT_MS}").as_str())
.await?;
Ok(())
})
})
.connect(&cfg.database_url)
.await
.context("connecting to the persons database")?;
reset_team_on_pool(
&pool,
cfg.team_id,
&cfg.tmp_person_table,
&cfg.tmp_pdi_table,
)
.await
}
pub async fn reset_team_on_pool(
pool: &PgPool,
team_id: i64,
tmp_person_table: &str,
tmp_pdi_table: &str,
) -> Result<()> {
// Distinct-id rows reference persons, so delete them first.
for table in [
"posthog_persondistinctid",
tmp_pdi_table,
"posthog_person",
tmp_person_table,
] {
let deleted = sqlx::query(&format!("DELETE FROM {table} WHERE team_id = $1"))
.bind(team_id)
.execute(pool)
.await
.with_context(|| format!("resetting {table}"))?
.rows_affected();
tracing::info!(table, team_id, deleted, "reset team rows");
}
Ok(())
}