search

andialbrecht / crunchyfrog

Head over to RunSQLRun, the successor of CrunchyFrog
http://runsqlrun.org
GNU General Public License v3.0
4 stars 2 forks source link

Display/surface column information (pk, type etc) #82

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
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 darren.w...@gmail.com on 17 Dec 2009 at 3:16

Attachments:

GoogleCodeExporter commented 9 years ago 
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

GoogleCodeExporter commented 9 years ago 
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 darren.w...@gmail.com on 2 Feb 2010 at 11:52

GoogleCodeExporter commented 9 years ago 
That's great!! Take your time :)

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