deleteJobsByPriority method

Future<int> deleteJobsByPriority(
  1. int priority, {
  2. DateTime? olderThan,
})

Implementation

Future<int> deleteJobsByPriority(int priority, {
  DateTime? olderThan,
}) async {
  String query = "DELETE FROM background_service_jobs WHERE priority <= ?";
  final params = <Object?>[priority];

  if (olderThan != null) {
    query += " AND created_at < ?";
    params.add(olderThan.toIso8601String());
  }

  final ResultSet result = await db.execute(query, params);
  return result.length;
}