Page MenuHomePhabricator

[SQLite] add table for messages to device
ClosedPublic

Authored by kamil on Feb 26 2024, 2:21 AM.
Tags
None
Referenced Files
Unknown Object (File)
Sun, Nov 24, 6:57 AM
Unknown Object (File)
Sat, Nov 23, 8:05 PM
Unknown Object (File)
Sat, Nov 23, 4:58 PM
Unknown Object (File)
Sat, Nov 23, 7:51 AM
Unknown Object (File)
Fri, Nov 22, 11:38 AM
Unknown Object (File)
Fri, Nov 22, 7:46 AM
Unknown Object (File)
Wed, Nov 6, 6:48 PM
Unknown Object (File)
Oct 15 2024, 7:58 AM
Subscribers

Details

Summary

ENG-6739.

Adding index because we'll need to query based on timestamp.

Test Plan
  1. Test migration.
  2. Logout and test creating database from scratch.

Test on both web (it's visible in worker's logs) and native.

Diff Detail

Repository
rCOMM Comm
Lint
No Lint Coverage
Unit
No Test Coverage

Event Timeline

kamil held this revision as a draft.
kamil published this revision for review.Mar 1 2024, 12:24 AM
native/cpp/CommonCpp/DatabaseManagers/SQLiteQueryExecutor.cpp
881 ↗(On Diff #37688)

Why don't we want to execute this migration inside a transaction?

Are we going to backup this table? If so then we should add it to NativeSQLiteConnectionManager so that logs are capture for this table. If not then we should update createMainCompaction method so that removeDeviceSpecificDataSQL script removes data from this table after backup is created.

Are we going to backup this table?

No, there is no need to

If not then we should update createMainCompaction method so that removeDeviceSpecificDataSQL script removes data from this table after backup is created.

Right, thanks for catching

native/cpp/CommonCpp/DatabaseManagers/SQLiteQueryExecutor.cpp
881 ↗(On Diff #37688)

that was a mistake, fixing

This revision is now accepted and ready to land.Mar 5 2024, 1:21 AM
This revision was automatically updated to reflect the committed changes.