stephenafamo / bob

44%

main: 47%

LAST BUILD ON BRANCH refactor/merge-when-chain-api

branch: refactor/merge-when-chain-api

CHANGE BRANCH

x

Reset

• refactor/merge-when-chain-api
• 497-match-by-regex
• 500-unset-fields
• 510-relations
• ability-to-use-in-and-notin-where-mods-with-empty-values
• add-support-for-custom-types-in-models-dir-v0.30
• alias-starter
• alias-warn
• alias-where
• allow-as-method-on-dialect.select
• antlr-visitor-improvments
• apply-limit-in-bob.one
• assign-set-expression
• atlas-int32
• augment-generated-queries
• augmented-generated-queries-followup
• bind-named-args
• bob-file-suffix
• bobgen-psql-performance
• bobgen-sql
• bugfix-658
• bugfix/missing-primary-key-schema-alias
• chores
• claude/fix-required-field-factory-NLRCC
• codegen-driver
• codex/random-factory-imports
• cols-in-insertq
• column-limits
• combined-query-fix
• decimal-compare
• deps
• discussion-branch-679
• docs
• docs-update
• empty-in-null
• enum-name
• enum-symbols
• enum-var
• enums-in-queries
• error-empty-set
• existing_relations
• expr_plus_operator
• feat/add-beforeupdatesetter-hook
• feat/add-each-executor
• feat/bobgen-sql-custom-image
• feat/column-order-config
• feat/columns-expr-expressions
• feat/configure_enum_format
• feat/conflict-target-helper
• feat/counts-grouped-by
• feat/disable-alias-for-build-columns
• feat/excluded-helper
• feat/multiple-from-using-psql
• feat/psql-from-tablesample
• feat/psql-grouping-elements
• feat/psql-join-using-alias
• feat/setcols-clause-sqlite
• feat/sub-query-expression
• feat/unqualified-columns-changelog
• feat/update-to-1.24
• feat/values-query
• feat/view-name-expr
• feat/view-table-name-columns-expr
• feat_comment_tag
• feat_older_pg
• feature/allow-changing-alias-of-table-ref
• feature/allow-retrieve-alias-field-from-view
• feature/grouped-hooks
• feature/merge-parser-support
• feature/new-type-system-aarondl-null-and-pointers
• feature/prepare-named-bind
• feature/quote-unquoted-api
• feature/returning-with-old-new-aliases
• feature/table-queries
• feature/where-or-and
• features/query-hooks
• filter-marshal
• fix-143
• fix-443
• fix-alias-clash
• fix-cte-col-alias
• fix-cte-parenthesis
• fix-enum-types-match-by-db_type
• fix-factory-rels
• fix-issues-related-to-count-loading
• fix-join-using
• fix-named-group
• fix-not-able-to-retrieve-rows
• fix-setter-if-relationships
• fix-update/delete-all
• fix/103-generated-rel-bug
• fix/112-join-alias
• fix/113-multi-fk
• fix/119-many-to-many-load-bug
• fix/better-go-version
• fix/bytea-cmp
• fix/coveralls
• fix/factory-circular-reference-stack-overflow
• fix/func-as
• fix/issue-693-for-update-of
• fix/missing-base-type-imports-in-to-optional
• fix/missing-pk-in-update
• fix/mysql-getinserted-explicit-columns
• fix/mysql-setter-invalid-expression
• fix/netip-import
• fix/pgx-json-simple-protocol-
• fix/pgx-tx-commit-error
• fix/psql-from-join-chains
• fix/psql-from-merge-joins
• fix/psql-searchbreadth-cte
• fix/run-in-tx-panic-rollback
• fix/setter-per-column-insert-values
• fix/sql-identifier-quoting-v2
• fixes
• flexible-conflict-mod
• generate-error-constants-for-unique-index
• goland-type-inference
• implicit-fk
• improve-generated-join
• in-package-types
• inet
• issue-574
• issue-585
• issue-610
• join-helpers-context-remove
• libsql-support
• load-refactor
• main
• mappings-pkg
• materialized-views-psql
• merge-psql-operation
• minor-doc-updates
• mod-values
• mysql-compound-query
• mysql-file
• mysql-fulltype
• mysql-keyword-id
• mysql-queries
• mysql-querygen
• mysql-retrieval
• mysql-union
• names-only-for-gen-templates
• ncruces
• nest-to-one
• nested-factory-rels
• nested-query
• netip-prefix
• nil-model-slice
• no-factory-docs
• non-cgo-pg-parse
• null-index-sort
• null-system-config
• omit-redundant-table-alias
• op
• opt-system
• other-lang-gen
• patch-1
• perf/loader-eq-any
• perf/loader-map-stitch
• pgvector
• pgx-improve
• pgx-tx
• pk-columns
• plugins-galore
• postgres-delete
• prefix-annotation
• preload-bug
• psql-case-sensitive
• psql-many-load
• psql-select-combined-args
• psql-update-query
• queries
• query-caching
• query-gen-testing
• query-improvements
• query-test-hook
• random
• randomize-test-fixes
• refactor-table-methods
• refactor/mm-merge-mods
• refs/tags/0.6.0
• refs/tags/v0.10.0
• refs/tags/v0.10.1
• refs/tags/v0.11.0
• refs/tags/v0.12.0
• refs/tags/v0.12.1
• refs/tags/v0.13.0
• refs/tags/v0.14.0
• refs/tags/v0.14.1
• refs/tags/v0.15.0
• refs/tags/v0.15.2
• refs/tags/v0.15.3
• refs/tags/v0.15.4
• refs/tags/v0.15.5
• refs/tags/v0.15.6
• refs/tags/v0.16.0
• refs/tags/v0.17.0
• refs/tags/v0.17.1
• refs/tags/v0.17.2
• refs/tags/v0.17.3
• refs/tags/v0.18.0
• refs/tags/v0.18.1
• refs/tags/v0.18.2
• refs/tags/v0.19.0
• refs/tags/v0.19.1
• refs/tags/v0.2.0
• refs/tags/v0.2.1
• refs/tags/v0.2.2
• refs/tags/v0.2.3
• refs/tags/v0.20.0
• refs/tags/v0.20.1
• refs/tags/v0.20.2
• refs/tags/v0.20.3
• refs/tags/v0.20.4
• refs/tags/v0.20.5
• refs/tags/v0.20.6
• refs/tags/v0.21.0
• refs/tags/v0.21.1
• refs/tags/v0.22.0
• refs/tags/v0.23.0
• refs/tags/v0.23.1
• refs/tags/v0.23.2
• refs/tags/v0.24.0
• refs/tags/v0.25.0
• refs/tags/v0.26.0
• refs/tags/v0.26.1
• refs/tags/v0.3.0
• refs/tags/v0.3.1
• refs/tags/v0.4.0
• refs/tags/v0.5.1
• refs/tags/v0.6.0
• refs/tags/v0.6.1
• refs/tags/v0.6.2
• refs/tags/v0.7.1
• refs/tags/v0.8.0
• refs/tags/v0.8.1
• refs/tags/v0.9.0
• refs/tags/v0.9.1
• related-where
• relation-count-improvements
• relation-counting
• remove-unqualified-for-generated-colums
• scan-by-index
• schema-in-preload
• setter-insert-mod
• sql-pattern
• sqlite-delete
• sqlite-insert
• sqlite-int
• sqlite-update
• stdlib-null
• string-writer
• subquery-parenthesis
• template-restructure
• testing
• track-relationship-loading
• types
• types-compare
• uint64
• um-set
• unique-alias-for-preloaders
• uniques
• update-docs
• wrap-marshallable-types

refactor(psql/mm): replace WHEN clause mods with fluent chain API

Change WhenMatched/WhenNotMatched/WhenNotMatchedByTarget/WhenNotMatchedBySource
from functional options pattern to method chaining.

Before:
  mm.WhenMatched(
      mm.And(condition),
      mm.ThenUpdate(mm.SetCol("x").ToExpr(e)),
  )

After:
  mm.WhenMatched().And(condition).ThenUpdate(
      mm.SetCol("x").ToExpr(e),
  )

Introduce WhenMatchedChain (for MATCHED / NOT MATCHED BY SOURCE)
and WhenNotMatchedChain (for NOT MATCHED [BY TARGET]) with
type-safe terminal methods: ThenUpdate, ThenDelete, ThenDoNothing,
ThenInsert, ThenInsertDefaultValues.

Remove standalone And, ThenDoNothing, ThenDelete, ThenUpdate,
ThenInsert, ThenInsertDefaultValues functions and WhenClause type.

Co-authored-by: Copilot <copilot@github.com>