I'm afraid you're not making a lot of sense, but if I read you right,
you want to match up primary keys / IDs from the Tradelead table with
their respective registered User's Login info. In which case you
could do the following:
from django.models.myapp import users,tradeleads
for tradelead in tradeleads.get_list():
print "Tradelead id: %s -> User login name: %s" % (tradelead.id,
tradelead.get_registration().Login)
There's no real "joins" happening there because you have no criteria
to apply, and in Django you work with data objects and not result
sets like you might see in PHP's mysql_/pgsql_/etc functions.
Therefore, all that's required to pull data from two tables with no
selection criteria, is to get a list from one and to call the
results' get_whatever() functions in order to obtain the related
records from the other table.
If you had certain criteria, like "I want all Tradeleads whose
registered user's login name starts with L,", then you could use the
following syntax:
tradeleads.get_list(registration__Login__startswith="L")
which just get you a list of Tradelead objects.
Regards,
Jeff
On Nov 4, 2005, at 5:16 AM, PythonistL wrote:
I have the following model
class User(meta.Model):
Login= meta.CharField( maxlength=50,unique=True)
Password= meta.CharField( maxlength=50)
Email= meta.EmailField(blank=True)
InvoicingAddress= meta.CharField( maxlength=200,blank=True)
Date_joined=meta.DateTimeField(auto_now_add=True)
def __repr__(self):
return self.Login
class META:
admin = meta.Admin()
class Tradelead(meta.Model):
Subject=meta.CharField( maxlength=50,unique=True)
Description=meta.TextField()
OfferType=meta.CharField(maxlength=50,choices=(('S','Sell'),
('B','Buy')))
registration=meta.ForeignKey(User)
def __repr__(self):
return self.Subject
class META:
admin = meta.Admin()
My question is:
How can I get through
id
in Tradelead table
Login
data from User table?
Thank you for help
L.
--
Jeffrey E. Forcier
Junior Developer, Research and Development
Stroz Friedberg, LLC
15 Maiden Lane, 12th Floor
New York, NY 10038
[main]212-981-6540 [direct]212-981-6546
http://www.strozllc.com
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No right to
confidential or privileged treatment of this message is waived or lost
by any error in transmission. If you have received this message in
error, please immediately notify the sender by e-mail or by telephone at
212.981.6540, delete the message and all copies from your system and
destroy any hard copies. You must not, directly or indirectly, use,
disclose, distribute, print or copy any part of this message if you are
not the intended recipient.
