Completed

Python Script to Monitor Database Tables

I need a Python script that will connect to 2 or 3 databases to do the following:

Task 1

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:

table_name date_column

tabe1 created_ts

table2 created_ts

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.

Task 2

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.

Skills: Linux, MySQL, PostgreSQL, Python

See more: zbxora, mysql database change notification java, run sqlplus script from python, pyora zabbix, mysql trigger python script, zabbix oracle template, python mysql trigger, python scripts for oracle dba, I need a script written that i can run on, I need a script written that i can run on a wind, I need a script written that i can run on a windows PC to rename 30,000 images from its existing name to another. -- 2, his is a simple project. I just need some database tables designe, I need help with a python script, i need python script, i need python shell, do i need python 2 2 1 on my computer, I need some Graphic design 2, i need some graphic design -- 2, i need python programmer, i need five articles in 2 days

About the Employer:
( 33 reviews ) Berlin, Germany

Project ID: #16194431

Awarded to:

lkhelladi

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.

€277 EUR in 2 days
(126 Reviews)
6.9

41 freelancers are bidding on average €373 for this job

€555 EUR in 10 days
(51 Reviews)
7.2
zhangyingtai

Hello sir I am a python developer with 8 years of professional experience. I got what you want from job description and am confident with this job. I am ready to start the work right now and deliver the result in 3 More

€250 EUR in 3 days
(76 Reviews)
7.2
ThanassisKalv

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

€250 EUR in 3 days
(100 Reviews)
6.0
exansoft

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.

€250 EUR in 2 days
(34 Reviews)
5.8
sstevan

Hello, I would like to make a demo script for you. If it works as it should you can award me for the project. In order to make it properly please share with me SQL dump (does not have to be large) so I can validat More

€300 EUR in 5 days
(14 Reviews)
5.8
stanislav103

Having experience of python, I can do what you want. Python is my primary programming language. Let us discuss details in chat.

€400 EUR in 5 days
(30 Reviews)
5.3
moeed10

Hi, I am an experienced python developer. I have been using python to develop business application of medium to large size for the past 4 years. I have experience with all the major databases (mysql, postgres, mssql, More

€500 EUR in 2 days
(9 Reviews)
5.5
technoweb7

A proposal has not yet been provided

€608 EUR in 10 days
(1 Review)
4.9
€555 EUR in 10 days
(36 Reviews)
5.4
filalizakariae

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

€500 EUR in 5 days
(11 Reviews)
5.0
urstealth

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

€250 EUR in 2 days
(30 Reviews)
4.7
cracken

I am well equip to this kind of task, can handle it pretty well. Let me know the best of your time so we can discuss further based on your requirements.

€748 EUR in 8 days
(23 Reviews)
4.9
novepi

Hi there, Your requirement is quite clear and straightforward to implement. A simple export of database schemas is all I need to start. I'm planning to use py2.7 branch along with smtptlib for email and appropriate More

€250 EUR in 2 days
(23 Reviews)
4.7
srajbr

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

€250 EUR in 3 days
(19 Reviews)
4.7
spikalev

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

€555 EUR in 5 days
(10 Reviews)
4.7
zkutch

Hello More 20 years programming experience. I need more details to set real price and time. Regards.

€250 EUR in 10 days
(22 Reviews)
4.8
khannanav

We are a team of experts with more than 8 years of rich experience in Machine Learning. We have developed recommendation/statistical engines, web scrapers/crawlers, web apps, analytical dashboards etc for our clients a More

€555 EUR in 10 days
(8 Reviews)
4.0
michaelwasher

English is my first language. I have experience in Python with accessing both SQL and non-SQL databases, also I have experience with programmatically sending email and syslog (systemd) logging. I have a Bachelors More

€577 EUR in 10 days
(2 Reviews)
3.7
ersagar

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....

€370 EUR in 3 days
(7 Reviews)
3.4
softtronicstech

I would be able to help you on this. I will make one python script which will reside in the local system, it will connect to DB1 and DB2 remotely and will send you a mail or even sms if needed. Let me know if you More

€250 EUR in 10 days
(7 Reviews)
3.7