def _getRowSet(self, connection, command): service = 'com.sun.star.sdb.RowSet' rowset = createService(self._ctx, service) rowset.ActiveConnection = connection rowset.CommandType = command rowset.FetchSize = g_fetchsize return rowset
def _smtpSend(self, context, authenticator, sender, recipient, subject, message, progress, setStep): step = 3 progress(5) service = 'com.sun.star.mail.MailServiceProvider2' progress(25) server = createService(self._ctx, service).create(SMTP) progress(50) try: server.connect(context, authenticator) except UnoException as e: print("DataSoure._smtpSend() 1 Error: %s" % e.Message) else: progress(75) if server.isConnected(): body = MailTransferable(self._ctx, message, False) mail = getMail(self._ctx, sender, recipient, subject, body) print("DataSoure._smtpSend() 2: %s - %s" % (type(mail), mail)) try: server.sendMailMessage(mail) except UnoException as e: print("DataSoure._smtpSend() 3 Error: %s - %s" % (e.Message, traceback.print_exc())) else: step = 5 server.disconnect() progress(100) setDebugMode(self._ctx, False) setStep(step)
def _getSmtpConfig(self, email, url, progress, updateModel): progress(5) url = getUrl(self._ctx, url) progress(10) mode = getConnectionMode(self._ctx, url.Server) progress(20) self.waitForDataBase() progress(40) user, servers = self.DataBase.getSmtpConfig(email) if len(servers) > 0: progress(100, 1) elif mode == OFFLINE: progress(100, 2) else: progress(60) service = 'com.gmail.prrvchr.extensions.OAuth2OOo.OAuth2Service' request = createService(self._ctx, service) response = self._getIspdbConfig(request, url.Complete, user.getValue('Domain')) if response.IsPresent: progress(80) servers = self.DataBase.setSmtpConfig(response.Value) progress(100, 3) else: progress(100, 4) updateModel(user, servers, mode)
def _getDataBaseConnection(self, url, info=()): service = 'com.sun.star.sdbc.DriverManager' manager = createService(self._ctx, service) if info: connection = manager.getConnectionWithInfo(url, info) else: connection = manager.getConnection(url) return connection
def sendDocument(self): subject, attachments = self._getSavedDocumentProperty() sender = self._view.getSender() recipients, indexes = self._view.getRecipients() url, datasource, query, table, identifier, bookmark = self._model.getDocumentInfo( ) print("MergerManager.sendDocument() %s: %s - %s - %s - %s" % (sender, subject, url, datasource, query)) service = 'com.sun.star.mail.SpoolerService' spooler = createService(self._ctx, service) id = spooler.addMergeJob(sender, subject, url, datasource, query, table, identifier, bookmark, recipients, indexes, attachments)
def __init__(self, ctx, datasource): self._ctx = ctx self._datasource = datasource self._configuration = getConfiguration(ctx, g_identifier, True) self._document = getDesktop(ctx).CurrentComponent #mri = createService(self._ctx, 'mytools.Mri') #mri.inspect(self._document) self._path = self._getPath() self._grid1 = GridModel() self._grid2 = GridModel() self._column = 'MergerGridColumns' self._column1 = ColumnModel(ctx) self._column2 = ColumnModel(ctx) self._widths = self._getGridColumnsWidth() self._maxcolumns = 8 self._prefix = 'Sub.' service = 'com.sun.star.sdb.DatabaseContext' self._dbcontext = createService(ctx, service) self._addressbook = None self._statement = None self._queries = None self._address = None self._recipient = None self._resultset = None self._composer = None self._subcomposer = None self._command = None self._subcommand = None self._name = None self._rows = () self._tables = () self._table = None self._query = None self._changed = False self._disposed = False self._similar = False self._temp = False self._lock = Condition() self._resolver = getStringResource(ctx, g_identifier, g_extension) self._resources = {'Step': 'MergerPage%s.Step', 'Title': 'MergerPage%s.Title', 'TabTitle': 'MergerTab%s.Title', 'Progress': 'MergerPage1.Label6.Label.%s', 'Error': 'MergerPage1.Label8.Label.%s', 'Index': 'MergerPage1.Label14.Label.%s', 'Message': 'MergerTab2.Label1.Label', 'Recipient': 'MailWindow.Label4.Label', 'PickerTitle': 'Mail.FilePicker.Title', 'Property': 'Mail.Document.Property.%s', 'Document': 'MailWindow.Label8.Label.1'}
def sendDocument(self): try: subject, attachments = self._getSavedDocumentProperty() print( "MailerManager.sendDocument() *************************** %s - %s" % (subject, attachments)) sender = self._view.getSender() recipients = self._view.getRecipients() url = self._model.getUrl() service = 'com.sun.star.mail.SpoolerService' spooler = createService(self._ctx, service) id = spooler.addJob(sender, subject, url, recipients, attachments) except Exception as e: msg = "Error: %s" % traceback.print_exc() print(msg)
def __init__(self, ctx): try: self._ctx = ctx self._stringResource = getStringResource(ctx, g_identifier, g_extension, 'OptionsDialog') service = 'com.sun.star.mail.SpoolerService' self._spooler = createService(ctx, service) datasource = DataSource(ctx) self._model = IspdbModel(ctx, datasource, True) self._logger = Pool(ctx).getLogger() self._logger.logMessage(INFO, "Loading ... Done", 'OptionsDialog', '__init__()') except Exception as e: msg = "Error: %s - %s" % (e, traceback.print_exc()) print(msg)
def __init__(self, ctx, datasource, parent): self._ctx = ctx self._lock = Condition() self._enabled = True self._model = SpoolerModel(ctx, datasource) self._view = SpoolerView(ctx, self, parent) service = 'com.sun.star.mail.SpoolerService' self._spooler = createService(ctx, service) self._listener = SpoolerListener(self) self._spooler.addListener(self._listener) self._refreshSpoolerState() self._model.initSpooler(self.initView) self._logger = Pool(ctx).getLogger('SpoolerLogger') self._handler = LogHandler(ctx, self.refreshLog) self._logger.addLogHandler(self._handler) self.refreshLog()
def _smtpConnect(self, context, authenticator, progress, callback): progress(0) step = 2 progress(5) service = 'com.sun.star.mail.MailServiceProvider2' progress(25) server = createService(self._ctx, service).create(SMTP) progress(50) try: server.connect(context, authenticator) except UnoException as e: progress(100) else: progress(75) if server.isConnected(): server.disconnect() step = 4 progress(100) else: progress(100) setDebugMode(self._ctx, False) callback(step)
def _createQuery(self, command): service = 'com.sun.star.sdb.QueryDefinition' query = createService(self._ctx, service) query.Command = command return query
def _getRowSet(self): service = 'com.sun.star.sdb.RowSet' rowset = createService(self._ctx, service) rowset.CommandType = COMMAND rowset.FetchSize = g_fetchsize return rowset