Das deutsche Python-Forum

Code: Alles auswählen

# Call the Sheets API
    sheet = service.spreadsheets()
    result = sheet.values().get(spreadsheetId=SAMPLE_SPREADSHEET_ID,
                                range=SAMPLE_RANGE_NAME).execute()
    values = result.get('values', [])
    print('values: ', values)
    user_agent = {'User-agent': 'Mozilla/5.0'}
    prices=[]
    proxy_host = "proxy.zyte.com"
    proxy_port = "8011"
    proxy_auth = "db4255942ad341c78efcfef838239084:" # Make sure to include ':' at the end
    proxies = {"https": "http://{}@{}:{}/".format(proxy_auth, proxy_host, proxy_port),
               "http": "http://{}@{}:{}/".format(proxy_auth, proxy_host, proxy_port)}
    r=requests.Session()
    r.proxies = proxies
    for i in values:
        if i != []:
            page=None
            try:
                page = r.get('https://www.futbin.com/22/playerPrices?player=' + i[0], verify='zyte-smartproxy-ca.crt')
                print('page response: ', page.reason)
                data=json.loads(page.content)
                print(data)
                psLcPrice = data[i[0]]['prices']['ps']['LCPrice']
                xboxLcPrice = data[i[0]]['prices']['xbox']['LCPrice']
                psMinPrice = data[i[0]]['prices']['ps']['MinPrice']
                psMaxPrice = data[i[0]]['prices']['ps']['MaxPrice']
                xboxMinPrice = data[i[0]]['prices']['xbox']['MinPrice']
                xboxMaxPrice = data[i[0]]['prices']['xbox']['MaxPrice']
                prices.append([psLcPrice.replace(',', ''), xboxLcPrice.replace(',', ''), psMinPrice.replace(',', ''), psMaxPrice.replace(',', ''), xboxMinPrice.replace(',', ''), xboxMaxPrice.replace(',', '')])
            except:
                print('page error: ')
                prices.append('None')
        else:
            prices.append([])
    print('Successfully got all Prices!')
    modified = sheet.values().update(spreadsheetId=SAMPLE_SPREADSHEET_ID, valueInputOption="RAW" ,range="Python!E3", body={'values':prices}).execute()

getPlayerPrices()

Code: Alles auswählen

#!/usr/bin/env python3
import logging
import math
from collections import namedtuple
...

LOGGER = logging.getLogger(__name__)

PROXY_HOST = "proxy.zyte.com"
PROXY_PORT = 8011
#
# Make sure to include ':' at the end.
#
PROXY_AUTH = "db4255942ad341c78efcfef838239084:"

...

Price = namedtuple("Price", "lc min max")


def get_price(name_to_value):
    return Price(
        *(
            float(name_to_value[name].replace(",", "."))
            for name in ["LCPrice", "MinPrice", "MaxPrice"]
        )
    )

...

def some_function():
    ...

    sheet = service.spreadsheets()
    values = (
        sheet.values()
        .get(spreadsheetId=SAMPLE_SPREADSHEET_ID, range=SAMPLE_RANGE_NAME)
        .execute()
    ).get("values", [])
    LOGGER.info("values: %s", values)

    session = requests.Session()
    session.proxies = {
        "https": f"http://{PROXY_AUTH}@{PROXY_HOST}:{PROXY_PORT}/",
        "http": f"http://{PROXY_AUTH}@{PROXY_HOST}:{PROXY_PORT}/",
    }
    session.verify = "zyte-smartproxy-ca.crt"
    prices = []
    #
    # TODO `items` and `item` need better names.
    #
    for items in values:
        if items:
            item = items[0]
            try:
                response = session.get(
                    "https://www.futbin.com/22/playerPrices",
                    params={"player": item},
                )
                LOGGER.info("response reason: %s", response.reason)
                data = response.json()
                LOGGER.info("%r", data)
                prices_data = data[item]["prices"]
                ps_price = get_price(prices_data["ps"])
                xbox_price = get_price(prices_data["xbox"])
                prices.append(
                    [
                        ps_price.lc,
                        xbox_price.lc,
                        ps_price.min,
                        ps_price.max,
                        xbox_price.min,
                        xbox_price.max,
                    ]
                )
            except:
                LOGGER.exception("response error")
                #
                # TODO Maybe do something different here?
                #
                prices.append([])
        else:
            prices.append([])
    LOGGER.info("Successfully got all Prices!")

    modified = (
        sheet.values()
        .update(
            spreadsheetId=SAMPLE_SPREADSHEET_ID,
            valueInputOption="RAW",
            range="Python!E3",
            body={"values": prices},
        )
        .execute()
    )
    
    ...