search

digitalinteraction / deconf-api-toolkit

A library for running decentralised virtual conferences
https://deconf-api.openlab.dev/
MIT License
2 stars 0 forks source link

The first pageView log doesn't have the `attendee` set #32

Open robb-j opened 2 years ago

robb-j commented 2 years ago

When you do an auth message it should run a query to patch all existing logs with attendee=null with the new attendee id.

Something like:

UPDATE logs
SET attendee = {new_attendee}
WHERE socket == {socket_id} AND attendee IS NULL
robb-j commented 2 years ago

There should also be a migration to add an index to the relevant column so this is always fast