Following on from this thread, I have now got my version of ActiveRecord (based on RoR’s implementation) to a point where I’d like to get some more pairs of eyes on it.

I’ve written up the class and provided a download here:

ActiveRecord Class on the wiki

I’m using it at the moment on a project in development, and it seems to be working fine - no noticeable impact on performance or query speed, and it makes developing a lot faster without having to write CRUD functions for every single model.

In summary, it means that you can do things like this without having to write all the database interaction code yourself:

Note that it’s PHP5 only.

Really nice addition, but i’m still looking for and update and update_by method, the class only contains methods to create new records, but how you update and existing one?

Thanks again for your contribution

alexsancho - 20 September 2007 08:32 AM

Really nice addition, but i’m still looking for and update and update_by method, the class only contains methods to create new records, but how you update and existing one?

They’re on my development machine at home - I’ll update the class and the wiki when I get in to add the update method.

If you want to work on merging this with Fire (I saw your reply in regards to this) feel free to do so. The code is publicly available and you are more than welcome to take it over (just give me a credit line in your readme).

Buddy Bradley - 20 September 2007 08:40 AM

They’re on my development machine at home - I’ll update the class and the wiki when I get in to add the update method.

I’ve added the basic update() method to the downloadable code and the wiki article now.

Hi!

and how can I use the update() ??

like this???

edit: I forget to say wow! and thanks!!

gunter - 21 September 2007 04:54 AM

and how can I use the update() ??

Like this:

Thanks for this nice library Buddy!

I’ll check it out!

Dan

I’ve been looking over this library since it was released - this is looking really, really, nice.

Any chance of getting some better relationships involved? The relationships table you are employing (similar to RoR’s HABTM relationships) is a bit excessive for just a belongs_to or has_many relationship.

For instance:

Table: pages
id
user_id
title
body

Table: users
id
username
email

Crating a pages_users table is a bit excessive and increases the number of calls made to the database, when a relationship could simply be formed between pages.user_id and users.id columns.

I’ve yet to actually play with this library, so if it’s covered somewhere I haven’t read about yet, feel free to correct me.

Great work though - I will definitely be using this in my next project.

Great work, I really like it and am definitely gonna use it in my next project. I, however, need to tweak it to PHP4. At first glance this seems feasible, or is there anything exotic you used?

walesmd - 21 September 2007 12:17 PM

Any chance of getting some better relationships involved? The relationships table you are employing (similar to RoR’s HABTM relationships) is a bit excessive for just a belongs_to or has_many relationship.

You’re right (and there isn’t any other kind of relationship defined). The difficulty is that there isn’t a built-in :has_many or similar pre-defined relationship archetypes like RoR has.

Perhaps if you specify an array of relationships in the constructor of the model, something like this:

And then the create_relationship() and fetch_related() functions would refer to those relationship properties when building their queries.

Does that make sense?