Re: New PDO-based DBAL/ORM for PEAR2

Le 21 nov. 07 à 09:11, Bertrand Mansion a écrit :

Singleton doesn't create a new database instance. Instead, if you are connecting with the same DSN, username, and password, it will return the same database connection that has already been established with that combination. It's nice so that you don't create multiple database connections with the exact same connection parameters.

I use named connections for that and only one method : getConnection($id = '__default__) IMO, no need for a meaningless singleton method. It's appealing at first to use such method names in your code but it just confuse users in the end because they have no idea what a singleton is or what will be returned.

Actually I use Session objects which hold each a distinct pdo object. Sessions are created with Phreez::connect($pdo, $id = '__default__'). Then, if I want to switch to another session, I use Phreez::useSession($id = '__default__). Thinking about it, my Session objects might look like your Domains and hold information about objects already loaded(?). For handling relations, I don't use RoR has_many etc, I think it's not good. I use a RelationRegistry that hods information about all the relations between objects in the database. Relations are represented as objects, they are able to automatically create joined queries for select, updates, etc. The RelationRegistry can be queried at any time by any other object. -- Bertrand Mansion Mamasam Work : http://www.mamasam.com Blog : http://golgote.freeflux.net