Display/surface column information (pk, type etc)

[GoogleCodeExporter]

I think it would be useful to display, or make available somehow more
information on columns. It looks like you had this on your radar (looking
at the __gproperties__ on objects.Column). How did you think it is best to
surface the pk, type, default value and nullable information?

One option would be to have a 'ColumnMeta' object and have it has a child
to Column, and just expand it. I did a quick hack to show the data in a
tooltip (attached). Part of thinks the column type should be very obvious -
maybe by icon or as a string in brackets next to the column name?

What are your thoughts on this? :)

Original issue reported on code.google.com by [email protected] on 17 Dec 2009 at 3:16

Attachments:

• cf-column-meta-str.png
• cf-column-meta-tooltip.png

[GoogleCodeExporter]

Yepp, you're right. Detailed information about columns (and much more like 
views) are 
intentionally left out for now. But I like the first version (not the tooltip 
one). 
Would you mind to share your patch for it :)

BTW, I thought of having some kind of detail pages opening in the main notebook 
(where the SQL editor lives). But that's a lot of work to do since it should be 
possible to display various kinds of objects (tables with colunms, constraints, 
... or 
views with their definitions and so on). The hardest part is, once such objects 
are 
displayed you probably want to change them, e.g. renaming a column, adding a 
comment 
on a table or modify a view's definition. But something like that is definitely 
on 
the todo list :)

Original comment by albrecht.andi on 23 Dec 2009 at 9:48

• Changed state: Accepted
• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

Hi,

Sorry for the silence - I took a bit of a break over Christmas and have recently
returned from holiday. I'll put a bit more work into a patch and get it over 
shortly.

Thanks :)

Original comment by [email protected] on 2 Feb 2010 at 11:52

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

That's great!! Take your time :)

Original comment by albrecht.andi on 3 Feb 2010 at 7:00

• Added labels: ****
• Removed labels: ****