Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Update SQLite rowid on update to make records immutable (Location and Tasks) #193

Open
githengi opened this issue Mar 7, 2019 · 0 comments
Labels
Required by Reveal Size: Short <=1 Issue Takes about 1 day to complete

Comments

@githengi
Copy link
Contributor

githengi commented Mar 7, 2019

As per SQLite documentation Whenever you create a table without specifying the WITHOUT ROWID option, you get an implicit auto increment column called rowid.

On updating either of below tables update the rowid to the maximum of that table +1. This makes updates for each object immutable.

  • Locations,
  • Structures
  • Tasks

The rowId will be used by P2PLibrary to identify records that should be synced

@githengi githengi added the Size: Short <=1 Issue Takes about 1 day to complete label Mar 19, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Required by Reveal Size: Short <=1 Issue Takes about 1 day to complete
Projects
None yet
Development

No branches or pull requests

1 participant