I need a Python script that will connect to 2 or 3 databases to do the following:
Connect to Database 1 (localhost) where a list of tables is saved in a table. The table contains the name of tables in other database (database 2) and the name of the column that holds the date of the data entry in this corresponding table in DB2. Example:
The python script should connect to this DB2 and for each table group data by date_column for previous and current date, count number of entries and send email if there is no data for current date or for previous date.
The python script connects to the localhost db where a table holds names of tables in 2 other databases, such as DB1 and DB2. For each table, the script should count records for days prior to today and if it is not an identical match, the script should send a notification/email.
Python script should be written in the best practice of python code with modularity, configuration file that holds all of the user defined variable, logging and error notification.
Your application should include a cost estimate please.
Hello, I'd be glad to develop DB monitoring and processing script for you using Python. looking forward to chat with you soon for more details. Best regards.
41 freelancers are bidding on average €373 for this job
I think this should be a straightforward code to build with Python, the DB manipulation seems clear and also you seem to know what you need! If you're interested let me know and we can start it! Thanassis
Hello I'm interested with your tasks and I'd like to implement it. The project will take me approx up to two hours. Let's discuss it in detail over the chat. Regards, Alex.
Hello I can create a well documented python script following the best practices to do the checks you asked about your databases. I'm ready to start this as soon as possible. Zakariae
hi, What type of database is envolve? mysql? i can do it for 200euros. lets discuss more about the work. thanks Relevant Skills and Experience python, OOPS, mysql
Hello, I can deliver this within 2-3 days. I would like to see some samples from each database. As you will be running locally, will you be using smtp to send emails? Regards, Samiran
Hallo ich bin ein PHP- und python-Entwickler aus Hamburg Es würde mich sehr freuen, wenn wir Ihren Projekt besprechen und evtl dran zusammenarbeiten könnten. VG Sergey
5+ years of exp. in Python and back end tech. Like Linux, PSQL/MYSQL, AWS 3+ years with Django and other front end technologies like CSS3, Bootstrap HTML5....