Subversion-Projekte lars-tiefland.php_share

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?php
2 
 
3 
/**
4 
 * Creates the <kbd>phptest</kbd> table
5 
 *
6 
 * Tries to drop the table first, in case it already exists.
7 
 *
8 
 * <pre>
9 
 * CREATE TABLE phptest (
10 
 *   a INTEGER NULL,
11 
 *   b CHAR(40) DEFAULT 'def' NOT NULL,
12 
 *   c VARCHAR(255) NULL,
13 
 *   d VARCHAR(20) NULL)
14 
 * </pre>
15 
 *
16 
 * Need <kbd>NOT NULL</kbd> on <kbd>b</kbd> to test
17 
 * <kbd>DB_PORTABILITY_RTRIM</kbd>.  MS SQL and Sybase trim output from
18 
 * <kbd>VARCHAR</kbd>, but not on <kbd>CHAR</kbd>.
19 
 *
20 
 * Need <kbd>DEFAULT</kbd> value on <kbd>b</kbd> because Oracle considers
21 
 * an empty string to be <kbd>NULL</kbd>.
22 
 *
23 
 * In Oracle, when using placeholders in <kbd>WHERE</kbd> clauses on
24 
 * <kbd>CHAR</kbd> columns, the column must have <kbd>RTRIM()</kbd> run on
25 
 * the column:
26 
 * <samp>
27 
 *    SELECT * FROM phptest WHERE RTRIM(b) = ?
28 
 * </samp>
29 
 *
30 
 * PHP versions 4 and 5
31 
 *
32 
 * LICENSE: This source file is subject to version 3.0 of the PHP license
33 
 * that is available through the world-wide-web at the following URI:
34 
 * http://www.php.net/license/3_0.txt.  If you did not receive a copy of
35 
 * the PHP License and are unable to obtain it through the web, please
36 
 * send a note to license@php.net so we can mail you a copy immediately.
37 
 *
38 
 * @category   Database
39 
 * @package    DB
40 
 * @author     Daniel Convissor <danielc@php.net>
41 
 * @copyright  1997-2005 The PHP Group
42 
 * @license    http://www.php.net/license/3_0.txt  PHP License 3.0
43 
 * @version    $Id: mktable.inc,v 1.19 2005/02/14 23:33:20 danielc Exp $
44 
 * @link       http://pear.php.net/package/DB
45 
 */
46 
 
47 
/**
48 
 * Establishes the DB object and connects to the database
49 
 */
50 
require_once './connect.inc';
51 
 
52 
/**
53 
 * Get the drop_table() function
54 
 */
55 
require_once './droptable.inc';
56 
 
57 
/**
58 
 * The error handler for the drop table procedure
59 
 *
60 
 * Prints out an error message and dies.
61 
 */
62 
function debug_die($o){
63 
    die($o->toString());
64 
}
65 
 
66 
 
67 
$dbh->setErrorHandling(PEAR_ERROR_RETURN);
68 
drop_table($dbh, 'phptest');
69 
 
70 
//$dbh->setErrorHandling(PEAR_ERROR_TRIGGER);
71 
$dbh->setErrorHandling(PEAR_ERROR_CALLBACK, 'debug_die');
72 
 
73 
if ($dbh->phptype == 'odbc') {
74 
    if ($dbh->dbsyntax == 'odbc') {
75 
        $type = $dbh->phptype;
76 
    } else {
77 
        $type = $dbh->dbsyntax;
78 
    }
79 
} else {
80 
    $type = $dbh->phptype;
81 
}
82 
 
83 
 
84 
switch ($type) {
85 
    case 'access':
86 
        $null = 'NULL';
87 
        $chrc = 'VARCHAR(255)';
88 
        $chrd = 'VARCHAR(20)';
89 
        $default = '';
90 
        $tabletype = '';
91 
        break;
92 
    case 'db2':
93 
    case 'ibase':
94 
        $null = '';
95 
        $chrc = 'VARCHAR(255)';
96 
        $chrd = 'VARCHAR(20)';
97 
        $default = "DEFAULT 'def' NOT NULL";
98 
        $tabletype = '';
99 
        break;
100 
    case 'fbsql':
101 
        $null = '';
102 
        $chrc = 'CHAR(255)';
103 
        $chrd = 'CHAR(20)';
104 
        $default = "DEFAULT 'def' NOT NULL";
105 
        $date_literal = ' DATE ';
106 
        $tabletype = '';
107 
        break;
108 
    case 'ifx':
109 
        // doing this for ifx to keep certain versions happy
110 
        $null = '';
111 
        $chrc = 'CHAR(255)';
112 
        $chrd = 'CHAR(20)';
113 
        $default = "DEFAULT 'def' NOT NULL";
114 
        $tabletype = '';
115 
        break;
116 
    case 'msql':
117 
        $null = '';
118 
        $chrc = 'CHAR(255)';
119 
        $chrd = 'CHAR(20)';
120 
        $default = '';
121 
        $tabletype = '';
122 
        break;
123 
    case 'mysql':
124 
    case 'mysqli':
125 
        $null = 'NULL';
126 
        $chrc = 'VARCHAR(255)';
127 
        $chrd = 'VARCHAR(20)';
128 
        $default = "DEFAULT 'def' NOT NULL";
129 
        if (!empty($needinnodb)) {
130 
            $tabletype = 'TYPE=INNODB';
131 
        } else {
132 
            $tabletype = '';
133 
        }
134 
        break;
135 
    default:
136 
        $null = 'NULL';
137 
        $chrc = 'VARCHAR(255)';
138 
        $chrd = 'VARCHAR(20)';
139 
        $default = "DEFAULT 'def' NOT NULL";
140 
        $tabletype = '';
141 
}
142 
 
143 
switch ($dbh->phptype) {
144 
    case 'dbase':
145 
        // file exists or was created in DB_dbase::connect()
146 
        break;
147 
    default:
148 
        $test_mktable_query = "
149 
            CREATE TABLE phptest (
150 
              a INTEGER $null,
151 
              b CHAR(40) $default,
152 
              c $chrc $null,
153 
              d $chrd $null) $tabletype
154 
        ";
155 
}
156 
 
157 
 
158 
$dbh->query($test_mktable_query);
159 
$dbh->query("INSERT INTO phptest VALUES(42, 'bing', 'This is a test', '1999-11-21')");
160 
 
161 
$dbh->setErrorHandling(PEAR_ERROR_RETURN);