My blog has a new theme! I spent a few hours today working on a design from my friend Dima at TYZ Design, and I’m pretty happy with the results. I plan on making some small changes to the appearance of links, and fix some XHTML validation errors in the next few days.
For those who have seen the previous versions of our site, I hope you will like the new site. My thanks goes out to Dima at TYZ Design for the original design, layout, and graphical elements of our new site!
I’ve been busy working on several PHP/MySQL web development projects. For the last few of them, I have been using PHP Object Generator to generate all of my Database Abstraction Layer/ORM code. One of the new things I have been trying out is modeling my database using UML. I used to sit down with phpMyAdmin and do my database design directly in SQL, but since I am going through POG to create the database, that wasn’t an option anymore.
So I started using Dia, and started modeling my tables as objects. That still left me with entering the field names from the diagram into the form for my local copy of POG. So I recently decided that I should write a script that transformed the dia XML format into a SOAP request to POG (POG has a built-in SOAP interface to its object generator), and then create the files for each class with the returned code.
I’m releasing the code to my little python script. There isn’t much error checking (or comments), and it may break on certain diagrams. Read the source for more details.