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)