/include/adodb/tests/test-xmlschema.php
PHP | 54 lines | 23 code | 18 blank | 13 comment | 2 complexity | c64f9923dda687bb398a44ceb708197a MD5 | raw file
Possible License(s): LGPL-2.1, GPL-2.0, BSD-3-Clause, LGPL-2.0, CC-BY-SA-3.0, AGPL-1.0
- <?PHP
- // V4.50 6 July 2004
- error_reporting(E_ALL);
- include_once( "../adodb.inc.php" );
- include_once( "../adodb-xmlschema03.inc.php" );
- // To build the schema, start by creating a normal ADOdb connection:
- $db = ADONewConnection( 'mysql' );
- $db->Connect( 'localhost', 'root', '', 'test' ) || die('fail connect1');
- // To create a schema object and build the query array.
- $schema = new adoSchema( $db );
- // To upgrade an existing schema object, use the following
- // To upgrade an existing database to the provided schema,
- // uncomment the following line:
- #$schema->upgradeSchema();
- print "<b>SQL to build xmlschema.xml</b>:\n<pre>";
- // Build the SQL array
- $sql = $schema->ParseSchema( "xmlschema.xml" );
- var_dump( $sql );
- print "</pre>\n";
- // Execute the SQL on the database
- //$result = $schema->ExecuteSchema( $sql );
- // Finally, clean up after the XML parser
- // (PHP won't do this for you!)
- //$schema->Destroy();
- print "<b>SQL to build xmlschema-mssql.xml</b>:\n<pre>";
- $db2 = ADONewConnection('mssql');
- $db2->Connect('','adodb','natsoft','northwind') || die("Fail 2");
- $db2->Execute("drop table simple_table");
- $schema = new adoSchema( $db2 );
- $sql = $schema->ParseSchema( "xmlschema-mssql.xml" );
- print_r( $sql );
- print "</pre>\n";
- $db2->debug=1;
- foreach ($sql as $s)
- $db2->Execute($s);
- ?>