squirrel

squirrel copied to clipboard

Hello，I have a problem. query := sq.Update("a").Set("orders", sq.Case("id").When("20027", "3")) _, err := query.RunWith(db).Exec() the err is : sql: converting argument $1 type: unsupported type squirrel.CaseBuilder, a struct How can I...

MagiClouds

Support for JOIN in DELETE or UPDATE

2

How can I generate a query like this using https://github.com/Masterminds/squirrel: ``` DELETE m FROM mainschema.maintable AS m LEFT JOIN (SELECT stagingid FROM stagingschema.stagingtable WHERE versionid= ?) AS s ON m.mainid...

alupuleasa

PostgreSQL :: insert into A (id, val) VALUES ((select x from y where a = ?), 'bbb')

1

``` package testing import ( "database/sql" "fmt" "testing" sq "github.com/Masterminds/squirrel" _ "github.com/lib/pq" "github.com/stretchr/testify/require" ) var psql = sq.StatementBuilder.PlaceholderFormat(sq.Dollar) func TestInsertSelect(t *testing.T) { driver, path := "postgres", "host=localhost sslmode=disable port=5432 user=postgres...

jdevelop

Update(table).Set("balance", sq.Expr("? + ?", "balance", price)) is no effect

3

hi， import ( "fmt" sq "github.com/Masterminds/squirrel" "github.com/Masterminds/structable" ) func UpdateUserBalance(db sq.DBProxyBeginner, uid int, price int64) error { query := sq.Update(table).Set("balance", sq.Expr("? + ?", "balance", price)) query = query.Where(sq.Eq{"id": uid}) s,...

MagiClouds

Support for STRAIGHT_JOIN in Mysql and MariaDB

1

Fantastic work to all involved! I recently came across a need that was difficult to work around. We had queries taking much longer than expected after a DB version change....

questin

[#82] Added FROM clause to update builder

2

#82

sivagollapalli

I would like better management Limit, Offset via interface struct, for example via sqlizer. example func fnSqlizer(customLimit) squirrel.SqLizer{ return squirrel.Exp("LIMIT ?", 10) } selectBuilder.Limit(fnSqLizer(customLimit))

talpa

Docs for Or/And querying

1

#102

sivagollapalli

Results in the ordering of the predicates in the query.

1

This allows for deterministic testing of the resulting query when more than one predicate is added to the Builder.

bfitzsimmons

We have a use-case where we need to be able to set the columns on a `SelectBuilder` after it has already been created. Example: ```go builder.SetColumns("biz", "baz") ```

andrewhare