summaryrefslogtreecommitdiff
path: root/datadict
diff options
context:
space:
mode:
authorDamien Regad <dregad@mantisbt.org>2024-12-15 13:16:09 +0100
committerDamien Regad <dregad@mantisbt.org>2024-12-15 13:16:09 +0100
commit474537615f700e9f87218249acb2a3a7052b9067 (patch)
tree7932d009ded6498220b6199307be57e702021803 /datadict
parentddb3bd3c5a94b64960f90f5ccbaef7f19bee50f8 (diff)
downloadadodb-474537615f700e9f87218249acb2a3a7052b9067.tar.gz
adodb-474537615f700e9f87218249acb2a3a7052b9067.tar.bz2
adodb-474537615f700e9f87218249acb2a3a7052b9067.zip
Coding guidelines
Diffstat (limited to 'datadict')
-rw-r--r--datadict/datadict-sqlite.inc.php80
1 files changed, 46 insertions, 34 deletions
diff --git a/datadict/datadict-sqlite.inc.php b/datadict/datadict-sqlite.inc.php
index 45b458dd..1d26123b 100644
--- a/datadict/datadict-sqlite.inc.php
+++ b/datadict/datadict-sqlite.inc.php
@@ -32,49 +32,59 @@ class ADODB2_sqlite extends ADODB_DataDict {
public $blobAllowsDefaultValue = true;
public $blobAllowsNotNull = true;
-
- function ActualType($meta)
+
+ 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]))
+
+ // 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': return 'VARCHAR'; // TEXT , TEXT affinity
- case 'XL':return 'LONGTEXT'; // TEXT , TEXT affinity
- case 'X': return 'TEXT'; // TEXT , TEXT affinity
+ 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 'C2': return 'VARCHAR'; // TEXT , TEXT affinity
- case 'X2': return 'LONGTEXT'; // TEXT , TEXT affinity
+ case 'B':
+ return 'LONGBLOB'; // TEXT , NONE affinity , BLOB
- case 'B': return 'LONGBLOB'; // TEXT , NONE affinity , BLOB
+ case 'D':
+ return 'DATE'; // NUMERIC , NUMERIC affinity
+ case 'T':
+ return 'DATETIME'; // NUMERIC , NUMERIC affinity
- case 'D': return 'DATE'; // NUMERIC , NUMERIC affinity
- case 'T': return 'DATETIME'; // NUMERIC , NUMERIC affinity
- case 'L': return 'TINYINT'; // NUMERIC , INTEGER 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 'R':
- case 'I4':
- case 'I': return 'INTEGER'; // NUMERIC , INTEGER affinity
- 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
- case 'F': return 'DOUBLE'; // NUMERIC , REAL affinity
- case 'N': return 'NUMERIC'; // NUMERIC , NUMERIC affinity
- default:
- return $meta;
+ default:
+ return $meta;
}
}
// return string must begin with space
- function _CreateSuffix($fname,&$ftype,$fnotnull,$fdefault,$fautoinc,$fconstraint,$funsigned)
+ function _createSuffix($fname, &$ftype, $fnotnull, $fdefault, $fautoinc, $fconstraint, $funsigned)
{
$suffix = '';
if ($funsigned) $suffix .= ' UNSIGNED';
@@ -85,13 +95,15 @@ class ADODB2_sqlite extends ADODB_DataDict {
return $suffix;
}
- function AlterColumnSQL($tabname, $flds, $tableflds='', $tableoptions='')
+ function alterColumnSQL($tabname, $flds, $tableflds='', $tableoptions='')
{
- if ($this->debug) ADOConnection::outp("AlterColumnSQL not supported natively by SQLite");
+ if ($this->debug) {
+ ADOConnection::outp("AlterColumnSQL not supported natively by SQLite");
+ }
return array();
}
- function DropColumnSQL($tabname, $flds, $tableflds='', $tableoptions='')
+ function dropColumnSQL($tabname, $flds, $tableflds='', $tableoptions='')
{
if (SQLite3::version()['versionNumber'] < 3035000) {
if ($this->debug) {
@@ -102,7 +114,7 @@ class ADODB2_sqlite extends ADODB_DataDict {
return parent::dropColumnSQL($tabname, $flds, $tableflds, $tableoptions);
}
- function RenameColumnSQL($tabname,$oldcolumn,$newcolumn,$flds='')
+ function renameColumnSQL($tabname, $oldcolumn, $newcolumn, $flds='')
{
if (SQLite3::version()['versionNumber'] < 3025000) {
if ($this->debug) {