Thursday, May 15, 2008

TurboGears 1.0.4.4

The rapid web development megaframework you've been looking for.

These notes refer to TurboGears 1.0.4.4

2008-04-16:
* storm as orm

2008-04-10:
* easy_install tgcrud == for basic crud forms
* tgcrud steps:
* Use the tg-admin crud command to generate the crud package.
* Customize the form field in /controllers folder.
* Import the package to your controllers.py
* Add a sub-controller to your Root controller class.

2008-04-09:
* if you create initial data when declaring your SQLObject classes, at the bottom of your model.py, create a temporary SQLObject class and issue dropTable() and createTable() to unlock the database
* to create unicode strings (for internationalization) prepend the string with the letter u (ie u'Name')
* use datetime.date(yyyy, mm, dd) to encode date values in SQLObject DateCol
* use lower case for all SQLObject class properties
* use underscore not uppercase for all SQLObject class properties
* use single noun when naming your SQLObject classes
* [tg-admin toolbox] automatically creates the database based on your model.py

Problems I have encountered so far:

2008-05-15:
* always changing modules, TG1 uses SQLObject while the not-yet-released TG2 now uses SQLAlchemy
* crud forms without coding, authentication without coding

2008-04-14:
* creating master-detail forms

2008-04-10:
* creating master templates

2008-04-09:
* create database schema from classes
* modify existing database with new classes

Useful Widgets:

2008-04-15:
* http://pythonisito.blogspot.com/2006/02/django-like-automated-admin-interface.html - todo

2008-04-14:
* FancyFlash - todo
* TGFastData == iconized crud forms
* DataGrid

2008-04-10:
* tgcrud == for basic crud forms

Overall, TurboGears is a very promising web development framework using Python.

Labels: , ,

Monday, May 05, 2008

Tersus Visual Programming Platform

100% Visual - No Coding, No Scripting

Tersus is a Visual Programming Platform for creating rich web applications.
Simply draw flow diagrams and Tersus will bring your application to life.
Tersus is open source.

These notes refer to Tersus version 1.0.36.

2008-05-04
* put the Display/Row inside a Display/Grid to align the display elements inside the row to columns.

2008-04-26:
* use trigger to [Find] template to sort found records
* put a database row inside a table row for referenced records for easy retrieval of referenced record (i.e. person database row for person id column)

2008-04-21:
* drop an Advance Table Display and Management template for CRUD of database-based data with paging, sorting and filter
* you must restart the application to create the tables from the template
* Table Row
* Table Row/Data Row
* Database
* Filter Group/Fiilter Row
* Filter Group/Extract Filter Row
* New/Details Grid
* New/Save/Save
* Populate Table/Convert Record to Row
* Update/Init
* Update/Save/Save

2008-04-19
2008-04-18
2008-04-17

And here are a few of my questions/issues to which I havent found the answers at their forum:

2008-05-02:
* how to migrate the database?
* how to do unit testing?
* how to create beautiful reports?

2008-04-22:
* how to have default sort for advanced table column?
* how to hide advanced table column?

As a programmer, I am amazed at the effort to create a really rapid application development platform. But on the sidenote, it still lacks the degree of customization that I need. I would recommend this to those who needs a quick way of putting your own web application without having to learn the major web programming technologies like AJAX.