Creating local json file in python

Question

I'm trying to create a Rest JSON server using python and flask as backend and JavaScript as front end, the server data need to be saved in local file but i can't seem to find a way to store the data like :

[
{'id': id, 'name': name},
<--- New record from POST request goes here
]

what i mange to do is:

def create(name, title):
    record= str({'id': id, 'name': name}) + '\n'
    rlist= open('static/notes-list.txt', 'a')
    rlist.write(note)
    rlist.close()

# Then for getting data
def get_data():
    f= open('static/notes-list.txt')
    content = f.read()
    f.close()
    data= content.strip().split('\n')
    return data

but this give me array of stings in fetch data`['{...}','{...}']

you can use sqlite3 db for this purpose, it will work locally :D — sahasrara62, Mar 02 '23 at 14:35
@JonSG `json.load(f)` resulted in this error ` Uncaught (in promise) ReferenceError: result is not defined` — MaximoConn, Mar 02 '23 at 14:46

JonSG · Accepted Answer · 2023-03-02T15:05:55.530

1

You look like you are storing rows of json (NDJSON). You can use the json package to help manage this. There are likely python packages to help manage this type of data structure as well. Check out How to open .ndjson file in Python? which might ultimately make this post a "dupe"

import json

data_file_path = "notes.txt"
id = 1

def create(name, title):
    note= {
        "id": id,
        "name": name,
        "title": title
    }

    with open(data_file_path, "a") as rlist:
        rlist.write(f"{json.dumps(note)}\n")

def get_data():
    with open(data_file_path, "r") as rlist:
        return [json.loads(row) for row in rlist]

create("foo", "bar")
create("foo2", "bar2")

data = get_data()
print(json.dumps(data, indent=4))

That should result in a file that looks like:

{"id": 1, "name": "foo", "title": "bar"}
{"id": 1, "name": "foo2", "title": "bar2"}

and data that looks like:

[
    {
        "id": 1,
        "name": "foo",
        "title": "bar"
    },
    {
        "id": 1,
        "name": "foo2",
        "title": "bar2"
    }
]

edited Mar 02 '23 at 15:05

answered Mar 02 '23 at 14:53

JonSG

10,542
2
25
36

1

The name of this format is NDJSON or JSONLines, btw. – AKX Mar 02 '23 at 14:55
Thanks, I could not recall the proper name off the top of my head. – JonSG Mar 02 '23 at 15:01
1

@JonSG Thanks for reply , i ll check and report back after – MaximoConn Mar 02 '23 at 15:28
1

@JonSG after checking that was exactly what i needed ty again – MaximoConn Mar 03 '23 at 05:14

score -2 · Answer 2 · edited Mar 02 '23 at 14:55

-2

Try in get data() putting the f.close() after data= content.strip().spli....

edited Mar 02 '23 at 14:55

Dexygen

12,287
13
80
147

answered Mar 02 '23 at 14:44

KenYen-10

1
1

it does not matter as content already stored in variable – MaximoConn Mar 02 '23 at 14:54
As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Friedrich Mar 07 '23 at 10:06

Creating local json file in python

2 Answers2