[Phpgroupware-cvs] phpgwapi/inc class.schema_proc.inc.php, 1.2, 1.3 class.schema_proc_array.inc.php, 1.3, 1.4 class.schema_proc_mssql.inc.php, 1.2, 1.3 class.schema_proc_pgsql.inc.php, 1.6, 1.7

[Dave Hall <address@hidden>]

Update of /cvsroot/phpgroupware/phpgwapi/inc
In directory subversions:/tmp/cvs-serv20560

Modified Files:
        class.schema_proc.inc.php class.schema_proc_array.inc.php 
        class.schema_proc_mssql.inc.php 
        class.schema_proc_pgsql.inc.php 
Log Message:
kai's schema proc changes for SAPDB


Index: class.schema_proc_array.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/phpgwapi/inc/class.schema_proc_array.inc.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** class.schema_proc_array.inc.php     17 May 2003 19:29:58 -0000      1.3
--- class.schema_proc_array.inc.php     10 Oct 2003 08:42:49 -0000      1.4
***************
*** 33,37 ****
                function TranslateDefault($sDefault)
                {
!                       return $sDefault;
                }
  
--- 33,37 ----
                function TranslateDefault($sDefault)
                {
!                       return "'" . $sDefault . "'";
                }
  
***************
*** 67,71 ****
                                unset($aTables[$sTableName]);
                        }
!                       
                        return True;
                }
--- 67,71 ----
                                unset($aTables[$sTableName]);
                        }
! 
                        return True;
                }
***************
*** 180,184 ****
  
                        return True;
!               }       
        }
  ?>
--- 180,184 ----
  
                        return True;
!               }
        }
  ?>

Index: class.schema_proc_pgsql.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/phpgwapi/inc/class.schema_proc_pgsql.inc.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** class.schema_proc_pgsql.inc.php     30 Apr 2003 11:07:24 -0000      1.6
--- class.schema_proc_pgsql.inc.php     10 Oct 2003 08:42:49 -0000      1.7
***************
*** 102,108 ****
                                case 'current_date':
                                case 'current_timestamp':
!                                       return 'now';
                        }
!                       return $sDefault;
                }
  
--- 102,108 ----
                                case 'current_date':
                                case 'current_timestamp':
!                                       return "'now'";
                        }
!                       return "'" . $sDefault . "'";
                }
  
***************
*** 276,282 ****
                                $sql_get_default = "
                                        SELECT d.adsrc AS rowdefault
!                                               FROM pg_attrdef d, pg_class c 
!                                               WHERE 
!                                                       c.relname = 
'$sTableName' AND 
                                                        c.oid = d.adrelid AND
                                                        d.adnum = $colnum
--- 276,282 ----
                                $sql_get_default = "
                                        SELECT d.adsrc AS rowdefault
!                                               FROM pg_attrdef d, pg_class c
!                                               WHERE
!                                                       c.relname = 
'$sTableName' AND
                                                        c.oid = d.adrelid AND
                                                        d.adnum = $colnum
***************
*** 307,317 ****
                        }
                        $sql_pri_keys = "
!                               SELECT 
!                                       ic.relname AS index_name, 
!                                       bc.relname AS tab_name, 
                                        ta.attname AS column_name,
                                        i.indisunique AS unique_key,
                                        i.indisprimary AS primary_key
!                               FROM 
                                        pg_class bc,
                                        pg_class ic,
--- 307,317 ----
                        }
                        $sql_pri_keys = "
!                               SELECT
!                                       ic.relname AS index_name,
!                                       bc.relname AS tab_name,
                                        ta.attname AS column_name,
                                        i.indisunique AS unique_key,
                                        i.indisprimary AS primary_key
!                               FROM
                                        pg_class bc,
                                        pg_class ic,
***************
*** 319,323 ****
                                        pg_attribute ta,
                                        pg_attribute ia
!                               WHERE 
                                        bc.oid = i.indrelid
                                        AND ic.oid = i.indexrelid
--- 319,323 ----
                                        pg_attribute ta,
                                        pg_attribute ia
!                               WHERE
                                        bc.oid = i.indrelid
                                        AND ic.oid = i.indexrelid
***************
*** 327,331 ****
                                        AND ta.attrelid = i.indrelid
                                        AND ta.attnum = i.indkey[ia.attnum-1]
!                               ORDER BY 
                                        index_name, tab_name, column_name";
                        $sdc->query($sql_pri_keys);
--- 327,331 ----
                                        AND ta.attrelid = i.indrelid
                                        AND ta.attnum = i.indkey[ia.attnum-1]
!                               ORDER BY
                                        index_name, tab_name, column_name";
                        $sdc->query($sql_pri_keys);
***************
*** 605,609 ****
  
                                $query .= "UPDATE $sTableName SET 
$sColumnName='$default';\n";
!                               
                                $Ok = !!($oProc->m_odb->query($query));
  
--- 605,609 ----
  
                                $query .= "UPDATE $sTableName SET 
$sColumnName='$default';\n";
! 
                                $Ok = !!($oProc->m_odb->query($query));
  

Index: class.schema_proc_mssql.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/phpgwapi/inc/class.schema_proc_mssql.inc.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** class.schema_proc_mssql.inc.php     11 Apr 2002 14:12:34 -0000      1.2
--- class.schema_proc_mssql.inc.php     10 Oct 2003 08:42:49 -0000      1.3
***************
*** 108,115 ****
                                case 'current_date':
                                case 'current_timestamp':
!                               return 'GetDate()';
                        }
  
!                       return $sDefault;
                }
  
--- 108,115 ----
                                case 'current_date':
                                case 'current_timestamp':
!                               return "'GetDate()'";
                        }
  
!                       return "'" . $sDefault . "'";
                }
  

Index: class.schema_proc.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/phpgwapi/inc/class.schema_proc.inc.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** class.schema_proc.inc.php   11 Apr 2002 14:12:34 -0000      1.2
--- class.schema_proc.inc.php   10 Oct 2003 08:42:49 -0000      1.3
***************
*** 390,394 ****
                                        // Get default DDL - useful for 
differences in date defaults (eg, now() vs. getdate())
                                        $sTranslatedDefault = 
$this->m_oTranslator->TranslateDefault($sDefault);
!                                       $sFieldSQL .= " DEFAULT 
'$sTranslatedDefault'";
                                }
                                elseif($sDefault == '0')
--- 390,394 ----
                                        // Get default DDL - useful for 
differences in date defaults (eg, now() vs. getdate())
                                        $sTranslatedDefault = 
$this->m_oTranslator->TranslateDefault($sDefault);
!                                       $sFieldSQL .= " DEFAULT 
$sTranslatedDefault";
                                }
                                elseif($sDefault == '0')