invalid character '-' in numeric literal
Keeps coming back EMPTY!

Golang code

type InlineObject struct {

  Username string json:"username,omitempty"

  Name string json:"name,omitempty"

  Password string json:"password,omitempty"
}

func Register(c *gin.Context) {
  var user InlineObject

  // current problem with binding
  err :=  c.ShouldBindJSON(&user)
  if err != nil {
    log.Println(user.Username)
    fmt.Println(err.Error())
  }
  log.Println(c.Params)
}

Error

GIN] 2021/01/29 - 02:26:17 | 200 |      2.9992ms |             ::1 | GET      "/api/v1/jobReports"
invalid character '-' in numeric literal
[GIN] 2021/01/29 - 02:36:20 | 400 |            0s |             ::1 | POST     "/api/v1/register?username=brando&name=Marlon&password=orange"
2021/01/29 02:36:20 
2021/01/29 02:36:20 []

Should be

[brando, Marlon, orange]

TODO - try out different ways of binding

1: Angular/Ionic app set up.
2: Golang BackEnd Server set up.
3: Made a Linux Server with ports 3306 & 8080 for mysql and Golang Server.
4: Made SQL Server with account John to access from anywhere.
5: Golang BackEnd Server is working with MySQL.

Now that this is all in place I just need to get some requests working for the BackEnd Server with Golang and MySQL.

I have worked out some MySQL JOIN queries that will be needed to display the data from 4 different tables in the database to the actual app itself. This is mainly to be able to display a Service Report Card of the data which is one of the app's main functions. I have broken the data up into blocks. The data is as follows:

Block 1

• Report number -- Date
• Customer name -- Vehicle model
• Vehicle registration -- Vehicle location
• Miles on vehicle -- Warranty | Breakdown

Block 2

• Customer complaint -- Cause
• Correction -- Parts

Block 3

• Worker name -- Work hours

This website really helped me complete this.

Issue for Tracking Tests.

The backend has been now generated by the openapi-generator project. This allowed to have a better set up for the server rather than having the code all in the main.go file.

I realized I have to redesign the database in order for these JOIN queries to work. The values in the database are not unique enough and that is why their outputs are duplicating. I need to add more variety to it. e.g. instead or having 'worker_id 1, 2, 3, 4' I need to do' worker_id 14, 23, 45, 66' and so on.

This will lead to do a Test Driven Development.
I have to start small, take one input for each table and verify query is correct for every possible outcome. Then increment slowly.

Test all possible routes with one worker_id ...

Two endpoints can't be defined with the same URL when using different request methods like GET and POST...

The BackEnd server is now set up to get the automobiles table data from the database 'repotadb'.

JSON parsing bools

The Database was refactored as it made more sense for creating and updating but some values were changed to booleans to work as tick boxes in the app.

Currently having JSON issues with parsing booleans from MySQL database.

The Client is requesting the data from the server and the server has no problem sending the data but as of now when it comes to the client - JSON cannot parse it.

Cookies are not being set in Browsers but are in Postman.

Using Golang with Gin.

c *gin.Context

c.SetCookie("session_id", session.Token, session.Expiry, "/", "localhost", false, false)

Ionic Checkboxes

The checkboxes do not currently input any values to the database. There definitely is a way to do this, It just needed to be figured out.