Python script to list tables those doesn't have primary key constraint in all postgres databases
$30-250 USD
Πληρώθηκε κατά την παράδοση
I have around 200 postgres databases in aws rds across all accounts. I have two metadata tables which has connection info and credentials info.
Tasks:
1. Need to use these two tables to make a connection string to connect every database.
2. loop over every database, connect and list tables those doesn't have primary key. If a table doesn't have primary key, get estimated number of rows from table statistics.
3. have the script create a table in local database with columns like account,region,inst_id,schema,table,estimated_rows.
4. store the results from step 2 in step 3 table.
Ταυτότητα Εργασίας: #26817264
Σχετικά με την εργασία
Ανατέθηκε στον:
I have rich experience designing database schema and Python programming. I can create write script to connect to databases an d check for primary key constraints as per given requirements. Please ping me to start with.
6 freelancers κάνουν προσφορές κατά μέσο όρο $138 για αυτή τη δουλειά
hello, I am a full-stack web developer. I have a lot of experience in CSS, Javascript, jQuery, HTML5, Joomla, Prestashop, Opencart, Drupal, Magento, React.js, React Native, mobile development ect. I also have huge ex Περισσότερα
Hope you are doing well.. An interesting task. This can be done through AWS Lambda function that executes your query against your backend database. The API Gateway REST API that invokes the Lambda function when you ac Περισσότερα