البيانات والـ API في SDK

// Simple list
const { data, error } = await dypai.api.get('get_products', {
  params: { category: 'electronics', limit: 10 }
});

// Paged list
const { data, error } = await dypai.api.get('get_products', {
  params: { limit: 20, offset: 0 }
});

const { data, error } = await dypai.api.post('create_order', {
  customer_id: 'uuid-123',
  items: [{ id: 'p1', qty: 2 }]
});

const { data, error } = await dypai.api.put('update_product/product-uuid', {
  price: 29.99
});

const { error } = await dypai.api.delete('delete_product/product-uuid');

import { createClient } from '@dypai-ai/client-sdk';

const dypaiAdmin = createClient('https://your-project.dypai.app', {
  serviceRoleKey: process.env.DYPAI_SERVICE_ROLE_KEY!,
});

const { data } = await dypaiAdmin.db.direct
  .from('products')
  .eq('active', true)
  .gt('price', 50)
  .orderBy('price', 'DESC')
  .limit(20)
  .select();

// Select specific columns
const { data } = await dypaiAdmin.db.direct.from('products').select('id, name, price');

// Single row
const { data: user } = await dypaiAdmin.db.direct.from('users').eq('id', id).single();

// Count
const { data: count } = await dypaiAdmin.db.direct.from('orders').eq('status', 'pending').count();

// Insert (single or bulk — auto-chunks at 1,000 rows)
await dypaiAdmin.db.direct.from('products').insert({ name: 'Widget', price: 9.99 });
await dypaiAdmin.db.direct.from('products').insert(thousandRows);

// Update (filter required)
await dypaiAdmin.db.direct.from('products').eq('category', 'old').update({ active: false });

// Delete (filter required)
await dypaiAdmin.db.direct.from('products').eq('id', 'abc').delete();

// Upsert (insert or update on conflict)
await dypaiAdmin.db.direct.from('products').upsert({ id: '1', name: 'Widget' }, 'id');

await dypaiAdmin.db.direct.sql('ALTER TABLE products ADD COLUMN sku TEXT');

const { data } = await dypaiAdmin.db.direct.sql(
  'SELECT category, COUNT(*) FROM products WHERE price > $1 GROUP BY category',
  [25]
);