From: Mariano Kamp <mariano.kamp@...>
Date: 2006-05-23T21:18:18+09:00
Subject: Does TMail support nested multipart messages?

------=_Part_2424_28651074.1148386694161
Content-Type: multipart/alternative; 
	boundary="----=_Part_2425_32518286.1148386694161"

------=_Part_2425_32518286.1148386694161
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi,

  does anybody know if TMail supports multipart messages?

  I am using TMail at the moment, but it doesn't seem to work for me. Maybe
I am doing something wrong here?

  I attached the sample and below is the code. The output looks like this:

body=3D!Hi,

   I have the following code:
         @conversation_pages,
          @conversations =3D paginate(:conversations,
                                    :per_page =3D> 20,
                                    :joins =3D> 'LEFT JOIN messages on
messages.conversation_id =3D conversations.id '+
                                              'LEFT JOIN email_addresses on
email_addresses.id =3D messages.email_address_id',
                                    :conditions =3D>
['email_addresses.emai_______________________________________________
Rails mailing list
Rails@lists.rubyonrails.org
http://lists.rubyonrails.org/mailman/listinfo/rails

!

  So the message is broken off at some point, arbitrary to me.
Cheers,
Mariano

require File.dirname(__FILE__) + '/../test_helper'

class TMailTest < Test::Unit::TestCase

  def test_multiparts
    assert raw =3D File.read("sample")
    assert mail =3D TMail::Mail.parse(raw)
    puts "body=3D!#{body_as_plain_text(mail)}!"
  end

  def body_as_plain_text(part)
    body =3D ''
    if part.multipart?
      part.parts.each do |subpart|
        if subpart.content_type =3D=3D 'text/plain' and
subpart.content_disposition =3D=3D 'inline'
          body << subpart.body
        elsif subpart.content_type =3D~ /^multipart/
          body << body_as_plain_text(subpart)
        end
      end
    else
      body =3D part.body
    end
    body
  end
end

------=_Part_2425_32518286.1148386694161
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi,<br><br>&nbsp; does anybody know if TMail supports multipart messages?<b=
r><br>&nbsp; I am using TMail at the moment, but it doesn't seem to work fo=
r me. Maybe I am doing something wrong here?<br><br>&nbsp; I attached the s=
ample and below is the code. The output looks like this:
<br><br>body=3D!Hi,<br><br>&nbsp;&nbsp; I have the following code:<br>&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; @conversation_pages,<br>&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; @conversations =3D paginate=
(:conversations,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp; :per_page =3D&gt; 20,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp; :joins =3D&gt; 'LEFT JOIN messages on
<br>messages.conversation_id =3D <a href=3D"http://conversations.id">conver=
sations.id</a> '+<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'LEFT JO=
IN email_addresses on<br>email_addresses.id =3D messages.email_address_id',=
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :conditions =
=3D&gt; ['email_addresses.emai_____________________________________________=
__<br>Rails mailing list<br><a href=3D"mailto:Rails@lists.rubyonrails.org">=
Rails@lists.rubyonrails.org
</a><br><a href=3D"http://lists.rubyonrails.org/mailman/listinfo/rails">htt=
p://lists.rubyonrails.org/mailman/listinfo/rails</a><br><br>!<br><br>&nbsp;=
 So the message is broken off at some point, arbitrary to me.<br>Cheers,<br=
>Mariano
<br><br>require File.dirname(__FILE__) + '/../test_helper'<br><br>class TMa=
ilTest &lt; Test::Unit::TestCase<br><br>&nbsp; def test_multiparts<br>&nbsp=
;&nbsp;&nbsp; assert raw =3D File.read(&quot;sample&quot;) &nbsp;<br>&nbsp;=
&nbsp;&nbsp; assert mail =3D TMail::Mail.parse
(raw)<br>&nbsp;&nbsp;&nbsp; puts &quot;body=3D!#{body_as_plain_text(mail)}!=
&quot;<br>&nbsp; end<br>&nbsp; <br>&nbsp; def body_as_plain_text(part)<br>&=
nbsp;&nbsp;&nbsp; body =3D ''<br>&nbsp;&nbsp;&nbsp; if part.multipart?<br>&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp; part.parts.each do |subpart|<br>&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if subpart.content_type
 =3D=3D 'text/plain' and subpart.content_disposition =3D=3D 'inline'<br>&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; body &lt;&lt; subpart.b=
ody<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; elsif subpart.content_typ=
e =3D~ /^multipart/<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p; body &lt;&lt; body_as_plain_text(subpart)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp; end
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end<br>&nbsp;&nbsp;&nbsp; else<br>&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp; body =3D part.body<br>&nbsp;&nbsp;&nbsp; end<br>&n=
bsp;&nbsp;&nbsp; body<br>&nbsp; end<br>end

------=_Part_2425_32518286.1148386694161--

------=_Part_2424_28651074.1148386694161
Content-Type: application/octet-stream; name=sample
Content-Transfer-Encoding: 7bit
X-Attachment-Id: f_enk7lpzk
Content-Disposition: attachment; filename="sample"

X-Apparently-To: onairam0@yahoo.de via 217.12.10.138; Fri, 19 May 2006 07:56:00 -0700
X-Originating-IP: [70.84.143.100]
Authentication-Results: mta217.mail.re4.yahoo.com
  from=lists.rubyonrails.org; domainkeys=fail (bad syntax)
Received: from 70.84.143.100  (EHLO wrath.rubyonrails.com) (70.84.143.100)
  by mta217.mail.re4.yahoo.com with SMTP; Fri, 19 May 2006 07:55:49 -0700
Received: from 6d.8f.5446.static.theplanet.com (localhost.rubyonrails.org [127.0.0.1])
	by wrath.rubyonrails.com (Postfix) with ESMTP id 8921F3B1CD;
	Fri, 19 May 2006 14:55:22 +0000 (GMT)
Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.178])
	by wrath.rubyonrails.com (Postfix) with ESMTP id CA77539D4A
	for <rails@lists.rubyonrails.org>; Fri, 19 May 2006 14:55:10 +0000 (GMT)
Received: by py-out-1112.google.com with SMTP id w49so799144pyg
	for <rails@lists.rubyonrails.org>; Fri, 19 May 2006 07:55:10 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=AOQZOjy0ZI9GWMOAX8ED10a2f4mN8STv2Wu3NnD6C87tfITYIsTQZlQMk//cn/jo2tzViUzrUO+l8eImUPjuevKFxuqjzxXu2pGeXvmhx0lGhHWi77dyWS0Ly8TJIibX7HEYL6EJBGaFnMY70PN2xtmLRKjARA6UdUsbAHBX4Kc=
Received: by 10.35.109.2 with SMTP id l2mr2133463pym;
	Fri, 19 May 2006 07:55:09 -0700 (PDT)
Received: by 10.35.67.5 with HTTP; Fri, 19 May 2006 07:55:09 -0700 (PDT)
Message-ID: <910a6fc10605190755v4e8a0b3dq66cfd2df99746f5e@mail.gmail.com>
Date: Fri, 19 May 2006 16:55:09 +0200
From: "Mariano Kamp" <mariano.kamp@gmail.com>
To: rails@lists.rubyonrails.org
MIME-Version: 1.0
Subject: [Rails] Problem with joins and overlapping field names
X-BeenThere: rails@lists.rubyonrails.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: rails@lists.rubyonrails.org
List-Id: rails.lists.rubyonrails.org
List-Unsubscribe: <http://lists.rubyonrails.org/mailman/listinfo/rails>,
	<mailto:rails-request@lists.rubyonrails.org?subject=unsubscribe>
List-Archive: <http://wrath.rubyonrails.org/pipermail/rails>
List-Post: <mailto:rails@lists.rubyonrails.org>
List-Help: <mailto:rails-request@lists.rubyonrails.org?subject=help>
List-Subscribe: <http://lists.rubyonrails.org/mailman/listinfo/rails>,
	<mailto:rails-request@lists.rubyonrails.org?subject=subscribe>
Content-Type: multipart/mixed; boundary="===============0196854335=="
Sender: rails-bounces@lists.rubyonrails.org
Errors-To: rails-bounces@lists.rubyonrails.org

--===============0196854335==
Content-Type: multipart/alternative; 
	boundary="----=_Part_27495_9198801.1148050509716"

------=_Part_27495_9198801.1148050509716
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi,

   I have the following code:
         @conversation_pages,
          @conversations =3D paginate(:conversations,
                                    :per_page =3D> 20,
                                    :joins =3D> 'LEFT JOIN messages on
messages.conversation_id =3D conversations.id '+
                                              'LEFT JOIN email_addresses on
email_addresses.id =3D messages.email_address_id',
                                    :conditions =3D> ['email_addresses.emai=
l =3D
?', @email_address.email])

  producing this sql staement:

SELECT * FROM conversations LEFT JOIN messages on messages.conversation_id =
=3D
conversations.id LEFT JOIN email_addresses on email_addresses.id =3D
messages.email_address_id WHERE (email_addresses.email =3D 'xyz@gmail.com')
LIMIT 0, 20

  The funny thing is that my conversation.id is no longer referencing the
conversation.id but email_addresses.id. I assume this is due to the fact
that "*" is generated in the sql, isn't it? I haven't found a way to
instruct active record to use explicit column names like conversations.id,
email_addressesses.id etc. etc.

  Any idea how to work around that problem?

Cheers,
Mariano

------=_Part_27495_9198801.1148050509716
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi,<br><br>&nbsp;&nbsp; I have the following code:<br>&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp; @conversation_pages, <br>&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; @conversations =3D paginate(:conversations=
, <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :per_pag=
e =3D&gt; 20,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p; :joins =3D&gt; 'LEFT JOIN messages on=20
messages.conversation_id =3D <a href=3D"http://conversations.id">conversati=
ons.id</a> '+<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'LEFT JOIN e=
mail_addresses on email_addresses.id =3D messages.email_address_id',<br>&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :conditions =3D&g=
t; ['email_addresses.email =3D ?', @email_address.email])=20
<br><br>&nbsp; producing this sql staement:<br><br>SELECT * FROM conversati=
ons LEFT JOIN messages on messages.conversation_id =3D <a href=3D"http://co=
nversations.id">conversations.id</a> LEFT JOIN email_addresses on email_add=
resses.id =3D=20
messages.email_address_id WHERE (email_addresses.email =3D '<a href=3D"mail=
to:xyz@gmail.com">xyz@gmail.com</a>') LIMIT 0, 20<br><br>&nbsp; The funny t=
hing is that my <a href=3D"http://conversation.id">conversation.id</a> is n=
o longer referencing the=20
<a href=3D"http://conversation.id">conversation.id</a> but email_addresses.=
id. I assume this is due to the fact that &quot;*&quot; is generated in the=
 sql, isn't it? I haven't found a way to instruct active record to use expl=
icit column names like=20
<a href=3D"http://conversations.id">conversations.id</a>, email_addressesse=
s.id etc. etc. <br><br>&nbsp; Any idea how to work around that problem?<br>=
<br>Cheers,<br>Mariano<br>

------=_Part_27495_9198801.1148050509716--

--===============0196854335==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Rails mailing list
Rails@lists.rubyonrails.org
http://lists.rubyonrails.org/mailman/listinfo/rails

--===============0196854335==--




------=_Part_2424_28651074.1148386694161--