Gorm uses update to update database (postgresql) Boolean values - Codes Helper - Programming Question Answer

Gorm uses update to update database (postgresql) Boolean values

problem description:

the problem we encountered this morning has been going on all morning, but we still haven"t found out what the problem is. Come to ask
purpose: use gorm to modify the Boolean value of a field in the database table

Code first:

func ChangeActive(id int) (*models.Comment, error) {
    var (
        model     *models.Comment
        pre_model models.PreComment
        err       error
    )

    //
    err = common.DB.Where("id = ?", id).First(&model).Error
    if err != nil {
        return nil, err
    }
    //
    model.IsActive = !model.IsActive
    //
    common.DB.Model(&model).Updates(&model)

    if !model.IsActive {
        pre_model.Create(common.DB)
    }

    return model, err
}

this function receives a ID , queries out the data corresponding to ID in the database, and modifies the active field of this data to reverse it. Finally, update the database.

The Bug: Boolean value encountered by

cannot be updated all the time.

troubleshooting process: at first I thought there was something wrong with the code statement, so I used goland"s Debug mode and found that there was nothing wrong with the code.

then I verify that modifies another field (model.CompanyID = 3) before updating the data table to see if the modification is successful. The result is that the modification is successful, but the Boolean value remains the same.

Gorm golang

Mar.25,2021

If
is zero, then the Updates method does not update this field, while the zero value of the Boolean value is false .

method 1: change the attribute from bool to * bool .

method 2: use other update methods.

Previous: How to understand such a problem? (don't test, leave your analysis process and results)

Next: Can't React add click events to child components?

After go gorm select, the result set or all struct are returned, except that the other fields are empty.
after go gorm select, the result set or all struct are returned, except that the other fields are empty the environmental background of the problems and what methods you have tried related codes db.Debug (). Where (s). Select ([] string { "id ", ...

Select gorm golang

Mar.31,2021

Gorm and or hybrid query
problem description just used gorm for query but encountered some problems. I want to do some mixed query of and and or, but db.Where in gorm is an and query, but if you add .Or () to query, all the conditions will become or. Ask for help from the bos...

Gorm golang

Apr.02,2021

Using gin+gorm, to define the model with gorm, how to generate data tables?
using gin+gorm, to define the model with gorm, how to generate a data table? The gorm document only states that the definition model http: gorm.io zh_CN docs mod. generates a datasheet. Do you want to use other tools? ...

Gorm golang

Oct.17,2021

Golang+gorm pagination, returning 50 pieces of data per page, is this correct?
the frontend is pulled down and refreshed, and the backend returns 50 pieces of data at a time. I wonder if the api, written by go+gorm is correct? Please have a look at gorm: http: gorm.io zh_CN docs que.. func ListArticle(offset int) ([]*ArticleMod...

Gorm golang

Oct.29,2021

Gorm Association query
SQL I want to implement select * from movies left join server on movies.server_id = server.id here is my go code. I don t know what the problem is. The data of the queried server field is not correct . type Server struct { Id int64 `gor...

Gorm golang

Dec.30,2021

Golang's gorm library, what is the default size of string?
what is the default size of the gorm library for golang? what is the default size of string? Is it 255? http: gorm.io zh_CN docs mod. type:varchar(100)type:varchar(255) ...

Gorm golang

Jan.11,2022

Gorm sets foreign key constraints
two tables, one is category, and the other is product, defined as follows: type Product struct { ProductId uint32 `gorm:"primary_key;type:int(11) unsigned auto_increment;"` Category Category `gorm:"ForeignKey:CateIDRef;"` ...

Foreign-key gorm golang

Jan.29,2022

Gorm update query doubt?
The gorm document has an update example: http: gorm.io zh_CN docs upd. db.First(&user) user.Name = "jinzhu 2" user.Age = 100 db.Save(&user) UPDATE users SET name= jinzhu 2 , age=100, birthday= 2016-01-01 , updated_at = 2...

Gorm golang

Mar.04,2022

Query with gorm, how to keep the fields in the database with the value of null in struct or null? Struct will become an empty string or 0 by default.
err: = db.Where ( "id =? ", id). First (& activity) .Error {"id": 30, "name": null} the name field of the database is null, but the name in & activity will become " ", how to keep it still null type Activity struct { Id ...

Mysql gorm golang

Mar.08,2022

Query with gorm, how to keep the fields in the database with the value of null in struct or null? Struct will become an empty string or 0 by default.
err: = db.Where ( "id =? ", id). First (& activity) .Error {"id": 30, "name": null} the name field of the database is null, but the name in & activity will become " ", how to keep it still null type Activity struct { Id ...

Mysql gorm golang

Mar.08,2022

False

Django, Why does the system automatically generate an empty session? every time the request is made?

Use python to convert dict1 to dict2, in the example. I tried for a long time but couldn't find a solution.

How to self-start the php-fpm service when building a LNMP environment with docker?

Can an array in react state be bound to a dom state using an element in the array?

Wechat browser version 6.6.5 cannot prevent the springback of pull-up and drop-down to the top under ios system.

In express+hbs, how do you define the routed data as a variable on the page?

How to use symbol reference of Iconfont in dva

How to elegantly add data to JSON objects?

Using node to build video streaming server

The proportional width of the echarts graph is inconsistent.

React uses axios to call the background data. After success, how to jump to the page based on the returned value?

I don't understand what a linux command means. Please explain it.

Vue introduces multiple components in vue-router by nesting named views, and does not refresh the same reference in other pages.

Running nodejs reports fewer errors ")"

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl

Element-ui input box rules check. When you do not enter blur, the check information pops up, and the input box becomes unavailable for input. How to remove the check information?

Ant-design-pro reported an error: No value found for key jest at when executing npm I

The problem of node adjusting python-cgi

How can I use the data in data as the value of a variable in Vue?

There is no rich text editor similar to Wechat's background editing graphics and text, open source.

© 2021 CodesHelper

Advertising Contact us About us

Menu