diff options
| author | Damien Regad <dregad@mantisbt.org> | 2024-12-15 13:16:09 +0100 |
|---|---|---|
| committer | Damien Regad <dregad@mantisbt.org> | 2024-12-15 13:16:09 +0100 |
| commit | 474537615f700e9f87218249acb2a3a7052b9067 (patch) | |
| tree | 7932d009ded6498220b6199307be57e702021803 /datadict | |
| parent | ddb3bd3c5a94b64960f90f5ccbaef7f19bee50f8 (diff) | |
| download | adodb-474537615f700e9f87218249acb2a3a7052b9067.tar.gz adodb-474537615f700e9f87218249acb2a3a7052b9067.tar.bz2 adodb-474537615f700e9f87218249acb2a3a7052b9067.zip | |
Coding guidelines
Diffstat (limited to 'datadict')
| -rw-r--r-- | datadict/datadict-sqlite.inc.php | 80 |
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) { |
