Changeset 1562

Timestamp:

05/25/07 19:37:48 (18 months ago)

Author:

jmoore

Message:

#712 Initial update scripts from patch 1 to 4. See also #373

Location:

trunk

Files:

• components/common/build.xml (modified) (1 diff)
• sql/README.txt (modified) (1 diff)
• sql/VERSIONS.txt (modified) (1 diff)
• sql/misc/macros.el (modified) (1 diff)
• sql/psql/OMERO3__1__OMERO3__4__A_hibtool.sql (added)
• sql/psql/OMERO3__1__OMERO3__4__B_apg.sql (added)
• sql/psql/OMERO3__1__OMERO3__4__C_enums.sql (added)
• sql/psql/OMERO3__1__data.sql (added)
• sql/psql/OMERO3__1__schema.sql (added)

trunk/components/common/build.xml

@@ -101 +101 @@
         </target>
 
+
+    <target name="schemaupdate" depends="prepare,load-hibernate">
+        <taskdef name="schemaupdate"
+            classname="org.hibernate.tool.hbm2ddl.SchemaUpdateTask"
+            classpathref="omero.classpath"/>
+
+        <schemaupdate
+            properties="${resrc.dest}/local.properties" text="true" quiet="no">
+            <fileset dir="${classes.dir}">
+                <include name="**/*.hbm.xml"/>
+            </fileset>
+        </schemaupdate>
+    </target>
+
+    <target name="schemavalidate" depends="prepare,load-hibernate">
+        <taskdef name="schemavalidator"
+            classname="org.hibernate.tool.hbm2ddl.SchemaValidatorTask"
+            classpathref="omero.classpath"/>
+
+        <schemavalidator
+            properties="${resrc.dest}/local.properties">
+            <fileset dir="${classes.dir}">
+                <include name="**/*.hbm.xml"/>
+            </fileset>
+        </schemavalidator>
+    </target>
+
 </project>

trunk/sql/README.txt

@@ -17 +17 @@
 
 
-
+To create the update scripts, first cleaned version of each schema are compared 
+(where cleaned means simple formatting differences, random foreign key names, etc. 
+are removed). Then it is necessary to compare the values in all enumerations.

trunk/sql/VERSIONS.txt

@@ -19 +19 @@
 HERE ARE WE -->               |                       
                               |                       
-DBUPDATE           2007/05    +-------+ r1397         
-Added dbpatch table.          |         OMERO3:4      
-                              |                       
-                              |                       
-                              |                       
-DBUPDATE           2007/04    +-------+ r1397         
-Added permissions column      |         OMERO3:3      
-security tables.              |                       
-                              |                       
-                              |                       
-DBUPDATE           2007/03    +-------+ r1394         
-Model updates, etc.           |         OMERO3:2      
-                              |                       
-                              |                       
-                              |                       
-                              |                       
-                              |                       
-                              |                       
-FIRST DATABASE     2007/01    +-------+ r???          
-                              |         OMERO3:1      
+DBUPDATE           2007/05    +-------+ r1547    <-+   
+Added dbpatch table.          |         OMERO3:4   |   
+                              |                    |   
+                              |                    |   
+                              |                    |   
+DBUPDATE           2007/04    +-------+ r1397      |   
+Added permissions column      |         OMERO3:3   |   
+security tables.              |                    |   
+                              |                    |   
+                              |                    |   
+DBUPDATE           2007/03    +-------+ r1394      |      
+Model updates, etc.           |         OMERO3:2   |   
+                              |                    |   
+                              |                    |   
+                              |                    |   
+                              |                    |   
+                              |                    |   
+                              |                    |   
+FIRST DATABASE     2007/01    +-------+ ~ r1216  >-+  
+3.0-Beta1 Release             |         OMERO3:1      
                               |                       
                               |                       

trunk/sql/misc/macros.el

@@ -3 +3 @@
 ;;
 
-(fset 'psql-fk-update
-      [?\C-s ?a ?l ?t ?e ?r ?  ?t ?a ?b ?l ?e ?\C-m right ?\C-  ?\C-e left escape ?w ?\C-s ?a ?d ?d ?  ?c ?o ?n ?s ?t ?r ?a ?i ?n ?t ?\C-m right right right ?\C-y ?\C-k ?\C-s ?f ?o ?r ?e ?i ?g ?n ?  ?k ?e ?y ?\C-m right right ?\C-  ?\C-s ?) left escape ?w up end ?_ ?\C-y ?\C-s ?r ?e ?f ?e ?r ?e ?n ?\C-m right right right right ?\C-  ?\C-e ?\; backspace left escape ?w up up end ?_ ?\C-y])
+(fset 'psql-fk-update [?\C-s ?a ?l ?t ?e ?r ?  ?t ?a ?b ?l ?e ?\C-m right ?\C-  ?\C-e left escape ?w ?\C-s ?a ?d ?d ?  ?c ?o ?n ?s ?t ?r ?a ?i ?n ?t ?\C-m right right right ?\C-y ?\C-k ?\C-s ?f ?o ?r ?e ?i ?g ?n ?  ?k ?e ?y ?\C-m right right ?\C-  ?\C-s ?) left escape ?w up end ?_ ?\C-y ?\C-s ?r ?e ?f ?e ?r ?e ?n ?\C-m right right right right ?\C-  ?\C-e ?\; backspace left escape ?w up up end ?_ ?\C-y])