'tg-admin gui'

CatWalk

A model browser for TurboGears

CatWalk is a single page (buzzword compliant) Ajax application build on top of TurboGears.

With it you can easily interact with your application model and manage your data.
Think of it as phpMyAdmin or pgAdmin at the ORM level instead of the RDBMS. It is database agnostic, all it's information is pulled out of SQLObject - not from the underlying data store.

CatWalk will be included in the next release of TurboGears 0.9.

Highlights

Take a look at some of the features coming with the 0.9 release of TurboGears.
If you can't wait, check out TurboGears from the repository and start playing.

Browse and manage your model data CatWalk let you display, create, update or delete your model instances from within your web browser.

Manage multiple joins (one to many) CatWalk knows how to handle one to many relations. For example if you preview your 'Author' instance it will display a list of it's books along it's other attributes.

Manage related joins (many to many) Do you need to configure which users belongs to a certain role? No problems, preview your 'role' instance and move users in or out of it.

Configure your views Reorder your columns by drag and drop, pick which column you want in a grid view, or choose which field to use as a label for your foreignKeys. Instead of seen 'Moby Dick' by author 5, you get 'Moby Dick' by 'Herman Melville'

SQL monitor Are you old school and convinced that real man should write their own SQL? Don't trust SQLObject? Keep an eye on it by monitoring the queries SQLObject generates for your.

Future development

Future development of CatWalk will be in the context of TurboGears. CatWalk will be one of several tools made available by TurboGears trough a web based admin interface

Short term, I'll be working on documentation, conformance with the functionality provided by SQLObject and getting the codebase ready for the 0.9 release of TurboGears.

For the future I have my eye on the following features:

• Graphic query builder with support for saving queries
• Import export of csv or xml data
• An easy way to let you display the result of your saved queries in your own apps.
  For example it could be nice to be able to write in your kid template something like this:
  

  ${turbogears.catwalk.render_query_view(query_name='female employees younger than 30',
                                                   table_id='chouvinist_table',
                                                   number_of_rows=30)}
       

• schema-model manipulation: create, alter your models from within CatWalk and define relations