load method
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'],
);
}