Use IF condition in Python to Import Data from SQL Table (or Import Data from SQL table only when condition satisfies in Python)

Question

I have a condition to check in Python. If the condition satisfies, only then I have to go ahead and extract data from a table in my SQL database.

The below code is working perfectly and giving me the extracted data from the SQL database.

import mysql.connector
conn = mysql.connector.connect(user='XXXXXXX', 
            password='XXXXXXX',host='XXXXXXX',database='XXXXXXX')
cursor = conn.cursor()
cursor.execute("SELECT * FROM table where table.column = 'abc')
result = cursor.fetchall()
print (result)
conn.close()

Now, I am trying to use an IF Condition before fetching data from SQL database. But this gives me syntax error.

Please find a sample of what I am trying as mentioned below:

if(x == 'True'):
    (import mysql.connector
     conn = mysql.connector.connect(user='XXXXXXX', 
            password='XXXXXXX',host='XXXXXXX',database='XXXXXXX')
     cursor = conn.cursor()
     cursor.execute("SELECT * FROM table where table.column = 'abc')
     result = cursor.fetchall()
     print (result)
     conn.close())
else:
    print("X is false, cannot execute")

Please help how can I execute only with a condition satisfied.

Try removing the bracket before the import keyword

user17083192
– user17083192

2021-10-22 07:32:38 +00:00
Commented Oct 22, 2021 at 7:32 — user17083192
– user17083192, Commented Oct 22, 2021 at 7:32

Pav3k · Accepted Answer · 2021-10-22 07:43:01Z

1

You should remove parenthesis in if block. Such a parenthesis you should use only when you call methods in chain, for example:

mysql.connector.connect(user='XXXXXXX', password='XXXXXXX',host='XXXXXXX',database='XXXXXXX')

(
    mysql.
    connector.
    connect(user='XXXXXXX', password='XXXXXXX',host='XXXXXXX',database='XXXXXXX')
)

If x condition returns Boolean output True/False, enough is:

if x:
    ....
else:
    ....

If x condition returns Boolean output True/False, True is not equal 'True':

True == 'True'

# output
False

answered Oct 22, 2021 at 7:43

Pav3k

9196 silver badges11 bronze badges

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

1 Comment

shweta_developer Over a year ago

Thank you. Removing the <brackets> worked. Also, there was indentation to be done post <brackets> removal. Code is working now.

Collectives™ on Stack Overflow

Use IF condition in Python to Import Data from SQL Table (or Import Data from SQL table only when condition satisfies in Python)

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