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 "Jun Li (JIRA)" <ji...@apache.org> on 2006/04/07 08:25:33 UTC
[jira] Created: (DDLUTILS-87) Did not filter out system table
dtproperties.
Did not filter out system table dtproperties.
---------------------------------------------
Key: DDLUTILS-87
URL: http://issues.apache.org/jira/browse/DDLUTILS-87
Project: DdlUtils
Type: Bug
Components: Core
Environment: SQL Server 2000.
Reporter: Jun Li
Assigned to: Thomas Dudziak
Priority: Minor
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.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DDLUTILS-87) Add ability to specify which tables
to include/exclude when reading a model from the database
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-87?page=all ]
Thomas Dudziak updated DDLUTILS-87:
-----------------------------------
Fix Version: 1.1
> Add ability to specify which tables to include/exclude when reading a model from the database
> ---------------------------------------------------------------------------------------------
>
> Key: DDLUTILS-87
> URL: http://issues.apache.org/jira/browse/DDLUTILS-87
> Project: DdlUtils
> Type: New Feature
> Components: Core
> Environment: Any database
> Reporter: Jun Li
> Assignee: Thomas Dudziak
> Fix For: 1.1
>
> 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.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DDLUTILS-87) Add ability to specify which tables
to include/exclude when reading a model from the database
Posted by "Daniel Lopez (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Resolved: (DDLUTILS-87) Add ability to specify which tables
to include/exclude when reading a model from the database
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DDLUTILS-87?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas Dudziak resolved DDLUTILS-87.
------------------------------------
Resolution: Fixed
The databaseToDdl task now has four additional attributes, includeTables & includeTableFilter and excludeTables & excludeTableFilter, that allow to specify which tables to include and exclude (as a comma-separated list or a regular expression). Includes are evaluated first, then excludes. If there are foreign keys between tables that are included and tables that are excluded (whether explicitly or not), then the task will fail.
> 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.
[jira] Updated: (DDLUTILS-87) Add ability to specify which tables
to include/exclude when reading a model from the database
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-87?page=all ]
Thomas Dudziak updated DDLUTILS-87:
-----------------------------------
Summary: Add ability to specify which tables to include/exclude when reading a model from the database (was: Did not filter out system table dtproperties.)
type: New Feature (was: Bug)
Environment: Any database (was: SQL Server 2000.)
Priority: Major (was: Minor)
Changed the issue to more accurately reflect the problem at hand. For instance, dtproperties is not a system table (i.e. it is a normal table of type TABLE), so DdlUtils cannot really know that it is a system table. Hence, it makes sense to add the ability to define include and exclude patterns that specify which tables to read from the database.
> Add ability to specify which tables to include/exclude when reading a model from the database
> ---------------------------------------------------------------------------------------------
>
> Key: DDLUTILS-87
> URL: http://issues.apache.org/jira/browse/DDLUTILS-87
> Project: DdlUtils
> Type: New Feature
> Components: Core
> Environment: Any database
> Reporter: Jun Li
> Assignee: Thomas Dudziak
>
> 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.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DDLUTILS-87) Add ability to specify which tables
to include/exclude when reading a model from the database
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-87?page=all ]
Thomas Dudziak updated DDLUTILS-87:
-----------------------------------
Component: Ant Tasks
> Add ability to specify which tables to include/exclude when reading a model from the database
> ---------------------------------------------------------------------------------------------
>
> Key: DDLUTILS-87
> URL: http://issues.apache.org/jira/browse/DDLUTILS-87
> Project: DdlUtils
> Type: New Feature
> Components: Core (No specific database), Ant Tasks
> Environment: Any database
> Reporter: Jun Li
> Assignee: Thomas Dudziak
> Fix For: 1.1
>
> 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.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira