Solutions Open Source

Référence du fichier Z:/doxygen/typo3_src-4.1.2/typo3/sysext/adodb/adodb/tests/test-datadict.php

Fonctions
	printsqla ($dbType, $sqla)
Variables
	$dict = NewDataDictionary($db)
$dict	debug = 1
	$opts = array('REPLACE','mysql' => 'ENGINE=INNODB', 'oci8' => 'TABLESPACE USERS')
	$flds
	$sqla = $dict->CreateDatabase('KUTU',array('postgres'=>"LOCATION='/u01/postdata'"))
	$sqli = ($dict->CreateTableSQL('testtable',$flds, $opts))
	$sqla = array_merge($sqla,$sqli)
	$sqli = $dict->CreateIndexSQL('idx','testtable','firstname,lastname',array('BITMAP','FULLTEXT','CLUSTERED','HASH'))
	$sqla = array_merge($sqla,$sqli)
	$sqli = $dict->CreateIndexSQL('idx2','testtable','price,lastname')
	$sqla = array_merge($sqla,$sqli)
	$addflds = array(array('height', 'F'),array('weight','F'))
	$sqli = $dict->AddColumnSQL('testtable',$addflds)
	$sqla = array_merge($sqla,$sqli)
	$addflds = array(array('height', 'F','NOTNULL'),array('weight','F','NOTNULL'))
	$sqli = $dict->AlterColumnSQL('testtable',$addflds)
	$sqla = array_merge($sqla,$sqli)
	$ff = file('xmlschema.xml')

---

Documentation des fonctions

printsqla	(	$	dbType,
		$	sqla
	)

---

Documentation des variables

$addflds = array(array('height', 'F','NOTNULL'),array('weight','F','NOTNULL'))

$addflds = array(array('height', 'F'),array('weight','F'))

$dict = NewDataDictionary($db)

$ff = file('xmlschema.xml')

$flds

Valeur initiale :

 "
ID            I           AUTO KEY,
FIRSTNAME     VARCHAR(30) DEFAULT 'Joan',
LASTNAME      VARCHAR(28) DEFAULT 'Chen' key,
averylonglongfieldname X(1024) DEFAULT 'test',
price         N(7.2)  DEFAULT '0.00',
MYDATE        D      DEFDATE,
BIGFELLOW     X      NOTNULL,
TS            T      DEFTIMESTAMP"

$opts = array('REPLACE','mysql' => 'ENGINE=INNODB', 'oci8' => 'TABLESPACE USERS')

$sqla = array_merge($sqla,$sqli)

$sqla = array_merge($sqla,$sqli)

$sqla = array_merge($sqla,$sqli)

$sqla = array_merge($sqla,$sqli)

$sqla = array_merge($sqla,$sqli)

$sqla = $dict->CreateDatabase('KUTU',array('postgres'=>"LOCATION='/u01/postdata'"))

$sqli = $dict->AlterColumnSQL('testtable',$addflds)

$sqli = $dict->AddColumnSQL('testtable',$addflds)

$sqli = $dict->CreateIndexSQL('idx2','testtable','price,lastname')

$sqli = $dict->CreateIndexSQL('idx','testtable','firstname,lastname',array('BITMAP','FULLTEXT','CLUSTERED','HASH'))

$sqli = ($dict->CreateTableSQL('testtable',$flds, $opts))

$dict debug = 1

---