Oracle adapter

[Angy999]

in the file oracle.py the code

cmd_fix = re.compile("[^']*('[^']*'[^']*)*\:(?P<clob>(C|B)LOB\('([^']+|'')*'\))")

def _initialize_(self, do_connect):
    super(Oracle, self)._initialize_(do_connect)
    ....

not work for me, I believe it must be the following

REGEX_CLOB = re.compile("[^']*('[^']*'[^']*)*\:(?P<clob>(C|B)LOB\('([^']+|'')*'\))")

def _initialize_(self):
    super(Oracle, self)._initialize_()
    ....

thanks

[mdipierro]

I have no way of testing it but if the latter works for you I will change it.

…

On Mon, Jul 19, 2021 at 4:58 AM Angy999 ***@***.***> wrote: in the file oracle.py the code cmd_fix = re.compile("[^']*('[^']*'[^']*)*\:(?P<clob>(C|B)LOB\('([^']+|'')*'\))") def _initialize_(self, do_connect): super(Oracle, self)._initialize_(do_connect) .... not work for me, I believe it must be the following REGEX_CLOB = re.compile("[^']*('[^']*'[^']*)*\:(?P<clob>(C|B)LOB\('([^']+|'')*'\))") def _initialize_(self): super(Oracle, self)._initialize_() .... — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#666>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAHLZTZT2ZEB5ZMMWN37N53TYQHPPANCNFSM5ATRR2HA> .

[Angy999]

OK Massimo, on web2py there is an error and it works with the change.
Comparing old versions I have that the init class has been rewritten

Old class BaseAdapter

def __init__(self, db, uri, pool_size=0, folder=None, db_codec='UTF-8',
             credential_decoder=IDENTITY, driver_args={},
             adapter_args={}, do_connect=True, after_connection=None,
             entity_quoting=False):
    super(BaseAdapter, self).__init__()
    self._load_dependencies()
    self.db = db
    self.uri = uri
    self.pool_size = pool_size
    self.folder = folder
    self.db_codec = db_codec
    self.credential_decoder = credential_decoder
    self.driver_args = driver_args
    self.adapter_args = adapter_args
    self.expand = self._expand
    self._after_connection = after_connection
    self.connection = None
    self.find_driver()
    self._initialize_(do_connect)
    if do_connect:
        self.reconnect()

New class BaseAdapter :

def __init__(
    self,
    db,
    uri,
    pool_size=0,
    folder=None,
    db_codec="UTF-8",
    credential_decoder=IDENTITY,
    driver_args={},
    adapter_args={},
    after_connection=None,
    entity_quoting=False
):
    super(BaseAdapter, self).__init__()
    self._load_dependencies()
    self.db = db
    self.uri = uri
    self.pool_size = pool_size
    self.folder = folder
    self.db_codec = db_codec
    self.credential_decoder = credential_decoder
    self.driver_args = driver_args
    self.adapter_args = adapter_args
    self.expand = self._expand
    self._after_connection = after_connection
    self.set_connection(None)
    self.find_driver()
    self._initialize_()

And now for example I no longer see the option "do_connect = True"

Then in line 51 of the oracle.py file there is the line "
m = re.match (self.REGEX_CLOB, command) "

but it is not defined" self.REGEX_CLOB ",

it should be cmd_fix which I renamed.

However now it works for me and connects to an Oracle Rac 12.0.2

I hope to be proved helpful

ciao

[mdipierro]

Thanks you. This helps a lot. Will fix it as you suggested.

…

On Mon, Jul 19, 2021, 16:35 Angy999 ***@***.***> wrote: OK Massimo, on web2py there is an error and it works with the change. Comparing old versions I have that the init class has been rewritten Old class BaseAdapter def __init__(self, db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=IDENTITY, driver_args={}, adapter_args={}, do_connect=True, after_connection=None, entity_quoting=False): super(BaseAdapter, self).__init__() self._load_dependencies() self.db = db self.uri = uri self.pool_size = pool_size self.folder = folder self.db_codec = db_codec self.credential_decoder = credential_decoder self.driver_args = driver_args self.adapter_args = adapter_args self.expand = self._expand self._after_connection = after_connection self.connection = None self.find_driver() self._initialize_(do_connect) if do_connect: self.reconnect() New class BaseAdapter : def __init__( self, db, uri, pool_size=0, folder=None, db_codec="UTF-8", credential_decoder=IDENTITY, driver_args={}, adapter_args={}, after_connection=None, entity_quoting=False ): super(BaseAdapter, self).__init__() self._load_dependencies() self.db = db self.uri = uri self.pool_size = pool_size self.folder = folder self.db_codec = db_codec self.credential_decoder = credential_decoder self.driver_args = driver_args self.adapter_args = adapter_args self.expand = self._expand self._after_connection = after_connection self.set_connection(None) self.find_driver() self._initialize_() And now for example I no longer see the option "do_connect = True" Then in line 51 of the oracle.py file there is the line " m = re.match (self.REGEX_CLOB, command) " but it is not defined" self.REGEX_CLOB ", it should be cmd_fix which I renamed. However now it works for me and connects to an Oracle Rac 12.0.2 I hope to be proved helpful — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#666 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAHLZTZYCYZRCPUGTQEKRI3TYQZZ7ANCNFSM5ATRR2HA> .

[Angy999]

Thanks