Case Study 4

PHTSG stands for the tables Person, House, Town, State and Governor. These 5 tables are created and used by the directions contained in the "PHTSG.inst" instruction file. See the README file to see how to process the .inst file. As Windsurf processes the .inst file Python code is emitted; when done the code can then be examined and run.

Note the generated code uses the gDS data handling scheme.

Note also the schema is understood not as just tables, rows and columns but as People, Houses and Towns.

Additional commands to can be posed to Windsurf that update the original code (e.g. "Also, print the population of each state")

It's ugly but it proves a point. Case Study 5's goal is to do the same thing but "the right way".