database schema in CaveatEmptor

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

I can't find database schema in CaveatEmptor

Is there this script ?

regards

christian · **Posted:** Thu Jul 22, 2004 12:33 pm

The schema is automatically generated by the unit tests.

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

How I can see schema ?

christian · **Posted:** Thu Jul 22, 2004 1:32 pm

By running the unit tests. You probably also like to disable the automatic dropping of the schema at the end, see TestCase.java and remove the "drop" in tearDown(). You could also simply write an Ant target and call SchemaExport yourself with the hibernate.cfg.xml.

I'll include a SQL DDL file in the next release...

wadeh · **Joined:** Thu Aug 05, 2004 2:53 pm **Posts:** 1

open TestCase.java....

protected void setUp() throws Exception {
super.setUp();
SchemaExport ddlExport = new SchemaExport(HibernateUtil.getConfiguration());
ddlExport.setOutputFile("createAll.sql");// <--- add this line
ddlExport.create(false, true);
}

protected void tearDown() throws Exception {

super.tearDown();
SchemaExport ddlExport = new SchemaExport(HibernateUtil.getConfiguration());
ddlExport.setOutputFile("dropAll.sql"); // <--- add this line
ddlExport.drop(false, true);
}

If you really want the sql script :)

christian · **Posted:** Thu Aug 05, 2004 3:01 pm

The 0.9.2 version released yesterday has an Ant task.