import type { DB } from "@op-engineering/op-sqlite";
import { useDevToolsPluginClient } from "expo/devtools";
import { useEffect } from "react";

export default function useDrizzleStudio(db: DB | null) {
    const client = useDevToolsPluginClient("expo-drizzle-studio-plugin");

    const transferData = (e: {
        sql: string;
        params: (string | number)[];
        arrayMode: boolean;
        id: string;
    }) => {
        if (!db) return;
        try {
            const statement = db.prepareStatement(e.sql);
            statement.bind(e.params);
            const data = statement.execute();

            client?.sendMessage(`transferData-${e.id}`, { from: "app", data });
        } catch (error) {
            console.error('transfer Data error, event:', e);
            console.error(error);
    
    }
    };

    useEffect(() => {
        const subscriptions: any[] = [];

        subscriptions.push(client?.addMessageListener("getData", transferData));

        return () => {
            for (const subscription of subscriptions) {
                subscription?.remove();
            }
        };
    }, [client]);
}