I have a python program that currently get information from a table in a MySql database and then allows the user to edit the information and it's saved back into the table. I would like someone to create a script that will go out to a website, fill in the appropriate fields, submit, and then return the correct results from the website and commit the information to the table. I want to add a button to my current script so that the users can continue to manually edit the table or do it automatically.
Once you get the appropriate information entered into the website it will return some information, I will need the program to go back to two selections prior to the selection that comes back and get those plus the current selection and then the information from the next five. The table will have numerous (up to nine) arrays that will need to be filled with this information.
I will need the script to open a website([url removed, login to view]) enter the username and password, either enter information or select information from drop down boxes, submit the information. What will be returned is a list of unexpired interest rates and another number associated with the interest rate. For Example, it might say 5.125% 0.375. I then need your program to go back and get the interest rate and corresponding information for 4.875% through 5.75%, take all the information and enter it into the table and then commit that information(the script is currently getting the information from a table, having the user update it, then selecting a commit button to update the table) Each table has a different number of arrays(up to nine), which will all need to be updated.
There will also need to be some programs that are returned that are excluded, and always exclude any that are "expired". If no values are returned, just return 9 with the corresponding interest rate currently in the array.