1. Introduction¶

The development environment is

• Linux (ubuntu)
• emacs(1) (with home-grown extensions)
• snippets(1) tool (templating)
• terminal/shell/make
• python 2.x/3.x

Although it is possible to use editors other than emacs for the current task, the missing highlighting support and tag navigation make comprehension and work quite hard.

The task can be completed in a terminal with ssh(1) access to sw-amt.ws. It is perfectly possible to use PuTTY under windows.

A more comfortable graphical environment is available with a VNC viewer (e.g. UltraVNC) via SSH-Tunnel.

2. Task¶

1. Create a project directory workpackage in your home directory.

2. Initialize documentation according to Documentation Standard:

   sda init 'Workpackage'
   

3. Create a python file with the snippets tool:

   snn workpackage.py
   

4. Create a sqlite3 database from an SQL file workpackage.sql, with tables person (see table 2.1) and car (see table 2.2):

   Note

   Do not declare the foreign key relation for driver_id explicitely.

   table 2.1 person¶

   column	type	attributes
   _id	INTEGER	AUTOINCREMENT, PRIMARY KEY
   name	TEXT
   first_name	TEXT

   table 2.2 car¶

   column	type	attributes
   _id	INTEGER	AUTOINCREMENT, PRIMARY KEY
   manufacturer	TEXT
   model	TEXT
   driver_id	INTEGER