GPT

Composable for Database Operations

// composables/useDatabase.ts import { ref } from 'vue'; import { sql } from '@/lib/db'; export function useDatabase () { const data = ref ([]); const loading = ref(false); const error = ref (null); const execute =

Prompt text

Original English text. Replace placeholders with your own details.

// composables/useDatabase.ts
import { ref } from 'vue';
import { sql } from '@/lib/db';

export function useDatabase<T>() {
 const data = ref<T[]>([]);
 const loading = ref(false);
 const error = ref<string | null>(null);

 const execute = async (query: string, params: any[] = []) => {
 loading.value = true;
 error.value = null;
 try {
 const result = await sql.raw(query, params);
 return result;
 } catch (e: any) {
 error.value = e.message;
 throw e;
 } finally {
 loading.value = false;
 }
 };

 const fetchAll = async (table: string, orderBy?: string) => {
 loading.value = true;
 error.value = null;
 try {
 data.value = await sql<T[]>`
 SELECT *
 FROM ${sql(table)}
 ${orderBy ? sql`ORDER BY ${sql(orderBy)}` : sql``}
 `;
 } catch (e: any) {
 error.value = e.message;
 } finally {
 loading.value = false;
 }
 };

 const fetchById = async (table: string, id: number) => {
 loading.value = true;
 error.value = null;
 try {
 const [result] = await sql<T[]>`
 SELECT *
 FROM ${sql(table)}
 WHERE id = ${id}
 `;
 return result;
 } catch (e: any) {
 error.value = e.message;
 } finally {
 loading.value = false;
 }
 };

 const insert = async (table: string, data: Partial<T>) => {
 loading.value = true;
 error.value = null;
 try {
 const columns = Object.keys(data);
 const values = Object.values(data);
 const [result] = await sql<T[]>`
 INSERT INTO ${sql(table)} (${sql(columns.join(', '))})
 VALUES (${sql(...values)})
 RETURNING *
 `;
 return result;
 } catch (e: any) {
 error.value = e.message;
 throw e;
 } finally {
 loading.value = false;
 }
 };

 const update = async (table: string, id: number, data: Partial<T>) => {
 loading.value = true;
 error.value = null;
 try {
 const setClause = Object.entries(data)
 .map(([key, value]) => `${key} = ${sql`${value}`}`)
 .join(', ');
 
 const [result] = await sql<T[]>`
 UPDATE ${sql(table)}
 SET ${sql(setClause)}
 WHERE id = ${id}
 RETURNING *
 `;
 return result;
 } catch (e: any) {
 error.value = e.message;
 throw e;
 } finally {
 loading.value = false;
 }
 };

 const remove = async (table: string, id: number) => {
 loading.value = true;
 error.value = null;
 try {
 await sql`
 DELETE FROM ${sql(table)}
 WHERE id = ${id}
 `;
 } catch (e: any) {
 error.value = e.message;
 throw e;
 } finally {
 loading.value = false;
 }
 };

 return {
 data,
 loading,
 error,
 execute,
 fetchAll,
 fetchById,
 insert,
 update,
 remove
 };
}

Source & attribution

Instructa AI Prompts · Instructa AI Prompts

Source-listed license: CC-BY-4.0. Prompt text is preserved; titles and previews may be shortened for display. Source examples are not NexGateHub test results.

View original source ↗ · Source credits & licenses

Explore more prompts →