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',
Field("init_search", "datetime", default=None),
Field("end_search", "datetime", default=None),
Field("status_now", type=json_type, default=None),
)
Its work for me
Em quinta-feira, 29 de junho de 2017 13:49:16 UTC-3, narcissus escreveu:
>
> 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 (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 convert the JSON field to a text field, define a
>> DAL custom field type
>> <http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Custom-Field-types--experimental->,
>>
>> or define filter_in/filter_out
>> <http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#filter_in-and-filter_out>
>>
>> functions. Or submit a pull request to support the MySQL JSON field type.
>>
>> Anthony
>>
>> On Thursday, June 29, 2017 at 9:10:16 AM UTC-4, narcissus wrote:
>>>
>>> Hi,
>>> I've created a database model containing a field of type json to access
>>> a pre-existent MySQL database (created with mysql server version > 5.7.11)
>>> containing the same field of type json into the same table.
>>> I cannot understand why the json data stored into the database are read
>>> always as null by web2py DAL functions.
>>> This happens only when I access to MySQL database (ex: Postgres works).
>>> It seems that no converter has been implemented for MySQL json field into
>>> web2py DAL.
>>>
>>> Thanks in advanced for helping me
>>>
>>
--
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.
