How to add to a json file in python

Question

I can read the json file and set the information I need to the variables. I have accounts, and I need to be able to add an account to it, this is the code I have so far:

import json

user = raw_input("User: ")

with open('text.json') as data_file:
    data = json.load(data_file)

code =  data["users"][user]["pass"]
display = data["users"][user]["display"]

print "Password: " + code
print "Display Name - " + display

This works fine to read the file, here is the expected format of the output json file:

{
  "users":{
    "User1": {
      "display": "User1",
      "pass": "EzPass123"
    },
    "Richard": {
      "display": "Attack69",
      "pass": "Smith"
    }
  }
}

Can someone show me how to add another account to the accounts already existing in the dictionary?

So? Use the dictionary as you normally would then dump after modification. — Malik Brahimi
– Malik Brahimi, Commented Jan 17, 2016 at 20:14
I am not familiar with the json lingo, the code I have is from another question, i just modified it. Can you explain in a little more detail please? — Richard Smith
– Richard Smith, Commented Jan 17, 2016 at 20:15

Samuele Mattiuzzo · Accepted Answer · 2016-01-17 21:33:46Z

2

import json

# here you read your new user and his password
user = raw_input("User: ")
display = raw_input("Display name: ")
pwd = raw_input("Pass: ")

with open('text.json') as data_file:
    data = json.load(data_file)
    # update the data dictionary then re-dump it in the file
    data['users'].update({
        user: {
            'display': display,
            'pass': pwd
        }
    })

with open('text.json', 'w') as data_file:
    json.dumps(data, data_file, indent=4)

edited Jan 17, 2016 at 21:33

answered Jan 17, 2016 at 20:15

Samuele Mattiuzzo

11.1k5 gold badges41 silver badges64 bronze badges

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

11 Comments

Richard Smith Over a year ago

that replaces user1 witht that information, I need to add a new user

Samuele Mattiuzzo Over a year ago

whops, typoed, updating now

Richard Smith Over a year ago

that doesn't add another account for some reason, but I have no errors

Mark Tolonen Over a year ago

json.dump, not json.dumps. Probably need to rewind the file too if using the same open instance for reading and writing.

Richard Smith Over a year ago

Traceback (most recent call last): File "add.py", line 17, in <module> json.dump(data, data_file) File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/json/__init__.py", line 190, in dump fp.write(chunk)

|

Mark Tolonen · Accepted Answer · 2016-01-17 20:42:11Z

0

Here's a solution covering the fixes discussed in the other answer:

#!python2
import json

# here you read your new user and his password
user = raw_input("User: ")
display = raw_input("Display name: ")
pwd = raw_input("Pass: ")

with open('text.json') as data_file:
    data = json.load(data_file)
    data['users'][user] = {'display':display,'pass':pwd}

with open('text.json','w') as data_file:
    json.dump(data, data_file, indent=4)

Output:

User: markt
Display name: Mark
Pass: 123

Result:

{
    "users": {
        "markt": {
            "display": "Mark",
            "pass": "123"
        },
        "Richard": {
            "display": "Attack69",
            "pass": "Smith"
        },
        "User1": {
            "display": "User1",
            "pass": "EzPass123"
        }
    }
}

answered Jan 17, 2016 at 20:42

Mark Tolonen

181k26 gold badges182 silver badges278 bronze badges

7 Comments

Richard Smith Over a year ago

Hey, Im making it where it users the username , password = data["users"][user]["pass"]

Richard Smith Over a year ago

when making a new account, i check if there is an account with the name they enter, and if they enter a name not in the database, it breaks, is there a way to fix this?

Richard Smith Over a year ago

is there a way i can set all the names to a variable, example here

Mark Tolonen Over a year ago

@RichardSmith, you should ask a new question showing the additional code checking for an existing user.

Mark Tolonen Over a year ago

data['users'].keys() will give you the names list.

|

Collectives™ on Stack Overflow

How to add to a json file in python

2 Answers 2

11 Comments

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

11 Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related