Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from codecs import utf_8_encode
- from email import charset
- from re import T
- from tkinter import INSERT
- from unittest import result
- from webbrowser import get
- import requests
- import pandas as pd
- import json
- #db connection
- import mysql.connector
- mydb=mysql.connector.connect(host='localhost',
- user='root',
- password='',
- #database ni creare garni code py ma lekhum ki afai database lai shell bata banaum. malai shell auxa so aile try garna tei garamla
- database='commodity'
- )
- #fetch from api
- jsondata = requests.get(
- 'https://r94nq6.deta.dev/kalimati_market')
- jsondata.encoding = jsondata.apparent_encoding
- commodity_data = json.loads(jsondata.content)
- # daily date
- daily_date = list(commodity_data.keys())[0]
- commodities = commodity_data [daily_date]['वस्तु']
- unit = commodity_data [daily_date]['एकाइ']
- Minimum = commodity_data [daily_date]['न्यूनतम']
- Maximum = commodity_data [daily_date]['अधिकतम']
- Average = commodity_data [daily_date]['औसत']
- print(commodities)
- print(unit)
- print(Minimum)
- print(Maximum)
- print(Average)
- #db part
- cur=mydb.cursor() #cursor object to write/read/update
- #Db ma insert garni function
- s="INSERT INTO commo (commodities,unit,Minimum,Maximum,Average) VALUES (%s,%s,%s,%s,%s) "
- #yesma chai yo value should directly be inserted into database ani yesma euta issue auxa hola. Pailako open data api wala ma loop lagako jastai yo value list lai loop hanna pako vaye individual data xuttidai enter hunthyo,idk tapaiko api bata kasari janxa
- for i in range(1, 10):
- value=[(' commodities ',' unit ',' Minimum ',' Maximum ',' Average ')]#this value will be from the jsondata
- #yo chai execute the insert function
- cur.execute(s,value)
- #commit nagaresamma database change hunna
- mydb.commit()
- # i+=1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
