Why not define it as you would with any table? If it's already within
the database, add a migrate=False option :)
On May 18, 7:50 am, Tito Garrido <titogarr...@gmail.com> wrote:
> Hi Folks! Thank you for yours answers!
>
> In fact what a really want is to get db data from a previously defined
> database on db.py.
> I have a table there called "album" and I'd like to get those albums to
> build a menu like on Maximo's example, but getting it from a table defined
> on db.py.
>
> Any ideas?
>
> Tito
>
>
>
> On Sun, May 17, 2009 at 11:47 PM, Jason Brower <encomp...@gmail.com> wrote:
>
> > Shucks, you beat me to it!
>
> > On Sun, 2009-05-17 at 19:32 -0700, mdipierro wrote:
> > > Yes, I think some like this should do it.
>
> > > db.define_table('menu_item',
> > > SQLField('name'),
> > > SQLField('link'),
> > > SQLField('position','integer'),
> > > SQLField('parent','integer',default=0))
>
> > > def menu(table=db.menu_item):
> > > items=table._db(table.id>0).select(orderby=table.parent|
> > > table.position).as_list()
> > > parent=0
> > > p={0:[]}
> > > for item in items:
> > > p[item.id]=[]
> > > p[item.parent].append([item.name,True,item.link,p[item.id]])
> > > return MENU(p[0])
>
> > > {{=menu(db.menu_item)}}
>
> > > On May 17, 8:23 pm, Tito Garrido <titogarr...@gmail.com> wrote:
> > > > Hi...
>
> > > > How can I use DB data on menu?
> > > > I'd like to use db data to build a submenu on menu.py...
>
> > > > Thanks!
>
> > > > Tito
>
> > > > --
> > > > Linux User #387870
> > > > .........____
> > > > .... _/_õ|__|
> > > > ..º[ .-.___.-._| . . . .
> > > > .__( o)__( o).:_______
> > > > Sent from Salvador, BA, Brazil
>
> --
> Linux User #387870
> .........____
> .... _/_õ|__|
> ..º[ .-.___.-._| . . . .
> .__( o)__( o).:_______
> Sent from Campinas, SP, Brazil
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
