Re: XML File format

[Marzullo Laurent <Laurent Marzullo sema be>]

Rodrigo Moya wrote:
> 
> Hi Laurent!
> 
> > Hello,
> >
> > Do you have some documentation about the XML file format of a db created
> > with gnome-db ?
> >
> 
> There are no docs on this, specially since I'm rewriting the XML interface.
> But, for the moment, it is something like this:
> 
> <DATABASE NAME="db_name">
> <TABLE NAME="table1" OWNER="user" SQL="create table ....">
>   <FIELD NAME="field1" GDA_TYPE="gda_type" TYPE="native_type" SIZE="4"
> PRECISION="0" NULLABLE"t or f"/>
>   ...
>   <ROW>
>     <VALUE>1</VALUE>
>     ....
>   </ROW>
>   ....
> </TABLE>
> </DATABASE>
> 

	If I well understand (I don't know XML yet), you store also the
	data of all your table in the XML file ?

	And also the SQL order to create it ?

	It's a kind of dump of a db, isn't it ?

> 
> I imagine this is for your db_designer app, isn't it? 

	Yes.

	But I was thinking about a file, just containing XML description
	of db table without SQL and data.

	something exactly as above, but without SQL="..." and <ROW></ROW>.

	db_designer will not be (as far as I think of it) a SQL front end
	for any rdbms.
	It's just a tool to help db design. One the db will be design,
	either it will call gda-server for creating db directly into the
	rdbms either it will generate a SQL script to create the db (this
	script could be generate by gda-xxxx-server ?)
	I'm not really thinking of this for now ... so It will be more
	clear for me later.


> You may want to use
> the GDA XML interface to save/load this file. You've got a new widget
> GnomeDbXmlViewer which will allow you to display the entire file as well as
> modify it at run-time.

	I Will try it as soon as I achieve my MDI gnome-- Application ...
	:-)

> 
> Cheers

	A+

> 
> --
> To unsubscribe: mail gnome-db-list-request@gnome.org with "unsubscribe"
> as the Subject.

-- 
+----------------------------------+
| Marzullo Laurent                 |
| Analyste-programmeur             |
| SEMA-GROUP Belgium S.A.          |
| Tél: (32) 2 333 52 43            |
| e-mail: Laurent.Marzullo@sema.be |
+----------------------------------+