Your oppinion counts

xenon · 01-20-2008, 12:32 AM

Howdy everybody. So, I have a DAL system setup, right? I need your thoughts about its implementation, and whether you would want to modify the factory or the interface if you were to develop an Oracle driver for instance - or any other database driver - (it's all about extensibility):

- Interface:

PHP Code:


			
interface DB_Driver
{
    public static function getInstance();
    public function connect();
    public function select( array $a );
    public function insert( array $a );
    public function update( array $a );
    public function delete( array $a );
}

- Factory:

PHP Code:


			
final class DB
{
    public static function getInstance( $type = 'mysql' )
    {
        // require the database driver
        self::$instance =& mysql_driver::getInstance();
    }
}

- and, of course, the mysql driver (the default one):

PHP Code:


			
class mysql_driver implements DB_Driver
{
    // singleton, implements the interface methods and its own methods (if you need anything, just write it :)
}

Only some excerpts are shown here, the real code doesn't matter that much. The idea itself is more important than the actual code.