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