Use `gorm` in the backend code

[frouioui]

[achintya-7]

Hi @frouioui

I am not sure if gorm is a requirement for the project but can I suggest this package - sqlc
It can generate idiomatic Go functions as per the queries from *.sql files along with proper structs and types.

A simple example can be like this
query

-- name: GetBubblesWithThreshold :many
SELECT * FROM bubbles_profile
WHERE profile_key = $1 AND staged_images >= $2;

usage of generated function

args := GetBubblesWithThresholdParams{
	ProfileKey:   profile.Key,
	StagedImages: int64(config.TrainingThreshold),
}

bubbles, err := store.GetBubblesWithThreshold(ctx, args)

It can also generate an interface of all the quries as per the *.sql files which can make testing easier.

PS, It does require migration file/files of the SQL database to have a reference for generating structs and assigning of types.