all method

Future<List<Model>?> all({
  1. int? paginate,
})

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');
  }
}