ozzo-dbx
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.
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...