PHP  
 PHP: Test and Code Coverage Analysis
downloads | QA | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | my php.net 
 

LCOV - code coverage report
Current view: top level - ext/pdo_dblib - dblib_stmt.c (source / functions) Hit Total Coverage
Test: PHP Code Coverage Lines: 0 151 0.0 %
Date: 2014-10-30 Functions: 0 10 0.0 %
Legend: Lines: hit not hit

          Line data    Source code
       1             : /*
       2             :   +----------------------------------------------------------------------+
       3             :   | PHP Version 7                                                        |
       4             :   +----------------------------------------------------------------------+
       5             :   | Copyright (c) 1997-2014 The PHP Group                                |
       6             :   +----------------------------------------------------------------------+
       7             :   | This source file is subject to version 3.01 of the PHP license,      |
       8             :   | that is bundled with this package in the file LICENSE, and is        |
       9             :   | available through the world-wide-web at the following url:           |
      10             :   | http://www.php.net/license/3_01.txt                                  |
      11             :   | If you did not receive a copy of the PHP license and are unable to   |
      12             :   | obtain it through the world-wide-web, please send a note to          |
      13             :   | license@php.net so we can mail you a copy immediately.               |
      14             :   +----------------------------------------------------------------------+
      15             :   | Author: Wez Furlong <wez@php.net>                                    |
      16             :   |         Frank M. Kromann <frank@kromann.info>                        |
      17             :   +----------------------------------------------------------------------+
      18             : */
      19             : 
      20             : /* $Id$ */
      21             : 
      22             : #ifdef HAVE_CONFIG_H
      23             : # include "config.h"
      24             : #endif
      25             : 
      26             : #include "php.h"
      27             : #include "php_ini.h"
      28             : #include "ext/standard/php_string.h"
      29             : #include "ext/standard/info.h"
      30             : #include "pdo/php_pdo.h"
      31             : #include "pdo/php_pdo_driver.h"
      32             : #include "php_pdo_dblib.h"
      33             : #include "php_pdo_dblib_int.h"
      34             : #include "zend_exceptions.h"
      35             : 
      36             : 
      37             : /* {{{ pdo_dblib_get_field_name
      38             :  * 
      39             :  * Return the data type name for a given TDS number
      40             :  * 
      41             :  */
      42           0 : static char *pdo_dblib_get_field_name(int type)
      43             : {
      44             :         /* 
      45             :          * I don't return dbprtype(type) because it does not fully describe the type 
      46             :          * (example: varchar is reported as char by dbprtype)
      47             :          * 
      48             :          * FIX ME: Cache datatypes from server systypes table in pdo_dblib_handle_factory()
      49             :          *                 to make this future proof.
      50             :          */
      51             :          
      52           0 :         switch (type) {
      53           0 :                 case 31: return "nvarchar";
      54           0 :                 case 34: return "image";
      55           0 :                 case 35: return "text";
      56           0 :                 case 36: return "uniqueidentifier";
      57           0 :                 case 37: return "varbinary"; /* & timestamp - Sybase AS12 */
      58           0 :                 case 38: return "bigint"; /* & bigintn - Sybase AS12 */
      59           0 :                 case 39: return "varchar"; /* & sysname & nvarchar - Sybase AS12 */
      60           0 :                 case 40: return "date";
      61           0 :                 case 41: return "time";
      62           0 :                 case 42: return "datetime2";
      63           0 :                 case 43: return "datetimeoffset";
      64           0 :                 case 45: return "binary"; /* Sybase AS12 */
      65           0 :                 case 47: return "char"; /* & nchar & uniqueidentifierstr Sybase AS12 */
      66           0 :                 case 48: return "tinyint";
      67           0 :                 case 50: return "bit"; /* Sybase AS12 */
      68           0 :                 case 52: return "smallint";
      69           0 :                 case 55: return "decimal"; /* Sybase AS12 */
      70           0 :                 case 56: return "int";
      71           0 :                 case 58: return "smalldatetime";
      72           0 :                 case 59: return "real";
      73           0 :                 case 60: return "money";
      74           0 :                 case 61: return "datetime";
      75           0 :                 case 62: return "float";
      76           0 :                 case 63: return "numeric"; /* or uint, ubigint, usmallint Sybase AS12 */
      77           0 :                 case 98: return "sql_variant";
      78           0 :                 case 99: return "ntext";
      79           0 :                 case 104: return "bit";
      80           0 :                 case 106: return "decimal"; /* decimal n on sybase */
      81           0 :                 case 108: return "numeric"; /* numeric n on sybase */
      82           0 :                 case 122: return "smallmoney";
      83           0 :                 case 127: return "bigint";
      84           0 :                 case 165: return "varbinary";
      85           0 :                 case 167: return "varchar";
      86           0 :                 case 173: return "binary";
      87           0 :                 case 175: return "char";
      88           0 :                 case 189: return "timestamp";
      89           0 :                 case 231: return "nvarchar";
      90           0 :                 case 239: return "nchar";
      91           0 :                 case 240: return "geometry";
      92           0 :                 case 241: return "xml";
      93           0 :                 default: return "unknown";
      94             :         }
      95             : }
      96             : /* }}} */
      97             : 
      98           0 : static int pdo_dblib_stmt_cursor_closer(pdo_stmt_t *stmt TSRMLS_DC)
      99             : {
     100           0 :         pdo_dblib_stmt *S = (pdo_dblib_stmt*)stmt->driver_data;
     101           0 :         pdo_dblib_db_handle *H = S->H;
     102             : 
     103             :         /* Cancel any pending results */
     104           0 :         dbcancel(H->link);
     105             :         
     106           0 :         return 1;
     107             : }
     108             : 
     109           0 : static int pdo_dblib_stmt_dtor(pdo_stmt_t *stmt TSRMLS_DC)
     110             : {
     111           0 :         pdo_dblib_stmt *S = (pdo_dblib_stmt*)stmt->driver_data;
     112             :         
     113           0 :         efree(S);
     114             :         
     115           0 :         return 1;
     116             : }
     117             : 
     118           0 : static int pdo_dblib_stmt_next_rowset(pdo_stmt_t *stmt TSRMLS_DC)
     119             : {
     120           0 :         pdo_dblib_stmt *S = (pdo_dblib_stmt*)stmt->driver_data;
     121           0 :         pdo_dblib_db_handle *H = S->H;
     122             :         RETCODE ret;
     123             :         
     124           0 :         ret = dbresults(H->link);
     125             : 
     126           0 :         if (FAIL == ret) {
     127           0 :                 pdo_raise_impl_error(stmt->dbh, stmt, "HY000", "PDO_DBLIB: dbresults() returned FAIL" TSRMLS_CC);                
     128           0 :                 return 0;
     129             :         }
     130             :         
     131           0 :         if(NO_MORE_RESULTS == ret) {
     132           0 :                 return 0;
     133             :         }
     134             :                 
     135           0 :         stmt->row_count = DBCOUNT(H->link);
     136           0 :         stmt->column_count = dbnumcols(H->link);
     137             :         
     138           0 :         return 1;
     139             : }
     140             : 
     141           0 : static int pdo_dblib_stmt_execute(pdo_stmt_t *stmt TSRMLS_DC)
     142             : {
     143           0 :         pdo_dblib_stmt *S = (pdo_dblib_stmt*)stmt->driver_data;
     144           0 :         pdo_dblib_db_handle *H = S->H;
     145             :         RETCODE ret;
     146             :         
     147           0 :         dbsetuserdata(H->link, (BYTE*) &S->err);
     148             :         
     149           0 :         pdo_dblib_stmt_cursor_closer(stmt TSRMLS_CC);
     150             :         
     151           0 :         if (FAIL == dbcmd(H->link, stmt->active_query_string)) {
     152           0 :                 return 0;
     153             :         }
     154             :         
     155           0 :         if (FAIL == dbsqlexec(H->link)) {
     156           0 :                 return 0;
     157             :         }
     158             :         
     159           0 :         ret = pdo_dblib_stmt_next_rowset(stmt TSRMLS_CC);
     160             :         
     161           0 :         stmt->row_count = DBCOUNT(H->link);
     162           0 :         stmt->column_count = dbnumcols(H->link);
     163             :         
     164           0 :         return 1;
     165             : }
     166             : 
     167           0 : static int pdo_dblib_stmt_fetch(pdo_stmt_t *stmt,
     168             :         enum pdo_fetch_orientation ori, zend_long offset TSRMLS_DC)
     169             : {
     170             :         
     171             :         RETCODE ret;
     172             :         
     173           0 :         pdo_dblib_stmt *S = (pdo_dblib_stmt*)stmt->driver_data;
     174           0 :         pdo_dblib_db_handle *H = S->H;
     175             :         
     176           0 :         ret = dbnextrow(H->link);
     177             :         
     178           0 :         if (FAIL == ret) {
     179           0 :                 pdo_raise_impl_error(stmt->dbh, stmt, "HY000", "PDO_DBLIB: dbnextrow() returned FAIL" TSRMLS_CC);
     180           0 :                 return 0;
     181             :         }
     182             :                 
     183           0 :         if(NO_MORE_ROWS == ret) {
     184           0 :                 return 0;
     185             :         }
     186             :         
     187           0 :         return 1;       
     188             : }
     189             : 
     190           0 : static int pdo_dblib_stmt_describe(pdo_stmt_t *stmt, int colno TSRMLS_DC)
     191             : {
     192           0 :         pdo_dblib_stmt *S = (pdo_dblib_stmt*)stmt->driver_data;
     193           0 :         pdo_dblib_db_handle *H = S->H;
     194             :         
     195           0 :         if(colno >= stmt->column_count || colno < 0)  {
     196           0 :                 return FAILURE;
     197             :         }
     198             :         
     199           0 :         struct pdo_column_data *col = &stmt->columns[colno];
     200             :         
     201           0 :         col->name =  estrdup(dbcolname(H->link, colno+1));
     202           0 :         col->maxlen = dbcollen(H->link, colno+1);
     203           0 :         col->namelen = strlen(col->name);
     204           0 :         col->param_type = PDO_PARAM_STR;
     205             :                 
     206           0 :         return 1;
     207             : }
     208             : 
     209           0 : static int pdo_dblib_stmt_get_col(pdo_stmt_t *stmt, int colno, char **ptr,
     210             :          zend_ulong *len, int *caller_frees TSRMLS_DC)
     211             : {
     212             :         
     213           0 :         pdo_dblib_stmt *S = (pdo_dblib_stmt*)stmt->driver_data;
     214           0 :         pdo_dblib_db_handle *H = S->H;
     215             :         
     216             :         int coltype;
     217             :         unsigned int tmp_len;
     218           0 :         char *tmp_ptr = NULL;
     219             :         
     220           0 :         coltype = dbcoltype(H->link, colno+1);
     221             :         
     222           0 :         *len = dbdatlen(H->link, colno+1);
     223           0 :         *ptr = dbdata(H->link, colno+1);
     224             :         
     225           0 :         if (*len == 0 && *ptr == NULL) {
     226           0 :                 return 1;
     227             :         }
     228             :         
     229           0 :         switch (coltype) {
     230             :                 case SQLVARBINARY:
     231             :                 case SQLBINARY:
     232             :                 case SQLIMAGE:
     233             :                 case SQLTEXT:
     234             :                         /* FIXME: Above types should be returned as a stream as they can be VERY large */
     235             :                 case SQLCHAR:
     236             :                 case SQLVARCHAR:
     237           0 :                         tmp_ptr = emalloc(*len + 1);
     238           0 :                         memcpy(tmp_ptr, *ptr, *len);
     239           0 :                         tmp_ptr[*len] = '\0';
     240           0 :                         *ptr = tmp_ptr;
     241           0 :                         break;
     242             :                 case SQLMONEY:
     243             :                 case SQLMONEY4:
     244             :                 case SQLMONEYN: {
     245             :                         DBFLT8 money_value;
     246           0 :                         dbconvert(NULL, coltype, *ptr, *len, SQLFLT8, (LPBYTE)&money_value, 8);
     247           0 :                         *len = spprintf(&tmp_ptr, 0, "%.4f", money_value);
     248           0 :                         *ptr = tmp_ptr;
     249           0 :                         break;
     250             :                 }
     251             :                 case SQLUNIQUE: {
     252           0 :                         *len = 37;
     253           0 :                         tmp_ptr = emalloc(*len + 1);
     254           0 :                         *len = dbconvert(NULL, SQLUNIQUE, *ptr, *len, SQLCHAR, tmp_ptr, *len);
     255           0 :                         php_strtoupper(tmp_ptr, *len);
     256           0 :                         tmp_ptr[36] = '\0';
     257           0 :                         *ptr = tmp_ptr;
     258           0 :                         break;
     259             :                 }
     260             :                 default:
     261           0 :                         if (dbwillconvert(coltype, SQLCHAR)) {
     262           0 :                                 tmp_len = 32 + (2 * (*len)); /* FIXME: We allocate more than we need here */
     263           0 :                                 tmp_ptr = emalloc(tmp_len);
     264           0 :                                 *len = dbconvert(NULL, coltype, *ptr, *len, SQLCHAR, tmp_ptr, -1);
     265           0 :                                 *ptr = tmp_ptr;
     266             :                         } else {
     267           0 :                                 *len = 0; /* FIXME: Silently fails and returns null on conversion errors */
     268           0 :                                 *ptr = NULL;
     269             :                         }
     270             :         }
     271             : 
     272           0 :         *caller_frees = 1;
     273             : 
     274           0 :         return 1;
     275             : }
     276             : 
     277           0 : static int pdo_dblib_stmt_param_hook(pdo_stmt_t *stmt, struct pdo_bound_param_data *param,
     278             :                 enum pdo_param_event event_type TSRMLS_DC)
     279             : {
     280           0 :         return 1;
     281             : }
     282             : 
     283           0 : static int pdo_dblib_stmt_get_column_meta(pdo_stmt_t *stmt, zend_long colno, zval *return_value TSRMLS_DC)
     284             : {
     285           0 :         pdo_dblib_stmt *S = (pdo_dblib_stmt*)stmt->driver_data;
     286           0 :         pdo_dblib_db_handle *H = S->H;
     287             :         DBTYPEINFO* dbtypeinfo;
     288             : 
     289           0 :         if(colno >= stmt->column_count || colno < 0)  {
     290           0 :                 return FAILURE;
     291             :         }
     292             : 
     293           0 :         array_init(return_value);
     294             : 
     295           0 :         dbtypeinfo = dbcoltypeinfo(H->link, colno+1);
     296             :         
     297           0 :         if(!dbtypeinfo) return FAILURE;
     298             :                 
     299           0 :         add_assoc_long(return_value, "max_length", dbcollen(H->link, colno+1) );
     300           0 :         add_assoc_long(return_value, "precision", (int) dbtypeinfo->precision );
     301           0 :         add_assoc_long(return_value, "scale", (int) dbtypeinfo->scale );
     302           0 :         add_assoc_string(return_value, "column_source", dbcolsource(H->link, colno+1));
     303           0 :         add_assoc_string(return_value, "native_type", pdo_dblib_get_field_name(dbcoltype(H->link, colno+1)));
     304           0 :         add_assoc_long(return_value, "native_type_id", dbcoltype(H->link, colno+1));
     305           0 :         add_assoc_long(return_value, "native_usertype_id", dbcolutype(H->link, colno+1));
     306             : 
     307           0 :         return 1;
     308             : }
     309             : 
     310             : 
     311             : struct pdo_stmt_methods dblib_stmt_methods = {
     312             :         pdo_dblib_stmt_dtor,
     313             :         pdo_dblib_stmt_execute,
     314             :         pdo_dblib_stmt_fetch,
     315             :         pdo_dblib_stmt_describe,
     316             :         pdo_dblib_stmt_get_col,
     317             :         pdo_dblib_stmt_param_hook,
     318             :         NULL, /* set attr */
     319             :         NULL, /* get attr */
     320             :         pdo_dblib_stmt_get_column_meta, /* meta */
     321             :         pdo_dblib_stmt_next_rowset, /* nextrow */
     322             :         pdo_dblib_stmt_cursor_closer
     323             : };
     324             : 

Generated by: LCOV version 1.10

Generated at Thu, 30 Oct 2014 07:41:36 +0000 (5 hours ago)

Copyright © 2005-2014 The PHP Group
All rights reserved.