parser.py

import json
import psycopg2
from pprint import pprint


def main():
    sql_insert = """INSERT INTO
                    worldbank_countries(countries)
                    VALUES (%s);"""

    with open('world_bank_countries.json') as data_file:
        data = json.load(data_file)
    conn = None
    cur = None
    try:
        conn = psycopg2.connect(host="localhost", database="postgres", user="postgres", password="myincridiblepasswd")
        cur = conn.cursor()
        for item in data:
            cur.execute(sql_insert, (json.dumps(item),))
    except (Exception, psycopg2.DatabaseError) as error:
        print(error)
    finally:
        
        if conn is not None:
            cur.close()
            conn.commit()
            conn.close()


if __name__ == '__main__':
    main()