pyax team mailing list archive

[Mr Python <raychorn@xxxxxxxxxxx>]

Public bug reported:

Consider the following SOQL statement:

Select COUNT() from Solution s WHERE (s.Status = 'Published') AND
(s.IsDeleted = False) AND (s.LastModifiedDate >
2008-08-24T00:00:00.000Z)

The results pyax reports from connection.py in the __processQueryResult
method is an empty {} in the query_result_batch variable.

The problem is the query_result says {u'records': None, u'done': True,
u'queryLocator': None, u'size': '106'}.

The fix would be to add the following exception code as follows:

        query_result_batch = self.__resultToObject(sobject_records)
        if (done is True) and (len(query_result_batch) == 0):
            query_result_batch = query_result
        return query_result_batch    

This is a hack but it works so long as I get something back from the
SOQL rather than nothing which is what pyax wants to give me.

Perhaps the development team can give me a more elegant solution in a
later release however since I need this to work now I am using my own
hack in the meantime.

I suspect the pyax development team simply did not expect people to use
the COUNT() function which can be useful even though it does not return
any SalesForce objects it does return the number of items a SOQL would
return.

** Affects: pyax
     Importance: Undecided
         Status: New

-- 
pyax fails to return results when COUNT() is used in SOQL
https://bugs.launchpad.net/bugs/301187
You received this bug notification because you are a member of pyax
Developers, which is the registrant for pyax.