Function getSchemaVersion

packages/core/src/schema/migrations.ts:20–33

(db: DatabaseAdapter)

 * 读取数据库的 schema 版本
 */
export function getSchemaVersion(db: DatabaseAdapter): number {
  try {
    const tableInfo = db.pragma('table_info(meta)') as Array<{ name: string }>
    const hasVersionColumn = tableInfo.some((col) => col.name === 'schema_version')
    if (!hasVersionColumn) return 0

    const result = db.prepare('SELECT schema_version FROM meta LIMIT 1').get() as
      | { schema_version: number | null }
      | undefined
    return result?.schema_version ?? 0
  } catch {
    return 0
  }
}

/**
 * 设置数据库的 schema 版本