demo_api_test.py

import sqlite3, os

from dotenv import load_dotenv
from playwright.sync_api import Playwright, expect

load_dotenv()
API_KEY = os.getenv("API_KEY")

def test_api_get_req(playwright: Playwright):
    api_request_context = playwright.request.new_context(
        base_url="https://api.openweathermap.org"
    )

    # yield api_request_context

    response = api_request_context.get("/data/2.5/weather",
        params={
            "q": "London",
            "appid": API_KEY,
            "units": "metric"
        }
    )

    assert response.ok
    data = response.json()

    # assert data["name"] == "London"
    # assert isinstance(data["main"]["temp"], (int, float))

    temp = data["main"]["temp"]
    city = data["name"]

    db_path = os.path.join(os.getcwd(), "Database", "demo.db")
    conn = sqlite3.connect(db_path)
    curr = conn.cursor()
    curr.execute("CREATE TABLE IF NOT EXISTS weather_info (city TEXT, temp REAL)")

    curr.execute("INSERT INTO weather_info VALUES (?, ?)", (city, temp))

    conn.commit()
    conn.close()


    # teardown
    api_request_context.dispose()