// ── IndexedDB (folders + images + thumbnails) ──────────────── import { DB_NAME, DB_VERSION, STORE_FOLDERS, STORE_IMAGES } from "./config.js"; let db = null; function ensureSchema(req) { const d = req.result; if (!d.objectStoreNames.contains(STORE_FOLDERS)) { d.createObjectStore(STORE_FOLDERS, { keyPath: "id" }); } if (!d.objectStoreNames.contains(STORE_IMAGES)) { const s = d.createObjectStore(STORE_IMAGES, { keyPath: "id" }); s.createIndex("folderId", "folderId", { unique: false }); s.createIndex("createdAt", "createdAt", { unique: false }); } else { // อัปเกรดจาก v1: เพิ่ม index createdAt ถ้ายังไม่มี const s = req.transaction.objectStore(STORE_IMAGES); if (!s.indexNames.contains("createdAt")) { s.createIndex("createdAt", "createdAt", { unique: false }); } } } const hasStores = (d) => d.objectStoreNames.contains(STORE_FOLDERS) && d.objectStoreNames.contains(STORE_IMAGES); export function open() { if (db) return Promise.resolve(db); return new Promise((resolve, reject) => { // เปิดด้วยเวอร์ชันปัจจุบันก่อน — กัน VersionError ถ้าเครื่องมี DB ใหม่กว่า const req = indexedDB.open(DB_NAME); req.onupgradeneeded = () => ensureSchema(req); req.onsuccess = () => { const d = req.result; if (hasStores(d)) { // ปิด connection เองเมื่อมีการขออัปเกรดจากแท็บอื่น กันการบล็อกค้าง d.onversionchange = () => { try { d.close(); } catch {} db = null; }; db = d; resolve(db); return; } // DB มีอยู่แต่ไม่มี store (เช่นเคยถูกสร้างว่างจากสคริปต์อื่น) → อัปเกรด schemas const next = d.version + 1; d.close(); const up = indexedDB.open(DB_NAME, next); up.onupgradeneeded = () => ensureSchema(up); up.onsuccess = () => { db = up.result; resolve(db); }; up.onerror = () => reject(up.error); }; req.onerror = () => { // ถ้าเปิดไม่ได้เพราะเวอร์ชันต่ำกว่า ให้ลองแบบไม่ระบุเวอร์ชันซ้ำ reject(req.error); }; }); } function tx(store, mode) { return db.transaction(store, mode).objectStore(store); } function wrap(request) { return new Promise((resolve, reject) => { request.onsuccess = () => resolve(request.result); request.onerror = () => reject(request.error); }); } // ── folders ── export async function getFolders() { const list = await wrap(tx(STORE_FOLDERS, "readonly").getAll()); return list.sort((a, b) => (a.createdAt || 0) - (b.createdAt || 0)); } export function getFolder(id) { return wrap(tx(STORE_FOLDERS, "readonly").get(id)); } export async function putFolder(folder) { await wrap(tx(STORE_FOLDERS, "readwrite").put(folder)); return folder; } export async function touchFolder(id) { const f = await getFolder(id); if (f) { f.updatedAt = Date.now(); await putFolder(f); } } export async function deleteFolder(id) { const imgs = await getImages(id); for (const img of imgs) await deleteImage(img.id); await wrap(tx(STORE_FOLDERS, "readwrite").delete(id)); } // ── images ── export async function getImages(folderId) { const list = await wrap(tx(STORE_IMAGES, "readonly").index("folderId").getAll(folderId)); return list.sort((a, b) => a.createdAt - b.createdAt); } export function getImage(id) { return wrap(tx(STORE_IMAGES, "readonly").get(id)); } export async function putImage(img) { await wrap(tx(STORE_IMAGES, "readwrite").put(img)); return img; } export async function deleteImage(id) { await wrap(tx(STORE_IMAGES, "readwrite").delete(id)); } export async function countImages(folderId) { return wrap(tx(STORE_IMAGES, "readonly").index("folderId").count(folderId)); } export async function storageInfo() { if (!navigator.storage || !navigator.storage.estimate) return null; try { const { usage = 0, quota = 0 } = await navigator.storage.estimate(); return { usage, quota }; } catch { return null; } }