Get Messages get most recent messages

[kienmarkdo]

Current gets oldest messages to newest messages, which is fine, but we want newest messages first.

Need to change the implementation of Get Messages such that newest messages are collected first.

• Track two offset IDs in SQLite3
  • Previous Start ID, Previous Stop ID.
• Each API call gets N messages.
• First collection
  • All initial values are 0 to indicate that collection should start with latest Message ID.
• Next collection
  • No new messages are sent...
    • Start at Previous Stop ID --> Stop when N messages are collected
    • Update Previous Start ID with current start ID --> Previous Stop ID with current stop ID
    • New messages are sent... Old messages still need to be collected.
    • Start at latest ID --> Stop at Previous Start ID --> Start at Previous Stop ID --> Stop when N messages are collected
    • Update Previous Start ID with current latest ID --> Previous Stop ID with current Stop ID