Function getLatestAgentVersion

packages/internal/src/utils/version-utils.ts:54–87

(params: {
  agentId: string
  publisherId: string
  db: CodebuffPgDatabase
})

 * Get the latest version for an agent from the database
 */
export async function getLatestAgentVersion(params: {
  agentId: string
  publisherId: string
  db: CodebuffPgDatabase
}): Promise<Version> {
  const { agentId, publisherId, db } = params

  const latestAgent = await db
    .select({
      major: schema.agentConfig.major,
      minor: schema.agentConfig.minor,
      patch: schema.agentConfig.patch,
    })
    .from(schema.agentConfig)
    .where(
      and(
        eq(schema.agentConfig.id, agentId),
        eq(schema.agentConfig.publisher_id, publisherId),
      ),
    )
    .orderBy(
      desc(schema.agentConfig.major),
      desc(schema.agentConfig.minor),
      desc(schema.agentConfig.patch),
    )
    .limit(1)
    .then((rows) => rows[0])

  return {
    major: latestAgent?.major ?? 0,
    minor: latestAgent?.minor ?? 0,
    patch: latestAgent?.patch ?? 0,
  }
}

/**
 * Determine the next version for an agent