On Jan 5, 6:15 pm, Gilles Ganault <nos...@nospam.com> wrote:
> Hello
>
> I successfully use the email package to send e-mail from Python
> scripts, but this script fails when I fetch addresses from an SQLite
> database where data is Unicode-encoded:
>
> ======
> from email.MIMEText import MIMEText
> import smtplib,sys
> import apsw
>
> connection=apsw.Connection("test.sqlite")
> cursor=connection.cursor()
>
> subject = "My subject"
> f = open("message.txt", "r")
> message = f.read()
> f.close()
>
> msg = MIMEText(message)
>
> msg['Subject'] = subject
> From = "m...@acme.com"
> msg['From'] = From
>
> server = smtplib.SMTP("smtp.acme.com")
>
> sql="SELECT email FROM people WHERE email IS NOT NULL"
> rows=list(cursor.execute(sql))
> for email in rows:
> To = email
> msg['To'] = email
>
> #print To
> #(u'du...@acme.com',)
That looks like a tuple to me. What does it look like to you?
>
> #AttributeError: 'tuple' object has no attribute 'lstrip'
> #server.sendmail(From,[To],msg.as_string())
When are asking for help, could you *PLEASE* supply the actual code
that you ran, with the actual output, and (just in case the problem is
not otherwise screamingly obvious) the *FULL* traceback?
The to_addrs arg of SMTP.sendmail() should be a single string, or a
list of strings. You have supplied [(u'du...@acme.com',)] which is a
list containing one tuple. That tuple is a result of your SQL query,
which has returned a 1-column row as a tuple (as expected/documented).
SMTP.sendmail() treats your tuple as though it were a string, and
consequently an exception is raised.
> server.quit
Should that perhaps be server.quit() ?
> Does email choke on Unicode?
I've got no idea; I've never used email or smtplib. Why don't you feed
them some Unicode and find out? Also consider having a look at the
manual.
HTH,
John
--
http://mail.python.org/mailman/listinfo/python-list
