Method GetAIProviderKeysByProviderID

coderd/database/queries.sql.go:249–277

Returns all keys for a provider, ordered by created_at ASC so the oldest key is returned first. AI Bridge currently uses the oldest key per provider; multiple keys are stored to support future failover and rotation flows.

(ctx context.Context, providerID uuid.UUID)

// key per provider; multiple keys are stored to support future
// failover and rotation flows.
func (q *sqlQuerier) GetAIProviderKeysByProviderID(ctx context.Context, providerID uuid.UUID) ([]AIProviderKey, error) {
	rows, err := q.db.QueryContext(ctx, getAIProviderKeysByProviderID, providerID)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var items []AIProviderKey
	for rows.Next() {
		var i AIProviderKey
		if err := rows.Scan(
			&i.ID,
			&i.ProviderID,
			&i.APIKey,
			&i.ApiKeyKeyID,
			&i.CreatedAt,
			&i.UpdatedAt,
		); err != nil {
			return nil, err
		}
		items = append(items, i)
	}
	if err := rows.Close(); err != nil {
		return nil, err
	}
	if err := rows.Err(); err != nil {
		return nil, err
	}
	return items, nil
}

const getAIProviderKeysByProviderIDs = `-- name: GetAIProviderKeysByProviderIDs :many
SELECT