library/adodb/tests/test-xmlschema.php

   1 <?PHP
   2
   3 // V4.50 6 July 2004
   4
   5 error_reporting(E_ALL);
   6 include_once( "../adodb.inc.php" );
   7 include_once( "../adodb-xmlschema03.inc.php" );
   8
   9 // To build the schema, start by creating a normal ADOdb connection:
  10 $db = ADONewConnection( 'mysql' );
  11 $db->Connect( 'localhost', 'root', '', 'test' ) || die('fail connect1');
  12
  13 // To create a schema object and build the query array.
  14 $schema = new adoSchema( $db );
  15
  16 // To upgrade an existing schema object, use the following
  17 // To upgrade an existing database to the provided schema,
  18 // uncomment the following line:
  19 #$schema->upgradeSchema();
  20
  21 print "<b>SQL to build xmlschema.xml</b>:\n<pre>";
  22 // Build the SQL array
  23 $sql = $schema->ParseSchema( "xmlschema.xml" );
  24
  25 var_dump( $sql );
  26 print "</pre>\n";
  27
  28 // Execute the SQL on the database
  29 //$result = $schema->ExecuteSchema( $sql );
  30
  31 // Finally, clean up after the XML parser
  32 // (PHP won't do this for you!)
  33 //$schema->Destroy();
  34
  35
  36
  37 print "<b>SQL to build xmlschema-mssql.xml</b>:\n<pre>";
  38
  39 $db2 = ADONewConnection('mssql');
  40 $db2->Connect('','adodb','natsoft','northwind') || die("Fail 2");
  41
  42 $db2->Execute("drop table simple_table");
  43
  44 $schema = new adoSchema( $db2 );
  45 $sql = $schema->ParseSchema( "xmlschema-mssql.xml" );
  46
  47 print_r( $sql );
  48 print "</pre>\n";
  49
  50 $db2->debug=1;
  51
  52 foreach ($sql as $s)
  53 $db2->Execute($s);
  54 ?>