Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I suggest using the mime encoder libraries:</p> <pre><code>from email.MIMEMultipart import MIMEMultipart from email.MIMEBase import MIMEBase from email.MIMEText import MIMEText from email.Utils import COMMASPACE, formatdate from email import Encoders import os import smtplib import datetime import logging class mailer: def __init__(self,SERVER="my.mail.server",FROM="email@mydomain.com"): self.server = SERVER self.send_from = FROM self.logger = logging.getLogger('mailer') def send_mail(self, send_to, subject, text, files=[]): assert type(send_to)==list assert type(files)==list if self.logger.isEnabledFor(logging.DEBUG): self.logger.debug(' '.join(("Sending email to:",' '.join(send_to)))) self.logger.debug(' '.join(("Subject:",subject))) self.logger.debug(' '.join(("Text:",text))) self.logger.debug(' '.join(("Files:",' '.join(files)))) msg = MIMEMultipart() msg['From'] = self.send_from msg['To'] = COMMASPACE.join(send_to) msg['Date'] = formatdate(localtime=True) msg['Subject'] = subject msg.attach( MIMEText(text) ) for f in files: part = MIMEBase('application', "octet-stream") part.set_payload( open(f,"rb").read() ) Encoders.encode_base64(part) part.add_header('Content-Disposition', 'attachment; filename="%s"' % os.path.basename(f)) msg.attach(part) smtp = smtplib.SMTP(self.server) mydict = smtp.sendmail(self.send_from, send_to, msg.as_string()) if self.logger.isEnabledFor(logging.DEBUG): self.logger.debug("Email Successfully Sent!") smtp.close() return mydict </code></pre> <p>Make sure to check the return dictionary, as it will let you know if only some people received the email.</p>
    singulars
    1. This table or related slice is empty.
    1. POWhen sending an email with smtp in python my \t are replaced with a single space.
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USSpencer Rathbun
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COThis is not at all what i asked for. I don't have any problems with sending the email. I just need the tabs to be tabs in the sent email.
      singulars
      1. PO
      1. USwDroter
    2. CO@wDroter If you read the function send_mail, you will note that it uses the mime libs to create the text, instead of creating one big string. This will keep the tabs in your text section, and let you add file attachments if you are so inclined later. The rest of it is just for convenience.
      singulars
      1. PO
      1. USSpencer Rathbun
    3. COThis also still leaves only spaces and not tabs.
      singulars
      1. PO
      1. USwDroter
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload