Home >Backend Development >Golang >How to Store an Array of Integers in a Gorm Model Using PostgreSQL?
Adding an Array of Integers as a Data Type in a Gorm Model
Introduction:
When working with PostgreSQL using Gorm, adding an array of integers as a data type in a model can present challenges. This article addresses a common issue encountered when attempting such an operation.
Problem:
Gorm models often encounter an error when trying to save an array of numbers in a single PostgreSQL field. The error typically reads, "panic: invalid sql type (slice) for postgres."
Troubleshooting:
The issue arises from using the slice as a data type. The solution involves utilizing custom types from the underlying PostgreSQL driver library.
Solution:
In the provided model:
<code class="go">type Game struct { gorm.Model GameCode string GameName string DeckType pq.Int64Array GameEndDate string }</code>
Replace DeckType []int64 with DeckType pq.Int64Array, where pq is imported as import pq "github.com/lib/pq".
GORM Tag:
To properly map the custom type to the database column, add a gorm tag to specify the column type:
<code class="go">DeckType pq.Int64Array `gorm:"type:integer[]"`</code>
This tag denotes that the DeckType field should be mapped to a PostgreSQL integer array.
Example Insertion:
After modifying the model and adding the GORM tag, you can insert an array of integers into the database:
<code class="go">dt := []int64{1, 2, 3} db.Create(&Game{GameCode: "xxx", GameName: "xxx", DeckType: pq.Int64Array(dt), GameEndDate: "xxx"})</code>
By using the custom type and GORM tag, you can successfully save an array of integers in a PostgreSQL field.
The above is the detailed content of How to Store an Array of Integers in a Gorm Model Using PostgreSQL?. For more information, please follow other related articles on the PHP Chinese website!