Using variables from one .py file in a loop in another .py file

Question

I have a sql_data.py file that looks like this:

TABLE_A = '''Select * from Table_A;'''
TABLE_B = '''Select * from Table_B;'''

I have a main.py file where I want to loop over those variables and print the SQL.

import sql_data

tables = ['TABLE_A', 'TABLE_B']

# this doesn't work, but this is what I am looking for.  Something dynamic like below

for table in tables:
    print(SQL_DATA.[table])

# this works, but it's hard coding in the table name which I don't want

for table in tables:
    print(SQL_DATA.TABLE_A)

Any suggestions?

Yep, sorry. Had typo in code. I did try lowercase. Doesnt work. — JD2775
– JD2775, Commented Feb 24, 2021 at 19:07

Razmik Melikbekyan · Accepted Answer · 2021-02-24 19:08:33Z

1

You should use the variable that you loop (aka, table) and getattr for getting attribute.

for table in tables:
    print(getattr(SQL_DATA, table))

answered Feb 24, 2021 at 19:08

Razmik Melikbekyan

7585 silver badges15 bronze badges

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

1 Comment

JD2775 Over a year ago

Perfect, that worked. I will accept when the timer lets me. Thanks again

Collectives™ on Stack Overflow

Using variables from one .py file in a loop in another .py file

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related