first method

@override Future<Map<String, dynamic>?> first([ List<String> columns = const [] ])

Implementation

@override
Future<Map<String, dynamic>?> first([List<String> columns = const []]) async {
  try {
    if (columns.isNotEmpty) {
      for (String column in columns) {
        selectColumns.remove(column);
      }
      selectColumns.addAll(columns);
    }
    final bindings = getBindings();
    String sql = limit(1).toSql();
    conn = await getConnection();
    final result = await conn.select(sql, bindings);
    if (result.isEmpty) {
      return null;
    }
    return result.first;
  } catch (e) {
    rethrow;
  }
}