############################################################################## # # Zope Public License (ZPL) Version 1.0 # ------------------------------------- # # Copyright (c) Digital Creations. All rights reserved. # Copyright (c) Nexedi SARL 2004. All rights reserved. # # This license has been certified as Open Source(tm). # # Redistribution and use in source and binary forms, with or without # modification, are permitted provided that the following conditions are # met: # # 1. Redistributions in source code must retain the above copyright # notice, this list of conditions, and the following disclaimer. # # 2. Redistributions in binary form must reproduce the above copyright # notice, this list of conditions, and the following disclaimer in # the documentation and/or other materials provided with the # distribution. # # 3. Digital Creations requests that attribution be given to Zope # in any manner possible. Zope includes a "Powered by Zope" # button that is installed by default. While it is not a license # violation to remove this button, it is requested that the # attribution remain. A significant investment has been put # into Zope, and this effort will continue if the Zope community # continues to grow. This is one way to assure that growth. # # 4. All advertising materials and documentation mentioning # features derived from or use of this software must display # the following acknowledgement: # # "This product includes software developed by Digital Creations # for use in the Z Object Publishing Environment # (http://www.zope.org/)." # # In the event that the product being advertised includes an # intact Zope distribution (with copyright and license included) # then this clause is waived. # # 5. Names associated with Zope or Digital Creations must not be used to # endorse or promote products derived from this software without # prior written permission from Digital Creations. # # 6. Modified redistributions of any form whatsoever must retain # the following acknowledgment: # # "This product includes software developed by Digital Creations # for use in the Z Object Publishing Environment # (http://www.zope.org/)." # # Intact (re-)distributions of any official Zope release do not # require an external acknowledgement. # # 7. Modifications are encouraged but must be packaged separately as # patches to official Zope releases. Distributions that do not # clearly separate the patches from the original work must be clearly # labeled as unofficial distributions. Modifications which do not # carry the name Zope may be packaged in any form, as long as they # conform to all of the clauses above. # # # Disclaimer # # THIS SOFTWARE IS PROVIDED BY DIGITAL CREATIONS ``AS IS'' AND ANY # EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE # IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR # PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL DIGITAL CREATIONS OR ITS # CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, # SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT # LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF # USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND # ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, # OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT # OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF # SUCH DAMAGE. # # # This software consists of contributions made by Digital Creations and # many individuals on behalf of Digital Creations. Specific # attributions are listed in the accompanying credits file. # ############################################################################## database_type='MySQL' import os from db import ThreadedDeferredDB import Shared.DC.ZRDB.Connection, sys, DABase from App.Dialogs import MessageDialog from App.special_dtml import HTMLFile from App.ImageFile import ImageFile from ExtensionClass import Base from DateTime import DateTime from thread import allocate_lock manage_addZMySQLDeferredConnectionForm=HTMLFile('deferredConnectionAdd',globals()) def manage_addZMySQLDeferredConnection(self, id, title, connection_string, check=None, REQUEST=None): """Add a DB connection to a folder""" self._setObject(id, DeferredConnection(id, title, connection_string, check)) if REQUEST is not None: return self.manage_main(self,REQUEST) # Connection Pool for connections to MySQL. database_connection_pool_lock = allocate_lock() database_connection_pool = {} class DeferredConnection(DABase.Connection): """ Experimental MySQL DA which implements deferred SQL code execution to reduce locking issues """ database_type=database_type id='%s_database_connection' % database_type meta_type=title='Z %s Deferred Database Connection' % database_type icon='misc_/Z%sDDA/conn' % database_type manage_properties=HTMLFile('connectionEdit', globals()) def factory(self): return ThreadedDeferredDB def connect(self, s): try: database_connection_pool_lock.acquire() self._v_connected = '' pool_key = self.getPhysicalPath() connection = database_connection_pool.get(pool_key) if connection is not None and connection._connection == s: self._v_database_connection = connection else: if connection is not None: connection.closeConnection() ThreadedDeferredDB = self.factory() database_connection_pool[pool_key] = ThreadedDeferredDB(s) self._v_database_connection = database_connection_pool[pool_key] # XXX If date is used as such, it can be wrong because an existing # connection may be reused. But this is suposedly only used as a # marker to know if connection was successfull. self._v_connected = DateTime() finally: database_connection_pool_lock.release() return self def sql_quote__(self, v, escapes={}): return self._v_database_connection.string_literal(v) classes=('DA.DeferredConnection') meta_types=( {'name':'Z %s Deferred Database Connection' % database_type, 'action':'manage_addZ%sDeferredConnectionForm' % database_type, }, ) folder_methods={ 'manage_addZMySQLDeferredConnection': manage_addZMySQLDeferredConnection, 'manage_addZMySQLDeferredConnectionForm': manage_addZMySQLDeferredConnectionForm, } __ac_permissions__=( ('Add Z MySQL Database Connections', ('manage_addZMySQLDeferredConnectionForm', 'manage_addZMySQLDeferredConnection')), ) misc_={'conn': ImageFile( os.path.join('Shared','DC','ZRDB','www','DBAdapterFolder_icon.gif'))} for icon in ('table', 'view', 'stable', 'what', 'field', 'text','bin','int','float', 'date','time','datetime'): misc_[icon]=ImageFile(os.path.join('icons','%s.gif') % icon, globals())