Inserting JSON into postgresql from Flask-Sql Alchemy

Question

I want to insert JSON type of data in PostgreSQL Database from flask

eg: {"a":[1,2,3] , "b":[1,2,3]}

One example for such data is Phone.no and Childrens, One person can have multiple ph.no and Childrens

In flask View


@app.route('/add', methods=['POST']) 
def addRex(): 
Name = request.form[‘name’] 
data = request.get_json(force=False, silent=False, cache=True)
p = Projects(name=name,data = data) 
db.session.add(p) 
db.session.commit()

In HTTP post method

def addData(): 
name = input ('Enter Name :') 
data = input('Enter Data :') 
headers = {'Content-type': 'application/json', 'Accept': 'text/plain'}
r = requests.post(localhost:5000/add, 
data ={'name':name}, json={'data':data}) 
if (r.status_code == 200):print(' Added Successfully!!') else:print('Already exists!')

How can I insert such kind of data from flask into postgresql.

if Anyone can help me with my problem.

Thanks in advance

score 0 · Answer 1 · answered Nov 24 '20 at 18:42

0

From sqlalchemy dialect, you can select JSON for Postgres. Here is an example,

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from sqlalchemy.dialects.postgresql import JSON

app = Flask(__name__)

app.config['SQLALCHEMY_DATABASE_URI'] = 'postgres://username:password@localhost:5432/db'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = True

db = SQLAlchemy(app)


class Person(db.Model):
    person_name = db.Column(db.Text, primary_key=True)
    details = db.Column(JSON)


# db.create_all() ==> for creating the db

per_1 = Person(person_name='Batman', details={"phone_no": [5, 6, 7, 8, 9], "children": {"son": [
               "Dick Grayson", "Jason Todd", "Damian Wayne", "Tim Drake"], "daughter": ['Helena Wayne']}})
db.session.add(per_1)
db.session.commit()

answered Nov 24 '20 at 18:42

NavaneethaKrishnan

1,213
1
9
22

Thanks for your answer it helped me out, but still, there's a problem that When I am trying to enter these details via API post requests like curl or something, the JSON gets converted into String like '{"a":[1,2,3] , "b":[1,2,3]}', I have already checked that the column type is JSON – Ayush Vyas Nov 25 '20 at 04:12
Can you tell how you passed the data in curl or post method – NavaneethaKrishnan Nov 25 '20 at 05:01
curl -d "data={'a':[1,2,3],'b':[1,2,3]}" localhost:5001/data -X POST, I even tried passing the data from python HTTP post request its still in form of String. – Ayush Vyas Nov 25 '20 at 05:42
1

add this -H "Content-Type: application/json".. Refer https://stackoverflow.com/questions/7172784/how-do-i-post-json-data-with-curl – NavaneethaKrishnan Nov 25 '20 at 08:21
data = request.get_json(force=False, silent=False, cache=True) when doing this on view and adding data from HTTP post request the data inserted in database is null – Ayush Vyas Nov 25 '20 at 13:11
get_json from the html form ourput? – NavaneethaKrishnan Nov 25 '20 at 13:15
get_json in flask view, and calling the API from python HTTP request post method – Ayush Vyas Nov 25 '20 at 16:39
can you add that part here – NavaneethaKrishnan Nov 25 '20 at 17:46
can you edit your question and add these things there – NavaneethaKrishnan Nov 26 '20 at 10:54

Inserting JSON into postgresql from Flask-Sql Alchemy

1 Answers1