[Sommaire] [Imprimer]

   1  <?php
   2  //
   3  // Created on: <30-Jan-2004 10:37:22 dr>
   4  //
   5  // SOFTWARE NAME: eZ publish
   6  // SOFTWARE RELEASE: 3.9.0
   7  // BUILD VERSION: 17785
   8  // COPYRIGHT NOTICE: Copyright (C) 1999-2006 eZ systems AS
   9  // SOFTWARE LICENSE: GNU General Public License v2.0
  10  // NOTICE: >
  11  //   This program is free software; you can redistribute it and/or
  12  //   modify it under the terms of version 2.0  of the GNU General
  13  //   Public License as published by the Free Software Foundation.
  14  //
  15  //   This program is distributed in the hope that it will be useful,
  16  //   but WITHOUT ANY WARRANTY; without even the implied warranty of
  17  //   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  18  //   GNU General Public License for more details.
  19  //
  20  //   You should have received a copy of version 2.0 of the GNU General
  21  //   Public License along with this program; if not, write to the Free
  22  //   Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
  23  //   MA 02110-1301, USA.
  24  //
  25  //
  26  
  27  include  ('lib/ezdbschema/classes/ezdbschema.php');
  28  include  ('lib/ezdbschema/classes/ezmysqlschema.php');
  29  include  ('lib/ezdbschema/classes/ezpgsqlschema.php');
  30  include  ('lib/ezdbschema/classes/ezdbschemachecker.php');
  31  
  32  $dbschema1 = new eZDbSchema();
  33  $schema1 = $dbschema1->readArray( '/tmp/schema1.php' );
  34  
  35  $dbschema2 = new eZDbSchema();
  36  $schema2 = $dbschema2->readArray( '/tmp/schema2.php' );
  37  
  38  $differences = eZDbSchemaChecker::diff( $schema1, $schema2 ); /* empty 2nd param force new script */
  39  
  40  $foo = new eZMysqlSchema( nULL );
  41  $foo->writeUpgradeFile( $differences, '/tmp/schema-diff.mysql' );
  42  
  43  $foo = new eZPgsqlSchema( nULL );
  44  $foo->writeUpgradeFile( $differences, '/tmp/schema-diff.pgsql' );
  45  
  46  ?>