Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

what is the right way connect a database manly. #465

Closed
imfht opened this issue Sep 23, 2019 · 0 comments
Closed

what is the right way connect a database manly. #465

imfht opened this issue Sep 23, 2019 · 0 comments

Comments

@imfht
Copy link
Contributor

imfht commented Sep 23, 2019

What happened

my code is like:

class User(db.Entity):
    id = PrimaryKey(int, auto=True)
   name = Optional(str)
db.bind("pymysql","")
db.generate_mapping()
@db_session
def long_time_task():
     # long long task

if __name__==__main__:
    while True:
        long_time_task()

when long time task run first time. everything is ok.
when it run into third time. pony raise an exception

ony.orm.dbapiprovider.OperationalError: (2013, 'Lost connection to MySQL server during query')

what do I want

I want to catch the exception and reconnect the database. I read the document but only found a discount() method(no connect method.).

Someone help me?
Thanks

kozlovsky added a commit that referenced this issue Oct 23, 2019
# Features

* #472: Python 3.8 support
* Support of hybrid functions (inlining simple Python functions into query)
* #438: support datetime-datetime, datetime-timedelta, datetime+timedelta in queries

# Bugfixes

* #430: add ON DELETE CASCADE for many-to-many relationships
* #465: Should reconnect to MySQL on OperationalError 2013 'Lost connection to MySQL server during query'
* #468: Tuple-value comparisons generate incorrect queries
* #470 fix PendingDeprecationWarning of imp module
* Fix incorrect unpickling of objects with Json attributes
* Check value of discriminator column on object creation if set explicitly
* Correctly handle Flask current_user proxy when adding new items to collections
* Some bugs in syntax of aggregated queries were fixed
* Fix syntax of bulk delete queries
* Bulk delete queries should clear query results cache so next select will get correct result from the database
* Fix error message when hybrid method is too complex to decompile
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant