Changing default alias

[go-jet]

Changing default alias

[go-jet]

@wijayaerick You can use standard table sql aliasing. For instance:
client := Clients.AS("client")
and then use aliased table instead of Clients:
stmt := SELECT(client.AllColumns).FROM(client)

Or you can tag the fields. But you should use alias tag instead of db.
Sample usage can be seen here: https://github.com/go-jet/jet/wiki/Query-Result-Mapping-(QRM)#tagging-model-files

For example:

type Client struct {
	ID        uuid.UUID `alias:"clients.id"` 
	CreatedAt time.Time `alias:"clients.created_at"`
	UpdatedAt time.Time `alias:"clients.updated_at"`
	Username  string    `alias:"clients.username"`
}

Future version will add support for customizing generated model files(like names and types).
Is the additional 's' in the name, the only reason why you didn't want to use generated model files?

[wijayaerick]

@go-jet Thank you for the suggestion. Using empty alias does the trick; it removes the table name prefix in columns and still preserve table name in FROM statement.

The reason I'm using my own model Struct is because I have methods defined in my models, for example func NewModel(..) *Model, func (m *Model) IsSomething() bool, etc..

[go-jet]

@wijayaerick If that's the case you can embed generated model struct into your custom model struct. For instance:

package mymodel

import ".../model"

struct Client struct {
   model.Clients
}

func (c Client) isSomething() bool {
   return c.Username != ""
}

With this approach you don't need to change SQL query for scan to work.

[wijayaerick]

Haven't thought about using embedding. Yes, that should work well for me. Thank you for your help. Also this is a great project and I'm looking forward to future development of this project.