Add unit tests for promptData.ts

[aboderinsamuel]

lib/promptData.ts contains all the core CRUD functions for prompts (create, read, update, delete, filter by collection). Currently there are no unit tests covering these functions. The goal is to add Jest tests that mock the Supabase client and verify each function handles success and error cases correctly. Good starting point for anyone familiar with Jest and TypeScript.