all method
Get all records with optional pagination
Implementation
Future<List<Model>?> all({int? paginate}) async {
try {
if (paginate != null) {
limit(paginate);
}
final query = _buildQuery();
Database db = await database;
final result = await db.rawQuery(query, _bindings);
if (result.isEmpty) return null;
return result.map((data) {
final newMap = _convertDataTypes(data);
return fromMap(newMap);
}).toList();
} catch (e) {
throw DatabaseException('Failed to fetch all records: $e');
}
}