is there a pythonic way to try something up to a maximum number of times?

by

How about:

conn = MySQLdb.connect(host, user, password, database)
cursor = conn.cursor()
attempts = 0

while attempts < 3:
    try:
        cursor.execute(query)
        rows = cursor.fetchall()
        for row in rows:
            # do something with the data
        break
    except MySQLdb.Error, e:
        attempts += 1
        print "MySQL Error %d: %s" % (e.args[0], e.args[1])

More Related Contents:

  1. Catch multiple exceptions in one line (except block)
  2. Is it a good practice to use try-except-else in Python?
  3. Better to ‘try’ something and catch the exception or test if it’s possible first to avoid an exception?
  4. Logging uncaught exceptions in Python
  5. Catching an exception while using a Python ‘with’ statement
  6. Disable assertions in Python
  7. Python “raise from” usage
  8. Python: One Try Multiple Except
  9. In Python, how does one catch warnings as if they were exceptions?
  10. UnicodeEncodeError: ‘ascii’ codec can’t encode character ‘\xe9’ – -when using urlib.request python3
  11. How do I log a Python error with debug information?
  12. Bad idea to catch all exceptions in Python
  13. How to get exception message in Python properly
  14. I want to exception handle ‘list index out of range.’
  15. Handle generator exceptions in its consumer
  16. Mirror individual words in a sentence, but not the sentence itself
  17. pip install from git repo branch
  18. What is a “slug” in Django?
  19. Why does sys.exit() not exit when called inside a thread in Python?
  20. where to put freeze_support() in a Python script?
  21. Duplicate log output when using Python logging module
  22. pip: how to install a git pull request
  23. Error when loading cookies into a Python request session
  24. Equivalent of Bash Backticks in Python [duplicate]
  25. How can I create a tmp file in Python?
  26. Writelines writes lines without newline, Just fills the file
  27. How do comparison operators < and > work with a function as an operand?
  28. Editing the date formatting of x-axis tick labels
  29. Playing note with pygame.midi
  30. Pandas: parse merged header columns from Excel

Leave a Comment