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've found the ability to determine DB column names from model structs helpful, but the code that handles this is not exported. @qiangxue, would you accept a pull request adding...

Hi! How to use builder with this query? `SELECT * FROM `dislocation` WHERE `status`='init' ORDER BY `operation_time` ASC LIMIT 1 FOR UPDATE SKIP LOCKED` https://mysqlserverteam.com/mysql-8-0-1-using-skip-locked-and-nowait-to-handle-hot-rows/

Hi :), I would like to chain a query though function. For example, i've : ``` err := db.Select("name"). From("users"). Where(dbx.HashExp{"UserId": 1}). One(&user) ``` And i would like to have...

When using the `Query.One` method to populate a single row from the database (like below), it would seem to me like the implication is that it will only select a...

Hi! Please add to query builder new construction to check is row exist or not like described below: https://stackoverflow.com/questions/1676551/best-way-to-test-if-a-row-exists-in-a-mysql-table Thanks!

Hi! I can't find any solutions for build UPDATE JOIN queries with query builder. https://www.mysqltutorial.org/mysql-update-join/

How to use this function (`UUID_TO_BIN`) to store in query biulder? Is it possible? https://stackoverflow.com/a/45186851/4174678

Hi! How can I get json from MySql to my model struct? Is this possible? ``` type Cargo struct { Id int64 `json:"id"` CompanyId int64 `json:"companyId"` ShipperId int64 `json:"shipperId"` ConsigneeId...

Any mssql examples ? none of the examples listed work with SQL Server 2016 when trying to substitute mysql driver for mssqldb

Hello :) When trying to save emoji's to my database, they got replaced against question marks. Shall i provide more informations?