在另一个.py文件的循环中使用一个.py文件中的变量

Question

我有一个sql_data.py文件，看起来像这样:

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

我有一个main.py文件，我想循环遍历这些变量并打印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)

有什么建议吗?

Answer 1

您应该使用您循环的变量(aka,table)和getattr来获取属性。

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