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

[PR #8539] refactor(test): use snapshot assertions for migration SQL output tests #16294

New Issue
Open
opened 2026-04-13 10:29:11 -05:00 by GiteaMirror · 0 comments
GiteaMirror commented 2026-04-13 10:29:11 -05:00
Owner
Copy Link

Original Pull Request: https://github.com/better-auth/better-auth/pull/8539

State: open
Merged: No

Summary

  • Use CREATE INDEX instead of MySQL-specific ALTER TABLE ... ADD INDEX when adding indexed columns to existing tables, fixing PostgreSQL compatibility
  • Refactor migration SQL output tests to use Vitest snapshot assertions instead of string matching

Changes

  • Switch added-column index generation from alterTable(...).addIndex(...) to createIndex(...).on(...).columns(...)
  • Handle unique indexes by emitting .unique() when the field is unique
  • Add PostgreSQL and SQLite regression tests for the CREATE INDEX fix
  • Replace toContain/regex assertions with toMatchSnapshot() for compiled migration SQL

Related Issues

Fixes #8536
Ported from better-auth/ai#57

Test plan

  • SQLite snapshot test passes locally
  • PostgreSQL tests pass in CI (require Docker)
**Original Pull Request:** https://github.com/better-auth/better-auth/pull/8539 **State:** open **Merged:** No --- ## Summary - Use `CREATE INDEX` instead of MySQL-specific `ALTER TABLE ... ADD INDEX` when adding indexed columns to existing tables, fixing PostgreSQL compatibility - Refactor migration SQL output tests to use Vitest snapshot assertions instead of string matching ## Changes - Switch added-column index generation from `alterTable(...).addIndex(...)` to `createIndex(...).on(...).columns(...)` - Handle unique indexes by emitting `.unique()` when the field is unique - Add PostgreSQL and SQLite regression tests for the CREATE INDEX fix - Replace `toContain`/regex assertions with `toMatchSnapshot()` for compiled migration SQL ## Related Issues Fixes #8536 Ported from better-auth/ai#57 ## Test plan - [x] SQLite snapshot test passes locally - [ ] PostgreSQL tests pass in CI (require Docker)
GiteaMirror added the pull-request label 2026-04-13 10:29:11 -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#16294
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?