Re: [PDO] Re: [PHP-DEV] [PATCH] New PDO methods for PostgreSQL driver

The other examples need to be included in the wiki somewhere for discussion ...

Denis Gasparin wrote:
> Another way could be to maintain a generic PDO driver with a standard dsn (for example "username:password@host/dbname" or the PDO standard "db:host=..,dbname=...") and then to inject a "strategy" to use for database connection and other specific DBMS functions.
>
> For example:
>
> $fbDb = new PDOFirebirdDatabase();
>
> $dbhpool = new PDO('user:pwd@pool/dbname',$fbDb);
>
> $dbhpool->db->attachChild(new PDOFirebirdConnection(..));
> $dbhpool->db->attachChild(new PDOFirebirdConnection(..));
> $dbhpool->db->beginTransaction());

The only problem I see with this is that one would normally be carrying out 
activity on one or other connections to check information, before carrying out 
an update that requires a 2 phase commit. And the operations are still carried 
out on one or other connection, so the $dbhpool->db-> still needs to know WHICH 
connection to carry the query out on.

 From one of the other examples ...
> Or the same as transaction object...
>
> $tobj = new PDOCrossTransaction();
> $tobj->attach($dbh1);
> $tobj->attach($dbh2);
> $tobj->beginTransaction($options);
>
> + Can change the function declaration for transaction options
Provided that $dbh1 and $dbh2 can be used within the transaction to identify the 
connection required. Firebird/Interbase normally has both the connection AND 
transaction passed to any activity so that 'query' for instance knows which 
transaction is active. So $dbh1->beginTransaction() would need to know that 
there is a PDOCrossTransaction active already.

-- 
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php