#import json
jsondata = {
'sqlserver': [
{
"server": "DESKTOP-NQK85G5\GEOVIN2008",
"useid": "sa",
"password": "geovindu",
"database": "Student"
}
],
'mysql':[
{
"server": "loacalhost",
"useid": "root",
"password": "geovindu",
"database": "Student"
}
]
}
json_string = json.dumps(jsondata)
print(json_string)
# Using a JSON string
with open('json_data.json', 'w') as outfile:
outfile.write(json_string)
# Directly from dictionary
with open('json_data2.json', 'w') as outfile:
json.dump(json_string, outfile)
with open('json_data.json') as json_file:
readdata = json.load(json_file)
print(type(readdata))
print(readdata['sqlserver'])
dictionary = {
"server": "DESKTOP-NQK85G5\GEOVIN2008",
"useid": "sa",
"password": "geovindu",
"database": "Student"
}
with open("databaseconfig.json", "w") as outfile:
json.dump(dictionary, outfile)
with open('databaseconfig.json', 'r') as openfile:
# Reading from json file
json_object = json.load(openfile)
print(json_object)
print(type(json_object))
Serializes
JSON encoder and decoder