CMS Made Simple Forums

Posted: **Sat Sep 08, 2012 3:41 pm**

Hi folks,

I had a need for an ORM (well, specifically a database-driven tree structure), and I'm a huge fan of Propel (http://www.propelorm.org/).

I've just managed to prototype a module that integrates Propel with CMSMS (1.11.1, but should work on 1.10.x too). This would allow you to do things like (with no new imports):

Code: Select all

		$user = new CmsUsers();
		$user->setUsername("drmikecrowe");
		$user->setPassword($password);
		$user->setAdminAccess(1);
		$user->setFirstName("Mike");
		$user->setLastName("Crowe");
		$user->setActive(1);
		$user->setEmail("mail@domain.com");
		$user->save();

and

Code: Select all

$users = CmsUsersQuery::create()->filterByActive(1)->orderByCreateDate()->find();

Caution: The paint is very wet, and I probably need a week or so to finalize this and massage it into something that might be testable.

LMK, by answering the poll, if there is any interest in this.

TIA
Mike

CMS Made Simple Forums

Any interest in an ORM module? (Propel/ActiveRecord)

Any interest in an ORM module? (Propel/ActiveRecord)