Styjun

Are double contractions formal? Eg: "couldn't've" for "could not have"

Which spells are in some way related to shadows or the Shadowfell?

Is there an application which does HTTP PUT?

Has there been evidence of any other gods?

Is it a good idea to copy a trader when investing?

Do Rabbis admit emotional involvement in their rulings?

How to find the transfer orbit from a initial circular orbit to a final elliptical orbit

Was Mohammed the most popular first name for boys born in Berlin in 2018?

What's an appropriate age to involve kids in life changing decisions?

Narcissistic cube asks who are we?

Are there vaccine ingredients which may not be disclosed ("hidden", "trade secret", or similar)?

Why is it wrong to *implement* myself a known, published, widely believed to be secure crypto algorithm?

Ugin's Conjurant vs. un-preventable damage

Was there a contingency plan in place if Little Boy failed to detonate?

Is it a Munchausen Number?

What is the Ancient One's mistake?

Using wilcox.test() and t.test() in R yielding different p-values

And now you see it II (the B side)

What is the status of the three crises in the history of mathematics?

What replaces x86 intrinsics for C when Apple ditches Intel CPUs for their own chips?

Rusty Chain and back cassette – Replace or Repair?

Can I use a 11-23 11-speed shimano cassette with the RD-R8000 11-speed Ultegra Shadow Rear Derailleur (short cage)?

Is it safe to keep the GPU on 100% utilization for a very long time?

Renting a house to a graduate student in my department

Django modelform submission with relational data

Does Django scale?django - inlineformset_factory with more than one ForeignKeyCan't add field to ModelForm at __init__Radio buttons in django adminfilter json data from Django modelDjango-Rest-Framework - How to serialize queryset from an unrelated model as nested serializerHow to expose some specific fields of model_b based on a field of model_a?How to set dynamic initial values to django modelform fieldrelated name in parent model in django if inherited in other modelHow to check if Django Signal works?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I have a django modelform that creates a new listing in my post app, I would like to associate this with a company id, which is an account type in my account app.

The account_company db table (postgresql) has a user_id field which is the pk of User. the post_listing table will have a company field which I think should be the pk of account_company.

As I am attempting to use modelforms for all forms, I am having an issue with making this association.

# models.py

class Listing(models.Model):
 title = models.CharField(max_length=200)
 company = models.ForeignKey(Company, on_delete=models.CASCADE)
 ...

# forms.py

class newListingForm(forms.ModelForm):

 class Meta:
 model = Listing
 fields = ('title'...)

 def __init__(self, user, *args, **kwargs):
 super(newListingForm, self).__init__(*args, **kwargs)
 self.fields['company'].queryset = Company.objects.filter(pk__user_id=user.id) 
 # above i am trying to filter the AutoField to the `company pk` where `user_id` is equal to `request.user.id`

# views.py

def post(request):

 if request.method == 'POST':
 form = newListingForm(request.user, request.POST)
 if form.is_valid():
 listing = form.save(commit=False)
 listing.user = request.user
 listing.save()
 else:
 form = newListingForm(request.user)
 return render(request, 'post/post.html', 'form': form)

The debug error i get is:

Unsupported lookup 'user_id' for AutoField or join on the field not permitted.

Updated

#accounts model.py

...
class Company(models.Model):
 user = models.OneToOneField(User, on_delete=models.CASCADE)
 name = models.CharField(max_length=200, null=True)
 photo = models.ImageField(upload_to='images/%Y/%m/%d/', null=True)
 description = models.TextField(null=True)

python django

share|improve this question

edited Mar 23 at 9:20

nghs

asked Mar 23 at 9:08

nghsnghs

6011

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  change Company.objects.filter(pk__user_id=user.id) to Company.objects.filter(user_id=user.id) is still throws same error?
  
  – shotgunner
  Mar 23 at 9:13
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you also include your Company model for completeness?
  
  – Mekicha
  Mar 23 at 9:15
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @shotgunner with that change it gives just company as an error, however the company field is defined in the model..
  
  – nghs
  Mar 23 at 9:18
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Mekicha added the accounts model.py with the Company model, here the OneToOneField says user, however in the db it is stored as user_id
  
  – nghs
  Mar 23 at 9:20
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  But show that error. Also show the bits of the form you've snipped. Is companyactually in the fields list?
  
  – Daniel Roseman
  Mar 23 at 9:48
  
  

  
  
  
  

 | 
show 6 more comments

0

I have a django modelform that creates a new listing in my post app, I would like to associate this with a company id, which is an account type in my account app.

The account_company db table (postgresql) has a user_id field which is the pk of User. the post_listing table will have a company field which I think should be the pk of account_company.

As I am attempting to use modelforms for all forms, I am having an issue with making this association.

# models.py

class Listing(models.Model):
 title = models.CharField(max_length=200)
 company = models.ForeignKey(Company, on_delete=models.CASCADE)
 ...

# forms.py

class newListingForm(forms.ModelForm):

 class Meta:
 model = Listing
 fields = ('title'...)

 def __init__(self, user, *args, **kwargs):
 super(newListingForm, self).__init__(*args, **kwargs)
 self.fields['company'].queryset = Company.objects.filter(pk__user_id=user.id) 
 # above i am trying to filter the AutoField to the `company pk` where `user_id` is equal to `request.user.id`

# views.py

def post(request):

 if request.method == 'POST':
 form = newListingForm(request.user, request.POST)
 if form.is_valid():
 listing = form.save(commit=False)
 listing.user = request.user
 listing.save()
 else:
 form = newListingForm(request.user)
 return render(request, 'post/post.html', 'form': form)

The debug error i get is:

Unsupported lookup 'user_id' for AutoField or join on the field not permitted.

Updated

#accounts model.py

...
class Company(models.Model):
 user = models.OneToOneField(User, on_delete=models.CASCADE)
 name = models.CharField(max_length=200, null=True)
 photo = models.ImageField(upload_to='images/%Y/%m/%d/', null=True)
 description = models.TextField(null=True)

python django

share|improve this question

edited Mar 23 at 9:20

nghs

asked Mar 23 at 9:08

nghsnghs

6011

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  change Company.objects.filter(pk__user_id=user.id) to Company.objects.filter(user_id=user.id) is still throws same error?
  
  – shotgunner
  Mar 23 at 9:13
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you also include your Company model for completeness?
  
  – Mekicha
  Mar 23 at 9:15
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @shotgunner with that change it gives just company as an error, however the company field is defined in the model..
  
  – nghs
  Mar 23 at 9:18
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Mekicha added the accounts model.py with the Company model, here the OneToOneField says user, however in the db it is stored as user_id
  
  – nghs
  Mar 23 at 9:20
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  But show that error. Also show the bits of the form you've snipped. Is companyactually in the fields list?
  
  – Daniel Roseman
  Mar 23 at 9:48
  
  

  
  
  
  

 | 
show 6 more comments

I have a django modelform that creates a new listing in my post app, I would like to associate this with a company id, which is an account type in my account app.

The account_company db table (postgresql) has a user_id field which is the pk of User. the post_listing table will have a company field which I think should be the pk of account_company.

As I am attempting to use modelforms for all forms, I am having an issue with making this association.

# models.py

class Listing(models.Model):
 title = models.CharField(max_length=200)
 company = models.ForeignKey(Company, on_delete=models.CASCADE)
 ...

# forms.py

class newListingForm(forms.ModelForm):

 class Meta:
 model = Listing
 fields = ('title'...)

 def __init__(self, user, *args, **kwargs):
 super(newListingForm, self).__init__(*args, **kwargs)
 self.fields['company'].queryset = Company.objects.filter(pk__user_id=user.id) 
 # above i am trying to filter the AutoField to the `company pk` where `user_id` is equal to `request.user.id`

# views.py

def post(request):

 if request.method == 'POST':
 form = newListingForm(request.user, request.POST)
 if form.is_valid():
 listing = form.save(commit=False)
 listing.user = request.user
 listing.save()
 else:
 form = newListingForm(request.user)
 return render(request, 'post/post.html', 'form': form)

The debug error i get is:

Unsupported lookup 'user_id' for AutoField or join on the field not permitted.

Updated

#accounts model.py

...
class Company(models.Model):
 user = models.OneToOneField(User, on_delete=models.CASCADE)
 name = models.CharField(max_length=200, null=True)
 photo = models.ImageField(upload_to='images/%Y/%m/%d/', null=True)
 description = models.TextField(null=True)

python django

share|improve this question

edited Mar 23 at 9:20

nghs

asked Mar 23 at 9:08

nghsnghs

6011

# models.py

class Listing(models.Model):
 title = models.CharField(max_length=200)
 company = models.ForeignKey(Company, on_delete=models.CASCADE)
 ...

# forms.py

class newListingForm(forms.ModelForm):

 class Meta:
 model = Listing
 fields = ('title'...)

 def __init__(self, user, *args, **kwargs):
 super(newListingForm, self).__init__(*args, **kwargs)
 self.fields['company'].queryset = Company.objects.filter(pk__user_id=user.id) 
 # above i am trying to filter the AutoField to the `company pk` where `user_id` is equal to `request.user.id`

# views.py

def post(request):

 if request.method == 'POST':
 form = newListingForm(request.user, request.POST)
 if form.is_valid():
 listing = form.save(commit=False)
 listing.user = request.user
 listing.save()
 else:
 form = newListingForm(request.user)
 return render(request, 'post/post.html', 'form': form)

#accounts model.py

...
class Company(models.Model):
 user = models.OneToOneField(User, on_delete=models.CASCADE)
 name = models.CharField(max_length=200, null=True)
 photo = models.ImageField(upload_to='images/%Y/%m/%d/', null=True)
 description = models.TextField(null=True)

share|improve this question

edited Mar 23 at 9:20

nghs

asked Mar 23 at 9:08

nghsnghs

6011

share|improve this question

edited Mar 23 at 9:20

nghs

asked Mar 23 at 9:08

nghsnghs

6011

asked Mar 23 at 9:08

nghsnghs

6011

asked Mar 23 at 9:08

nghsnghs

6011