Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-10-18 Thread Niphlod
PR sent to fix the behaviour with pg8000 On Friday, October 17, 2014 9:02:08 PM UTC+2, Anthony wrote: > > 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 > chan

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-10-17 Thread Anthony
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

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-10-17 Thread Niphlod
we don't test contrib modules. pg8000 is the place to make PRs to test, not web2py... On Friday, October 17, 2014 8:36:00 PM UTC+2, Paolo Valleri wrote: > > Hi, > I created a PR to run test on travis against pg8000 too, > https://github.com/web2py/web2py/pull/530. Given that we can check wha

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-10-17 Thread Paolo Valleri
Hi, I created a PR to run test on travis against pg8000 too, https://github.com/web2py/web2py/pull/530. Given that we can check what works and what doesn't. I'd suggest that you can open an issue here https://github.com/mfenniak/pg8000/issues regarding the missing feature of having json as fiel

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-10-15 Thread Arnav Sharma
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 wrote: > > > On Tuesday, October 14, 2014 11:50:45 PM UTC+2, ArnvShrma wrote: >> >

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-10-14 Thread Anthony
Is your problem that pg8000 doesn't support the JSON field type, or something else? On Monday, October 13, 2014 8:26:34 PM UTC-4, ArnvShrma wrote: > > Hi, > > I am facing the exact same issue. Any work-around for this? > > On Saturday, March 8, 2014 8:15:26 PM UTC+5:30, Tony Locke wrote: >> >> T

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-10-14 Thread Niphlod
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

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-10-14 Thread Arnav Sharma
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/e

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-10-14 Thread Niphlod
until pg8000 supports it, use psycopg2 instead. On Tuesday, October 14, 2014 2:26:34 AM UTC+2, ArnvShrma wrote: > > Hi, > > I am facing the exact same issue. Any work-around for this? > > On Saturday, March 8, 2014 8:15:26 PM UTC+5:30, Tony Locke wrote: >> >> Thanks for your list (and patch) Mari

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-10-13 Thread ArnvShrma
Hi, I am facing the exact same issue. Any work-around for this? On Saturday, March 8, 2014 8:15:26 PM UTC+5:30, Tony Locke wrote: > > Thanks for your list (and patch) Mariano, that's very useful. I've opened > an issue for it at: > > https://github.com/mfenniak/pg8000/issues/30 > > On Monday, 3

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-03-09 Thread Tony Locke
Thanks for your list (and patch) Mariano, that's very useful. I've opened an issue for it at: https://github.com/mfenniak/pg8000/issues/30 On Monday, 3 March 2014 20:26:15 UTC, Mariano Reingart wrote: > > Including contrib in sys.path would be interesting but there could be > collisions (for ex

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-03-03 Thread Massimo Di Pierro
On Monday, 3 March 2014 14:26:15 UTC-6, Mariano Reingart wrote: > > Including contrib in sys.path would be interesting but there could be > collisions (for example, in this case, witch pg8000 will be imported: the > one installed or the one in gluon.contrib?) > That depends on the order in sys

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-03-03 Thread Mariano Reingart
Including contrib in sys.path would be interesting but there could be collisions (for example, in this case, witch pg8000 will be imported: the one installed or the one in gluon.contrib?) Tony: there are other changes needed for web2py (see the diff for web2py DAL I've attached earlier), the most

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-03-03 Thread Niphlod
just be sure that the same sys.path is then in scheduler, shell, tests, and so on ^_^ BTW: from gluon.contrib import something should be the recommended way to import something from contrib let's not forget all the hassle we've been into dealing with from gluon import module vs import module

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-03-03 Thread Massimo Di Pierro
I agree with Niphlod. I do not like packages that need to be installed to work and explicit relative imports is better than absolute imports. Yet, this is not the only package we had to tweak to include in contrib. So this may come up again. Any objection to include contrib in sys.path? On Sunda

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-03-02 Thread Niphlod
as long as you can use it without installing it in sys.path, then it's fine. If not, it can't be shipped with web2py, just supported as a module. I don't like packages that needs a complete install to work. It's true that we have venvs for quite some time now, but a module with less than 10 files

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-03-02 Thread Massimo Di Pierro
I think you are right. We should include contrib to the sys.path. You should not have to change pg8000 for this. On Sunday, 2 March 2014 12:24:58 UTC-6, Tony Locke wrote: > > Hi, I'm a contributor to pg8000 and if there are any changes you need to > get pg8000 working with web2py, let me know. L

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-03-02 Thread Tony Locke
Hi, I'm a contributor to pg8000 and if there are any changes you need to get pg8000 working with web2py, let me know. Looking at the absolute import problem, PEP8 seems to think absolute imports are the way to go: http://legacy.python.org/dev/peps/pep-0008/ (search for 'relative' in the text) b

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-03-01 Thread Joe Barnhart
Hi Mariano -- I'd like to encourage you to keep making pg8000 a viable alternative for web2py. I started with it but had to change to psycopg2 because of some issues that postgres handled better under the psy driver. But I think pypy could be the future of python and it won't support a driver

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-02-25 Thread Mariano Reingart
Hi Horst: Sadly there have been a lot of changes in pg8000, so it is not backward compatible with the current custom version in web2py. First, you need to delete the pg8000 folder in contrib, and put the new pg8000 folder (the one with __init__.py) directly in the web2py top level folder (at the

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-02-25 Thread Horst Horst
I've tried the latest pg8000 as a drop-in replacement, but it seems web2py can't import it: Failure to connect, tried 5 times: Traceback (most recent call last): File "/Users/sfx/dev/mdb/web2py.app/Contents/Resources/gluon/dal.py", line 7766, in __init__ File "/Users/sfx/dev/mdb/web2py.app/C

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-02-25 Thread Massimo Di Pierro
Let me know if you think we should upgrade. On Monday, 24 February 2014 14:32:05 UTC-6, Mariano Reingart wrote: > > You could try to update pg8000 from the official: > > https://github.com/mfenniak/pg8000 > > Let us know if that works, so we could update the one distributed with > web2py > The on

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-02-24 Thread Mariano Reingart
You could try to update pg8000 from the official: https://github.com/mfenniak/pg8000 Let us know if that works, so we could update the one distributed with web2py The one currently distributed in contrib is an older version with custom patches (as it was not being mantained at the time it was inc

[web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-02-24 Thread Horst Horst
I'm getting a: type oid 114 not mapped to py type I'm wondering what's the best thing to do now? Currently I'm considering: - using TEXT instead. But my former JSON strings are then enclosed by "|" which leads to new errors - updating gp8000 (there seems to be a newer version, but the vers