1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
|
<?php
/**
* Data Dictionary for SQLite.
*
* This file is part of ADOdb, a Database Abstraction Layer library for PHP.
*
* @package ADOdb
* @link https://adodb.org Project's web site and documentation
* @link https://github.com/ADOdb/ADOdb Source code and issue tracker
*
* The ADOdb Library is dual-licensed, released under both the BSD 3-Clause
* and the GNU Lesser General Public Licence (LGPL) v2.1 or, at your option,
* any later version. This means you can use it in proprietary products.
* See the LICENSE.md file distributed with this source code for details.
* @license BSD-3-Clause
* @license LGPL-2.1-or-later
*
* @copyright 2000-2013 John Lim
* @copyright 2014 Damien Regad, Mark Newnham and the ADOdb community
*/
// security - hide paths
if (!defined('ADODB_DIR')) die();
class ADODB2_sqlite extends ADODB_DataDict {
var $databaseType = 'sqlite';
var $seqField = false;
var $addCol=' ADD COLUMN';
var $dropTable = 'DROP TABLE IF EXISTS %s';
var $dropIndex = 'DROP INDEX IF EXISTS %s';
var $renameTable = 'ALTER TABLE %s RENAME TO %s';
public $blobAllowsDefaultValue = true;
public $blobAllowsNotNull = true;
function actualType($meta)
{
$meta = strtoupper($meta);
// Add support for custom meta types.
// We do this first, that allows us to override existing types
if (isset($this->connection->customMetaTypes[$meta])) {
return $this->connection->customMetaTypes[$meta]['actual'];
}
switch(strtoupper($meta)) {
case 'C':
case 'C2':
return 'VARCHAR'; // TEXT , TEXT affinity
case 'XL':
case 'X2':
return 'LONGTEXT'; // TEXT , TEXT affinity
case 'X':
return 'TEXT'; // TEXT , TEXT affinity
case 'B':
return 'LONGBLOB'; // TEXT , NONE affinity , BLOB
case 'D':
return 'DATE'; // NUMERIC , NUMERIC affinity
case 'T':
return 'DATETIME'; // NUMERIC , NUMERIC affinity
case 'I':
case 'R':
case 'I4':
return 'INTEGER'; // NUMERIC , INTEGER affinity
case 'L':
case 'I1':
return 'TINYINT'; // NUMERIC , INTEGER affinity
case 'I2':
return 'SMALLINT'; // NUMERIC , INTEGER affinity
case 'I8':
return 'BIGINT'; // NUMERIC , INTEGER affinity
case 'F':
return 'DOUBLE'; // NUMERIC , REAL affinity
case 'N':
return 'NUMERIC'; // NUMERIC , NUMERIC affinity
default:
return $meta;
}
}
// return string must begin with space
function _createSuffix($fname, &$ftype, $fnotnull, $fdefault, $fautoinc, $fconstraint, $funsigned, $fprimary, &$pkey)
{
$suffix = '';
if ($funsigned && !($fprimary && $fautoinc)) $suffix .= ' UNSIGNED';
if ($fnotnull) $suffix .= ' NOT NULL';
if (strlen($fdefault)) $suffix .= " DEFAULT $fdefault";
if ($fprimary && $fautoinc) {
$suffix .= ' PRIMARY KEY AUTOINCREMENT';
array_pop($pkey);
}
if ($fconstraint) $suffix .= ' '.$fconstraint;
return $suffix;
}
function alterColumnSQL($tabname, $flds, $tableflds='', $tableoptions='')
{
if ($this->debug) {
ADOConnection::outp("AlterColumnSQL not supported natively by SQLite");
}
return array();
}
function dropColumnSQL($tabname, $flds, $tableflds='', $tableoptions='')
{
if (SQLite3::version()['versionNumber'] < 3035000) {
if ($this->debug) {
ADOConnection::outp("DropColumnSQL is only supported since SQLite 3.35.0");
}
return array();
}
return parent::dropColumnSQL($tabname, $flds, $tableflds, $tableoptions);
}
function renameColumnSQL($tabname, $oldcolumn, $newcolumn, $flds='')
{
if (SQLite3::version()['versionNumber'] < 3025000) {
if ($this->debug) {
ADOConnection::outp("renameColumnSQL is only supported since SQLite 3.25.0");
}
return array();
}
return parent::renameColumnSQL($tabname, $oldcolumn, $newcolumn, $flds);
}
}
|
