Re: Database Views

2019-08-27 Thread Doddahulugappa.B
Thank you. I got it.. Issue with timezone By default django considering TIME_ZONE = 'UTC' USE_TZ = True Thats the reason it was showing less records than actual.. I changed it local to local time zone name and USE_TZ = False Its working perfectly.. I also understood that its not only to database

Re: Database Views

2019-08-27 Thread Doddahulugappa.B
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 Sa

Re: Database Views

2019-08-27 Thread Jani Tiainen
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 kirjoitti: > Hi All, >

Re: Database views

2006-04-11 Thread George Sakkis
Thank you both for your answer. What I had in mind was read-only views, so all the update limitations are not a problem at all. Also, I am less interested in wrappers over native DBMS views. What I'd like is a programmer-friendly API for views, transparent to the underlying DBMS, similar to how Mo

Re: Database views

2006-04-10 Thread Andy Dustman
On 4/10/06, Adrian Holovaty <[EMAIL PROTECTED]> wrote: > > On 4/10/06, George Sakkis <[EMAIL PROTECTED]> wrote: > > I understand Django doesn't support database views > > (http://en.wikipedia.org/wiki/View_%28database%29) right out of the > > box, but I was wondering if there's a reasonably easy w

Re: Database views

2006-04-10 Thread Adrian Holovaty
On 4/10/06, George Sakkis <[EMAIL PROTECTED]> wrote: > I understand Django doesn't support database views > (http://en.wikipedia.org/wiki/View_%28database%29) right out of the > box, but I was wondering if there's a reasonably easy way to implement > (or at least emulate) them. Here's an illustrat