How to import JSON File into SQLAlchemy Table using Python 3.6?

Question

Trying to import data from a JSON File into a column data in a Table using SQLAlchemy.

Version looks kind of like this:

class  JsonTable(declarative_base()):
__tablename__ = "json_table"

id = Column(Integer, primary_key=True)
data = Column(JSON)


json_data = open('U:\\data.json')
data = json.load(json_data)    
for key, value in data.items():
    JsonTable

How to get the single JSON elements into my data column? JSON file looks very basic, like this

{
  "company": "test",
  "number": "123"
}

ked2liz · Accepted Answer · 2018-10-18 09:04:30Z

1

You can use mapping interface offered by SQLAlchemy:

metadata = MetaData()

columns = (
    Column('id', Integer, primary_key=True),
    Column('data', JSON, nullable=False),
    ...
)

jsonTable = Table('JsonTable', metadata, *columns)

class JsonTable(object):
    def __init__(self, json_data):    
      json_data = open('U:\\data.json')
      data = json.load(json_data)    
      for key, value in data.iteritems():
        setattr(self, key, value)

mapper(JsonTable, jsonTable)

edited Oct 18, 2018 at 9:04

ked2liz

672 gold badges3 silver badges11 bronze badges

answered Oct 11, 2018 at 11:38

Giorgos Myrianthous

40.4k21 gold badges156 silver badges175 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to import JSON File into SQLAlchemy Table using Python 3.6?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related