ensureSyncInfoTable method

Future<void> ensureSyncInfoTable()

Implementation

Future<void> ensureSyncInfoTable() async {
  final (conn, _) = await LiteConnection.getConnectionWithStatus();
  await conn.execute('''
    CREATE TABLE IF NOT EXISTS sync_info (
      table_name      VARCHAR(100) PRIMARY KEY,
      sync_at         INTEGER,
      retention_days  INTEGER,
      read_only       INTEGER DEFAULT 0,
      write_only      INTEGER DEFAULT 0
    );
  ''');
  await _ensureSyncInfoColumn(conn, 'write_only', 'INTEGER DEFAULT 0');
  LOG.printInfo(['TABLE_SYNC_SERVICE', 'sync_info ensured']);
}