問題內容
我正在嘗試更新插入表a，以及與表b 的關係- 另外，透過ent-go 的框架與postgres 進行更新插入。
cmdbciservervmwarevirtualmachine:
+----------------+--------------------------------+--------+----------+----------+---------+---------------+-----------+---------------------------------+------------+---------+
| field | type | unique | optional | nillable | default | updatedefault | immutable | structtag | validators | comment |
+----------------+--------------------------------+--------+----------+----------+---------+---------------+-----------+---------------------------------+------------+---------+
| id | uuid.uuid | false | false | false | true | false | false | json:"id,omitempty" | 0 | |
| created_at | time.time | false | false | false | true | false | true | json:"created_at,omitempty" | 0 | |
| updated_at | time.time | false | false | false | true | true | false | json:"updated_at,omitempty" | 0 | |
| deleted_at | time.time | false | true | false | false | true | false | json:"deleted_at,omitempty" | 0 | |
| sysid | uuid.uuid | true | false | false | false | false | false | json:"sysid,omitempty" | 0 | |
| name | string | false | true | false | false | false | false | json:"name,omitempty" | 0 | |
| vcpu | int | false | true | false | false | false | false | json:"vcpu,omitempty" | 0 | |
| corespersocket | int | false | true | false | false | false | false | json:"corespersocket,omitempty" | 0 | |
| memory | int | false | true | false | false | false | false | json:"memory,omitempty" | 0 | |
| hwversion | string | false | true | false | false | false | false | json:"hwversion,omitempty" | 0 | |
| guestos | string | false | true | false | false | false | false | json:"guestos,omitempty" | 0 | |
| guestosfamily | string | false | true | false | false | false | false | json:"guestosfamily,omitempty" | 0 | |
| guestosfqdn | string | false | true | false | false | false | false | json:"guestosfqdn,omitempty" | 0 | |
| powerstate | string | false | true | false | false | false | false | json:"powerstate,omitempty" | 0 | |
| customfields | []struct { key int | false | false | false | false | false | false | json:"customfields,omitempty" | 0 | |
| | "json:\"key\""; value string | | | | | | | | | |
| | "json:\"value\"" } | | | | | | | | | |
| data | vmware.vcentervirtualmachine | false | true | false | false | false | false | json:"data,omitempty" | 0 | |
+----------------+--------------------------------+--------+----------+----------+---------+---------------+-----------+---------------------------------+------------+---------+
+--------+---------------------------------------------+---------+---------+----------+--------+----------+---------+
| edge | type | inverse | backref | relation | unique | optional | comment |
+--------+---------------------------------------------+---------+---------+----------+--------+----------+---------+
| fields | cmdbciservervmwarevirtualmachinecustomfield | false | | o2m | false | true | |
+--------+---------------------------------------------+---------+---------+----------+--------+----------+---------+
cmdbciservervmwarevirtualmachinecustomfield:
+------------+-----------+--------+----------+----------+---------+---------------+-----------+-----------------------------+------------+---------+
| field | type | unique | optional | nillable | default | updatedefault | immutable | structtag | validators | comment |
+------------+-----------+--------+----------+----------+---------+---------------+-----------+-----------------------------+------------+---------+
| id | uuid.uuid | false | false | false | true | false | false | json:"id,omitempty" | 0 | |
| created_at | time.time | false | false | false | true | false | true | json:"created_at,omitempty" | 0 | |
| updated_at | time.time | false | false | false | true | true | false | json:"updated_at,omitempty" | 0 | |
| deleted_at | time.time | false | true | false | false | true | false | json:"deleted_at,omitempty" | 0 | |
| sysid | uuid.uuid | false | false | false | false | false | false | json:"sysid,omitempty" | 0 | |
| key | int | false | false | false | false | false | false | json:"key,omitempty" | 0 | |
| value | string | false | true | false | false | false | false | json:"value,omitempty" | 0 | |
+------------+-----------+--------+----------+----------+---------+---------------+-----------+-----------------------------+------------+---------+
+----------------+----------------------------------+---------+---------+----------+--------+----------+---------+
| edge | type | inverse | backref | relation | unique | optional | comment |
+----------------+----------------------------------+---------+---------+----------+--------+----------+---------+
| virtualmachine | cmdbciservervmwarevirtualmachine | true | fields | m2o | true | true | |
+----------------+----------------------------------+---------+---------+----------+--------+----------+---------+登入後複製
如您所見，我有我的 edge，並且我的索引對於字段表上的 sys_id 和鍵是唯一的。
// Indexes of the CmdbCiServerVmwareVirtualMachineCustomField.
func (CmdbCiServerVmwareVirtualMachineCustomField) Indexes() []ent.Index {
return []ent.Index{
index.Fields("key", "sysId").
Edges("virtualMachine").Unique(),
}
}登入後複製
以下程式碼似乎可以正常建立行/關係，但它不會在第二次執行時更新插入 - 只會重複並在關係列中給出 null 條目。
我正在使用以下程式碼：
http://pastie.org/p/6vx6yugiwwlchkmssjnpis
##正確答案
func (cmdbciservervmwarevirtualmachinecustomfield) indexes() []ent.index {
return []ent.index{
index.fields("key", "sysid").unique(),
}
}登入後複製
以上索引，結合：
...
.OnConflictColumns(
cmdbciservervmwarevirtualmachinecustomfield.FieldSysId,
cmdbciservervmwarevirtualmachinecustomfield.FieldKey).
UpdateNewValues().
ID(context.Background())
登入後複製
足以使其正常運作。
以上是ent-go o2m upsert 複製的詳細內容。更多資訊請關注PHP中文網其他相關文章！
