fix: support d1 local migrations

atinux · atinux · commit fa0b2b7ae5c5 · 2025-12-11T12:31:44.000+01:00
diff --git a/playground/nuxt.config.ts b/playground/nuxt.config.ts
@@ -17,9 +17,10 @@ export default defineNuxtConfig({
     '/cached': { prerender: true }
   },
 
-  compatibilityDate: '2025-09-09',
+  compatibilityDate: '2025-12-11',
 
   nitro: {
+    preset: 'cloudflare-module',
     experimental: {
       websocket: true
     }
diff --git a/src/cache/setup.ts b/src/cache/setup.ts
@@ -23,7 +23,7 @@ export function resolveCacheConfig(hub: HubConfig): ResolvedCacheConfig | false
 
   // Cloudflare KV cache binding
   if (hub.hosting.includes('cloudflare')) {
-    let driver: string = resolve('cache/runtime/cloudflare-driver')
+    let driver: string = resolve('cache/runtime/cloudflare-driver.mjs')
     if (isWindows) {
       driver = pathToFileURL(driver).href
     }
diff --git a/src/db/lib/migrations.ts b/src/db/lib/migrations.ts
@@ -16,7 +16,7 @@ export async function applyDatabaseMigrations(hub: ResolvedHubConfig, db: any) {
   const migrationsStorage = useDatabaseMigrationsStorage(hub)
   const dialect = hub.db.dialect
   const execute = dialect === 'sqlite' ? 'run' : 'execute'
-  const getRows = (result: any) => (dialect === 'mysql' ? result[0] : result.rows || result)
+  const getRows = (result: any) => (dialect === 'mysql' ? result[0] : result.results || result.rows || result) || []
 
   const createMigrationsTableQuery = getCreateMigrationsTableQuery({ dialect: hub.db.dialect })
   log.debug('Creating migrations table if not exists...')
diff --git a/src/db/runtime/plugins/migrations.dev.ts b/src/db/runtime/plugins/migrations.dev.ts
@@ -2,7 +2,6 @@ import type { ResolvedHubConfig } from '../../../types'
 import { applyDatabaseMigrations, applyDatabaseQueries } from '../../lib/migrations'
 // @ts-expect-error - Generated at runtime
 import { db } from 'hub:db'
-// @ts-expect-error - Generated at runtime
 import { defineNitroPlugin, useRuntimeConfig } from '#imports'
 
 export default defineNitroPlugin(async () => {

Original file line number	Diff line number	Diff line change
`@@ -23,7 +23,7 @@ export function resolveCacheConfig(hub: HubConfig): ResolvedCacheConfig \| false`
`23`	`23`
`24`	`24`	`// Cloudflare KV cache binding`
`25`	`25`	`if (hub.hosting.includes('cloudflare')) {`
`26`		`- let driver: string = resolve('cache/runtime/cloudflare-driver')`
	`26`	`+ let driver: string = resolve('cache/runtime/cloudflare-driver.mjs')`
`27`	`27`	`if (isWindows) {`
`28`	`28`	`driver = pathToFileURL(driver).href`
`29`	`29`	`}`