adam/meshcore-hub
1
0 Fork 0
mirror of https://github.com/ipnet-mesh/meshcore-hub.git synced 2026-11-03 03:52:20 +01:00
Code Issues 1 Packages Projects Releases Wiki Activity

Parse channel message sender prefix to associate with a real Node (for filtering etc) #29

New Issue
Closed
opened 2026-10-04 23:09:34 +02:00 by adam · 1 comment
adam commented 2026-10-04 23:09:34 +02:00
Owner
Copy link
Copy source

Access DB with SQLite

  1. Add field "sender" to table messages
  2. Run query: UPDATE "messages" SET sender = substr( text, 1, INSTR(text, ':')-1 )
  3. run your queries
  4. do not forget to repeat step 1
Access DB with SQLite 1. Add field "sender" to table messages 2. Run query: `UPDATE "messages" SET sender = substr( text, 1, INSTR(text, ':')-1 ) ` 3. run your queries 4. do not forget to repeat step 1 <!-- github-sync-id:3907236074 -->
adam closed this issue 2026-10-04 23:09:34 +02:00
adam commented 2026-10-04 23:09:35 +02:00
Author
Owner
Copy link
Copy source

Thanks for the tip. Its something I've thought about, but assumes MeshCore firmware keeps prefixing the node name before the message.

Ideally, I'd like to handle this at the "collector" stage, basically, splitting the string (as per your example), but then looking up the "friendly name" in the Node table and dereferencing so we can then filter by "Nodes" (for example).

I'll update the issue title and have a think.

Thanks for the tip. Its something I've thought about, but assumes MeshCore firmware keeps prefixing the node name before the message. Ideally, I'd like to handle this at the "collector" stage, basically, splitting the string (as per your example), but then looking up the "friendly name" in the Node table and dereferencing so we can then filter by "Nodes" (for example). I'll update the issue title and have a think. <!-- github-comment-id:3861774616 -->
Sign in to join this conversation.
No Branch/Tag Specified
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
adam (Adam Wojcieszonek)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: adam/meshcore-hub#29