// current implementationfunc (h*ApiKeyServiceHandler)GetAPIKey(ctx context.Context,req*connect.Request[sdp.GetAPIKeyRequest]) (*connect.Response[sdp.GetAPIKeyResponse],error) {// skipped authorization codedatabaseKey,err:=h.Queries.GetApiKeyByID(ctx, models.GetApiKeyByIDParams{ExternalID:id,AccountName:claims.AccountName,})// skipped error handlingresp:=connect.NewResponse(&sdp.GetAPIKeyResponse{Key:databaseKey.ToSDP(),})returnresp,nil}// ApiKey is the generated model from sqlcfunc (k*ApiKey)ToSDP()*sdp.APIKey {result:=&sdp.APIKey{Metadata:&sdp.APIKeyMetadata{Uuid:k.ExternalID[:],Created:&k.CreatedAt,LastUsed:k.LastUsed,Key:k.Key,Scopes:k.Scopes,Status:sdp.KeyStatus(k.Status),},Properties:&sdp.APIKeyProperties{Name:k.Name,},}ifk.Error.Valid {result.Metadata.Error=k.Error.String}returnresult}

-- name: GetApiKeyByID :oneSELECT*FROM api_keysWHERE account_name= @account_nameand external_id= @external_id;

-- name: GetApiKeyByID :one :go:result:*sdp.APIKeySELECT*FROM api_keysWHERE account_name= @account_nameand external_id= @external_id;

// current implementationfunc (h*ApiKeyServiceHandler)GetAPIKey(ctx context.Context,req*connect.Request[sdp.GetAPIKeyRequest]) (*connect.Response[sdp.GetAPIKeyResponse],error) {// skipped authorization codedatabaseKey,err:=h.Queries.GetApiKeyByID(ctx, models.GetApiKeyByIDParams{ExternalID:id,AccountName:claims.AccountName,})// skipped error handlingresp:=connect.NewResponse(&sdp.GetAPIKeyResponse{Key:databaseKey// pass object through directly})returnresp,nil}// no ApiKey model generated, no manual copying required

func (q*Queries)GetApiKeyByID(ctx context.Context,argGetApiKeyByIDParams) (*sdp.APIKey,error) {row:=q.db.QueryRowContext(ctx,getApiKeyByID,arg.AccountName,arg.ExternalID)varexternalId uuid.UuidvaraccountNamestring// etcerr:=row.Scan(&externalID,&accountName,// etc)vari sdp.APIKeyi.ExternalID=externalIdi.AccountName=accountName// etcreturn&i,err}