42 lines
1.3 KiB
TypeScript
42 lines
1.3 KiB
TypeScript
|
|
import { siteConfig } from '../config/site'
|
|
import { PrismaClient } from '@prisma/client'
|
|
|
|
async function main() {
|
|
console.log('🕵️♀️ Comparing Databases...')
|
|
|
|
// 1. Check Root DB
|
|
console.log('--- ROOT DB (./dev.db) ---')
|
|
const prismaRoot = new PrismaClient({
|
|
datasources: { db: { url: 'file:./dev.db' } }
|
|
})
|
|
try {
|
|
const countRoot = await prismaRoot.note.count()
|
|
console.log(`📦 Note Count: ${countRoot}`)
|
|
const usersRoot = await prismaRoot.user.count()
|
|
console.log(`👥 User Count: ${usersRoot}`)
|
|
} catch (e) {
|
|
console.log('❌ Failed to connect to Root DB', e)
|
|
} finally {
|
|
await prismaRoot.$disconnect()
|
|
}
|
|
|
|
// 2. Check Prisma Folder DB
|
|
console.log('\n--- PRISMA DB (./prisma/dev.db) ---')
|
|
const prismaPrisma = new PrismaClient({
|
|
datasources: { db: { url: 'file:./prisma/dev.db' } }
|
|
})
|
|
try {
|
|
const countPrisma = await prismaPrisma.note.count()
|
|
console.log(`📦 Note Count: ${countPrisma}`)
|
|
const usersPrisma = await prismaPrisma.user.count()
|
|
console.log(`👥 User Count: ${usersPrisma}`)
|
|
} catch (e) {
|
|
console.log('❌ Failed to connect to Prisma DB', e)
|
|
} finally {
|
|
await prismaPrisma.$disconnect()
|
|
}
|
|
}
|
|
|
|
main().catch(console.error)
|