discontinuedPackage connect_database has been discontinued.

validateConnection method

@override Future<Result<bool>> validateConnection()

Validates if the connection is still alive and usable. Returns Success(true) if connection is valid, Success(false) otherwise.

Implementation

@override
Future<Result<bool>> validateConnection() async {
  try {
    final result = await execute('SELECT 1 AS validation_check');
    if (result.isSuccess()) {
      final rows = result.getOrThrow();
      return Success(rows.isNotEmpty);
    }
    return const Success(false);
  } catch (e) {
    return const Success(false);
  }
}