upsert

import { DB } from 'ai-database'

const { db } = DB({
  Post: { title: 'string', content: 'markdown' },
})

db.Type.upsert(id, data)
db.Type.upsert(id, data, options)

// Creates if doesn't exist
await db.Post.upsert('hello-world', {
  title: 'Hello World',
  content: 'My post content...',
})

// Updates if it exists
await db.Post.upsert('hello-world', {
  title: 'Hello World',
  content: 'Updated content...',
})

const post = await db.Post.upsert('hello-world', {
  title: 'Hello World',
})

console.log(post.$id)       // 'hello-world'
console.log(post.title)     // 'Hello World'
console.log(post.createdAt) // Date

// First call - creates with all fields
await db.Post.upsert('hello', {
  title: 'Hello',
  content: 'Initial content',
  views: 0,
})

// Second call - only updates title
await db.Post.upsert('hello', {
  title: 'Updated Title',
})
// content and views unchanged

await db.Post.upsert('new-post', { title: 'New' })
// Emits: Post.created (if new)

await db.Post.upsert('existing', { title: 'Updated' })
// Emits: Post.updated (if exists)

// Sync external data
for (const item of externalData) {
  await db.Product.upsert(item.id, {
    name: item.name,
    price: item.price,
  })
}

// Idempotent operations
await db.Config.upsert('app-settings', {
  theme: 'dark',
  language: 'en',
})

await db.Post.upsert('hello', data, {
  onConflict: 'replace',  // 'replace' | 'merge' | 'skip'
})