|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.apache.tools.ant.ProjectComponent
org.apache.tools.ant.Task
org.apache.ddlutils.task.DatabaseTaskBase
org.apache.ddlutils.task.DdlToDatabaseTask
public class DdlToDatabaseTask
Task for performing operations on a live database. Sub tasks e.g. create the
schema in the database, drop database schemas, insert data into the database,
create DTDs for data files, or write the SQL for creating a schema to a file.
Example:
<taskdef classname="org.apache.ddlutils.task.DdlToDatabaseTask" name="ddlToDatabase" classpathref="project-classpath"/> <ddlToDatabase usedelimitedsqlidentifiers="true"> <database driverclassname="org.apache.derby.jdbc.ClientDriver" url="jdbc:derby://localhost/ddlutils" username="ddlutils" password="ddlutils"/> <fileset dir="."> <include name="*schema.xml"/> </fileset> <createdatabase failonerror="false"/> <writeschematodatabase alterdatabase="true" failonerror="false"/> <writedatatodatabase datafile="data.xml" usebatchmode="true" batchsize="1000"/> </ddlToDatabase>This Ant build file snippet essentially creates a database, creates tables, foreign keys etc. int it and then writes data into the newly created tables.
Field Summary |
---|
Fields inherited from class org.apache.ddlutils.task.DatabaseTaskBase |
---|
_log |
Fields inherited from class org.apache.tools.ant.Task |
---|
target, taskName, taskType, wrapper |
Fields inherited from class org.apache.tools.ant.ProjectComponent |
---|
description, location, project |
Constructor Summary | |
---|---|
DdlToDatabaseTask()
|
Method Summary | |
---|---|
void |
addConfiguredFileset(org.apache.tools.ant.types.FileSet fileset)
Adds a fileset. |
void |
addCreateDatabase(CreateDatabaseCommand command)
Adds the "create database"-command. |
void |
addDropDatabase(DropDatabaseCommand command)
Adds the "drop database"-command. |
void |
addWriteDataToDatabase(WriteDataToDatabaseCommand command)
Adds the "write data to database"-command. |
void |
addWriteDataToFile(WriteDataToFileCommand command)
Adds the "write data to file"-command. |
void |
addWriteDtdToFile(WriteDtdToFileCommand command)
Adds the "write dtd to file"-command. |
void |
addWriteSchemaSqlToFile(WriteSchemaSqlToFileCommand command)
Adds the "write schema sql to file"-command. |
void |
addWriteSchemaToDatabase(WriteSchemaToDatabaseCommand command)
Adds the "write schema to database"-command. |
protected Database |
readModel()
Reads the database model on which the commands will work. |
void |
setSchemaFile(java.io.File schemaFile)
Defines the single file that contains the database file. |
void |
setUseInternalDtd(boolean useInternalDtd)
Specifies whether DdlUtils shall use the embedded DTD for validating the schema XML (if it matches http://db.apache.org/torque/dtd/database.dtd ). |
void |
setValidateXml(boolean validateXml)
Specifies whether XML input files should be validated against the DTD at all. |
Methods inherited from class org.apache.ddlutils.task.DatabaseTaskBase |
---|
addCommand, addConfiguredDatabase, execute, executeCommands, getCommands, getDatabaseType, getDataSource, getPlatform, getPlatformConfiguration, hasCommands, isShutdownDatabase, isSortForeignKeys, isUseDelimitedSqlIdentifiers, setCatalogPattern, setDatabaseType, setSchemaPattern, setShutdownDatabase, setSimpleLogging, setSortForeignKeys, setUseDelimitedSqlIdentifiers, setVerbosity |
Methods inherited from class org.apache.tools.ant.Task |
---|
bindToOwner, getOwningTarget, getRuntimeConfigurableWrapper, getTaskName, getTaskType, getWrapper, handleErrorFlush, handleErrorOutput, handleFlush, handleInput, handleOutput, init, isInvalid, log, log, log, log, maybeConfigure, perform, reconfigure, setOwningTarget, setRuntimeConfigurableWrapper, setTaskName, setTaskType |
Methods inherited from class org.apache.tools.ant.ProjectComponent |
---|
clone, getDescription, getLocation, getProject, setDescription, setLocation, setProject |
Methods inherited from class java.lang.Object |
---|
equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public DdlToDatabaseTask()
Method Detail |
---|
public void setUseInternalDtd(boolean useInternalDtd)
http://db.apache.org/torque/dtd/database.dtd
). This is
especially useful in environments where no web access is possible or desired.
useInternalDtd
- true
if input files are to be validated against the internal DTDpublic void setValidateXml(boolean validateXml)
validateXml
- true
if input files are to be validatedpublic void addConfiguredFileset(org.apache.tools.ant.types.FileSet fileset)
fileset
- The additional input filespublic void setSchemaFile(java.io.File schemaFile)
fileset
elements if you only have one schema file.
schemaFile
- The schemapublic void addCreateDatabase(CreateDatabaseCommand command)
command
- The commandpublic void addDropDatabase(DropDatabaseCommand command)
command
- The commandpublic void addWriteDtdToFile(WriteDtdToFileCommand command)
command
- The commandpublic void addWriteSchemaToDatabase(WriteSchemaToDatabaseCommand command)
command
- The commandpublic void addWriteSchemaSqlToFile(WriteSchemaSqlToFileCommand command)
command
- The commandpublic void addWriteDataToDatabase(WriteDataToDatabaseCommand command)
command
- The commandpublic void addWriteDataToFile(WriteDataToFileCommand command)
command
- The commandprotected Database readModel()
readModel
in class DatabaseTaskBase
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |