No that table name will be different every time based on some id. If table name is same then there is no problem but the issue arises when table names are different but the schema is same.
On May 26, 3:51 pm, Ankit <ankit....@mkhoj.com> wrote: > ds99 wrote: > > Hi Ankit, > > I got what you are saying. I'll tell you what I want to do. > > > For eg: For one request one process creates table called "books_111" > > and after its purpose is done, whole table will be dropped. It may > > also happen that while this table is being worked upon, another table > > with same schema is created for another request. Now to access this > > table using django APIs, i need to have latest snapshot of the > > database,i.e, updated model file. For that again we need to fire > > "python manage.py inspectdb" to create missing models. Is there any > > other way to do it on the fly? > > > Thanks, > > ds99 > > > On May 26, 3:11 pm, Ankit <ankit....@mkhoj.com> wrote: > > >> ds99 wrote: > > >>> Hi Alex, > >>> Thanks a lot or quick reply. A couple of queries below: > > >>> 1) How can this be handled when the tables are created dynamically? > >>> Actually the tables will be created dynamically by some other process > >>> and will be deleted after its purpose is over. So is there any other > >>> way or we need to call python script with inspectdb everytime we get a > >>> new request? > > >>> 2) This is possible for only one database as it would inspect database > >>> pointed by DATABASE_NAME setting and create models. Can this be done > >>> if we have one database per session? > > >>> Thanks again, > >>> ds99 > > >>> On May 26, 8:13 am, Alex Gaynor <alex.gay...@gmail.com> wrote: > > >>>> On Mon, May 25, 2009 at 10:07 PM, ds99 <cozydarsh...@gmail.com> wrote: > > >>>>> Hi, > >>>>> I am new to django.I have a requirement where in have to access tables > >>>>> which are not created using django models, using django APIs. > > >>>>> For eg: I already have tables "book_111" and "book_222" created in > >>>>> sqlite db by some different process. Both having same schema.I want to > >>>>> access them to retrieve records using django database APIs. How can i > >>>>> do that? > >>>>> Do i need to add their schema in models.py? Can one model be used to > >>>>> refer to multiple tables in database? > > >>>>> Please let me know. > > >>>>> Thanks, > >>>>> ds99 > > >>>> Yes, you can use those models with django, you'll need to create Model > >>>> classes for them > >>>> though,http://docs.djangoproject.com/en/dev/ref/django-admin/#inspectdbcanas... > >>>> with this task. No one model can't be used to refer to multiple tables. > > >>>> Alex > > >>>> -- > >>>> "I disapprove of what you say, but I will defend to the death your right > >>>> to > >>>> say it." --Voltaire > >>>> "The people's good is the highest law."--Cicero > > >>> . > > >> hi > > >> If there is table in the database you are connected to django will > >> not create a new one.If you are using django1.1 you can manually set > >> whether to create a table or not in the db(manged option in class > >> meta).Is complete table is being drop or only the data is being > >> deleted.what you to do with these tables.Explanation is required. > > > . > > See first of all table name will be same.Django displays latest data of > the table only.If the table content has been changed then it will the > latest one but the schema of the table should be same as > before.According to you a table is created on request by some thing for > that you can have a cron that will change the content of the table after > specific time so that your work is not intrupt. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
