Thank you for your help.
I finished a "pre-alpha-like" version (understand, not really tested
version, badly coded and without comments) which seems to work well.
It works with a postGis database (and not with a mySql one, but it could
be
implemented).
I used some of the GeoTools 2 code to handle the postGIS connection, and
made two type conversion function : one for gml types (should be okay) and
one for converting postgis data types to schema types.
I attached the jars and the two documents which helped me to do the second
conversion function in a zip file.
If you want the source code, i'll send it to you. Just mail me.
To use this program with command line :
java -cp jdcbPostgres.jar;pg2schema.jar org.chew.pgutils.Pg2schema
This won't work because of arguments; so try something like :
[...]pgutils.Pg2schema postgre_login postgre_passwd localhost 5432 test_db
table_to_convert
I hope this will work for you (it works for me so it should be fine !)
>From: "Nedjo Rogers" <nedjo@anonymised.com>
>To: <chewbizz@anonymised.com>
>CC: <geoserver-devel@lists.sourceforge.net>
>Subject: Re: [Geoserver-devel] A little question (schemas)
>Date: Mon, 12 May 2003 18:39:27 -0700
>
>In the simple wfs included with GeoClient there is some PHP code to
>generate
>a basic XML schema description that might be a useful reference. I've
>attached the code (XSD.php); see other files in the GeoClient
distribution
>(available on the Sourceforge GeoServer site) for variables and functions
>referenced.
>
>Nedjo Rogers
>----- Original Message -----
>From: Chris Holmes <cholmes@anonymised.com>
>To: W. Steph <>
>Cc: <geoserver-devel@lists.sourceforge.net>
>Sent: Monday, May 12, 2003 1:16 PM
>Subject: Re: [Geoserver-devel] A little question (schemas)
>
> > I know of no such tool that exists, and I think it would be a great
>idea.
> > And I'm positive other users would love it, so if you like we might be
> > able to add it to the geoserver download page. Let us know if you
find
> > any or build one; we'd love to try it out.
> >
> > Chris
> >
> > On Mon, 12 May 2003, W. Steph wrote:
> >
> > > Hello !
> > >
> > > I just need a little tool able to build my xml schemas.
> > > For example, this tool could get the data needed by a schema file
from
>a
> > > shapefile, or a sql file (with a create table request and
>addGeometryColumn
> > > requests), or directly from a PostiGIS DataBase ...
> > >
> > > I don't know if such a tool exists, but if I can't find any... I
will
>build
> > > one myself (let me know if you're interested)
> > >
> > > Regards,
> > > sw
> > >
> > > _________________________________________________________________
> > > MSN Search, le moteur de recherche qui pense comme vous !
> > > http://search.msn.fr/worldwide.asp
> > >
> > > -------------------------------------------------------
> > > Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa
Clara
> > > The only event dedicated to issues related to Linux enterprise
>solutions
> > > www.enterpriselinuxforum.com
> > >
> > > _______________________________________________
> > > Geoserver-devel mailing list
> > > Geoserver-devel@lists.sourceforge.net
> > > https://lists.sourceforge.net/lists/listinfo/geoserver-devel
> > >
> >
> > -------------------------------------------------------
> > Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa Clara
> > The only event dedicated to issues related to Linux enterprise
solutions
> > www.enterpriselinuxforum.com
> >
> > _______________________________________________
> > Geoserver-devel mailing list
> > Geoserver-devel@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/geoserver-devel
> >
><< XSD.php >>
_________________________________________________________________
Hotmail : un compte GRATUIT qui vous suit partout et tout le temps ! http://g.msn.fr/FR1000/9493
(attachments)
pg2schema.zip (191 KB)