[Phpgroupware-cvs] phpgwapi/inc class.sql.inc.php, 1.3 class.schema_proc.inc.php, 1.11

[fipsfuchs]

Update of phpgwapi/inc

Modified Files:
     Branch: MAIN
            class.sql.inc.php lines: +28 -2
            class.schema_proc.inc.php lines: +26 -2

Log Message:
fixes for postgreSQL DBMS

====================================================
Index: phpgwapi/inc/class.sql.inc.php
diff -u phpgwapi/inc/class.sql.inc.php:1.2 phpgwapi/inc/class.sql.inc.php:1.3
--- phpgwapi/inc/class.sql.inc.php:1.2  Thu Dec 30 06:47:31 2004
+++ phpgwapi/inc/class.sql.inc.php      Thu Mar  3 17:14:26 2005
@@ -21,7 +21,33 @@
        /**
        * Include concrete database class
        */
-       
include(PHPGW_API_INC.'/class.sql_'.$GLOBALS['phpgw_info']['server']['db_type'].'.inc.php');
+       switch($GLOBALS['phpgw_info']['server']['db_type'])
+       {
+               case 'mysql':
+               $file = 'class.sql_mysql.inc.php';
+               break;
+
+               case 'postgres':
+               $file = 'class.sql_pgsql.inc.php';
+               break;
+
+               case 'oracle':
+               $file = 'class.sql_oracle.inc.php';
+               break;
+
+               case 'sapdb':
+               $file = 'class.sql_sapdb.inc.php';
+               break;
+
+               case 'mssql':
+               $file = 'class.sql_mssql.inc.php';
+               break;
+
+               default:
+               //what now?
+       }
+
+       include(PHPGW_API_INC.'/'.$file);


        /**

====================================================
Index: phpgwapi/inc/class.schema_proc.inc.php
diff -u phpgwapi/inc/class.schema_proc.inc.php:1.10 
phpgwapi/inc/class.schema_proc.inc.php:1.11
--- phpgwapi/inc/class.schema_proc.inc.php:1.10 Sun Jan 16 22:08:35 2005
+++ phpgwapi/inc/class.schema_proc.inc.php      Thu Mar  3 17:14:26 2005
@@ -27,7 +27,31 @@

                function schema_proc($dbms)
                {
-                       $this->m_oTranslator    = 
CreateObject('phpgwapi.schema_proc_' . $dbms);
+                       switch($dbms)
+                       {
+                               case 'mysql':
+                               $this->m_oTranslator    = 
CreateObject('phpgwapi.schema_proc_mysql');
+                               break;
+
+                               case 'postgres':
+                               $this->m_oTranslator    = 
CreateObject('phpgwapi.schema_proc_pgsql');
+                               break;
+
+                               case 'oracle':
+                               $this->m_oTranslator    = 
CreateObject('phpgwapi.schema_proc_oracle');
+                               break;
+
+                               case 'sapdb':
+                               $this->m_oTranslator    = 
CreateObject('phpgwapi.schema_proc_sapdb');
+                               break;
+
+                               case 'mssql':
+                               $this->m_oTranslator    = 
CreateObject('phpgwapi.schema_proc_mssql');
+                               break;
+
+                               default:
+                               //what now?
+                       }
                        $this->m_oDeltaProc             = 
CreateObject('phpgwapi.schema_proc_array');
                        $this->m_aTables                = array();
                        $this->m_bDeltaOnly             = False; // Default to 
false here in case it's just a CreateTable script