Rest-API-requesting-project/api_requests.py at master · gaspF/Rest-API-requesting-project · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
import requests
from Product import *
import mysql.connector


def get_data():
    """Get data (categories and products from OpenFoodFacts"""
    main_url = "https://fr.openfoodfacts.org/categories.json"
    r = requests.get(main_url)
    categories = r.json()
    category_name = ""
    categorie = Category()
    nbr = 15

    print("Téléchargement de ", nbr, "catégories")

    for c in range(nbr):
        category_name_url = categories["tags"][c]["name"]
        categorie.add(category_name_url)
        print("Téléchargement des produits de la catégorie", category_name_url)

        for page in range(4):
            product_url = categories["tags"][c]["url"] + "/" + str(page + 1) + ".json"
            pr = requests.get(product_url)
            products = pr.json()

            product_name = ""
            product_url = ""
            nutrition_grade = ""
            product_store = ""
            category_name = ""

            product = Products()

            for p in products["products"]:
                if not all(tag in p for tag in ("product_name", "nutrition_grades", "url", "stores")):
                    pass

                else:
                    product_name = p["product_name"]
                    nutrition_grade = p["nutrition_grades"]
                    product_url = p["url"]
                    product_store = p["stores"]
                    category_name = category_name_url

                    product.add(product_name,
                                nutrition_grade,
                                product_url,
                                product_store,
                                category_name,
                                )

            product.cursor_closed()