[Phpgroupware-cvs] phpgwapi/inc/sql class.sql_mssql.inc.php class....

[Dave Hall]

CVSROOT:        /sources/phpgwapi
Module name:    phpgwapi
Changes by:     Dave Hall <skwashd>     06/12/26 11:37:44

Added files:
        inc/sql        : class.sql_mssql.inc.php class.sql_mysql.inc.php 
                         class.sql_oracle.inc.php 
                         class.sql_pgsql.inc.php class.sql_sapdb.inc.php 

Log message:
        don't know why these files didn't commit the first time, moving them 
from inc to inc/sql

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/phpgwapi/inc/sql/class.sql_mssql.inc.php?cvsroot=phpgwapi&rev=1.1
http://cvs.savannah.gnu.org/viewcvs/phpgwapi/inc/sql/class.sql_mysql.inc.php?cvsroot=phpgwapi&rev=1.1
http://cvs.savannah.gnu.org/viewcvs/phpgwapi/inc/sql/class.sql_oracle.inc.php?cvsroot=phpgwapi&rev=1.1
http://cvs.savannah.gnu.org/viewcvs/phpgwapi/inc/sql/class.sql_pgsql.inc.php?cvsroot=phpgwapi&rev=1.1
http://cvs.savannah.gnu.org/viewcvs/phpgwapi/inc/sql/class.sql_sapdb.inc.php?cvsroot=phpgwapi&rev=1.1

Patches:
Index: class.sql_mssql.inc.php
===================================================================
RCS file: class.sql_mssql.inc.php
diff -N class.sql_mssql.inc.php
--- /dev/null   1 Jan 1970 00:00:00 -0000
+++ class.sql_mssql.inc.php     26 Dec 2006 11:37:44 -0000      1.1
@@ -0,0 +1,41 @@
+<?php
+       /**
+       * SQL Generator for MS SQL Server
+       * @author Edgar Antonio Luna Diaz <address@hidden>
+       * @author Alejadro Borges
+       * @author Jonathan Alberto Rivera Gomez
+       * @copyright Copyright (C) 2003,2004 Free Software Foundation, Inc. 
http://www.fsf.org/
+       * @license http://www.fsf.org/licenses/gpl.html GNU General Public 
License
+       * @package phpgwapi
+       * @subpackage database
+       * @version $Id: class.sql_mssql.inc.php,v 1.1 2006/12/26 11:37:44 
skwashd Exp $
+       * @internal Development of this application was funded by 
http://www.sogrp.com
+       * @link http://www.sogrp.com/
+       */
+
+       /**
+       * SQL Generator for MS SQL Server
+       *
+       * @package phpgwapi
+       * @subpackage database
+       * @ignore
+       */
+       class sql extends sql_
+       {
+               function sql_()
+               {
+               }
+
+               function concat($elements)
+               {
+                       $str = implode(' + ', $elements);
+                       return ($str)? '('.$str.')' : '';
+               }
+
+               function concat_null($elements)
+               {
+                       $str = implode(' + ', sql::safe_null($elements));
+                       return ($str)? '('.$str.')' : '';
+               }
+       }
+?>

Index: class.sql_mysql.inc.php
===================================================================
RCS file: class.sql_mysql.inc.php
diff -N class.sql_mysql.inc.php
--- /dev/null   1 Jan 1970 00:00:00 -0000
+++ class.sql_mysql.inc.php     26 Dec 2006 11:37:44 -0000      1.1
@@ -0,0 +1,41 @@
+<?php
+       /**
+       * SQL Generator for MySQL
+       * @author Edgar Antonio Luna Diaz <address@hidden>
+       * @author Alejadro Borges
+       * @author Jonathan Alberto Rivera Gomez
+       * @copyright Copyright (C) 2003,2004 Free Software Foundation, Inc. 
http://www.fsf.org/
+       * @license http://www.fsf.org/licenses/gpl.html GNU General Public 
License
+       * @package phpgwapi
+       * @subpackage database
+       * @version $Id: class.sql_mysql.inc.php,v 1.1 2006/12/26 11:37:44 
skwashd Exp $
+       * @internal Development of this application was funded by 
http://www.sogrp.com
+       * @link http://www.sogrp.com/
+       */
+
+       /**
+       * SQL Generator for MySQL
+       *
+       * @package phpgwapi
+       * @subpackage database
+       */
+       class sql extends sql_
+       {
+               function sql_()
+               {
+               }
+
+               function concat($elements)
+               {
+                       $str =  implode(', ', $elements);
+                       return ($str) ? 'concat('.$str.')' : '';
+
+               }
+
+               function concat_null($elements)
+               {
+                       $str =  implode(', ', sql::safe_null($elements));
+                       return ($str) ? 'concat('.$str.')' : '';
+               }
+       }
+?>

Index: class.sql_oracle.inc.php
===================================================================
RCS file: class.sql_oracle.inc.php
diff -N class.sql_oracle.inc.php
--- /dev/null   1 Jan 1970 00:00:00 -0000
+++ class.sql_oracle.inc.php    26 Dec 2006 11:37:44 -0000      1.1
@@ -0,0 +1,38 @@
+<?php
+       /**
+       * SQL Generator for Oracle
+       * @author Yoshihiro Kamimura <address@hidden>
+       * @copyright Copyright (C) 2003,2004 Free Software Foundation, Inc. 
http://www.fsf.org/
+       * @license http://www.fsf.org/licenses/gpl.html GNU General Public 
License
+       * @package phpgwapi
+       * @subpackage database
+       * @version $Id: class.sql_oracle.inc.php,v 1.1 2006/12/26 11:37:44 
skwashd Exp $
+       */
+
+       /**
+       * SQL Generator for Oracle
+       *
+       * @package phpgwapi
+       * @subpackage database
+       * @ignore
+       */
+       class sql extends sql_
+       {
+               function sql_()
+               {
+               }
+
+               function concat($elements)
+               {
+                       $str =  implode(', ', $elements);
+                       return ($str) ? 'concat('.$str.')' : '';
+
+               }
+
+               function concat_null($elements)
+               {
+                       $str =  implode(', ', sql::safe_null($elements));
+                       return ($str) ? 'concat('.$str.')' : '';
+               }
+       }
+?>

Index: class.sql_pgsql.inc.php
===================================================================
RCS file: class.sql_pgsql.inc.php
diff -N class.sql_pgsql.inc.php
--- /dev/null   1 Jan 1970 00:00:00 -0000
+++ class.sql_pgsql.inc.php     26 Dec 2006 11:37:44 -0000      1.1
@@ -0,0 +1,45 @@
+<?php
+       /**
+       * SQL Generator for PostrgreSQL
+       * @author Edgar Antonio Luna Diaz <address@hidden>
+       * @author Alejadro Borges
+       * @author Jonathan Alberto Rivera Gomez
+       * @copyright Copyright (C) 2003,2004 Free Software Foundation, Inc. 
http://www.fsf.org/
+       * @license http://www.fsf.org/licenses/gpl.html GNU General Public 
License
+       * @package phpgwapi
+       * @subpackage database
+       * @version $Id: class.sql_pgsql.inc.php,v 1.1 2006/12/26 11:37:44 
skwashd Exp $
+       * @internal Development of this application was funded by 
http://www.sogrp.com
+       * @link http://www.sogrp.com/
+       */
+
+       /**
+       * SQL Generator for PostrgreSQL
+       *
+       * @package phpgwapi
+       * @subpackage database
+       * @ignore
+       */
+       class sql extends sql_
+       {
+               function sql_()
+               {
+               }
+
+               function concat($elements)
+               {
+                       $str = implode(' || ', $elements);
+                       return ($str)? '('.$str.')' : '';
+               }
+
+               function concat_null($elements)
+               {
+                       $str = implode(' || ', sql::safe_null($elements));
+                       return ($str)? '('.$str.')' : '';
+               }
+               function has($field, $value)
+               {
+                       return sql_criteria::upper($field).' ILIKE 
'."'%$value%'";
+               }
+       }
+?>

Index: class.sql_sapdb.inc.php
===================================================================
RCS file: class.sql_sapdb.inc.php
diff -N class.sql_sapdb.inc.php
--- /dev/null   1 Jan 1970 00:00:00 -0000
+++ class.sql_sapdb.inc.php     26 Dec 2006 11:37:44 -0000      1.1
@@ -0,0 +1,25 @@
+<?php
+       /**
+       * SQL Generator for SAPDB
+       * @author Kai Hofmann &lt;address@hidden&gt;
+       * @copyright Copyright (C) 2003,2004 Free Software Foundation, Inc.
+       * @license http://www.gnu.org/licenses/lgpl.html GNU Lesser General 
Public License
+       * @package phpgwapi
+       * @subpackage database
+       * @version $Id: class.sql_sapdb.inc.php,v 1.1 2006/12/26 11:37:44 
skwashd Exp $
+       */
+
+       /**
+       * SQL Generator for SAPDB
+       *
+       * @package phpgwapi
+       * @subpackage database
+       * @ignore
+       */
+       class sql extends sql_
+       {
+               function sql_()
+               {
+               }
+       }
+?>