def getPropertyInfo(self, url, infos):
try:
msg = getMessage(self.ctx, g_message, 131, url)
logMessage(self.ctx, INFO, msg, 'Driver', 'getPropertyInfo()')
for info in infos:
msg = getMessage(self.ctx, g_message, 132,
(info.Name, info.Value))
logMessage(self.ctx, INFO, msg, 'Driver', 'getPropertyInfo()')
drvinfo = []
dbinfo = getDataBaseInfo()
for info in dbinfo:
drvinfo.append(self._getDriverPropertyInfo(info, dbinfo[info]))
for info in infos:
if info.Name not in dbinfo:
drvinfo.append(
self._getDriverPropertyInfo(info.Name, info.Value))
for info in drvinfo:
msg = getMessage(self.ctx, g_message, 133,
(info.Name, info.Value))
logMessage(self.ctx, INFO, msg, 'Driver', 'getPropertyInfo()')
return tuple(drvinfo)
except Exception as e:
msg = getMessage(self.ctx, g_message, 134,
(e, traceback.print_exc()))
logMessage(self.ctx, SEVERE, msg, 'Driver', 'getPropertyInfo()')
def _logInfo(self, dialog):
version = ' '.join(sys.version.split())
msg = getMessage(self.ctx, g_message, 121, version)
logMessage(self.ctx, INFO, msg, "OptionsDialog", "_logInfo()")
path = os.pathsep.join(sys.path)
msg = getMessage(self.ctx, g_message, 122, path)
logMessage(self.ctx, INFO, msg, "OptionsDialog", "_logInfo()")
url = getLoggerUrl(self.ctx)
self._setDialogText(dialog, url)
def __init__(self, ctx):
self.ctx = ctx
self._index = 0
self.stringResource = getStringResource(self.ctx, g_identifier,
g_extension, 'OptionsDialog')
msg = getMessage(self.ctx, g_message, 101)
logMessage(self.ctx, INFO, msg, 'OptionsDialog', '__init__()')
def connect(self, url, infos):
try:
transformer = getUrlTransformer(self.ctx)
location = self._getUrl(transformer, infos)
if location is None:
code = getMessage(self.ctx, g_message, 111)
msg = getMessage(self.ctx, g_message, 112,
(url, self._getInfo(infos)))
raise self._getException(code, 1001, msg, self)
msg = getMessage(self.ctx, g_message, 113, location.Main)
logMessage(self.ctx, INFO, msg, 'Driver', 'connect()')
name = self._getDataSourceName(location)
sf = getSimpleFile(self.ctx)
split = self._getSplitUrl(transformer, location, name)
if not sf.isFolder(split):
if sf.exists(split):
code = getMessage(self.ctx, g_message, 114)
msg = getMessage(self.ctx, g_message, 115, split)
raise self._getException(code, 1002, msg, self)
self._splitDataBase(transformer, sf, location, split, name)
datasource = self._getDataSource(transformer, location, name)
connection = Connection(self.ctx, datasource, url, self._user,
self._password, None, True)
version = connection.getMetaData().getDriverVersion()
msg = getMessage(self.ctx, g_message, 116, (version, self._user))
logMessage(self.ctx, INFO, msg, 'Driver', 'connect()')
return connection
except SQLException as e:
raise e
except Exception as e:
msg = getMessage(self.ctx, g_message, 117,
(e, traceback.print_exc()))
logMessage(self.ctx, SEVERE, msg, 'Driver', 'connect()')
def __init__(self, ctx):
self.ctx = ctx
self._supportedProtocol = 'sdbc:embedded:hsqldb'
self._dbdir = 'database'
self._dbfiles = ('script', 'properties', 'data', 'backup', 'log')
self._user = '******'
self._password = ''
msg = getMessage(self.ctx, g_message, 101)
logMessage(self.ctx, INFO, msg, 'Driver', '__init__()')
def _getDriverVersion(self):
try:
service = '%s.Driver' % g_identifier
driver = createService(self.ctx, service)
url = 'sdbc:embedded:hsqldb'
infos = getPropertyValueSet({'URL': self._getUrl()})
connection = driver.connect(url, infos)
version = connection.getMetaData().getDriverVersion()
connection.close()
return version
except UnoException as e:
msg = getMessage(self.ctx, g_message, 141, e.Message)
logMessage(self.ctx, SEVERE, msg, 'OptionsDialog',
'_getDriverVersion()')
except Exception as e:
msg = getMessage(self.ctx, g_message, 142,
(e, traceback.print_exc()))
logMessage(self.ctx, SEVERE, msg, 'OptionsDialog',
'_getDriverVersion()')
def _reloadVersion(self, dialog):
msg = getMessage(self.ctx, g_message, 131)
dialog.getControl('Label3').Text = msg
def _clearLog(self, dialog):
clearLogger()
msg = getMessage(self.ctx, g_message, 111)
logMessage(self.ctx, INFO, msg, 'OptionsDialog', '_clearLog()')
url = getLoggerUrl(self.ctx)
self._setDialogText(dialog, url)
def dropCatalog(self, name, info):
msg = getMessage(self.ctx, g_message, 171, name)
logMessage(self.ctx, INFO, msg, 'Driver', 'dropCatalog()')
def createCatalog(self, info):
msg = getMessage(self.ctx, g_message, 161)
logMessage(self.ctx, INFO, msg, 'Driver', 'createCatalog()')
def getDataDefinitionByURL(self, url, infos):
msg = getMessage(self.ctx, g_message, 151, url)
logMessage(self.ctx, INFO, msg, 'Driver', 'getDataDefinitionByURL()')
connection = self.connect(url, infos)
return self.getDataDefinitionByConnection(connection)
def getDataDefinitionByConnection(self, connection):
msg = getMessage(self.ctx, g_message, 141)
logMessage(self.ctx, INFO, msg, 'Driver',
'getDataDefinitionByConnection()')
return connection
def acceptsURL(self, url):
accept = url.startswith(self._supportedProtocol)
msg = getMessage(self.ctx, g_message, 121, (url, accept))
logMessage(self.ctx, INFO, msg, 'Driver', 'acceptsURL()')
return accept
