gorm | The fantastic ORM library for Golang, aims to be developer friendly | Object-Relational Mapping library

Here is list of available tags used in echo. If you want to parse from body, then use json

• query - source is request query parameters.
• param - source is route path parameter.
• header - source is header parameter.
• form - source is form. Values are taken from query and request body. Uses Go standard library form parsing.
• json - source is request body. Uses Go json package for unmarshalling.
• xml - source is request body. Uses Go xml package for unmarshalling.

You need to wrap time.Time into custom struct and then implement json.Marshaler and json.Unmarshaler interfaces

You can update the code as below to solve the issue.

Q1: Based on how you defined your structs, you don't need an explicit O2M relationship in the Company struct, but when loading Company details, if you want to load all users that are assigned to that specific company, you need to add that field as well. It will need an additional function call like Preload or Joins, but you shouldn't need an explicit definition of this relationship.

You need to add WorkingDirectory to your system file

You are almost there with the second query, you can combine the Preload and Where functions with it.

If the error occurs (only once), your databaseSingleton will not be setup. You should return the error in all cases.

Although this isn't something you can do anything about (since the attempt to initialize databaseSingleton will not be repeated due to the use of sync.Once), you could as well halt the app.

In fact, there is no point deferring this initialization, you could just do it during package init, and terminate if it fails. And if it succeeds, you could use databaseSingleton without having to check error of the initialization.

So simply do it like this:

It seems like .env file is not contained in your image.

Try to execute source .env after copying .env file into the image.

The gorm.io documentation says the following on the use of structs in Where conditionals:

When querying with struct, GORM will only query with non-zero fields, that means if your field’s value is 0, '', false or other zero values, it won’t be used to build query conditions ...

The suggested solution to this is:

To include zero values in the query conditions, you can use a map, which will include all key-values as query conditions ...

So, when the token header or both headers are empty, but you still want to include them in the WHERE clause of the generated query, you need to use a map instead of the struct as the argument to the Where method.

When connecting to the MySQL database, ensure you leverage the parseTime and loc parameters as per the docs:

to scan MySQL DATE and DATETIME values into time.Time variables, which is the logical equivalent in Go to DATE and DATETIME in MySQL. You can do that by changing the internal output type from []byte to time.Time with the DSN parameter parseTime=true. You can set the default time.Time location with the loc DSN parameter.

to generate a DSN connection strings to set parseTime & loc see i.e.