Insert GIS data in sample dataset

View: New views
2 Messages — Rating Filter:   Alert me  

Insert GIS data in sample dataset

by Sebastien Arbogast :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I'm using DbUnit via dbunit-maven-plugin 1.0-beta1 to insert sample data in my PostgreSQL/Postgis database before I run my tests.

<?xml version="1.0" encoding="UTF-8"?>
<dataset>
    <table name="tag">
        <column>id</column>
        <column>word</column>
        <row>
            <value>1</value>
            <value>tag</value>
        </row>
    </table>
</dataset>

Now I would like to insert sample data with geometry type. For example I have a table whose one column's type is geometry and that is supposed to contain GIS Point data.
Is it possible to insert that kind of data with my sample-data.xml file?

--
Sébastien Arbogast

http://sebastien-arbogast.com
-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
dbunit-user mailing list
dbunit-user@...
https://lists.sourceforge.net/lists/listinfo/dbunit-user

Re: Insert GIS data in sample dataset

by Keith Sader :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Probably the easiest way to do this would be to export some existing GIS data and see what the resultant XML is.

On Fri, Jul 4, 2008 at 12:32 PM, Sebastien ARBOGAST <sebastien.arbogast@...> wrote:
I'm using DbUnit via dbunit-maven-plugin 1.0-beta1 to insert sample data in my PostgreSQL/Postgis database before I run my tests.

<?xml version="1.0" encoding="UTF-8"?>
<dataset>
    <table name="tag">
        <column>id</column>
        <column>word</column>
        <row>
            <value>1</value>
            <value>tag</value>
        </row>
    </table>
</dataset>

Now I would like to insert sample data with geometry type. For example I have a table whose one column's type is geometry and that is supposed to contain GIS Point data.
Is it possible to insert that kind of data with my sample-data.xml file?

--
Sébastien Arbogast

http://sebastien-arbogast.com

-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
dbunit-user mailing list
dbunit-user@...
https://lists.sourceforge.net/lists/listinfo/dbunit-user




--
Keith Sader
ksader@...
http://www.sader-family.org/roller/page/ksader
-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
dbunit-user mailing list
dbunit-user@...
https://lists.sourceforge.net/lists/listinfo/dbunit-user