Method Create

internal/models/client_api_key.go:35–89

(ctx context.Context, clientName string, instanceID int)

}

func (s *ClientAPIKeyStore) Create(ctx context.Context, clientName string, instanceID int) (string, *ClientAPIKey, error) {
	// Generate new API key
	rawKey, err := GenerateAPIKey()
	if err != nil {
		return "", nil, fmt.Errorf("failed to generate API key: %w", err)
	}

	// Hash the key for storage
	keyHash := HashAPIKey(rawKey)

	// Use a transaction to atomically intern the string and insert the API key
	tx, err := s.db.BeginTx(ctx, nil)
	if err != nil {
		return "", nil, fmt.Errorf("failed to begin transaction: %w", err)
	}
	defer tx.Rollback()

	// Intern the client name
	ids, err := dbinterface.InternStringNullable(ctx, tx, &clientName)
	if err != nil {
		return "", nil, fmt.Errorf("failed to intern client_name: %w", err)
	}

	// Insert the client API key
	clientAPIKey := &ClientAPIKey{}
	var createdAt, lastUsedAt sql.NullTime
	err = tx.QueryRowContext(ctx, `
		INSERT INTO client_api_keys (key_hash, client_name_id, instance_id)
		VALUES (?, ?, ?)
		RETURNING id, key_hash, instance_id, created_at, last_used_at
	`, keyHash, ids[0], instanceID).Scan(
		&clientAPIKey.ID,
		&clientAPIKey.KeyHash,
		&clientAPIKey.InstanceID,
		&createdAt,
		&lastUsedAt,
	)

	if err != nil {
		return "", nil, err
	}

	if err = tx.Commit(); err != nil {
		return "", nil, fmt.Errorf("failed to commit transaction: %w", err)
	}

	clientAPIKey.ClientName = clientName
	clientAPIKey.CreatedAt = createdAt.Time
	if lastUsedAt.Valid {
		clientAPIKey.LastUsedAt = &lastUsedAt.Time
	}

	// Return both the raw key (to show user once) and the model
	return rawKey, clientAPIKey, nil
}

func (s *ClientAPIKeyStore) GetAll(ctx context.Context) ([]*ClientAPIKey, error) {
	query := `