Recent changes to patches

Batch file for open with ...

2010-03-26T10:15:42Z

I wrote a batch file for being able to open directly the .druid files from windows file manager (Open with ...).
The file must simply be installed alongside druid.jar file and consists in a single line :
start "Druid" "%~dp0\druid.jar" -proj:%*

Is this possible to had icon for .druid files and the link to the bat file during druid installation ?

Patch for the PDF module and added localization files

2008-01-30T00:35:11Z

This is a patch for the Druid's PDF module. The patch adds "Add Fonts"
panel to the PDF module configuration. The "Add Fonts" panel allows the
user to specify a list of directories where additional font files
are located. After saving the configuration and restarting Druid
the additional fonts will be selectable in the Font Chooser dialog.
Selected fonts can be marked as Unicode fonts in the Font Chooser
dialog to support rendering of Unicode national character data
in PDF documents. The patch also contains Russian localization files.

Template-based SQL generation improved

2008-01-28T10:52:15Z

This patch is to improve the way Druid generates constraints (i.e. primary keys, foreign keys, unique constraints, check constraints). More specifically the patch affects the way a template is handled during SQL-generation.
- Changes:
1) Support for two new template parameters for template-based generation of primary keys, foreign keys, unique/check constraints:
{table_acronym}: generates an acronym of the table (e.g. CUSTOM_ACCOUNT_BASKET --> CAB)
{fields_acronym}: generates an acronym of a field or a list of fields (e.g. basket_id, item_type --> biit). This may be especially useful for people stuck with a name length limit imposed by the DBMS. For example most versions of Oracle allow a limit of 30 characters for each database object (table, fields, etc.). Using an acronym might help users automatize the generation without exceed the ridiculous limit.
2) Now the generation of domain-based check constraints uses the template "Other" to generate constraint names (instead of generating anonymous constraints). Previously, the template "Other" was only used for the generation of unique constraints and domain-based check constraints were generated as anonymous constraints. By the way, the use of anonymous check constraints is strongly discouraged, as most DBMS don't allow the user to drop such constraints in an easy way. Domain-based check constraint are all the constraints generated by Druid when a custom-defined field type has a domain. For example we might want to define a type BOOLEAN with a domain "Set of values: 0,1" for a DBMS that doesn't support the boolean type. With the patch all these constraints are generated by using the template "Other". If the template has not been specified, Druid falls back to the previous implementation, i.e. generating an anonymous check constraint.

Oracle Sequence order

2007-11-15T15:50:14Z

The syntax for a sequence in Oracle is slightly off. Here is a patch to fix that.

Fix some unused imports

2007-11-15T15:43:56Z

The Java code generator puts in unused import. This code removes some of those unused imports.

serial8 to int8 foreign key mapping patch for postgres

2007-05-15T06:32:26Z

The attached file contains a patch for postgres that allows usage and generation of serial8 data types and subsequent mapping to int8 data types in foreign key references when auto-generating postgres sql.

To use:
Detach the attached patch file into your druid root directory, then run the following command from a terminal session within that directory:
"patch -p0 <postgres_diff_serial8.patch"
Then (again from within the druid root directory) run "ant" to rebuild druid and you're done.

Only tested on Mac OS/x, but should work under Linux too....

BTW - great little tool - I LOVE it!

Thanks,
Marty Lampard
marty@ccicon.com
mlampard@excite.com

Enhancement OJB Module

2005-12-21T02:13:25Z

1. Now the OJB module generate correctly the mapping
for a table that have several foreign keys to one
single table.

2. The field are converted to a identifier with the
java name convention. We use the char "_" for this task.

If i have a field name "person_first_name", we convert
to "personFirstName", and we generate the setter and
getter: getPersonFirstName() and setPersonFirstName().

any comments are welcome.

build.xml, MySQL, and gui/guardian changes

2005-10-08T12:13:32Z

the build.xml now separates cleaning from building. You
can still call the default target and it will clean and
build like before. You can also call make-druid and it
will just compile the changed files. This is make the
build.xml file a little more IDE friendly.

MySQL want "if exists" in the drop table command.

the gui/guardian changes are to remove compiler warnings.

SQL script module patch for 3.6

2005-05-27T18:12:49Z

This patch supersedes 1208057 and is based on Druid
3.6. 1208057 should only be used with 3.5.

Adds the following options to the SQL Generation tab:

Inline FKs to generate foreign keys inline (when
checked) or as ALTER table statements following the
table DDL.

Pre SQL to include the Extra SQL/Pre SQL scripts if
any.

Post SQL to include the Extra SQL/Post SQL scripts.

Others changes to script generation:

Adds OR REPLACE to CREATE DDL in for triggers.

Adds support for MATERIALIZED VIEW to SQL
generation code. Use Add View and change the
template text to CREATE MATERIALIZED VIEW.

A PACKAGE can be defined using the Add Procedure
type in the context menu. Although CREATE
PROCEDURE... appears as the template text it can
just be erased and replaced with CREATE OR
REPLACE PACKAGE which will work when SQL is
generated for the package and drop.

Fixes bug in statement level trigger SQL generation
code so that FOR EACH STATEMENT is not added to
the code when selected.

Removes extraneous line endings and REM separators
for options not generated.

List of where criteria entered

2005-05-27T15:33:40Z

Add a popup on the right of the where field on the data
tab containing the old where criteria entered.
They are not saved when Druid is closed.

Generated by eclipse on the HEAD version.
Works too with version V3_5 and V3_4 and Root_V3_X