The keyPath I talked about last time is just to useful to wait on. So I added it. This lets you easly get values from DBObjects within other DBObjects. So on the death date example from last time.
return (DateTime)((DBObject)valueForKey(“user_info”)).valueForKey(“column_death_date”);
is replaced with
return (DateTime)valueForKeyPath(“user_info.column_death_date”);

I think it’s time for a demonstration. In this example I show two ways you can use joined tables within the object. I also so why the KeyPath would be a useful addition to the object.
In User.BirthDate I’m joining two columns from the table users_info directly into the User object. There are problems with this. [...]

Note: I really shouldn’t call this refactoring because it’s an api change.
My SetProperty() and GetProperty() methods are really just my weak attempt to add KVC (Key Value Coding) to the DBObject. This is something built in to objective-c. So I want to rename these methods to reflect their true nature. (The word Property was confusing [...]

DBObject has come a long way recently and there is a lot of duplicated code. So I think now is a good time to refactor.
Let’s start with the most obvious items. There are only 11 methods in the DBObject, 7 of them take string connection, 4 take string index_column, and another 4 take string table. [...]

Last time I said it would be nice to know if the record already exists in the database. When you want a one-to-many relationship, you don’t want to accidentally add the same record more than once. If an object is made that has the exact same values as another record, we shouldn’t add it, but [...]

I’ve added self updating and Insert to the DBObject. I’ve also changed the naming of the columns it pulls from the database. Each column property now starts with “column_”.

Recently someone found my blog by searching google asking how to get the column name from a MySqlDataReader. I doubt they found the answer on my blog, so I figured I’d write about, just in case anyone else needs to know.

Looking into other ORMs and Linq I came across subsonic. I watched the video and build a quick little sample application with it. I had a slight problem at first because it kept giving me an error with my MySql.Data reference. I upgraded my DLL and played around with it some more, still no luck. [...]

I created the GetProperty() and SetProperty() methods to allow the base object to manage holding the variables needed for the object. I’ve implemented these methods on my old object classes just to test them out in some real world examples. I’ve found two problems, the first is that sometimes I only want to set a [...]

I’ve worked on the Joining with attributes a little bit but I’ve run into a problem. Maybe it’s not really a problem but I just think it is.
I can easily get the Join string from the attribute, and the new .WhereJoin uses it. The method gets all the tags for the user as expected.
So whats [...]