sqlboiler

sqlboiler copied to clipboard

BeforeSelectHook

12

Hi! I think it would be great, to have a BeforeSelectHook, where we could modify the incoming query. It would be great for things like enforce deleted_at is null. What...

KopiasCsaba

Feature Request: make enums their own type

9

I'm new to Go and SQLBoiler but would it be possible to have enums be their own type like this? ``` type Workday const ( WorkdayMonday Workday = "monday" WorkdayTuesday...

jstrohm-triller

SQLBoiler is not cross-schema-aware. Need qualified table identifiers for FK.

14

SQL Boiler Version 2.20 using Postgres 9.6 When referencing a foreign key from another schema, SQLBoiler panics. ``` CREATE SCHEMA IF NOT EXISTS identity; CREATE TABLE identity.profile ( id uuid...

FourSigma

No insert error on foreign key exception + QueryRowContext

2

If you're having a generation problem please answer these questions before submitting your issue. Thanks! ### What version of SQLBoiler are you using (`sqlboiler --version`)? 4.2.0 Possibly relevant, using pgx...

DGollings

Generated tests do not pass

12

### What version of SQLBoiler are you using (`sqlboiler --version`)? ``` $ sqlboiler --version SQLBoiler v4.1.2 ``` ### What is your database and version (eg. Postgresql 10) `sqlite3` ### If...

the-maldridge

In addition to `where in (a, b, c)` postgres can also do `where in (VALUES (a), (b), (c))` which has [huge performance benefits](https://dba.stackexchange.com/questions/91247/optimizing-a-postgres-query-with-a-large-in) for a large set of values.

tzachshabtay

postgresql: `WHERE IN` support for bytea

1

I need to fetch rows from a database that match a large list of sha256 hashes. would it be possible to get support for this.

hsyed

Type safe updates

2

Are type-safe updates possible? So far I've seen only an `UpdateAll` method which takes a `map[string] interface{}` (as opposed to the type-specific columns in the where clauses). Apologies if I...

rakeshbala

SQLBoiler fails on creating schema during `go test` when there's a non-FK constraint

1

If you're having a generation problem please answer these questions before submitting your issue. Thanks! ### What version of SQLBoiler are you using (`sqlboiler --version`)? 4.1.2 ### What is your...

ejulen

Using array of enum values does not generate enum constants for Postgres

1

### What version of SQLBoiler are you using (`sqlboiler --version`)? SQLBoiler v4.1.1 ### What is your database and version (eg. Postgresql 10) PostgreSQL 12.2 (postgres:12.2-alpine Docker Image) ### If this...

MorpheusXAUT