blocks|key|421865|text|我不熟悉Gorm，但使用postgres+时，您需要实现sql.Scanner和sql.Valuer接口，以便将数据转换为postgres类型。下面的代码没有检查错误，因此需要进行一些调整。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|421866|https://play.golang.org/p/2-Y-wSeAWnj|offset|length|421867|package+main

import+(
++++"database/sql/driver"
++++"fmt"
++++"strconv"
++++"strings"
)

type+GeoPoint+struct+{
++++Lat+float64
++++Lon+float64
}

func+(gp+GeoPoint)+Value()+(driver.Value,+error)+{
++++return+fmt.Sprintf("(%25d,%25d)",+gp.Lat,+gp.Lon),+nil
}

func+(gp+GeoPoint)+Scan(src+interface{})+error+{
++++raw+:=+src.(string)
++++coords+:=+raw[1+:+len(raw)-1]
++++vals+:=+strings.Split(coords,+",")
++++gp.Lat,+_+=+strconv.ParseFloat(vals[0],+64)
++++gp.Lon,+_+=+strconv.ParseFloat(vals[1],+64)
++++return+nil
}

func+main()+{
++++gp+:=+GeoPoint{Lat:+112,+Lon:+53}
++++d,+_+:=+gp.Value()
++++fmt.Printf("%25%2Bv\n",+d)

++++gp.Scan("(53,+-110)")
++++fmt.Printf("%25%2Bv\n",+gp)
}|code-block|syntax|javascript|421868|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|11|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|H|7|W|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|C]]]]

I am not familiar with Gorm, but with sqlx you will need to implement the sql.Scanner and sql.Valuer interfaces to allow the data to be converted to the postgres <code>point</code> type. The code below isn't checking for errors so it will need some tweaks.

<a href="https://play.golang.org/p/2-Y-wSeAWnj" rel="nofollow noreferrer">https://play.golang.org/p/2-Y-wSeAWnj</a>

<pre><code>package main

import (
 "database/sql/driver"
 "fmt"
 "strconv"
 "strings"
)

type GeoPoint struct {
 Lat float64
 Lon float64
}

func (gp GeoPoint) Value() (driver.Value, error) {
 return fmt.Sprintf("(%d,%d)", gp.Lat, gp.Lon), nil
}

func (gp GeoPoint) Scan(src interface{}) error {
 raw := src.(string)
 coords := raw[1 : len(raw)-1]
 vals := strings.Split(coords, ",")
 gp.Lat, _ = strconv.ParseFloat(vals[0], 64)
 gp.Lon, _ = strconv.ParseFloat(vals[1], 64)
 return nil
}

func main() {
 gp := GeoPoint{Lat: 112, Lon: 53}
 d, _ := gp.Value()
 fmt.Printf("%+v\n", d)

 gp.Scan("(53, -110)")
 fmt.Printf("%+v\n", gp)
}
</code></pre>

blocks|key|424646|text|首先，使用gorm时，您永远不能定义小写的第一个字母字段。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|424647|如果您确保GeoPoint链接为辅助，您可以使用ForeingKey标记，如，确保Id是表A的主键。|424648|type+A+struct+{
++++Id+int+`gorm:"column:"id""`
++++Point+GeoPoint+`gorm:"column:geo_point;ForeignKey:OrderId"`
}

type+GeoPoint+struct+{
++++Aid+int
++++Lat+float64
++++Lon+float64
}

func+main(){
++++...
++++...
++++var+as+[]A
++++if+e:=db.Model(&A{}).Find(&as).Error;e!=nil{
++++++++handle(e)
++++}
++++fmt.Println(as)
}|code-block|syntax|javascript|424649|如果不是通过主键链接的话。您可以使用像这样的中间件|424650|type+A+struct+{
++++Id+int+`gorm:"column:"id""`
++++Point+GeoPoint+`gorm:"column:geo_point"`
}

func+(a+*A)+AfterFind()error{
+++return+db.Model(&GeoPoint{}).First(&(a.Point)).Error
}

type+GeoPoint+struct+{
++++Aid+int
++++Lat+float64
++++Lon+float64
}

func+main(){
++++...
++++...
++++var+as+[]A
++++if+e:=db.Model(&A{}).Find(&as).Error;e!=nil{
++++++++handle(e)
++++}
++++fmt.Println(as)
}|424651|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

First, using gorm you never define fields with the first letter in lower case.

If you make sure GeoPoint is linked as Aid , you can use ForeingKey tag like,
MAKE SURE Id is table A 's primary key.

<pre class="lang-golang prettyprint-override"><code>type A struct {
 Id int `gorm:"column:"id""`
 Point GeoPoint `gorm:"column:geo_point;ForeignKey:OrderId"`
}

type GeoPoint struct {
 Aid int
 Lat float64
 Lon float64
}

func main(){
 ...
 ...
 var as []A
 if e:=db.Model(&amp;A{}).Find(&amp;as).Error;e!=nil{
 handle(e)
 }
 fmt.Println(as)
}
</code></pre>

If not linked by primary key. You can use middleware like

<pre class="lang-golang prettyprint-override"><code>type A struct {
 Id int `gorm:"column:"id""`
 Point GeoPoint `gorm:"column:geo_point"`
}

func (a *A) AfterFind()error{
 return db.Model(&amp;GeoPoint{}).First(&amp;(a.Point)).Error
}

type GeoPoint struct {
 Aid int
 Lat float64
 Lon float64
}

func main(){
 ...
 ...
 var as []A
 if e:=db.Model(&amp;A{}).Find(&amp;as).Error;e!=nil{
 handle(e)
 }
 fmt.Println(as)
}
</code></pre>

blocks|key|5546207|text|您可以尝试：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5546208|+++type+A+struct+{
++++point+GeoPoint+`gorm:"embedded"`
}+|code-block|syntax|javascript|5546209|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can try: 

<pre><code> type A struct {
 point GeoPoint `gorm:"embedded"`
} 
</code></pre>

blocks|key|5546238|text|对于任何正在寻找将struct放入GORM模型中并使其自动编组和解组的人来说。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5546239|这个解决方案是基于chris的答案的，而且它是有效的！|offset|length|style|BOLD|5546240|例如，我想把孩子的数组放在Parent内部作为编组的JSON：|5546241|type+Child+struct+{
++++Lat+float64
++++Lng+float64
}

type+ChildArray+[]Children

func+(sla+*ChildArray)+Scan(src+interface{})+error+{
++++return+json.Unmarshal(src.([]byte),+&sla)
}

func+(sla+ChildArray)+Value()+(driver.Value,+error)+{
++++val,+err+:=+json.Marshal(sla)
++++return+string(val),+err
}

type+Parent+struct+{
++++*gorm.Model++++
++++Childrens+ChildArray+`gorm:"column:childrens;type:longtext"`
}|code-block|syntax|javascript|5546242|entityMap^0|0|9|5|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@$D|S|E|T|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|U|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|V|8|@]|9|@]|A|$M|N]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

For anyone, who's searching the way to put struct inside GORM model and make it marshalling and unmarshalling automatically. 

This solution is based on chris's answer. And it works!

For example, I want to put array of Childrens inside Parent as marshalled JSON:

<pre><code>type Child struct {
 Lat float64
 Lng float64
}

type ChildArray []Children

func (sla *ChildArray) Scan(src interface{}) error {
 return json.Unmarshal(src.([]byte), &amp;sla)
}

func (sla ChildArray) Value() (driver.Value, error) {
 val, err := json.Marshal(sla)
 return string(val), err
}

type Parent struct {
 *gorm.Model 
 Childrens ChildArray `gorm:"column:childrens;type:longtext"`
}
</code></pre>

How can I store an embedded struct with GORM if I have a type like this

<pre><code>type A struct {
 point GeoPoint
}

type GeoPoint struct {
 Lat float64
 Lon float64
}
</code></pre>

GORM tries to add it in a new table, but I want to add it as another field.

How can this be done?

How to store embedded struct with GORM?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

如果我有这样的类型，如何使用GORM存储嵌入式结构type A struct {    point GeoPoint}type GeoPoint struct {    Lat float64    Lon float64}GORM尝试将其添加到新表中，但我想将其添加为另一个字段。如何做到这一点？

问如何用GORM存储嵌入式结构？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何用GORM存储嵌入式结构？EN