The fantastic ORM library for Golang, aims to be developer friendly, check http://gorm.io/community.html#Ask before ask
Hello,
I am implementing some delete functionality using GORM. My idea is to cascade delete where when the parent row is deleted, the childern are deleted aswell. I have tried the delete with select. But it only deletes the parent record.
func DeleteProject(db *gorm.DB, id uint) (Project, error) {
var project Project
if err := db.Select(clause.Associations).Delete(&project, id).Error; err != nil {
return Project{}, err
}
return project, nil
}I have the following model:
type Project struct {
ID uint `gorm:"primary_key" json:"id"`
CreatedAt time.Time `json:"created_at"`
UpdatedAt time.Time `json:"updated_at"`
DeletedAt gorm.DeletedAt `gorm:"index" json:"deleted_at"`
TicketNumber string `gorm:"size:6;unique;not null" json:"ticketnumber"`
Name string `json:"name"`
MailingList string `json:"mailinglist"`
Environment string `gorm:"not null" json:"environment"`
UserID uint `gorm:"index" json:"user_id"`
Diagrams []Diagram `json:"diagrams"`
}
type Diagram struct {
ID uint `gorm:"primary_key" json:"id"`
CreatedAt time.Time `json:"created_at"`
UpdatedAt time.Time `json:"updated_at"`
DeletedAt gorm.DeletedAt `gorm:"index" json:"deleted_at"`
Data string `json:"data"`
ProjectID uint `gorm:"index" json:"project_id"`
Instances []Instance `json:"instances"`
}
type Instance struct {
ID uint `gorm:"primary_key" json:"id"`
CreatedAt time.Time `json:"created_at"`
UpdatedAt time.Time `json:"updated_at"`
DeletedAt gorm.DeletedAt `gorm:"index" json:"deleted_at"`
Key uint `json:"key"`
DiagramID uint `gorm:"index" json:"diagram_id"`
}Where a project can have multiple diagrams and a diagram can have multiple instances. But when I am running the DeleteProject function it is only deleting the Project and not the associated diagrams and instances.
How can I delete a project and it's associated diagrams and instances in this case?
Hi! I'm having a bit of trouble selecting multiple rows.
I have defined User as
type User struct {
ID string `gorm:"primaryKey"`
Name string
IsAdmin bool `gorm:"default:false"`
CreatedAt time.Time
UpdatedAt time.Time
DeletedAt gorm.DeletedAt
}and am trying to get all users with
var users []models.User
result := db.GetDB().Find(&users)but keep getting runtime error: invalid memory address or nil pointer dereferenceon the last line
Hi there! I need some help with a simple query.
These are my data models(simplified)
type Conference struct {
gorm.Model `json:"-"`
Name string
Tags []Tag `gorm:"many2many:conference_tags;"`
}
type Tag struct {
gorm.Model `json:"-"`
TagName string
Conferences []Conference `gorm:"many2many:conference_tags;"`
}My Goal is to query so that:
given a list of tags
a list of conferences that are connected to the given tags is returned
My attempts were to preload the tags into the conference table
starting with this query i was not able to access the tagnames and filter by those
db.Preload("Tags").Find(&conferences)
db.Preload("Tags").Where("tag_name IN ?", []string{"javascript", "css", "devops"}).Order("start_date ASC").Find(&conferences) //failssecond query outupts cannot find table named tag_name
(this example is just to illustrate my problem.. Ive tried multiple things and failed)
second attempt was to start with the tag table
db.Where("tag_name IN ?", []string{"javascript", "css", "devops"}).Preload("Conferences").Group("tag_name").Find(&tags)While this neatly groups conferences to tags it is also a one-to-many association and not how i need my data
my desired result looks like this
Result=[
{
Name:CSS Day,
Tags:
[
{
TagName:css
},
{
TagName:html
}
]
},
{
Name:Devops Day,
Tags: [
{
TagName:devops
}
]
}
]
.....Any help is greatly appreciated :)
res := db.GetDB().Model(&db.User{}).First(&user, "id = ?", userID) and then resolves to SELECT * FROM "users" WHERE id = 'tHi9KeXYpMhqyKSUUpmkBpK0Z9F2' AND "users"."deleted_at" IS NULL ORDER BY "users"."id" LIMIT 1.However, it says it found 0 rows when there is one. If I run the same query in pgadmin, I get a result.
type Category struct {
gorm.Model `json:"gorm_model"`
Name string `json:"name"`
Description string `json:"description"`
ParentID int `json:"parent_id"`
Parent *Category `gorm:"foreignKey:ParentID;constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"`
}
package model
type Post struct {
Id string `gorm:"primaryKey"`
Text string
Title string
SubTitle string
}
type Fragment interface {
ID() string
Name() string
}
type fragment struct {
id string `gorm:"primaryKey"`
name string
Block Block
BlockID string
Type string
}
func (f fragment) ID() string {
return f.id
}
func (f fragment) Name() string {
return f.name
}
type TextFragment struct {
fragment
Content string
}
type ImageFragment struct {
fragment
URI string
}
type VideoFragment struct {
fragment
URI string
}
type ProofStepFragment struct {
fragment
ReportUri string
Content string
Buttons int
}
type Block struct {
Id string `gorm:"primaryKey"`
Name string
Fragments []Fragment `gorm:"polymorphic:;"`
StageID string `gorm:"column:stage_id"`
Stage Stage
}
type Stage struct {
Id string `gorm:"primaryKey"`
Name string
Blocks []Block `gorm:"foreignkey:stage_id"`
CourseID string `gorm:"column:course_id"`
Course Course
}
type Course struct {
Id string `gorm:"primaryKey"`
Name string
Stages []Stage `gorm:"foreignkey:course_id"`
}
type Company struct {
Id string `gorm:"primaryKey"`
Name string
Course []Course `gorm:"many2many:company_courses;"`
}package model
type Post struct {
Id string `gorm:"primaryKey"`
Text string
Title string
SubTitle string
}
/*
type Fragment interface {
ID() string
Name() string
}
*/
type Fragment struct {
id string `gorm:"primaryKey"`
name string
Block Block
BlockID string
Type string
}
func (f Fragment) ID() string {
return f.id
}
func (f Fragment) Name() string {
return f.name
}
type TextFragment struct {
Fragment
Content string
}
type ImageFragment struct {
Fragment
URI string
}
type VideoFragment struct {
Fragment
URI string
}
type ProofStepFragment struct {
Fragment
ReportUri string
Content string
Buttons int
}
type Block struct {
Id string `gorm:"primaryKey"`
Name string
Fragments []Fragment `gorm:"polymorphic:;"`
StageID string `gorm:"column:stage_id"`
Stage Stage
}
type Stage struct {
Id string `gorm:"primaryKey"`
Name string
Blocks []Block `gorm:"foreignkey:stage_id"`
CourseID string `gorm:"column:course_id"`
Course Course
}
type Course struct {
Id string `gorm:"primaryKey"`
Name string
Stages []Stage `gorm:"foreignkey:course_id"`
}
type Company struct {
Id string `gorm:"primaryKey"`
Name string
Course []Course `gorm:"many2many:company_courses;"`
}
How to query same table in callback?
db.Callback().Update().Before("gorm:update").Register("obz:old_object", loadOldObject)
func loadOldObject(db *gorm.DB) {
fmt.Println("******************* loadOldObject ************************")
orgID, orgExists := db.Get("org_id")
field, ok := db.FieldByName("OldObject")
if field != nil && orgExists {
object := db.IndirectValue()
objectType := reflect.TypeOf(object) // this type of this variable is reflect.Type
objectPointer := reflect.New(objectType) // this type of this variable is reflect.Value.
objectValue := objectPointer.Elem().Addr() // this type of this variable is reflect.Value.
objectInterface := objectValue.Interface()
field.Set(objectInterface)
db := db.DB().Table(db.TableName())
if orgID != nil {
db.Where(db.Statement.Table+".org_id = ?", orgID)
}
db.Where(db.PrimaryKey()+" = ?", db.PrimaryKeyValue()).First(field.Field.Interface())
}
}
I did this in form V1. Please help me to achieve in v2
3 replies
Hello. Having some strange issues with Gorm.
type VM struct {
ID string
TypeId string `gorm:"type:string;size:191;index"`
Type VMType `gorm:"references:TypeId"`
}
type VMType struct {
ID string `gorm:"primaryKey;index"`
Name string `gorm:"primaryKey;index"`
}gives me this error:
define a valid foreign key for relations or implement the Valuer/Scanner interface
type MerchantProduct struct {
Product_id uint `json:"product_id"`
MerchantID uint `json:"merchant_id"`
// Product []Product `gorm:"foreignkey:ID ;association_foreignkey:Product_id" json:"product"`
}
type Product struct {
gorm.Model
Name string `json:"name"`
Sku uint `json:"sku"`
Image string `json:"image"`
MerchantProduct MerchantProduct `gorm:"foreignkey:Product_id;association_foreignkey:ID"`
}
Hi guys!
Question, theres a way that i can do not insert duplicate itens? my table has an id and name fields, only the id is my PK (auto increment) and i dont want to insert duplicate names
I tried something like this, but not work, it keeps inserting records if the fields initiative_name already exists in the database
db.Table(constant.TableNameInitiativesTracking).Clauses(clause.OnConflict{
Columns: []clause.Column{{Name: "initiative_name"}},
DoNothing: true,
}).Create(&initiatives).Errormy model
type InitiativeTracking struct {
Id int `db:"id" json:"id,omitempty"`
InitiativeName string `db:"initiative_name" json:"name" binding:"required"`
}Tks
CreatedAt := time.Now() I want it to be automated that table auto update time
I am trying to add array data type using gorm
type Token struct {
Base
Tags pq.StringArray json:"tags"
}
using
t.DB.Model(&database.Token{}).Where("address = ?", address).Update(&database.Token{
Tags: ["1","2"],
})
But, I am unable to append a new tag to the data. It is getting replaced..
Any idea??