Hello:
I am new to sqlalchemy and i want to know that how i can map my json keys
with database table columns to insert the json key values.
Below is my data.
{'sampleTimestamp': '2018-05-31T13:52:00.000Z', 'waterHeight': '0.0',
'fuelHeight': '31.02', 'temperature01': '60.00', 'temperature00': '60.00',
'temperature03': '60.00', 'temperature02': '60.00', 'temperature05':
'60.00', 'temperature04': '60.00', 'sampleCount': '1.0', 'sendOrder':
'43.0', 'utcOffsetSeconds': '17946.872', 'tankId': '222', 'state': '0',
'deviceType': 'abcdefg', 'sentTimestamp': '2018-05-31T18:51:06.925Z',
'messageId': '97dc5e4e-3bf2-4280-a206-8b721761105d', 'siteName': 'burger
King', 'timeZone': 'US/Central', 'source': '1287148', 'type': 'sales',
'deviceId': '1287373', 'localId': '1', '@timestamp':
'2018-05-31T18:51:06.925Z', 'lon': '-223.265588', 'lat': '101.542036',
'sourceType': 'abc', '@version': '1', 'siteId': '123456', 'operation':
'sample', 'brand': 'XYZ', 'timestamp': '2018-05-31T18:51:06.951Z',
'organizationId': ['0', '11111111111']}
As per above keys, i have same columns in my Mysql Database Table.
I need help to do the mapper between keys & table columns.
Any help is greatly appreciated.
Thanks
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
