[web2py] Re: JSON field with MySQL database

2018-07-14 Thread Rodrigo Sacht
from gluon.dal import SQLCustomType json_type = SQLCustomType(type ='text', native='JSON', encoder=(lambda x: x), decoder=(lambda x: x) ) db.define_table('product_country_search',

[web2py] Re: JSON field with MySQL database

2017-07-03 Thread narcissus
OK, I've tried filtering_out (as described into the book) and ended up with the following error when accessing into the table containing the JSON field object of type 'NoneType' has no len() I think this happens because the problem is not at back-end (field filtering function) but at the

[web2py] Re: JSON field with MySQL database

2017-07-03 Thread narcissus
Thanks, I'll try. Il giorno giovedì 29 giugno 2017 23:59:03 UTC+2, Anthony ha scritto: > > On Thursday, June 29, 2017 at 12:49:16 PM UTC-4, narcissus wrote: >> >> Thanks for your answer. >> Option 1) In my case I cannot change fields into the original database. >> Option 2) and 3) can you provide

[web2py] Re: JSON field with MySQL database

2017-06-29 Thread Anthony
On Thursday, June 29, 2017 at 12:49:16 PM UTC-4, narcissus wrote: > > Thanks for your answer. > Option 1) In my case I cannot change fields into the original database. > Option 2) and 3) can you provide implementation examples for my specific > case > I'm not familiar with how MySQL JSON fields

[web2py] Re: JSON field with MySQL database

2017-06-29 Thread narcissus
Thanks for your answer. Option 1) In my case I cannot change fields into the original database. Option 2) and 3) can you provide implementation examples for my specific case Option 4) I think I'll do it Il giorno giovedì 29 giugno 2017 15:23:37 UTC+2, Anthony ha scritto: > > In most databases

[web2py] Re: JSON field with MySQL database

2017-06-29 Thread Anthony
In most databases (including MySQL), the DAL simply stores JSON in a text field and converts to and from Python objects when writing/reading the data. The Postgres adapter makes use of the Postgres native JSON field type, but the MySQL adapter does not yet do so. Some options might be to