def initialize(self, scheme, plugin, folder, link):
self.Scheme = scheme
self.Plugin = plugin
self.Folder = folder
self.Link = link
self.SourceURL = getResourceLocation(self.ctx, plugin, scheme)
self.SessionMode = getConnectionMode(self.ctx, self.Host)
def initialize(self, scheme, plugin, folder, link):
#if not user.Request.initializeSession(scheme):
# return False
self.Scheme = scheme
self.Plugin = plugin
self.Folder = folder
self.Link = link
self.SourceURL = getResourceLocation(self.ctx, plugin, scheme)
def _doViewDataBase(self, dialog):
try:
path = getResourceLocation(ctx, g_identifier, 'hsqldb')
url = '%s/%s.odb' % (path, g_scheme)
desktop = self.ctx.ServiceManager.createInstance('com.sun.star.frame.Desktop')
desktop.loadComponentFromURL(url, '_default', 0, ())
#mri = self.ctx.ServiceManager.createInstance('mytools.Mri')
#mri.inspect(connection)
print("PyOptionsDialog._doConnect() 2")
except Exception as e:
print("PyOptionsDialog._doConnect().Error: %s - %s" % (e, traceback.print_exc()))
def _getUrl(self):
path = getResourceLocation(self.ctx, g_identifier, g_path)
url = '%s/dbversion.odb' % path
if not getSimpleFile(self.ctx).exists(url):
service = 'com.sun.star.sdb.DatabaseContext'
datasource = createService(self.ctx, service).createInstance()
datasource.URL = self._getDataSourceUrl(path)
datasource.Settings.JavaDriverClass = g_class
datasource.Settings.JavaDriverClassPath = self._getDataSourceClassPath(
path)
datasource.DatabaseDocument.storeAsURL(url, ())
return url
def getDataSourceUrl(ctx, dbname, plugin, register):
error = None
url = getResourceLocation(ctx, plugin, g_path)
odb = '%s/%s.odb' % (url, dbname)
if not getSimpleFile(ctx).exists(odb):
dbcontext = ctx.ServiceManager.createInstance('com.sun.star.sdb.DatabaseContext')
datasource = createDataSource(dbcontext, url, dbname)
error = _createDataBase(ctx, datasource, url, dbname)
if error is None:
datasource.DatabaseDocument.storeAsURL(odb, ())
if register:
registerDataSource(dbcontext, dbname, odb)
return url, error
def getDataSource(ctx, dbname, plugin, register):
location = getResourceLocation(ctx, plugin, g_path)
url = '%s/%s.odb' % (location, dbname)
dbcontext = createService(ctx, 'com.sun.star.sdb.DatabaseContext')
if getSimpleFile(ctx).exists(url):
odb = dbname if dbcontext.hasByName(dbname) else url
datasource = dbcontext.getByName(odb)
created = False
else:
datasource = createDataSource(dbcontext, location, dbname)
created = True
if register:
registerDataSource(dbcontext, dbname, url)
return datasource, url, created
def _upload(self, dialog):
service = 'com.sun.star.util.PathSubstitution'
ps = createService(self.ctx, service)
path = ps.substituteVariables('$(work)', True)
service = 'com.sun.star.ui.dialogs.FilePicker'
fp = createService(self.ctx, service)
fp.setDisplayDirectory(path)
fp.appendFilter(g_jar, '*.jar')
fp.setCurrentFilter(g_jar)
if fp.execute() == OK:
url = getUrl(self.ctx, fp.getFiles()[0])
if url.Name == g_jar:
jar = '%s/%s' % (g_path, g_jar)
target = getResourceLocation(self.ctx, g_identifier, jar)
getSimpleFile(self.ctx).copy(url.Main, target)
self._reloadVersion(dialog)
def getDataSourceUrl(ctx, dbname, plugin, register):
error = None
print("dbinit.getDataSourceUrl() 1")
url = getResourceLocation(ctx, plugin, g_path)
odb = '%s/%s.odb' % (url, dbname)
print("dbinit.getDataSourceUrl() 2")
dbcontext = createService(ctx, 'com.sun.star.sdb.DatabaseContext')
print("dbinit.getDataSourceUrl() 3")
if not getSimpleFile(ctx).exists(odb):
print("dbinit.getDataSourceUrl() 4")
datasource = createDataSource(dbcontext, url, dbname)
error = createDataBase(ctx, datasource, url, dbname)
print("dbinit.getDataSourceUrl() 5 %s" % error)
if error is None:
datasource.DatabaseDocument.storeAsURL(odb, ())
if error is None and register:
registerDataSource(dbcontext, dbname, odb)
return url, error
def getDataSourceClassPath(ctx, identifier):
path = getResourceLocation(ctx, identifier, g_path)
return '%s/%s' % (path, g_jar)
