How to replace user input values in the Get request by using Python

Question

Urls are defined in a single variable and will be used in get request as per the user put, please find code below...

d = {'Mango': 'http://12.345.67.891:8000/api/datasources/proxy/1/query?db=UK_GHS&q=SELECT%20sum(%22count%22)%20FROM%20%22gatling%22%20WHERE%20%22status%22%20%3D%20%27ok%27%20AND%20%22simulation%22%20%3D~%20%2Fsoak-test*%2F%20AND%20time%20%3E%201544491800000ms%20and%20time%20%3C%201544495400000ms%20GROUP%20BY%20%22script%22&epoch=ms',
 'Banana':'http://12.345.67.891:8000/api/datasources/proxy/1/query?db=UK_GHS&q=SELECT%20sum(%22count%22)%20FROM%20%22gatling%22%20WHERE%20%22status%22%20%3D%20%27ok%27%20AND%20%22simulation%22%20%3D~%20%2Fspike-test*%2F%20AND%20time%20%3E%201544491800000ms%20and%20time%20%3C%201544495400000ms%20GROUP%20BY%20%22script%22&epoch=ms',
 'Apple':'http://12.345.67.891:8000/api/datasources/proxy/1/query?db=UK_GHS&q=SELECT%20sum(%22count%22)%20FROM%20%22gatling%22%20WHERE%20%22status%22%20%3D%20%27ok%27%20AND%20%22simulation%22%20%3D~%20%2Fload-test*%2F%20AND%20time%20%3E%201544491800000ms%20and%20time%20%3C%201544495400000ms%20GROUP%20BY%20%22script%22&epoch=ms'}

Dashboard_name = raw_input("Enter dashboard name from the above list :")

if the user enters Mango get request will take 1st URL and if user enters banana get request will take 2nd url and so on

user_input_from = raw_input("Enter from date and time in YYYY-MM-DD HH:MM:SS format :")
user_input_to = raw_input("Enter to date and time in YYYY-MM-DD HH:MM:SS format :")

def user_input_to_epoch_time(user_input):
    return int(time.mktime(time.strptime(user_input, '%Y-%m-%d %H:%M:%S')))

final_url = d.format(user_input_to_epoch_time(user_input_from),
                                  user_input_to_epoch_time(user_input_to))
print(final_url)
results = d.get(Dashboard_name, 'No value in list')
print results

I implemented the code suggested by you, but getting below error as URL is not direct and it is taking as per the user input.

    final_url = d.format(user_input_to_epoch_time(user_input_from),
AttributeError: 'dict' object has no attribute 'format'

you can have a look at How to change values of url query in python? — anky
– anky, Commented Feb 16, 2019 at 11:29
Possible duplicate of How to change values of url query in python? — Constantin Guidon
– Constantin Guidon, Commented Feb 16, 2019 at 12:04

balderman · Accepted Answer · 2019-02-16 18:22:15Z

1

Code below:

import time

SHORT_URL_TEMPLATE_MANGO = 'http://12.345.67.891:8000/api/mango?from={}&to={}'
SHORT_URL_TEMPLATE_APPLE = 'http://12.345.67.891:8000/api/apple?from={}&to={}'

URLS = {'mango': SHORT_URL_TEMPLATE_MANGO, 'apple': 
        SHORT_URL_TEMPLATE_APPLE}


def user_input_to_epoch_time(user_input):
    return int(time.mktime(time.strptime(user_input, '%Y-%m-%d %H:%M:%S')))


dash_board = 'mango'
user_input_from = "2018-10-12 23:12:44"
user_input_to = "2018-10-12 23:17:55"

final_url = URLS[dash_board].format(user_input_to_epoch_time(user_input_from),
                                user_input_to_epoch_time(user_input_to))

print(final_url)

Output:

http://12.345.67.891:8000/api/mango?from=1539375164&to=1539375475

edited Feb 16, 2019 at 18:22

answered Feb 16, 2019 at 11:30

balderman

24k8 gold badges39 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

anky Over a year ago

this doesnot replace the query in the url

SG131712 Over a year ago

Above code help me in convert human time to unix time but how to store taht unix time in a variable and replace that in the get request URL?

balderman Over a year ago

Code was modified and shows how to replace time fields in url

SG131712 Over a year ago

Thanks it worked fine. But in my code URL is defined in different way. I edited the code with more details can you please have a look.

balderman Over a year ago

I am not sure I follow.. All you need to do (as far as I understand) is to modify SHORT_URL_TEMPLATE according to your needs. Is there anything else left? Please explain

|

Collectives™ on Stack Overflow

How to replace user input values in the Get request by using Python

if the user enters Mango get request will take 1st URL and if user enters banana get request will take 2nd url and so on

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

if the user enters Mango get request will take 1st URL and if user enters banana get request will take 2nd url and so on

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related