So far we are planning three "untutorials":

TurboGears 2 - Chris Perkins
Relational Database Applications with TurboGears
-------------------------------------------------
This tutorial is intended to be an un-tutorial. The idea is simple.
Bring me a public database, (or 4) and share with the class as we explore
the new admin-level RESTful features that TurboGears2 employs.

At the end of the class, the goal is for everyone to have a working TG2 application,
with a working admin, at least one customized form or table, based on a database
they, or another student brought to class.

I will ask the students to do some prep-work. For those who would like to
share a database, or a database schema, they should bring with them a database
dump, be it a sqlite file on a memory stick, or a pgdump file, or a mysqldump
file. If the students would like to share with the class, that'd be the best
way to run the tutorial, and if people provide me with dumps of reasonable
sizes ahead of time, I will distribute them with the class material.

We will then split up into teams of people working on similar database systems.

Intro Talk
++++++++++
A 10 minute talk to introduce myself and describe what SA and TG2
aim to do for relational databases. I will also discuss goals for the tutorial.

Part I
++++++++
The goal of part one is to break the ice with everyone, getting them into groups
and getting the first database interactions happening.

* Student Database descriptions (10 mins)
* Splitting into groups (5 mins)
* Copying/Loading databases all around (10 mins)
* Install SQLAlchemy and SQLAutocode (5 mins)
* Run sqlautocode on your loaded database. (30 mins)
We will discuss the different options sqlautocode provides,
and take a look at the output it produces.
* Set up TG2 and Quickstart a new App. (20 mins)

Part II
++++++++
The goal of part 2 is to integrate the work done in Part I and
explore the ways we can put the turbogears admin and sprox to good
use.

* Integrate sqlautocode with the quickstarted TG app. (10 mins)
* Fire up the admin, see how it works with the existing schema. (5 mins)
* Modify the TG code to replace the default TG AdminConfig with A customizable one. (10 mins)
* See where the class would like to customize their admin, following necessary parts of:
http://turbogears.org...
http://www.sprox.org/...
http://www.sprox.org/...
as needed (60 minutes)

Bonus
+++++++
If we need extra filler at the end (not likely), or, if people want to meet
after the afternoon session, I will have a mini-tutorial for BootAlchemy. BootAlchemy
allows people to load Yaml files directly into a relational database.

Requirements
+++++++++++++
Laptop with Python 2.5 or 2.6 installed.
Database system of your choice (Postgres, Sqlite, MySQL)
Python drivers for your desired database system installed. (psychopg2, pg8000, pysqlite, mysql-python)

Pinax - Brian Rosner
Code katas for those new to Python or who would like to improve their skills in a specific area