Boolean and null normalization support

[macpreet]

I tried to use your code. It reads null values in json and stores it in sql by replacing with NONE(python). As per my requirement, we need null to be stored as it is in sql. Any help would be appreciated. Thanks

[samos667]

Exactly the same thing for me !

Some logs:

json used: https://api.themoviedb.org/3/movie/500?api_key=

null value need to be None true to True false to False

@zolekode you know a method to fix it without rewrite the json ?

i will try some fix in my way, i'll keep you informed

[samos667]

@macpreet i think* title need to be set to "Boolean and null normalization support"

[macpreet]

@macpreet i thing title need to be set to "Boolean and null normalization support"

Done.

[macpreet]

Closed the issue by mistake . Sorry

[zolekode]

@samos667 regarding the screenshot you shared, you need to pass a dictionary (python dict) instead of a json. You will probably first need to do something like import json json.loads(your_json)

[zolekode]

@macpreet @samos667 could you reexplain with the help of examples and screenshots? I am not very certain if I understand what you need.

[zolekode]

Issue should be fixed. @samos667 @macpreet

• None is now cast to pure Nan which should save values as null
• Python bool objects are cast to pandas bool

To solve both your problems:

table_maker.save_tables(..., cast_none_to_nan=True, cast_object_to_bool=True)

[zolekode]

Please leave a star and share the love of open source @samos667 @macpreet

[macpreet]

Thanks for your help @zolekode