Tuesday, August 27, 2019

Re: Database Views

Thanks for your response.

In Django models.. For example 

class TempUser(models.Model):      first_name = models.CharField(max_length=100)        class Meta:          managed = False          db_table = "temp_user"


temp_user is database view. 
Now assume select * from temp_user
Gives 5 records 

Same model if i register in admin panel. 
It will show less records than 5. 
Even if i do TempUser.Objects.Count()
It will show less records than 5.

Very rare case it show exactly what view is having otherwise most of the time it fails to show exact records. 
I observed this since many days in 3 to 4 projects of my django



On Tue, Aug 27, 2019, 9:01 PM Jani Tiainen <redetin@gmail.com> wrote:
Hi.

You really need to provide more context. Without knowing your data, tables involved in a view. Your model and query you used and query you used to verify wrong (or correct) results it is virtually impossible to help you further.


ti 27. elok. 2019 klo 17.47 HULUGESH B <doddahulugappa@gmail.com> kirjoitti:
Hi All,


I am facing issues in Django Models:

If connect databse views in models.

It shows less records than actual number of records. Kindly assist me. How to solve. This is not all the time.. sometimes it is correct sometimes not correct.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/29c228cc-295a-487e-a5df-afb1471b8730%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAHn91ocVY%2B-Z-9_GYKa0gbT5MCg%2Bh%2BvBzfLEgVf5QmnArV%2BaZw%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAKfjjGq5JFLz62UYD5CcPbYoqkOkty%2BBUz-O%2B9pwPZ%3DGazNvMw%40mail.gmail.com.

No comments:

Post a Comment