GPT

Database Operations

// Basic CRUD operations class DatabaseService { constructor(tableName) { this.tableName = tableName; } async create(data) { try { const { data: result, error } = await supabase .from(this.tableName) .insert([d

Prompt text

Original English text. Replace placeholders with your own details.

// Basic CRUD operations
class DatabaseService {
 constructor(tableName) {
 this.tableName = tableName;
 }
 
 async create(data) {
 try {
 const { data: result, error } = await supabase
 .from(this.tableName)
 .insert([data])
 .select();
 
 if (error) throw error;
 return result[0];
 } catch (error) {
 console.error(`Create ${this.tableName} error:`, error);
 throw error;
 }
 }
 
 async read(id) {
 try {
 const { data, error } = await supabase
 .from(this.tableName)
 .select('*')
 .eq('id', id)
 .single();
 
 if (error) throw error;
 return data;
 } catch (error) {
 console.error(`Read ${this.tableName} error:`, error);
 throw error;
 }
 }
 
 async update(id, updates) {
 try {
 const { data, error } = await supabase
 .from(this.tableName)
 .update(updates)
 .eq('id', id)
 .select();
 
 if (error) throw error;
 return data[0];
 } catch (error) {
 console.error(`Update ${this.tableName} error:`, error);
 throw error;
 }
 }
 
 async delete(id) {
 try {
 const { error } = await supabase
 .from(this.tableName)
 .delete()
 .eq('id', id);
 
 if (error) throw error;
 } catch (error) {
 console.error(`Delete ${this.tableName} error:`, error);
 throw error;
 }
 }
 
 async list(query = {}) {
 try {
 let request = supabase
 .from(this.tableName)
 .select('*');
 
 // Apply filters
 Object.entries(query).forEach(([key, value]) => {
 request = request.eq(key, value);
 });
 
 const { data, error } = await request;
 
 if (error) throw error;
 return data;
 } catch (error) {
 console.error(`List ${this.tableName} error:`, error);
 throw error;
 }
 }
}

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 →