ozzo-dbx icon indicating copy to clipboard operation
ozzo-dbx copied to clipboard

A Go (golang) package that enhances the standard database/sql package by providing powerful data retrieval methods as well as DB-agnostic query building capabilities.

Results 41 ozzo-dbx issues
Sort by recently updated
recently updated
newest added

I'm not sure what the ins and outs are for everyone here, but a problem I'm encountering with SQL logging in ozzo is that it logs byte slices as raw...

Hi. I am developer transitioning from `Node.js` to `go` and it has been smooth. But, I'm finding it hard to update a model without overwriting the role in the db...

Hi! Is it possible to get main table Id column only by default? ``` func (dao *DeviceDAO) Get(rs app.RequestScope, id int) (*models.Device, error) { var analysis models.Device err := rs.Tx().Select()....

Hi! Is it possible to insert multiple rows with one insert query? `INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);`

The intro page provides limited examples on the query conditions, as a newbie, I don't really know how to use it for complex conditions... How about adding more examples? E.g.:...

I try get some model by some regexp ``` func (dao *SomeModelDAO) findListNumbers(rs app.RequestScope, someModel *models.SomeModel, regexp string) error { err := rs.Tx().Select("id", "number"). From("someModel s"). AndWhere(dbx.NewExp("s.number REGEXP {:regexp}", dbx.Params{"regexp":...

I have the following struct: ```go type Order struct { OrderResourceID string `json:"orderResourceID" db:"orderResourceID"` OrderStatusID int `json:"orderStatusID" db:"orderStatusID"` ClientUsername string `json:"clientUsername" db:"clientUsername"` ClientFullName string `json:"clientFullName" db:"clientFullName"` ClientPhotoUrl string `json:"clientPhotoUrl" db:"clientPhotoUrl"`...

struct.go: ```   | 217 | func parseTag(tag string) (string, bool) {   | 218 | if tag == "pk" {   | 219 | return "", true   | 220 | }   |...

[CDbCommandBuilder.createMultipleInsertCommand()](http://www.yiiframework.com/doc/api/1.1/CDbCommandBuilder#createMultipleInsertCommand-detail) Is there any way to do this now? or, will it be supported later?

Besides being able to retrieve the results: is there any deeper sense in restricting the destination object when scanning values from DB to be a ptr on a struct? I...