clearDatabaseIfNotEmpty method

Future<void> clearDatabaseIfNotEmpty()

Implementation

Future<void> clearDatabaseIfNotEmpty() async {
  logger.d("Checking if database has data");

  final db = await _getDatabase();
  final count = Sqflite.firstIntValue(
      await db.rawQuery('SELECT COUNT(*) FROM $_intervalTableName'));

  if (count != null && count > 0) {
    logger.d("Database has data, clearing it");
    await db.delete(_intervalTableName);
  } else {
    logger.d("Database is already empty");
  }
}