<div dir="ltr"><div class="gmail_default" style="font-family:trebuchet ms,sans-serif;color:rgb(61,133,198)">I agree, it is better to use the context manager provided.<br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Dec 11, 2014 at 5:06 AM, Alexander Kozlovsky <span dir="ltr"><<a href="mailto:alexander.kozlovsky@gmail.com" target="_blank">alexander.kozlovsky@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div>Hi Arthur!<br><br></div><div>For what purpose do you want to use `disconnect` method? I'm not sure I correctly understand what example you want to see, but the simplest example of `disconnect` method is this:<br></div><div><br></div> from pony.orm import *<br><br> db = Database('mysql', host="myhost", user="me", passwd="123", db="mydb")<br><br> class Person(db.Entity):<br> name = Required(str)<br><br> db.generate_mapping(create_tables=True)<br><br> with db_session:<br> p1 = Person(name='John')<br><br> db.disconnect()<br><br></div><br>The disconnect method works for current thread only. It releases connection to the server which db object holds in its connection pool.<br><div><br></div><div>This method should be called outside of any db session.<br></div><div><br></div><div>If you application is multi-threaded and you want to disconnect your db object from the database, the you need to call `disconnect` method from each thread in which you have worked with the entities of this db object.<br></div><div><br><br></div><div>Regards,<br></div><div>Alexander Kozlovsky<br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="h5">On Wed, Dec 10, 2014 at 5:39 AM, Goldberg, Arthur P <span dir="ltr"><<a href="mailto:arthur.p.goldberg@mssm.edu" target="_blank">arthur.p.goldberg@mssm.edu</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"> <div style="word-wrap:break-word"> Hi Guys <div><br> </div> <div>Could you please show an example with disconnect()? I'm using a couple of dbmses in one SQL server, and getting </div> <div> <div>Database object was already bound to MySQL provider</div> <div>Sorry, I'm too rushed to debug carefully.</div> <div><br> </div> <div>Yhanks</div> <div>A</div> <div><br> </div> <div><br> <div> <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word"> <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word"> <div style="color:rgb(0,0,0);font-family:Helvetica;font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word"> <span style="border-collapse:separate;border-spacing:0px"> <div style="word-wrap:break-word"> <span style="border-collapse:separate;color:rgb(0,0,0);font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;border-spacing:0px;font-size:medium"> <div style="word-wrap:break-word"> <span style="text-align:-webkit-auto;text-indent:0px"> <div style="word-wrap:break-word"> <span style="text-align:-webkit-auto;text-indent:0px"> <div style="word-wrap:break-word"> <span style="text-align:-webkit-auto;text-indent:0px"> <div style="word-wrap:break-word"> <span style="text-align:-webkit-auto;text-indent:0px"> <div style="word-wrap:break-word"> <span style="text-align:-webkit-auto;text-indent:0px"> <div style="word-wrap:break-word"> <div style="word-wrap:break-word"> <div style="border-collapse:separate;color:rgb(0,0,0);font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;border-spacing:0px;font-size:medium"> <div style="border-collapse:separate;color:rgb(0,0,0);font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;border-spacing:0px;font-size:medium"> ---</div> <div> </div> <div>Arthur Goldberg <div style="border-collapse:separate;color:rgb(0,0,0);font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;border-spacing:0px;font-size:medium"> Associate Professor of Psychiatry</div> <div>Seaver Autism Center and Icahn Institute for Genomics & Multiscale Biology</div> <div>Icahn School of Medicine at Mount Sinai</div> <div style="border-collapse:separate;color:rgb(0,0,0);font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;border-spacing:0px;font-size:medium"> Seaver Center, Room ABE-33</div> <div style="border-collapse:separate;color:rgb(0,0,0);font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;border-spacing:0px;font-size:medium"> 212-241-4229<br> <a href="mailto:Arthur.Goldberg@mssm.edu" target="_blank">Arthur.Goldberg@mssm.edu</a></div> </div> </div> <div>Follow us on Twitter <a href="https://twitter.com/IcahnInstitute" target="_blank">@IcahnInstitute</a></div> <div style="border-collapse:separate;color:rgb(0,0,0);font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-transform:none;white-space:normal;word-spacing:0px;border-spacing:0px;font-size:medium"> <br> </div> </div> </div> </span></div> </span></div> </span></div> </span></div> </span></div> </span></div> </span></div> </div> </div> <br> <br> </div> <br> </div> </div> </div> <br></div></div>_______________________________________________<br> ponyorm-list mailing list<br> <a href="mailto:ponyorm-list@ponyorm.org" target="_blank">ponyorm-list@ponyorm.org</a><br> <a href="/ponyorm-list" target="_blank">/ponyorm-list</a><br> <br></blockquote></div><br></div> <br>_______________________________________________<br> ponyorm-list mailing list<br> <a href="mailto:ponyorm-list@ponyorm.org">ponyorm-list@ponyorm.org</a><br> <a href="/ponyorm-list" target="_blank">/ponyorm-list</a><br> <br></blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature"><div dir="ltr"><div><font size="4" face="trebuchet ms, sans-serif" color="#6fa8dc">Kind Regards,</font></div><div><img src="https://brnbcg.blu.livefilestore.com/y1mIyqRuYWMVkEp1XgqnpPJw31rRYoNvXRcLpo1WOUfIx-d9b0krZq2EJ4vUjOgoHcfZow1IZifvV3JxEuWl7yinOPYSMwlrPk7rFfWQ7RMTlkgQ9uTAq0uNQ/Signature1.png?psid=1" width="96" height="69"><br></div><div></div><div><span style="font-family:'trebuchet ms',sans-serif;font-size:large"><font color="#6fa8dc">Quazi Nafiul Islam</font></span></div></div></div> </div>