Add primary key change to tests

porsager · porsager · commit d169712cb6a7 · 2023-06-06T22:57:28.000+02:00
diff --git a/tests/index.js b/tests/index.js
@@ -1989,9 +1989,9 @@ t('subscribe', { timeout: 2 }, async() => {
 
   const result = []
 
-  const { unsubscribe } = await sql.subscribe('*', (row, { command, old }) =>
-    result.push(command, row.name || row.id, old && old.name)
-  )
+  const { unsubscribe } = await sql.subscribe('*', (row, { command, old }) => {
+    result.push(command, row.name, row.id, old && old.name, old && old.id)
+  })
 
   await sql`
     create table test (
@@ -2003,6 +2003,7 @@ t('subscribe', { timeout: 2 }, async() => {
   await sql`alter table test replica identity default`
   await sql`insert into test (name) values ('Murray')`
   await sql`update test set name = 'Rothbard'`
+  await sql`update test set id = 2`
   await sql`delete from test`
   await sql`alter table test replica identity full`
   await sql`insert into test (name) values ('Murray')`
@@ -2013,7 +2014,7 @@ t('subscribe', { timeout: 2 }, async() => {
   await sql`insert into test (name) values ('Oh noes')`
   await delay(10)
   return [
-    'insert,Murray,,update,Rothbard,,delete,1,,insert,Murray,,update,Rothbard,Murray,delete,Rothbard,',
+    'insert,Murray,1,,,update,Rothbard,1,,,update,Rothbard,2,,1,delete,,2,,,insert,Murray,2,,,update,Rothbard,2,Murray,2,delete,Rothbard,2,,',
     result.join(','),
     await sql`drop table test`,
     await sql`drop publication alltables`,
