Need Help With Using Transactions

[b2jant]

Below Is my Gin Code with Neo4J but I am unable to get Delete working:

type UpdateAttorney struct {
	ID             int64    `json:"id"`
	Name           string   `json:"name"`
	Email          string   `json:"email"`
	Phone          string   `json:"phone"`
	Representation []string `json:"representation"`
}

func (h *AttorneyHandler) DeleteAttorney(c *gin.Context) {
	var attorney UpdateAttorney
	var responseData interface{}

	session := h.Driver.NewSession(c.Request.Context(), neo4j.SessionConfig{AccessMode: neo4j.AccessModeWrite})
	defer session.Close(c.Request.Context())

	writeQuery := `MATCH (n:Attorney) 
				   WHERE ID(n) = $id 
				   DETACH DELETE n`

	_, err := session.ExecuteWrite(c.Request.Context(), func(transaction neo4j.ManagedTransaction) (interface{}, error) {
		result, err := transaction.Run(c.Request.Context(), writeQuery, map[string]interface{}{
			"id": attorney.ID,
		})

		if err != nil {
			c.JSON(http.StatusInternalServerError, gin.H{"error": err.Error()})
			return nil, err
		}

		if result.Next(c.Request.Context()) {
			responseData = result.Record().Values[0]
			return responseData, nil
		}

		return nil, result.Err()
	})

	if err != nil {
		c.JSON(http.StatusInternalServerError, gin.H{"error": err.Error()})
		return
	}
	c.JSON(http.StatusOK, gin.H{"Message": "Successfully deleted attorney"})
}

[fbiville]

Hello @b2jant, do you still need help with this or did you figure out what the problem was?

[b2jant]

Hi @fbiville, I was able to figure out the problem. I forgot to bind the JSON body in my request to my attorney variable