{/* Auto-generated by scripts/mdx_snippets_gen.py. Do not edit manually. */}

export const TsInsertIfNotExists = "const table2 = await db.createTable(\"domains\", [\n  { domain: \"google.com\", name: \"Google\" },\n  { domain: \"github.com\", name: \"GitHub\" },\n]);\n\nconst newDomains = [\n  { domain: \"google.com\", name: \"Google\" },\n  { domain: \"facebook.com\", name: \"Facebook\" },\n];\nawait table2\n  .mergeInsert(\"domain\")\n  .whenNotMatchedInsertAll()\n  .execute(newDomains);\nawait table2.countRows(); // 3\n";

export const TsReplaceRange = "const table3 = await db.createTable(\"chunks\", [\n  { doc_id: 0, chunk_id: 0, text: \"Hello\" },\n  { doc_id: 0, chunk_id: 1, text: \"World\" },\n  { doc_id: 1, chunk_id: 0, text: \"Foo\" },\n  { doc_id: 1, chunk_id: 1, text: \"Bar\" },\n]);\n\nconst newChunks = [{ doc_id: 1, chunk_id: 0, text: \"Baz\" }];\n\nawait table3\n  .mergeInsert([\"doc_id\", \"chunk_id\"])\n  .whenMatchedUpdateAll()\n  .whenNotMatchedInsertAll()\n  .whenNotMatchedBySourceDelete({ where: \"doc_id = 1\" })\n  .execute(newChunks);\n\nawait table3.countRows(\"doc_id = 1\"); // 1\n";

export const TsUpsertBasic = "const table = await db.createTable(\"users\", [\n  { id: 0, name: \"Alice\" },\n  { id: 1, name: \"Bob\" },\n]);\n\nconst newUsers = [\n  { id: 1, name: \"Bobby\" },\n  { id: 2, name: \"Charlie\" },\n];\nawait table\n  .mergeInsert(\"id\")\n  .whenMatchedUpdateAll()\n  .whenNotMatchedInsertAll()\n  .execute(newUsers);\n\nawait table.countRows(); // 3\n";