Python3 Loop Through Array of DBs Then Connect

Question

I am trying to loop through a number of mysql hosts which have the same connection info and execute the same query on each of them & fetch the results.

I'm still learning python & am stuck on the following;

import pymysql

ENDPOINTS=['endpoint01', 'endpoint02', 'endpoint03', 'endpoint04']
USER="SOME_USER"
PASS="SOME_PASSWORD"

print("Testing")

for x in ENDPOINTS:
  # Open database connection
  DATAB = pymysql.connect(x,USER,PASS)
  cursor = DATAB.cursor()
  cursor.execute("show databases like 'THIS%'")
  data = cursor.fetchall()
  print (data)
  DATAB.close()

And this is the error I receive;

DATAB = pymysql.connect(x,USER,PASS)
TypeError: __init__() takes 1 positional argument but 4 were given

I think you need to replace ENDPOINTS with x in the line that's failing. — Ben
– Ben, Commented May 10, 2022 at 19:50
@Ben I tried that (replacing ENDPOINTS wth x in the failing line) & receive the same error. — paulg
– paulg, Commented May 10, 2022 at 19:56

Ben · Accepted Answer · 2022-05-10 20:11:28Z

4

You're passing the parameters incorrectly. Try DATAB = pymysql.connect(host=x,user=USER,password=PASS):

answered May 10, 2022 at 20:11

Ben

411 bronze badge

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python3 Loop Through Array of DBs Then Connect

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related