python: Reading and Writing JSON to a File

 

python.exe -m pip install --upgrade pip

pip install pymssql

pip install pymysql
pip install pyodbc

pip install SQLAlchemy

pip install xlrd
pip install xlwt
pip install xlutils
pip install xlwings
pip install XlsxWriter
pip install openpyxl
pip install pandas
pip install pandasql

pip install win32com

pip install pyspark

    #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))

　　

JSON encoder and decoder

Serialize and Deserialize