executeQueryParams method

Future<Result<QueryResult>> executeQueryParams(String connectionId, String sql, List params)

Executes a SQL query with parameters.

Convenience method that combines prepare and execute in a single call. The connectionId must be a valid active connection. The sql must be a non-empty parameterized SQL statement. The params list should contain values for each '?' placeholder in sql.

Returns a ValidationError if SQL is empty.

Implementation

Future<Result<QueryResult>> executeQueryParams(
  String connectionId,
  String sql,
  List<dynamic> params,
) async {
  if (sql.trim().isEmpty) {
    return const Failure<QueryResult, OdbcError>(
      ValidationError(message: 'SQL query cannot be empty'),
    );
  }
  return _repository.executeQueryParams(connectionId, sql, params);
}