1) Change an existing Python script to connect to a different database (from SQLite to MySQL). The Python script is available here: [url removed, login to view]
and it currently uses the SQLAlquemy library to connect to a SQLite database.
So, I guess all that is needed is to change the SQLAlquemy database driver config from SQLite to MySQL.
2) Add a script that, every X hours, runs one of the already available templated queries:
The existing code is already executing this query when the Fetch button is pressed by the user. This query will return the last 25 members (1 page) which have been added to the group. Typically, out of those 25, the top 10 or 12 members will be new to us(ie we didnt get them in the last query we run X hours ago). The rest of the members, we already have in our GROUP_MEMBERS table.
If all of the 25 members returned by the query are new to us, then the script will run the query again to get the next 25 members and so on.
So, the input parameters into the script are:
a) the list of groups
b) X = number of hours
Looking to make some money?
- Set your budget and the time frame
- Outline your proposal
- Get paid for your work
Bids on this Project
Perfection and dedication are the way we deal with projects on freelancer. There have been many clients all over the world that are satisfied with the solutions provided.All types of automation works along with web based solutions are our expertise. Looking to provide solutions in the Mobile markets as well. Some of the automation tools are listed in portfolio and here as well: * AutoBidder tool for Madbid like sites * Automation tools For all emails and social Bookmark sites * Social Bookmarking tools * Facebook Likes Automation * Webbased Versions of tools tailored to custom needs * Desktop apps tailored to customer needs * Proxy tools tailored to your requirements. A dedicated team that can literally deliver any project solution with high expertise. Please don't hesitate to contact us via freelancer. Satisfaction guaranteed solutions delivered all over the world. The Skill Set ranges from C# to PHP, Iphone to Andriod. We can deliver almost any solutions for your needs. We can also take up any type of work based on web design to desktop or mobile in the broad spectrum as we always strive to learn and perfect.
www.smartdba.in Installation, configuration and upgrading of Microsoft SQL Server/MySQL/Oracle server software and related products. Evaluate MSSQL/MySQL/Oracle features and MSSQL/MySQL/Oracle related products. Establish and maintain sound backup and recovery policies and procedures. Take care of the Database design and implementation. Implement and maintain database security (create and maintain users and roles, assign privileges). Database tuning and performance monitoring. Application tuning and performance monitoring.
[+] Web Developer [ PHP, MySQL, html/css/bootstrap/JS/ajax , Laravel ] . [+] Web app Pent-Tester ... listed on (Facebook - Microsoft) hall of fame .