我的SQL代码在MVC中应该放在哪里

Question

I'm just starting to learn the MVC design pattern, and I was wondering where should my SQL code go.

For example, lets say I have a register form structure that looks like this

type Form struct {
 Username string
 Password string
}

I assume that the form structure is part of the model, so I have some function that goes with the form that after a user submits the form, the data gets put into the database, so my function would look something like this

func (f *Form) registerUser() {
   // SQL code goes here
}

Is this the best way of doing it? I have been searching around for open source Golang web apps that utilizes the MVC pattern, but I have not be able to find one which I completely understand.

Answer 1

In model-view-controller pattern...

Model is for entities all your classes represent real world objects.

View is the forms and all the graphic things user can see and interact with.

Controller is for controller classes, is all the logic of the program, for the sql code as you said you can implement a dao pattern and have all the sql code in the controller package and the database class in the entities package(i leave it in the Controller class).