Table of Contents
Correct answer
Home Backend Development Golang Updates in Gorm use created_at, updated_at as default times

Updates in Gorm use created_at, updated_at as default times

Feb 05, 2024 pm 11:21 PM

Gorm 中的更新将created_at、updated_at 作为默认时间

Question content

I am trying to update an entity post in the database using gorm, the update is reflected correctly in the database but in the object returned by the gorm package , the created_at and Updated_at fields are the default time, which is "0001/01/01..." p>

My database model is

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

type Base struct {

    ID        uuid.UUID       `json:"id" gorm:"primaryKey;default:gen_random_uuid();not null"`

    CreatedAt time.Time       `json:"created_at" gorm:"default:now()"`

    UpdatedAt time.Time       `json:"updated_at" gorm:"default:now()"`

    DeletedAt *gorm.DeletedAt `gorm:"index" json:"deleted_at" swaggertype:"primitive,string"`

}

 

 

 

type Post struct {

    Base

    Title       string    `json:"title" gorm:"column:title"`

    TLDR        string    `json:"tldr" gorm:"column:tldr"`

    HTML        string    `json:"html" gorm:"column:html"`

    JSON        string    `json:"json" gorm:"column:json"`

    BannerImage string    `json:"banner_image" gorm:"column:banner_image"`

    Slug        string    `json:"slug" gorm:"column:slug"`

    Status      Status    `json:"status" gorm:"column:status"`

    AuthorID    uuid.UUID `json:"author_id" gorm:"column:author_id;"`

}

Copy after login

query is

1

2

3

4

5

6

7

8

9

10

11

12

func (p *pgPostRepository) UpdatePost(postDetails *models.Post) (*models.Post, error) {

    db := p.db.GetClient().(*gorm.DB)

    err := db.Model(&models.Post{}).Where(&models.Post{

        Base: models.Base{

            ID: postDetails.ID,

        },

    }).Updates(&postDetails).Error

    if err != nil {

        return nil, err

    }

    return postDetails, nil

}

Copy after login

For reference only, the API response is -

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

{

    "message": "post updated successfully",

    "post": {

        "id": "e4645d79-51da-4e08-85d3-e7409ad6b77b",

        "created_at": "0001-01-01T00:00:00Z",

        "updated_at": "0001-01-01T00:00:00Z",

        "deleted_at": null,

        "title": "Sample Title",

        "tldr": "Brief summary of the content",

        "html": "<p>This is the HTML content.</p>",

        "json": "{\"key\": \"value\"}",

        "banner_image": "https://example.com/image.jpg",

        "slug": "sample-title-1694539437151872840",

        "status": "draft",

        "author_id": "96fa719c-358e-4c5d-b878-daee02e2c38b"

    }

}

Copy after login


Correct answer


You should try to manually set the UpdatedAt field when updating a record. Something like this:

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

func (p *pgPostRepository) UpdatePost(postDetails *models.Post) (*models.Post, error) {

    db := p.db.GetClient().(*gorm.DB)

 

    postDetails.UpdatedAt = time.Now()

 

    err := db.Model(&models.Post{}).Where(&models.Post{

        Base: models.Base{

            ID: postDetails.ID,

        },

    }).Updates(&postDetails).Error

 

    if err != nil {

        return nil, err

    }

     

    return postDetails, nil

}

Copy after login

The above is the detailed content of Updates in Gorm use created_at, updated_at as default times. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial
1653
14
PHP Tutorial
1251
29
C# Tutorial
1224
24
Golang's Purpose: Building Efficient and Scalable Systems Golang's Purpose: Building Efficient and Scalable Systems Apr 09, 2025 pm 05:17 PM

Go language performs well in building efficient and scalable systems. Its advantages include: 1. High performance: compiled into machine code, fast running speed; 2. Concurrent programming: simplify multitasking through goroutines and channels; 3. Simplicity: concise syntax, reducing learning and maintenance costs; 4. Cross-platform: supports cross-platform compilation, easy deployment.

Golang and C  : Concurrency vs. Raw Speed Golang and C : Concurrency vs. Raw Speed Apr 21, 2025 am 12:16 AM

Golang is better than C in concurrency, while C is better than Golang in raw speed. 1) Golang achieves efficient concurrency through goroutine and channel, which is suitable for handling a large number of concurrent tasks. 2)C Through compiler optimization and standard library, it provides high performance close to hardware, suitable for applications that require extreme optimization.

Golang vs. Python: Key Differences and Similarities Golang vs. Python: Key Differences and Similarities Apr 17, 2025 am 12:15 AM

Golang and Python each have their own advantages: Golang is suitable for high performance and concurrent programming, while Python is suitable for data science and web development. Golang is known for its concurrency model and efficient performance, while Python is known for its concise syntax and rich library ecosystem.

Golang vs. Python: Performance and Scalability Golang vs. Python: Performance and Scalability Apr 19, 2025 am 12:18 AM

Golang is better than Python in terms of performance and scalability. 1) Golang's compilation-type characteristics and efficient concurrency model make it perform well in high concurrency scenarios. 2) Python, as an interpreted language, executes slowly, but can optimize performance through tools such as Cython.

The Performance Race: Golang vs. C The Performance Race: Golang vs. C Apr 16, 2025 am 12:07 AM

Golang and C each have their own advantages in performance competitions: 1) Golang is suitable for high concurrency and rapid development, and 2) C provides higher performance and fine-grained control. The selection should be based on project requirements and team technology stack.

Golang's Impact: Speed, Efficiency, and Simplicity Golang's Impact: Speed, Efficiency, and Simplicity Apr 14, 2025 am 12:11 AM

Goimpactsdevelopmentpositivelythroughspeed,efficiency,andsimplicity.1)Speed:Gocompilesquicklyandrunsefficiently,idealforlargeprojects.2)Efficiency:Itscomprehensivestandardlibraryreducesexternaldependencies,enhancingdevelopmentefficiency.3)Simplicity:

C   and Golang: When Performance is Crucial C and Golang: When Performance is Crucial Apr 13, 2025 am 12:11 AM

C is more suitable for scenarios where direct control of hardware resources and high performance optimization is required, while Golang is more suitable for scenarios where rapid development and high concurrency processing are required. 1.C's advantage lies in its close to hardware characteristics and high optimization capabilities, which are suitable for high-performance needs such as game development. 2.Golang's advantage lies in its concise syntax and natural concurrency support, which is suitable for high concurrency service development.

Golang and C  : The Trade-offs in Performance Golang and C : The Trade-offs in Performance Apr 17, 2025 am 12:18 AM

The performance differences between Golang and C are mainly reflected in memory management, compilation optimization and runtime efficiency. 1) Golang's garbage collection mechanism is convenient but may affect performance, 2) C's manual memory management and compiler optimization are more efficient in recursive computing.

See all articles