schemaspy:schemaspy

Note:This goal should be used as a Maven report.

Full name:

nl.geodienstencentrum.maven:schemaspy-maven-plugin:5.2.2-SNAPSHOT:schemaspy

Description:

The SchemaSpy Maven plugin report.

Attributes:

  • Requires a Maven project to be executed.
  • The goal is not marked as thread-safe and thus does not support parallel builds.
  • Since version: 2.0.
  • Binds by default to the lifecycle phase: site.

Required Parameters

Name Type Since Description
<database> String - The name of the database being analysed.
User property is: database.

Optional Parameters

Name Type Since Description
<allowHtmlInComments> Boolean - Allow HTML In Comments. Any HTML embedded in comments normally gets encoded so that it's rendered as text. This option allows it to be rendered as HTML.
User property is: allowHtmlInComments.
<commentsInitiallyDisplayed> Boolean - Deprecated. Comments Initially Displayed. Column comments are normally hidden by default. This option displays them by default.
User property is: commentsInitiallyDisplayed.
<connprops> String - Specifies additional properties to be used when connecting to the database. Specify the entries directly, escaping the ='s with \= and separating each key\=value pair with a ;. May also be a file name, useful for hiding connection properties from public logs.
User property is: connprops.
<cssStylesheet> String - The CSS Stylesheet. Allows you to override the default SchemaSpyCSS stylesheet.
User property is: cssStylesheet.
<databaseType> String - The type of database being analysed - defaults to ora.
User property is: databaseType.
<excludeColumnNamesRegex> String - Exclude matching columns from relationship analysis to simplify the generated graphs. This is a regular expression that's used to determine which columns to exclude. It must match table name, followed by a dot, followed by column name. For example: -x "(book.isbn)|(borrower.address)" Note that each column name regular expression must be surround by ()'s and separated from other column names by a |.
User property is: excludeColumnNamesRegex.
<highQuality> Boolean - Generate higher-quality diagrams. Various installations of Graphviz (depending on OS and/or version) will default to generating either higher or lower quality images. That is, some might not have the "lower quality" libraries and others might not have the "higher quality" libraries.
User property is: highQuality.
<host> String - The host address of the database being analysed.
User property is: host.
<includeTableNamesRegex> String - Only include matching tables/views. This is a regular expression that's used to determine which tables/views to include. For example: -i "(.*book.*)|(library.*)" includes only those tables/views with 'book' in their names or that start with 'library'. You might want to use "description" with this option to describe the subset of tables.
User property is: includeTableNamesRegex.
<logLevel> String - Detail of execution logging.
User property is: logLevel.
<lowQuality> Boolean - Generate lower-quality diagrams. Various installations of Graphviz (depending on OS and/or version) will default to generating either higher or lower quality images. That is, some might not have the "lower quality" libraries and others might not have the "higher quality" libraries.
User property is: lowQuality.
<noAds> Boolean - Deprecated. Don't generate ads in reports.
Default value is: true.
User property is: noAds.
<noHtml> Boolean - Only generate files needed for insertion/deletion of data (e.g. for scripts).
User property is: noHtml.
<noImplied> Boolean - Don't include implied foreign key relationships in the generated table details.
User property is: noImplied.
<noLogo> Boolean - Deprecated. Don't generate sourceforge logos in reports.
Default value is: true.
User property is: noLogo.
<noRows> Boolean - Don't query or display row counts.
User property is: noRows.
<noSchema> Boolean - No schema required for this database (e.g. derby).
User property is: noSchema.
<noViews> Boolean - Don't query or display row counts.
User property is: noViews.
<outputDirectory> String - The output directory where the final HTML reports will be generated. Note that the reports are always generated in a directory called "schemaspy". The output directory refers to the directory in which the "schemaspy" will be generated.
Default value is: ${project.build.directory}/site.
User property is: outputDirectory.
<password> String - Database password to use - defaults to none.
User property is: password.
<pathToDrivers> String - If specified, SchemaSpy will look for JDBC drivers on this path, rather than using the application classpath. Useful if your database has a non-O/S driver not bundled with the plugin.
User property is: pathToDrivers.
<port> String - The port, required by some drivers.
User property is: port.
<runOnExecutionRoot> boolean 5.0.4 Whether to create the report only on the execution root of a multi-module project.
Default value is: false.
User property is: runOnExecutionRoot.
<schema> String - Database schema to use - defaults to the specified user.
User property is: schema.
<schemaDescription> String - Schema description. Displays the specified textual description on summary pages. If your description includes an equals sign then escape it with a backslash. NOTE: This field doesn't seem to be used by SchemaSpy in the current version.
User property is: schemaDescription.
<schemas> String - Evaluate specified schemas. Similar to -showAllSchemas, but explicitly specifies which schema to evaluate without interrogating the database's metadata. Can be used with databases like MySQL where a database isn't composed of multiple schemas.
User property is: schemas.
<showAllSchemas> Boolean - Evaluate all schemas in a database. Generates a high-level index of the schemas evaluated and allows for traversal of cross-schema foreign key relationships. Use with -schemaSpec "schemaRegularExpression" to narrow-down the schemas to include.
User property is: showAllSchemas.
<singleSignOn> Boolean - Single Sign-On. Don't require a user to be specified with -user to simplify configuration when running in a single sign-on environment.
User property is: singleSignOn.
<targetDirectory> File - The output directory for the intermediate report.
Default value is: ${project.build.directory}.
User property is: targetDirectory.
<useDriverManager> Boolean - Some databases, like Derby, will crash if you use the old driver object to establish a connection (eg "connection = driver.connect(...)"). In this case, set useDriverManager to true to use the DriverManager.getConnection() method instead (eg "connection = java.sql.DriverManager.getConnection(...)"). Other databases (eg MySQL) seem to only work with the first method, so don't use this parameter unless you have to.
User property is: useDriverManager.
<user> String - Connect to the database with this user id.
User property is: user.

Parameter Details

<allowHtmlInComments>

Allow HTML In Comments. Any HTML embedded in comments normally gets encoded so that it's rendered as text. This option allows it to be rendered as HTML.
  • Type: java.lang.Boolean
  • Required: No
  • User Property: allowHtmlInComments

<commentsInitiallyDisplayed>

Deprecated. this seems to no longer be a supported option in SchemaSpy
Comments Initially Displayed. Column comments are normally hidden by default. This option displays them by default.
  • Type: java.lang.Boolean
  • Required: No
  • User Property: commentsInitiallyDisplayed

<connprops>

Specifies additional properties to be used when connecting to the database. Specify the entries directly, escaping the ='s with \= and separating each key\=value pair with a ;. May also be a file name, useful for hiding connection properties from public logs.
  • Type: java.lang.String
  • Required: No
  • User Property: connprops

<cssStylesheet>

The CSS Stylesheet. Allows you to override the default SchemaSpyCSS stylesheet.
  • Type: java.lang.String
  • Required: No
  • User Property: cssStylesheet

<database>

The name of the database being analysed.
  • Type: java.lang.String
  • Required: Yes
  • User Property: database

<databaseType>

The type of database being analysed - defaults to ora.
  • Type: java.lang.String
  • Required: No
  • User Property: databaseType

<excludeColumnNamesRegex>

Exclude matching columns from relationship analysis to simplify the generated graphs. This is a regular expression that's used to determine which columns to exclude. It must match table name, followed by a dot, followed by column name. For example: -x "(book.isbn)|(borrower.address)" Note that each column name regular expression must be surround by ()'s and separated from other column names by a |.
  • Type: java.lang.String
  • Required: No
  • User Property: excludeColumnNamesRegex

<highQuality>

Generate higher-quality diagrams. Various installations of Graphviz (depending on OS and/or version) will default to generating either higher or lower quality images. That is, some might not have the "lower quality" libraries and others might not have the "higher quality" libraries.
  • Type: java.lang.Boolean
  • Required: No
  • User Property: highQuality

<host>

The host address of the database being analysed.
  • Type: java.lang.String
  • Required: No
  • User Property: host

<includeTableNamesRegex>

Only include matching tables/views. This is a regular expression that's used to determine which tables/views to include. For example: -i "(.*book.*)|(library.*)" includes only those tables/views with 'book' in their names or that start with 'library'. You might want to use "description" with this option to describe the subset of tables.
  • Type: java.lang.String
  • Required: No
  • User Property: includeTableNamesRegex

<logLevel>

Detail of execution logging.
  • Type: java.lang.String
  • Required: No
  • User Property: logLevel

<lowQuality>

Generate lower-quality diagrams. Various installations of Graphviz (depending on OS and/or version) will default to generating either higher or lower quality images. That is, some might not have the "lower quality" libraries and others might not have the "higher quality" libraries.
  • Type: java.lang.Boolean
  • Required: No
  • User Property: lowQuality

<noAds>

Deprecated. will be removed
Don't generate ads in reports.
  • Type: java.lang.Boolean
  • Required: No
  • User Property: noAds
  • Default: true

<noHtml>

Only generate files needed for insertion/deletion of data (e.g. for scripts).
  • Type: java.lang.Boolean
  • Required: No
  • User Property: noHtml

<noImplied>

Don't include implied foreign key relationships in the generated table details.
  • Type: java.lang.Boolean
  • Required: No
  • User Property: noImplied

<noLogo>

Deprecated. will be removed
Don't generate sourceforge logos in reports.
  • Type: java.lang.Boolean
  • Required: No
  • User Property: noLogo
  • Default: true

<noRows>

Don't query or display row counts.
  • Type: java.lang.Boolean
  • Required: No
  • User Property: noRows

<noSchema>

No schema required for this database (e.g. derby).
  • Type: java.lang.Boolean
  • Required: No
  • User Property: noSchema

<noViews>

Don't query or display row counts.
  • Type: java.lang.Boolean
  • Required: No
  • User Property: noViews

<outputDirectory>

The output directory where the final HTML reports will be generated. Note that the reports are always generated in a directory called "schemaspy". The output directory refers to the directory in which the "schemaspy" will be generated.
  • Type: java.lang.String
  • Required: No
  • User Property: outputDirectory
  • Default: ${project.build.directory}/site

<password>

Database password to use - defaults to none.
  • Type: java.lang.String
  • Required: No
  • User Property: password

<pathToDrivers>

If specified, SchemaSpy will look for JDBC drivers on this path, rather than using the application classpath. Useful if your database has a non-O/S driver not bundled with the plugin.
  • Type: java.lang.String
  • Required: No
  • User Property: pathToDrivers

<port>

The port, required by some drivers.
  • Type: java.lang.String
  • Required: No
  • User Property: port

<runOnExecutionRoot>

Whether to create the report only on the execution root of a multi-module project.
  • Type: boolean
  • Since: 5.0.4
  • Required: No
  • User Property: runOnExecutionRoot
  • Default: false

<schema>

Database schema to use - defaults to the specified user.
  • Type: java.lang.String
  • Required: No
  • User Property: schema

<schemaDescription>

Schema description. Displays the specified textual description on summary pages. If your description includes an equals sign then escape it with a backslash. NOTE: This field doesn't seem to be used by SchemaSpy in the current version.
  • Type: java.lang.String
  • Required: No
  • User Property: schemaDescription

<schemas>

Evaluate specified schemas. Similar to -showAllSchemas, but explicitly specifies which schema to evaluate without interrogating the database's metadata. Can be used with databases like MySQL where a database isn't composed of multiple schemas.
  • Type: java.lang.String
  • Required: No
  • User Property: schemas

<showAllSchemas>

Evaluate all schemas in a database. Generates a high-level index of the schemas evaluated and allows for traversal of cross-schema foreign key relationships. Use with -schemaSpec "schemaRegularExpression" to narrow-down the schemas to include.
  • Type: java.lang.Boolean
  • Required: No
  • User Property: showAllSchemas

<singleSignOn>

Single Sign-On. Don't require a user to be specified with -user to simplify configuration when running in a single sign-on environment.
  • Type: java.lang.Boolean
  • Required: No
  • User Property: singleSignOn

<targetDirectory>

The output directory for the intermediate report.
  • Type: java.io.File
  • Required: No
  • User Property: targetDirectory
  • Default: ${project.build.directory}

<useDriverManager>

Some databases, like Derby, will crash if you use the old driver object to establish a connection (eg "connection = driver.connect(...)"). In this case, set useDriverManager to true to use the DriverManager.getConnection() method instead (eg "connection = java.sql.DriverManager.getConnection(...)"). Other databases (eg MySQL) seem to only work with the first method, so don't use this parameter unless you have to.
  • Type: java.lang.Boolean
  • Required: No
  • User Property: useDriverManager

<user>

Connect to the database with this user id.
  • Type: java.lang.String
  • Required: No
  • User Property: user