[Cayenne-cvs] cayenne/src/tutorials/cayenne-cmd-app build.xml,NONE,1.1 cayenne.xml,NONE,1.1 datamap.xml,NONE,1.1 driverinfo.xml,NONE,1.1 tutorialdb.sql,NONE,1.1

[<me...@us...>]

Update of /cvsroot/cayenne/cayenne/src/tutorials/cayenne-cmd-app
In directory usw-pr-cvs1:/tmp/cvs-serv26389/src/tutorials/cayenne-cmd-app

Added Files:
	build.xml cayenne.xml datamap.xml driverinfo.xml 
	tutorialdb.sql 
Log Message:
relocated tutorials to a subproject
(old tutorials are still around but will be deleted soon)


--- NEW FILE: build.xml ---
<?xml version="1.0"?>


<!-- =============================================== -->
<!-- cayenne-cmd-app tutorial buildfile.             -->
<!-- =============================================== -->
<project name="cayenne-cmd-app" default="compile">
    <property name="tutorial.subpath" value="tutorials/cayenne-cmd-app"/>
    <property name="tutorial.build" value="${build}/${tutorial.subpath}/classes"/>
    <property name="tutorial.src" value="src/${tutorial.subpath}/java"/>
    
    
    <path id="classpath">
		<fileset dir="otherlib">
			<include name="*.jar"/>
		</fileset>
		<pathelement path="${build}/cayenne/classes"/>
    </path>
    
    
    <target name="prepare">
    	<mkdir dir="${tutorial.build}"/>
    </target>
    
    
	<target name="compile" depends="prepare">
		<javac	srcdir="${tutorial.src}" 
				destdir="${tutorial.build}" 
				debug="on" 
				deprecation="on">
			<classpath refid="classpath"/>
		</javac>
	</target>
	
	<target name="dist-src">
	
	</target>

	<target name="dist-bin" depends="compile">

	</target>
</project>
--- NEW FILE: cayenne.xml ---
<?xml version="1.0" encoding="utf-8"?>
<domains>
<domain name="DefaultDomain">
	 <map name="datamap"  location="datamap.xml"/> 
	<node name="datanode"
		 datasource="driverinfo.xml"
		 adapter="org.objectstyle.cayenne.dba.mysql.MySQLAdapter"
		 factory="org.objectstyle.cayenne.conf.DriverDataSourceFactory">
			<map-ref name="datamap"/>
	 </node>
</domain>
</domains>

--- NEW FILE: datamap.xml ---
<?xml version="1.0" encoding="UTF-8"?>
<data-map>
	<db-entity name="ARTIST" schema="">
		<db-attribute name="DATE_OF_BIRTH" type="TIME" length="8"/>
		<db-attribute name="ARTIST_ID" type="INTEGER" isPrimaryKey="true" isMandatory="true" length="11"/>
		<db-attribute name="ARTIST_NAME" type="CHAR" isMandatory="true" length="255"/>
	</db-entity>
	<db-entity name="GALLERY" schema="">
		<db-attribute name="GALLERY_ID" type="INTEGER" isPrimaryKey="true" isMandatory="true" length="11"/>
		<db-attribute name="GALLERY_NAME" type="VARCHAR" isMandatory="true" length="100"/>
	</db-entity>
	<db-entity name="PAINTING" schema="">
		<db-attribute name="PAINTING_TITLE" type="VARCHAR" isMandatory="true" length="255"/>
		<db-attribute name="GALLERY_ID" type="INTEGER" length="11"/>
		<db-attribute name="ESTIMATED_PRICE" type="DECIMAL" length="10"/>
		<db-attribute name="PAINTING_ID" type="INTEGER" isPrimaryKey="true" isMandatory="true" length="11"/>
		<db-attribute name="ARTIST_ID" type="INTEGER" length="11"/>
	</db-entity>
	<obj-entity name="Artist" className="test.Artist" dbEntityName="ARTIST">
		<obj-attribute name="dateOfBirth" type="java.sql.Time" db-attribute-name="DATE_OF_BIRTH"/>
		<obj-attribute name="artistName" type="java.lang.String" db-attribute-name="ARTIST_NAME"/>
	</obj-entity>
	<obj-entity name="Gallery" className="test.Gallery" dbEntityName="GALLERY">
		<obj-attribute name="galleryName" type="java.lang.String" db-attribute-name="GALLERY_NAME"/>
	</obj-entity>
	<obj-entity name="Painting" className="test.Painting" dbEntityName="PAINTING">
		<obj-attribute name="estimatedPrice" type="java.math.BigDecimal" db-attribute-name="ESTIMATED_PRICE"/>
		<obj-attribute name="paintingTitle" type="java.lang.String" db-attribute-name="PAINTING_TITLE"/>
	</obj-entity>
	<db-relationship name="paintingArray" source="ARTIST" target="PAINTING" toDependentPK="false" toMany="true">
		<db-attribute-pair source="ARTIST_ID" target="ARTIST_ID"/>
	</db-relationship>
	<db-relationship name="paintingArray" source="GALLERY" target="PAINTING" toDependentPK="false" toMany="true">
		<db-attribute-pair source="GALLERY_ID" target="GALLERY_ID"/>
	</db-relationship>
	<db-relationship name="toGallery" source="PAINTING" target="GALLERY" toDependentPK="false" toMany="false">
		<db-attribute-pair source="GALLERY_ID" target="GALLERY_ID"/>
	</db-relationship>
	<db-relationship name="toArtist" source="PAINTING" target="ARTIST" toDependentPK="false" toMany="false">
		<db-attribute-pair source="ARTIST_ID" target="ARTIST_ID"/>
	</db-relationship>
	<obj-relationship name="paintingArray" source="Artist" target="Painting" toMany="true">
		<db-relationship-ref source="ARTIST" target="PAINTING" name="paintingArray"/>
	</obj-relationship>
	<obj-relationship name="paintingArray" source="Gallery" target="Painting" toMany="true">
		<db-relationship-ref source="GALLERY" target="PAINTING" name="paintingArray"/>
	</obj-relationship>
	<obj-relationship name="toGallery" source="Painting" target="Gallery" toMany="false">
		<db-relationship-ref source="PAINTING" target="GALLERY" name="toGallery"/>
	</obj-relationship>
	<obj-relationship name="toArtist" source="Painting" target="Artist" toMany="false">
		<db-relationship-ref source="PAINTING" target="ARTIST" name="toArtist"/>
	</obj-relationship>
</data-map>

--- NEW FILE: driverinfo.xml ---
<driver class="org.gjt.mm.mysql.Driver">
	<url value="jdbc:mysql://localhost/test"/>
	<connectionPool min="1" max="1" />
	<login userName="dummy" password="dummy" />
</driver>

--- NEW FILE: tutorialdb.sql ---
CREATE TABLE ARTIST (
	DATE_OF_BIRTH TIME NULL, 
	ARTIST_ID INT NOT NULL, 
	ARTIST_NAME CHAR(255) NOT NULL, 
	PRIMARY KEY (ARTIST_ID)
);

CREATE TABLE GALLERY (
	GALLERY_ID INT NOT NULL, 
	GALLERY_NAME VARCHAR(100) NOT NULL, 
	PRIMARY KEY (GALLERY_ID)
);

CREATE TABLE PAINTING (
	PAINTING_TITLE VARCHAR(255) NOT NULL, 
	GALLERY_ID INT NULL, 
	ESTIMATED_PRICE DECIMAL NULL, 
	PAINTING_ID INT NOT NULL, 
	ARTIST_ID INT NULL, 
	PRIMARY KEY (PAINTING_ID)
);

INSERT INTO GALLERY (GALLERY_ID, GALLERY_NAME) 
VALUES (1, 'The Metropolitan Museum of Art');

INSERT INTO GALLERY (GALLERY_ID, GALLERY_NAME) 
VALUES (2, 'Louvre');

INSERT INTO GALLERY (GALLERY_ID, GALLERY_NAME) 
VALUES (3, 'The State Hermitage Museum');