Persist structures with no data fields besides id

[grossvater]

I have a mapping like this:

type Product struct {
    Id           int
    PropertyGroup   PropertyGroup `ref:"property_group_id" fk:"id" autosave:"true" autoload:"true"`
    PropertyGroupId int
}

type PropertyGroup struct {
    Id         int
    Properties []Property `ref:"id" fk:"group_id" autosave:"true" autoload:"true"`
}

type Property struct {
    Id    int
    Key   string
    Value string

    Group   PropertyGroup `ref:"group_id" fk:"id"`
    GroupId int
}

Please note that what's important here is the PropertyGroup, which has no data fields. I kept Property in sample only to show what I want to achieve and why I might need such an empty table.

When doing the insert for Product, with a reference to an existing PropertyGroup, I have this error: pq: syntax error at or near "WHERE"

Generated sql is this: UPDATE "property_groups" SET WHERE "property_groups"."id"=$1; - pq: syntax error at or near "WHERE"

Of course an workaround might be to remove the autosave:"true" between Product and PropertyGroup, but this would break the insert when the PropertyGroup doesn't exist.

[Fs02]

Of course an workaround might be to remove the autosave:"true" between Product and PropertyGroup, but this would break the insert when the PropertyGroup doesn't exist.

one possible fix that I can think of is to not do any updates/insert if the struct only have primary fields, but this will still break the insert if property group doesn't exists 🤔

with a reference to an existing PropertyGroup

seems the best way to go here is to disable autosave and set property group using PropertyGroupId