You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by "Daniel Lopez (JIRA)" <ji...@apache.org> on 2008/02/27 08:10:51 UTC

[jira] Updated: (DDLUTILS-87) Add ability to specify which tables to include/exclude when reading a model from the database

     [ https://issues.apache.org/jira/browse/DDLUTILS-87?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Daniel Lopez updated DDLUTILS-87:
---------------------------------

    Attachment: DDLUtils-TableNameRegExpFilter.patch

A patch file with the addition of a new parameter, tableFilter, to the databaseToDdl  task and associated methods. This parameter is a regular expression that will be matched against all table names to decide whether they are processed or not [using tableName.matches(tableFilter)].

Here is it an example of usage:
**********************************
<databaseToDdl
    usedelimitedsqlidentifiers=...
    shutdowndatabase=...
    modelname=...
    tableFilter="TTST_.*"
>
...
**********************************
In the example, just the tables starting with TTST_ will be read and processed

> Add ability to specify which tables to include/exclude when reading a model from the database
> ---------------------------------------------------------------------------------------------
>
>                 Key: DDLUTILS-87
>                 URL: https://issues.apache.org/jira/browse/DDLUTILS-87
>             Project: DdlUtils
>          Issue Type: New Feature
>          Components: Ant Tasks, Core (No specific database)
>         Environment: Any database
>            Reporter: Jun Li
>            Assignee: Thomas Dudziak
>             Fix For: 1.1
>
>         Attachments: DDLUtils-TableNameRegExpFilter.patch
>
>
> On SQL Server dtproperties is a system table.
>  
> But DdlUtils did not filter it out like it does for other system tables like syscolumns, sysfiles, sysindexes, and so on.
> Some people reported that it's also a issue in PostgreSQL 8.1

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.