first method

Implementation

Future<Model?> first({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;

    final newMap = _convertDataTypes(result.first);
    return fromMap(newMap);
  } catch (e) {
    throw DatabaseException('Failed to fetch first record: $e');
  }
}