Author: tfischer
Date: Mon Sep 16 19:28:10 2013
New Revision: 1523769
URL: http://svn.apache.org/r1523769
Log:
TORQUE-302 Describe generation of schema from database
Modified:
db/torque/torque4/trunk/torque-site/src/site/xdoc/documentation/orm-reference/defining-the-schema.xml
db/torque/torque4/trunk/torque-site/src/site/xdoc/documentation/orm-reference/running-the-generator.xml
Modified:
db/torque/torque4/trunk/torque-site/src/site/xdoc/documentation/orm-reference/defining-the-schema.xml
URL:
http://svn.apache.org/viewvc/db/torque/torque4/trunk/torque-site/src/site/xdoc/documentation/orm-reference/defining-the-schema.xml?rev=1523769&r1=1523768&r2=1523769&view=diff
==============================================================================
---
db/torque/torque4/trunk/torque-site/src/site/xdoc/documentation/orm-reference/defining-the-schema.xml
(original)
+++
db/torque/torque4/trunk/torque-site/src/site/xdoc/documentation/orm-reference/defining-the-schema.xml
Mon Sep 16 19:28:10 2013
@@ -272,7 +272,7 @@
createSql with the sql needed to create the sql.
</p>
</subsection>
- <subsection name="examle schema file">
+ <subsection name="example schema file">
<p>
For an example schema file conaining most of the discussed features,
look at the bookstore-schema.xml from the test project.
@@ -402,5 +402,22 @@
</p>
</section>
+
+ <section name="Creating a schema from an existing database">
+
+ <p>
+ Torque can create a starting point for a schema file from an existing
+ database. For doing this, Torque uses the JDBC metainformation
+ provided by the database driver. Not all information about the
+ schema can be collected from JDBC metainformation, so this can only
+ serve as a starting point.
+ </p>
+
+ <p>
+ See the information about
+ <a
href="running-the-generator.html#Generation_of_XML_schema_from_an_existing_database">running
the Torque generator</a>
+ on how to generate a schema file from an existing database.
+ </p>
+
</body>
</document>
Modified:
db/torque/torque4/trunk/torque-site/src/site/xdoc/documentation/orm-reference/running-the-generator.xml
URL:
http://svn.apache.org/viewvc/db/torque/torque4/trunk/torque-site/src/site/xdoc/documentation/orm-reference/running-the-generator.xml?rev=1523769&r1=1523768&r2=1523769&view=diff
==============================================================================
---
db/torque/torque4/trunk/torque-site/src/site/xdoc/documentation/orm-reference/running-the-generator.xml
(original)
+++
db/torque/torque4/trunk/torque-site/src/site/xdoc/documentation/orm-reference/running-the-generator.xml
Mon Sep 16 19:28:10 2013
@@ -409,6 +409,21 @@
You may want to replace ${torque.database.schema} with the database
schema to read, if not please remove the line containing it.
</p>
+ <p>
+ Note that Torque relies on metainformation supplied by the database
+ driver for creating the schema file.
+ This metainformation does not contain all information which is
+ contained in the schema file, so the created file can only serve
+ as a starting point.
+ The information which can be read from the database differs from
+ database to database.
+ Table and column names can be read for almost every database.
+ Column types and primary key information is available
+ for most databases, but there might be edge cases where type
information
+ is not detailed enough to determine the correct column type.
+ Foreign key information and information about indices are typically
+ not read.
+ </p>
</subsection>
</section>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
