Looks like a good idea to me. Can you drop this in a ticket? (Or just add it)
Kevin
On 1/19/06, Max Ischenko <[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> I wrote a version of DataGrid that supports "dynamic" columns, e.g. a column
> which value depends on the current row being processed. I wonder if it's
> useful enough to be shared and may be integrated with stock DataGrid (it is
> fully backward compatible).
>
> # Usage is like this:
> grid = DataGrid(fields=['userId', ('Homepage', get_user_home_url)])
>
> there is tuple instead of plain string; the second arg is callable which is
> called for each raw (sql object). E.g:
>
> def get_user_home_url(user):
> from kid.pull import XML
> s = '<a href="%s">%s</a>' % (user.url, user.url)
> return XML(s)
>
> Here is implementation:
>
> (the template is the same, the only difference is ${widget.getcol(row, col)}
> instead of getattr)
>
>
> class DataGrid(widgets.Widget):
> """Presents a grid with add/edit/delete controls based on a
> SelectResults object."""
> css=[widgets.CSSLink(widgets.static, "grid.css")]
> template = """
> <div xmlns:py="http://purl.org/kid/ns#";>
> <table id="${widget.name}" class="grid" cellpadding="0" cellspacing="1"
> border="0">
> <thead py:if="headers">
> <td> </td>
> <td py:for="head in headers">
> ${head}
> </td>
> </thead>
> <tr py:for="i, row in enumerate(widget_value)" class="${i%2 and 'odd'
> or 'even'}">
> <td>
> <a href="${std.url([str(row.id), 'edit'])}">
> <img src="${std.tg_static}/images/edit.png" border="0"/>
> </a>
> <a href="${std.url([str(row.id), 'delete'])}">
> <img src="${std.tg_static}/images/discard.png" border="0"/>
> </a>
> </td>
> <td py:for="col in collist">
> ${widget.getcol(row, col)}
> </td>
> </tr>
> </table>
> <p><a href="add" style="text-decoration:none"><img
> src="${std.tg_static}/images/add.png" border="0"/> Add a record</a></p>
> </div>
> """
>
> def __init__(self, fields=None, **kw):
> super(DataGrid, self).__init__(**kw)
> self.fields = fields
> self.dynfields = {}
> self.collist = []
>
> def getcol(self, row, col):
> if col in self.dynfields:
> return self.dynfields[col](row)
> return getattr(row, col)
>
> def update_dict(self, d):
> "Sets up headers based on the select results columns"
> value = d["widget_value"]
> cols = value.sourceClass.sqlmeta.columns
> collist_raw = d.get('fields') or self.fields or list(cols.keys())
> headers = []
> collist = []
> for name in collist_raw:
> if not isinstance(name, tuple):
> column = cols[name]
> header = column.title or column.name.capitalize()
> else:
> header, f = name
> self.dynfields[header] = f
> name = header # to be able to key dynfields dict
> headers.append(header)
> collist.append(name)
> d.update(dict(headers=headers, collist=collist))
>
>
>
--
Kevin Dangoor
Author of the Zesty News RSS newsreader
email: [EMAIL PROTECTED]
company: http://www.BlazingThings.com
blog: http://www.BlueSkyOnMars.com
