org.transitime.applications

Class SchemaGenerator

java.lang.Object

org.transitime.applications.SchemaGenerator

public class SchemaGenerator
extends java.lang.Object

For generating SQL schema files based on classes to be stored in database that were annotated for Hibernate. This is much nicer than trying to figure out what the schema really should be by hand. This code was copied from http:/ /jandrewthompson.blogspot.nl/2009/10/how-to-generate-ddl-scripts-from.html

Note that unfortunately there does not appear to be a way to specify the order of the columns in the resulting create table SQL statements. Though this has been asked for, it appears to still be a limitation of Hibernate. The default ordering appears to be first the @Id columns in reverse alphabetical order, and then the non @Id columns in alphabetical order. Yes, quite peculiar.

Since the resulting automatically generated files have unneeded drop commands these are filtered out. This way the resulting sql is smaller and easier to understand.

Author:

john.thompson, Skibu Smith, and Sean Crudden

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SchemaGenerator.ImprovedMySQLDialect MySQL handles fractional seconds differently from PostGRES and other DBs.

Constructor Summary

Constructors

Constructor and Description
SchemaGenerator(java.lang.String packageName, java.lang.String outputDirectory)

Method Summary

Modifier and Type	Method and Description
static void	main(java.lang.String[] args) Param args args[0] is the package name for the Hibernate annotated classes whose schema is to be exported such as "org.transitime.db.structs".

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SchemaGenerator

public SchemaGenerator(java.lang.String packageName,
                       java.lang.String outputDirectory)
                throws java.lang.Exception

Throws:

java.lang.Exception

Method Detail

main

public static void main(java.lang.String[] args)
                 throws java.lang.Exception

Param args args[0] is the package name for the Hibernate annotated classes whose schema is to be exported such as "org.transitime.db.structs". args[1] is optional output directory where the resulting files are to go. If the optional output directory is not specified then schema files written to local directory.

The resulting files have the name "ddl_" plus dialect name such as mysql or oracle plus the first two components of the package name such as org_transitime.

Throws:

java.lang.Exception