load method

  1. @override
Future<DataProviderResult<T>> load(
  1. RouteDataContext context
)
override

Loads typed data for the given context.

Implementation

@override
Future<DataProviderResult<T>> load(RouteDataContext context) async {
  if (!_isSafeIdentifier(tableName) || !_isSafeIdentifier(keyColumn)) {
    throw ArgumentError(
      'tableName and keyColumn must be simple SQL identifiers.',
    );
  }
  final key =
      context.parameters[paramName] ?? context.queryParameters[paramName];
  if (key == null || key.isEmpty) {
    return DataProviderResult<T>.notFound();
  }

  final sql = 'SELECT * FROM $tableName WHERE $keyColumn = ? LIMIT 1';
  final row = await queryRunner(sql, [key]);

  if (row == null) {
    return DataProviderResult<T>.notFound();
  }

  if (row['is_deleted'] == true || row['deleted_at'] != null) {
    return DataProviderResult<T>.gone(
      cacheTags: [tableName, '$tableName:$key'],
    );
  }

  final entity = rowMapper(row);
  DateTime? updatedAt;
  if (row['updated_at'] is DateTime) {
    updatedAt = row['updated_at'] as DateTime;
  } else if (row['updated_at'] is String) {
    updatedAt = DateTime.tryParse(row['updated_at'] as String);
  }

  final version = row['version']?.toString() ?? row['id']?.toString();
  final etag = version != null ? 'w/"$version"' : null;

  return DataProviderResult<T>.found(
    entity,
    lastModified: updatedAt,
    etag: etag,
    cacheTags: [tableName, '$tableName:$key'],
  );
}