Error Handling (Specifically ProgrammingError handling)

[mattdavis17]

Driver version

redshift_connector==2.0.902

Problem description

Everything is working like expected so this is not a "this is terrible" post. I'm trying to figure out how to handle errors when trying to execute a statement. The statement in question is "CREATE USER ____ WITH PASSWORD ____" where I am connected to a redshift cluster. If the user isn't there, all is great! When the user is there, I need to handle that error. I just can't seem to figure out error handling in that response. I notice that there is a returned class (`<class 'redshift_connector.error.ProgrammingError'>) and this is totally fine. I just want to know how I can handle those errors in a programmatic way. Is there any documentation on this?

[iggarish]

You can do as below:

try:
          with con.cursor() as cursor:
              cursor.execute("drop table if exists t1")
      except redshift_connector.ProgrammingError:
          // Use ProgrammingError and handle the error as per your requirement

You can find more in the "test" folder. Above snippet is from test/integration/test_query.py

Hope this helps.

[Brooke-white]

Hi @mattdavis17 -- thank you for your feedback. I hope iggarish's response above addressed your question. Please let me know if any more information is needed. We will work to add documentation about this topic.

The Python DB-API spec, which redshift_connector abides by, has a section on exception handling you may find useful.

[Brooke-white]

We've added documentation to our readme regarding exceptions in 2.0.903.