cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Kienenberger <mkien...@gmail.com>
Subject Re: Easily Import/Export tables
Date Tue, 08 Sep 2009 17:49:15 GMT
As an alternative:

I find it far easier to use DBUnit to export and import data in a
database-independent format.   If you use Eclipse, you can install the
QuantumDB plugin and export/import directly from eclipse (for small
tables).

Otherwise, it's trivial to write ant tasks to export and import data.

    <target name="export" description="Copies all global table data to
XML files" depends="">
		<dbunit
			driver="oracle.jdbc.driver.OracleDriver"
			classpath="${Oracle.lib}"
			url="${jdbc.url}"
			schema="schema"
			userid="user"
			password="password">

    		<export dest="./data/dbunit/schema/TABLE1.xml" format="flat">
    			<query name="SCHEMA.TABLE1" sql="SELECT * FROM SCHEMA.TABLE1
ORDER BY ID"/>
    		</export>						
    		<export dest="./data/dbunit/schema/TABLE2.xml" format="flat">
    			<query name="SCHEMA.TABLE2" sql="SELECT * FROM SCHEMA.TABLE2
ORDER BY ID"/>
    		</export>
		</dbunit>
    </target>


    <target name="import" description="Recreates global tables in
Oracle from XML files" depends="">
		<dbunit
			driver="oracle.jdbc.driver.OracleDriver"
			classpath="${Oracle.lib}"
			url="${jdbc.url}"
			schema="schema"
			userid="user"
			password="password">
            <operation type="CLEAN_INSERT"
src="./data/dbunit/schema/TABLE1.xml" "/>
            <operation type="CLEAN_INSERT"
src="./data/dbunit/schema/TABLE2.xml" "/>
		</dbunit>
    </target>

On Mon, Sep 7, 2009 at 5:07 AM, open.pumpkin<open.pumpkin@gmail.com> wrote:
> Hello,
>
> Is it possible to export tables using a dedicated cayenne function ?
>
> I would like to export one or more tables (and data), specified by the user
> of my application, to import them in another environment (for example from
> development to production).
>
> The ideal thing would be a SQL script generated by cayenne, independant of
> databases and cayenne (I could use it with Mysql query browser, for
> example).
>
> Else, using serialization of cayenne objects ?
> Or another possibility ?
>
> The interest is to not manually write SELECT and UPDATE statements.
>
> Thanx.
> O.P.
>

Mime
View raw message