Can someone explain what is happening here?

[Rc85]

https://github.com/margelo/react-native-nitro-sqlite?tab=readme-ov-file#batch-operation

const commands = [
  {query: 'CREATE TABLE TEST (id integer)'},
  {query: 'INSERT INTO TEST (id) VALUES (?)', params: [value1]},
  {query: 'INSERT INTO TEST (id) VALUES (?)', params: [value2]},
  {query: 'INSERT INTO TEST (id) VALUES (?)', params: [value3, value4, value5, value6]},
];

const res = NitroSQLite.executeSqlBatch('myDatabase', commands);

console.log(`Batch affected ${result.rowsAffected} rows`);

Specifically this.

{query: 'INSERT INTO TEST (id) VALUES (?)', params: [value3, value4, value5, value6]}

Is this inserting 4 rows at once? If so, how would it look with multiple columns?

[nickrstan]

@Rc85

The docs need to be updated, the methods look to now be executeBatchAsync and executeBatch.

Is this inserting 4 rows at once? If so, how would it look with multiple columns?

Yes it would insert four rows. Here is a better, multi column example.

const commands = [
  // create a table with two columns
  { query: "CREATE TABLE TEST (id integer, age integer)" },

  // add one row
  { query: "INSERT INTO TEST (id, age) VALUES (?, ?)", params: [1, 10] },

  // add another
  { query: "INSERT INTO TEST (id, age) VALUES (?, ?)", params: [2, 20] },

  // add two rows
  {
    query: "INSERT INTO TEST (id, age) VALUES (?, ?)",
    params: [
      [3, 30],
      [4, 40],
    ],
  },
];

const res = await NitroSQLite.executeBatchAsync(DB_NAME, commands);

Will result in:

id	age
1	10
2	20
3	30
4	40

[chrispader]

Thanks for the hint, updating the READMe right now including your optimized comment. Thanks @nickrstan