This is how I changed SQLTABLE class http://snipt.net/rochacbruno/sqltable
2010/12/6 Bruno Rocha <[email protected]> > One more time: > > in sqlhtml.py we have: > > if headers=='fieldname:capitalize': headers = {} for c > in columns: headers[c] = ' '.join([w.capitalize() for w in > c.split('.')[-1].split('_')]) > > > so what about including the peace of code I mentioned? > > > if headers=='labels': > headers = {} > for c in columns: > tablename = ' '.join([w for w in c.split('.')[0].split('_')]) > fieldname = ' '.join([w for w in c.split('.')[-1].split('_')]) > headers[c] = sqlrows.db[tablename][fieldname].label > > > > > > 2010/12/6 Bruno Rocha <[email protected]> > > I do not want a form, a need to use the plugin_datatable. >> >> Finally what I did: >> >> # In models >> def get_header_labels(table=None): >> headers = {} >> for field in db[table].fields: >> headers[table+'.'+field] = db[table][field].label >> return headers >> >> >> # in My view/controller >> >> list = SQLTABLE(db(db.category.id>0). select(db.category.id, >> db.category.name), >> headers = get_header_labels('category')) >> >> >> >> >> >> >> 2010/12/6 mdipierro <[email protected]> >> >> if you make a form there is a dict in form.custom.label[fielname] or >>> form.custom.label.fielname >>> >>> On Dec 6, 5:19 pm, Bruno Rocha <[email protected]> wrote: >>> > OK, I found that labels are in db.fieldname.label, now I just have to >>> create >>> > a dict. >>> > >>> > 2010/12/6 Bruno Rocha <[email protected]> >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > > HI, >>> > >>> > > I have a 'category' table: >>> > >>> > > db.define_table('category', >>> > > Field('name',label=T('Name')), >>> > > signature, >>> > > format='%(name)s' >>> > > ) >>> > >>> > > which I defined a label for the field 'name' >>> > >>> > > I need to create something like: >>> > >>> > > list = plugin_datatable(db(db.category.id>0).select(db.category.id, >>> > > db.category.name), >>> > > _class='datatable', >>> > > headers = {'category.name':T('Name')}, >>> > > ) >>> > >>> > > Is there a way to pass my previously defined labels to the SQLTABLE? >>> > >>> > > where the 'labels' are stored? I tried db.category.labels, >>> > > db.category['labels'] ? >>> > >>> > > Thanks >>> > >>> > > -- >>> > >>> > > Bruno Rocha >>> > >http://about.me/rochacbruno/bio >>> > >>> > -- >>> > >>> > Bruno Rochahttp://about.me/rochacbruno/bio >>> >> >> >> >> -- >> >> Bruno Rocha >> http://about.me/rochacbruno/bio >> > > > > -- > > Bruno Rocha > http://about.me/rochacbruno/bio > -- Bruno Rocha http://about.me/rochacbruno/bio
