error in create nested structure when nested ID is uuid Type that ID is expected to be an integer.

[abserari]

Description

If this is a feature request, explain why it should be added. Specific use-cases are best.

For bug reports, please provide as much relevant info as possible.

Steps to Reproduce the Problem

Please describe in painful detail what you did (so others can play along with you) to get to this point. This includes things like the exact command(s) you used, or the curl command you used, that sort of thing.

1. nested structure is disk

{
  "host_id": "b2312720-242f-4af9-8b2e-a1fe3257052b",
  "os_type": "centos",
  "disks": [
      {
          "id": "dd119bf2-09a2-49ff-8c0e-2f4a20063893"
      }
  ]
}

	err = tx.Create(virtualMachine)
	if err != nil {
		return err
	}

3. Check for this nested relationship is manytomany

 	Disks Disks `many_to_many:"vms_disks"`

Expected Behavior

Create an entry and create their relationship

Actual Behavior

got an error.

Info

{
    "error": "ERROR: invalid input syntax for type integer: \"14fdf24c-1c29-4f9e-a9ce-f4c55da7a1d5\" (SQLSTATE 22P02)",
    "trace": "ERROR: invalid input syntax for type integer: \"14fdf24c-1c29-4f9e-a9ce-f4c55da7a1d5\" (SQLSTATE 22P02)",
    "code": 500
}

OS:centos8 database: postgreSQL
Use Pop through buffalo

[abserari]

I found a possible answer is that:
VmsDisk, the relations table of VM and disk, which has an int primary key but pop auto insert with a UUID type.

type VmsDisks struct {
	ID               int       `json:"id,omitempty" db:"id"`
	VirtualMachineID uuid.UUID `json:"virtual_machine_id,omitempty" db:"virtual_machine_id"`
	DiskID           uuid.UUID `json:"disk_id,omitempty" db:"disk_id"`

	CreatedAt time.Time `json:"created_at,omitempty" db:"created_at"`
	UpdatedAt time.Time `json:"updated_at,omitempty" db:"updated_at"`
}

I'll check it later.

[abserari]

Yes, It means tx.Create or tx.ValidateAndCreate would auto determine that relation table like VmsDisks's ( which is targeted by tag in many to many associations) primary key is UUID type, but not int type with the model target: integer.

Maybe it would be fix with a feature PR?