ADODB2_sqlite Klassenreferenz

Klassendiagramm für ADODB2_sqlite:

Zusammengehörigkeiten von ADODB2_sqlite:

Öffentliche Methoden
	ActualType ($meta)
	_CreateSuffix ($fname, $ftype, $fnotnull, $fdefault, $fautoinc, $fconstraint, $funsigned)
	AlterColumnSQL ($tabname, $flds)
	DropColumnSQL ($tabname, $flds)
	RenameColumnSQL ($tabname, $oldcolumn, $newcolumn, $flds='')
Datenfelder
	$databaseType = 'sqlite'
	$seqField = false
	$addCol = ' ADD COLUMN'
	$dropTable = 'DROP TABLE IF EXISTS %s'
	$dropIndex = 'DROP INDEX IF EXISTS %s'
	$renameTable = 'ALTER TABLE %s RENAME TO %s'

---

Ausführliche Beschreibung

Definiert in Zeile 18 der Datei datadict-sqlite.inc.php.

---

Dokumentation der Elementfunktionen

ActualType

(

$

meta

)

Returns the actual type given a character code.

C: varchar X: CLOB (character large object) or largest varchar size if CLOB is not supported C2: Multibyte varchar X2: Multibyte CLOB

B: BLOB (binary large object)

D: Date T: Date-time L: Integer field suitable for storing booleans (0 or 1) I: Integer F: Floating point number N: Numeric or decimal number

Erneute Implementation von ADODB_DataDict.

Definiert in Zeile 28 der Datei datadict-sqlite.inc.php.

        {
                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 'C2': return 'VARCHAR'; //  TEXT , TEXT affinity
                case 'X2': return 'LONGTEXT'; //  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 'L': return 'TINYINT'; // 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
                default:
                        return $meta;
                }
        }

RenameColumnSQL	(	$	tabname,
		$	oldcolumn,
		$	newcolumn,
		$	flds = ''
	)

Rename one column

Some DBM's can only do this together with changeing the type of the column (even if that stays the same, eg. mysql)

Parameter:

string	$tabname	table-name
string	$oldcolumn	column-name to be renamed
string	$newcolumn	new column-name
string	$flds,=''	complete column-defintion-string like for AddColumnSQL, only used by mysql atm., default=''

Rückgabe:

array with SQL strings

Erneute Implementation von ADODB_DataDict.

Definiert in Zeile 82 der Datei datadict-sqlite.inc.php.

        {
                if ($this->debug) ADOConnection::outp("RenameColumnSQL not supported natively by SQLite");
                return array(); 
        }

---

Die Dokumentation für diese Klasse wurde erzeugt aufgrund der Datei:

• datadict/datadict-sqlite.inc.php