Open History to see the last commit
1import { readFileSync } from 'node:fs'
2import { fileURLToPath } from 'node:url'
3
4import ejs from 'ejs'
5import { describe, expect, it } from 'vitest'
6
7const root = fileURLToPath(
8 new URL('../src/frameworks/react/add-ons/', import.meta.url),
9)
10const render = (file: string, data: Record<string, unknown>) =>
11 ejs.render(readFileSync(`${root}${file}`, 'utf8'), data)
12
13// Better Auth's default database contract needs all four tables, including
14// account.password for email sign-in and unique session.token for lookups.
15describe('Better Auth database templates', () => {
16 for (const orm of ['drizzle', 'prisma']) {
17 for (const database of orm === 'drizzle'
18 ? ['postgresql', 'mysql', 'sqlite']
19 : ['postgres', 'mysql', 'sqlite']) {
20 it(`provides the auth contract for ${orm} ${database}`, () => {
21 const data = {
22 addOnEnabled: { 'better-auth': true, [orm]: true },
23 addOnOption: { [orm]: { database } },
24 }
25 const schema = render(
26 orm === 'drizzle'
27 ? 'drizzle/assets/src/db/schema.ts.ejs'
28 : 'prisma/assets/prisma/schema.prisma.ejs',
29 data,
30 )
31 for (const table of ['user', 'session', 'account', 'verification']) {
32 expect(schema).toContain(
33 orm === 'drizzle' ? `export const ${table} =` : `model ${table} {`,
34 )
35 }
36 expect(schema).toContain('password')
37 if (database === 'mysql') {
38 expect(schema).toContain(
39 orm === 'drizzle'
40 ? "image: text('image')"
41 : 'image String? @db.Text',
42 )
43 expect(schema).toContain(
44 orm === 'drizzle'
45 ? "value: text('value')"
46 : 'value String @db.Text',
47 )
48 }
49 expect(schema).toContain(orm === 'drizzle' ? '.unique()' : '@unique')
50 expect(schema).toContain(
51 orm === 'drizzle' ? "onDelete: 'cascade'" : 'onDelete: Cascade',
52 )
53 const pkg = JSON.parse(render('better-auth/package.json.ejs', data))
54 expect(pkg.dependencies[`@better-auth/${orm}-adapter`]).toBe('^1.7.18')
55 expect(pkg.dependencies['better-auth']).toBe('^1.7.18')
56 if (orm === 'drizzle') {
57 const ormPackage = JSON.parse(
58 render('drizzle/package.json.ejs', data),
59 )
60 expect(ormPackage.dependencies['drizzle-orm']).toBe('^0.45.2')
61 }
62 const auth = render('better-auth/assets/src/lib/auth.ts.ejs', data)
63 expect(auth).toContain(`${orm}Adapter(`)
64 const provider =
65 orm === 'drizzle' && database === 'postgresql'
66 ? 'pg'
67 : database === 'postgres'
68 ? 'postgresql'
69 : database
70 expect(auth).toContain(`provider: '${provider}'`)
71 const withoutAuth = {
72 ...data,
73 addOnEnabled: { [orm]: true, 'better-auth': false },
74 }
75 const plainSchema = render(
76 orm === 'drizzle'
77 ? 'drizzle/assets/src/db/schema.ts.ejs'
78 : 'prisma/assets/prisma/schema.prisma.ejs',
79 withoutAuth,
80 )
81 expect(plainSchema).not.toContain(
82 orm === 'drizzle' ? 'export const user =' : 'model user {',
83 )
84 expect(plainSchema).toContain(
85 orm === 'drizzle' ? 'export const todos =' : 'model Todo {',
86 )
87 })
88 }
89 }
90
91 it('keeps standalone Better Auth stateless without adding an adapter', () => {
92 const data = { addOnEnabled: { 'better-auth': true }, addOnOption: {} }
93 expect(
94 render('better-auth/assets/src/lib/auth.ts.ejs', data),
95 ).not.toContain('database:')
96 expect(
97 Object.keys(
98 JSON.parse(render('better-auth/package.json.ejs', data)).dependencies,
99 ),
100 ).toEqual(['better-auth'])
101 })
102})