The fantastic ORM library for Golang, aims to be developer friendly, check http://gorm.io/community.html#Ask before ask
type Name struct {
gorm.Model // creates fields for created/modified dates and id
ExampleField string
ExampleField int
// and so on...
}
db.AutoMigrate(&Name{})func StartDB() {} with all the migration commands for each model and caching commands, then I trigger that on startup to generate everything
DB, DBError := gorm.Open(...), then as part of your startdb function you can check for an error to make sure that everything loaded in properly and stop the app with a console msg or similar if db load fails
Hi All :)
For a new app that I'm developing, I need to read and approve the SQL commands before committing them to the database.
For example, forCreate(&User{name:"John"})
I need to have the gorm-transalated SQL command : INSERT INTO users (name) VALUES ("John"); before the transaction is committed.
Is it possible to do it with gorm? how can I extract the about-to-be-executed SQL commands?
Thanks!
I've created a gorm plugin for OpenTelemetry, very handy if you use that for tracing.
https://github.com/kostyay/gorm-opentelemetry
"service_credentials" ("created_at","updated_at","archived_at","source_ref","source_created_at","last_seen_at","name","type_name","description","tenant_id","source_id") VALUES ('2021-01-01 14:46:01.031','2021-01-01 14:46:01.031',NULL,'4','2020-01-08 10:22:59.423',NULL,'demo','','desc',99,1) RETURNING "id",”service_credential_type_id"
Versus
INSERT INTO "service_credentials" ("created_at","updated_at","archived_at","source_ref","source_created_at","last_seen_at","name","type_name","description","tenant_id","source_id") VALUES ('2021-01-01 14:47:25.842','2021-01-01 14:47:25.842',NULL,'4','2020-01-08 10:22:59.423',NULL,'demo','','desc',99,1) RETURNING "service_credential_type_id",”id"
Hey!
I'm running in to an issue when trying to migrate my customized Many2Many table, i keep getting a "invalid memory address or nil pointer dereference", which ive traced down to a relationship on the join table.
The only issue is.. that this is not a relation that i've added myself, It seems to be a fully nilled out relation to itself, so when trying to get the rel.Field.TagSettings["CONSTRAINT"] in relationship.go:475 it panics.
The join table:
type EventAttendee struct {
EventID uint64 `gorm:"index:unique_attendee,unique"`
CharacterID uint64 `gorm:"index:unique_attendee,unique"`
Role string
CreatedAt time.Time `gorm:"default:now()"`
UpdatedAt time.Time `gorm:"default:now()"`
DeletedAt gorm.DeletedAt `gorm:"index" json:"-"`
}
Hey fellas,
I'm working with Gormv2 and Postgres. I cannot get the following code to work because I suspect Gorm isn't escaping table names properly for Postgres.
db.Exec(
"DELETE FROM ? WHERE id IN (SELECT seed_id FROM seeds WHERE table_name = ?)",
tableName,
tableName,
)If I change the code to the following, it works.
db.Exec(
"DELETE FROM \"users\" WHERE id IN (SELECT seed_id FROM seeds WHERE table_name = ?)",
tableName,
)or
db.Exec(
"DELETE FROM users WHERE id IN (SELECT seed_id FROM seeds WHERE table_name = ?)",
tableName,
)
Hey there,
I am trying to add a record with a map as follow:
var newRow map[string]interface{}
tx.Create(newRow)How can I get the id of the inserted record or the other field that does not exist in the newRow map in the case that I am not using a struct?
I have tried to do as follow:
addedRow := map[string]interface{}{}
tx.Create(newRow).Order("id DESC").Find(&addedRow).Limit(1)However, I consider, it is not an optimized approach!
Thanks
you aren't really doing that in a logical way
Is working with GORM without structs recommend for a data provider layer of an application? Actually, there are a lot of tables, which have to be modeled with structs then. And, a dynamic table and struct selection is another consideration.
1 reply
type User struct {
//gorm.Model
ID string json:"id" gorm:"primary_key"
LastLogin time.Time json:"last_login"
UserCount uint json:"user_count"
Roles []Role gorm:"many2many:user_roles;"
}
//Role are exported
type Role struct {
//gorm.Model
ID uint json:"id" gorm:"primary_key"
Name string json:"name"
}
when pesisting the user records into mysql db then getting error like below.
//save user and rolesrecords into database
db.Save(&user)
error:
Error 1366: Incorrect integer value: 'ń' for column 'user_id' at row 1 ←[0m
Please let me know the solution for the same.
The Demo
https://gorm.io/docs/advanced_query.html#Group-Conditions
db.Where(
db.Where("pizza = ?", "pepperoni").Where(db.Where("size = ?", "small").Or("size = ?", "medium")),
).Or(
db.Where("pizza = ?", "hawaiian").Where("size = ?", "xlarge"),
).Find(&Pizza{}).Statement
// SELECT * FROM `pizzas` WHERE (pizza = "pepperoni" AND (size = "small" OR size = "medium")) OR (pizza = "hawaiian" AND size = "xlarge")But my code
var result []map[string]interface{}
db = db.Table("test")
db.Where(
db.Where("pizza = ?", "pepperoni").Where(db.Where("size = ?", "small").Or("size = ?", "medium")),
).Or(
db.Where("pizza = ?", "hawaiian").Where("size = ?", "xlarge"),
).Find(&result)I got sql
SELECT * FROM `test` WHERE pizza = 'pepperoni' AND size = 'small' OR size = 'medium' AND (pizza = 'pepperoni' AND size = 'small' OR size = 'medium') AND (pizza = 'pepperoni' AND size = 'small' OR size = 'medium' AND (pizza = 'pepperoni' AND size = 'small' OR size = 'medium')) AND pizza = 'hawaiian' AND size = 'xlarge' OR (pizza = 'pepperoni' AND size = 'small' OR size = 'medium' AND (pizza = 'pepperoni' AND size = 'small' OR size = 'medium') AND (pizza = 'pepperoni' AND size = 'small' OR size = 'medium' AND (pizza = 'pepperoni' AND size = 'small' OR size = 'medium')) AND pizza = 'hawaiian' AND size = 'xlarge')
Where(&paymentSchema, map[string]interface{}{
"modality": paymentScheme.Modality().Value(),
"brand": brand,
}) , How find with string nil ?
Hello Guys..
Please do the needful for help.I'm using two table User and roles with many2many relationship ,once saving the records into DB then getting issue as mentioned .
type User struct {
//gorm.Model
ID string json:"id" gorm:"primary_key"
LastLogin time.Time json:"last_login"
UserCount uint json:"user_count"
Roles []Role gorm:"many2many:user_roles;"
}
//Role are exported
type Role struct {
//gorm.Model
ID uint json:"id" gorm:"primary_key"
Name string json:"name"
}
when pesisting the user records into mysql db then getting error like below.
//save user and rolesrecords into database
var roles []Role
db.Model(Role{}).Where("Name = ?", "ROLE_ADMIN").Take(&roles)
newUser:=&User{Password:EncodePassword(user.Password),CreatedTimeStamp:time.Now(),UpdateTimeStamp:time.Now(),LastLogin:time.Now(),Roles:roles}
db.Save(&user)
error:
Error 1366: Incorrect integer value: 'ń' for column 'user_id' at row 1 ←[0m
Please suggest what is the issue ?
