finally I got the answer... http://www.sqlalchemy.org/trac/wiki/SqlSoup http://spyced.blogspot.com/2006/04/introducing-sqlsoup.html
from sqlalchemy.ext.sqlsoup import SqlSoup db = SqlSoup('oracle://zzzzz:zzzzz@xe') rp = db.bind.execute('select * from mupp') a = rp.fetchall() a[0].kodeupp a[0].nama that's what i looking for...do django has the same function??? I hope so... thanks for all inspiring response 2011/2/1 Jani Tiainen <rede...@gmail.com> > On Monday 31 January 2011 18:21:40 Ian wrote: > > On Jan 31, 3:29 am, arief nur andono <ariefnurand...@gmail.com> wrote: > > > oh please... > > > > > > i need only to query the table, have no access to modified the table > > > > > > why there is no way query the database and then make the output as > > > object?? > > > > You don't need to modify the table. That was just a recommendation. > > I also suggested changing the precision (max_digits) and scale > > (decimal_places) in your models file to match what is actually used in > > your data. If you have no idea what to use, then > > DecimalField(max_digits=38, decimal_places=19) is *probably* safe. > > > > If updating the models is going to be too laborious, then you should > > probably look at a different ORM. I don't know whether SQLAlchemy > > will do a better job introspecting your database, but it's worth a > > shot and can be used in conjunction with TurboGears or Pylons. > > > > Cheers, > > Ian > > In the past I used MyGeneration > <http://sourceforge.net/projects/mygeneration/> to generate models for me. > > It's pretty neat ORM template mapper (Not bound to any particular ORM). > > I'm not sure does it run under Mono or Linux but. But it did very good job > to > produce output like I wanted with a little effort. > > -- > > Jani Tiainen > > -- > 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<django-users%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > > -- 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.