github-starred/better-auth
2
0
Fork 0
mirror of https://github.com/better-auth/better-auth.git synced 2026-05-22 22:32:01 -05:00
Code Issues 2.5k Packages Projects Releases 112 Wiki Activity

[PR #4449] [MERGED] feat: add support for not in operator #13640

New Issue
Closed
opened 2026-04-13 09:02:37 -05:00 by GiteaMirror · 0 comments
GiteaMirror commented 2026-04-13 09:02:37 -05:00
Owner
Copy Link

📋 Pull Request Information

Original PR: https://github.com/better-auth/better-auth/pull/4449
Author: @Bekacru
Created: 9/5/2025
Status: ✅ Merged
Merged: 9/5/2025
Merged by: @Bekacru

Base: canary ← Head: feat/not-in

📝 Commits (4)

📊 Changes

8 files changed (+95 additions, -1 deletions)

View changed files

📝 packages/better-auth/src/adapters/drizzle-adapter/drizzle-adapter.ts (+18 -0)
📝 packages/better-auth/src/adapters/kysely-adapter/kysely-adapter.ts (+8 -0)
📝 packages/better-auth/src/adapters/kysely-adapter/test/state.txt (+1 -1)
📝 packages/better-auth/src/adapters/memory-adapter/memory-adapter.ts (+6 -0)
📝 packages/better-auth/src/adapters/mongodb-adapter/mongodb-adapter.ts (+9 -0)
📝 packages/better-auth/src/adapters/prisma-adapter/prisma-adapter.ts (+2 -0)
📝 packages/better-auth/src/adapters/test.ts (+50 -0)
📝 packages/better-auth/src/types/adapter.ts (+1 -0)

📄 Description

we currently don't support not_in as operator for adapter queries

Summary by cubic

Add support for the not_in operator across all adapters to allow filtering records that exclude a set of values (e.g., id not in [...]). This enables consistent query behavior in find/findMany across databases.

  • New Features
    • Drizzle: maps to notInArray; validates value is an array and throws otherwise.
    • Kysely: maps to "not in" (coerces single value to array).
    • MongoDB: maps to $nin with proper ID serialization.
    • Prisma: maps to notIn in operator translation.
    • Types: adds "not_in" to Where.operator.
    • Tests: adds findMany test case for excluding IDs.

🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/better-auth/better-auth/pull/4449 **Author:** [@Bekacru](https://github.com/Bekacru) **Created:** 9/5/2025 **Status:** ✅ Merged **Merged:** 9/5/2025 **Merged by:** [@Bekacru](https://github.com/Bekacru) **Base:** `canary` ← **Head:** `feat/not-in` --- ### 📝 Commits (4) - [`68ede0a`](https://github.com/better-auth/better-auth/commit/68ede0a8b0e99bb9c60d64aba9e49edc7333b786) feat: supprot not in operator - [`510db4a`](https://github.com/better-auth/better-auth/commit/510db4a9f71daae03d52aa2fcef95536450450ae) fix test - [`36ea062`](https://github.com/better-auth/better-auth/commit/36ea0629dad6bfbcf6aa026be9fb24253fc55de2) memory adapter - [`df3c22e`](https://github.com/better-auth/better-auth/commit/df3c22e6ba368b6cfb106da7d866a820bde96638) chore: remove comments ### 📊 Changes **8 files changed** (+95 additions, -1 deletions) <details> <summary>View changed files</summary> 📝 `packages/better-auth/src/adapters/drizzle-adapter/drizzle-adapter.ts` (+18 -0) 📝 `packages/better-auth/src/adapters/kysely-adapter/kysely-adapter.ts` (+8 -0) 📝 `packages/better-auth/src/adapters/kysely-adapter/test/state.txt` (+1 -1) 📝 `packages/better-auth/src/adapters/memory-adapter/memory-adapter.ts` (+6 -0) 📝 `packages/better-auth/src/adapters/mongodb-adapter/mongodb-adapter.ts` (+9 -0) 📝 `packages/better-auth/src/adapters/prisma-adapter/prisma-adapter.ts` (+2 -0) 📝 `packages/better-auth/src/adapters/test.ts` (+50 -0) 📝 `packages/better-auth/src/types/adapter.ts` (+1 -0) </details> ### 📄 Description we currently don't support `not_in` as operator for adapter queries <!-- This is an auto-generated description by cubic. --> --- ## Summary by cubic Add support for the not_in operator across all adapters to allow filtering records that exclude a set of values (e.g., id not in [...]). This enables consistent query behavior in find/findMany across databases. - **New Features** - Drizzle: maps to notInArray; validates value is an array and throws otherwise. - Kysely: maps to "not in" (coerces single value to array). - MongoDB: maps to $nin with proper ID serialization. - Prisma: maps to notIn in operator translation. - Types: adds "not_in" to Where.operator. - Tests: adds findMany test case for excluding IDs. <!-- End of auto-generated description by cubic. --> --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
GiteaMirror added the pull-request label 2026-04-13 09:02:37 -05:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
adapter
astro
awaiting external contributor
blocked
breaking
breaking change
bug
c-devops
core
credentials
database
dependencies
devops
devtools
docs
documentation
duplicate
elysia
enhancement
enterprise
expo
express
fastify
good first issue
help wanted
hono
identity
infra
integration
invalid
javascript
locked
maintenance
need-more-information
needs: info
needs: repro
nextjs
nuxt
oauth
organization
P0
payments
perf
platform
plugin
pull-request
Mirrored from GitHub Pull Request
 question
ready
regression
remix
security
social-provider
solid
stale
svelte
tanstack-start
tracking
version-bump
vue
wontfix
No Label pull-request
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/better-auth#13640
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?