If the only problem is with JSON support, you might try the following:
db._adapter.types['JSON'] = 'TEXT'
The above is the default when the driver doesn't support JSON (it gets
changed to 'JSON' when the DAL thinks the driver supports 'JSON').
If pg8000 doesn't support JSON, then presumably in
PostgreSQLAdapter.try_json, the following code is incorrect and should be
changed:
if self.driver_name == "pg8000":
supports_json = self.connection.server_version >= "9.2.0"
Anthony
On Wednesday, October 15, 2014 12:07:49 PM UTC-4, ArnvShrma wrote:
>
> Hi Niphlod,
>
> I am a newbie to unittests, Eden unittests, postgis, postgresql and its
> drivers which is why I had come asking for help. Anyhow, I appreciate your
> input.
>
> Many thanks
>
> On 15 October 2014 03:55, Niphlod <[email protected]> wrote:
>
>>
>>
>> On Tuesday, October 14, 2014 11:50:45 PM UTC+2, ArnvShrma wrote:
>>>
>>> Hi Niphlod,
>>>
>>> I tried using psycopg2 but there are few reasons because of which I can
>>> not use it. I am currently deploying travis CI to run Sahana Eden unit
>>> tests. psycopg2 fails a few of the tests which it really should not. You
>>> can see the build here [1].
>>>
>>> [1] https://travis-ci.org/arnavsharma93/eden/jobs/37883503
>>>
>>> So, any temporary fix of running pg8000?
>>>
>>
>> web2py does not maintain pg8000 (although its developer is a contributor
>> to web2py's code). Contact him about the issue on the json type.
>>
>> Also, it seems that most of the errors (web2py doesn't maintain Sahana
>> Eden either, and I'm not a developer or Sahana Eden) comes from lat/long
>> differences from fixed values (again, probably, related from a quick
>> copy/paste unittest suite than a carefully built one)
>>
>> If only people could READ unittests instead of pointing out failing ones
>> as actual failures....world will have less headaches.
>> E.g.:
>>
>> 26.0729016786571 != 26.072901678657075
>>
>> let's confront them carefully...
>>
>> 26.0729016786571
>> 26.072901678657075
>>
>> yep. psycopg2 returns the same value than pg8000, only with a lesser
>> precision, estimated in roughly...wait, let's do calcs.
>> 26.07291 to 26.07292 equals to 1 meter. Every digit you loose in precision,
>> adds up roughly to an order of magnitude...
>> meaning 26.0729 to 26.0730 equals 10 meters.
>> sahana's tests are complaining about a difference of .... well, much more
>> LESS than the dimension a grain of salt (actually, a lot less).
>> If sahana is not trying to tie gps coordinates to atoms, psycopg2 is not the
>> problem, sahana's tests are.
>>
>> --
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> ---
>> You received this message because you are subscribed to a topic in the
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/web2py/BfSIbUSPk38/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> [email protected].
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> *Arnav Sharma <http://web.iiit.ac.in/~arnav.s/>*
> *IIITH*
>
> "If everything is under control, you are going too slow." - Some wise man
> with big nerdy glasses.
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
