Hello, On 11/05/2002 06:44 PM, Bernardo De Barros Franco wrote:
Metabase does that and much more. It installs a schema from a description in XML of tables, fields, indexes and sequences.I've recently tried to find info about creating databases from XML files and didn't find anything. Since there is no php.XML I'm posting it in the general section. Does anyone know where I can find PHP source code that will parse an XML file and generate SQL queries that would create tables based on the structure described on the XML? Something like: xml = " <Database name='db1'> <Table name='Table1'> <Attribute name='foo1' type='int4' /> </Table> </Database> "; and some function func(xml) would return a set of SQL queries that would create that database in a particular DB (say PostgreSQL or MySQL). Anything similar would help already.
If you change that schema, it is capable of figuring the changes and performing the alterations without disturbing the data that has been added to the database since the database was installed for the first time or installed for the last time.
Metabase is Open Source and is available here:
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php