1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165
|
Revision history for Perl module Parse::Dia::SQL.
0.31 Wed Jun 17 22:29:02 CEST 2020
Merged PR "Support `drop table if exists`"
Thanks to biaocy
https://github.com/aff/Parse-Dia-SQL/pull/9
0.30 Thu, 11 May 2017 19:09:19 +0200
Set "aggregate" attribute for Dia version=2 associations when
in ERD mode. Thanks to djerius@cpan.org
https://github.com/aff/Parse-Dia-SQL/pull/7
0.29 Sun Jan 15 15:44:09 2017 +0100
RT #119853 Fix spelling mistakes in the POD.
Thanks to gregor herrmann, Debian Perl Group.
0.28 Tue Jan 10 20:03:04 2017 +0100
Updated due to misuse of HTML::Lint 2.26.
0.27 Fri Jan 3 14:37:55 CET 2014
- RT #91654 Spelling mistake. Thanks to gregor herrmann and perl
debian team.
0.26 Tue Dec 17 22:07:00 CET 2013
- RT #66031 dia changed naming from aggregate_a/b to assoc_type.
- added support for bigserial & smallserial under postgresql.
(Thanks to Felix Ostmann)
0.25 Wed Mar 20 09:29:29 CET 2013
- Fixed bug in "nullable" implementation introducted in 0.24.
0.24 Mon Mar 18 08:22:54 CET 2013
- Added previously unsupported "nullable" feature for non-primary
key columns when using Database shape (added in 0.15).
0.23 Tue Aug 28 08:28:19 CEST 2012
- RT #79218 Spelling patch from debian downstream (Thanks to
Gregor Herrmann).
0.22 Tue Aug 7 09:00:00 CEST 2012
- RT #78818 syntax error fixed (thanks to openback).
- Makefile.PL - added BUILD_REQUIRES => { 'CPAN::Meta' => 0, },
to ensure META.yml is created during build.
- Changed META_MERGE => repository to github.com
0.21 Tue Jul 24 09:40:21 CEST 2012
- Added 'html' output options (thanks to Peter Langton).
Check generated html with XML::DOM::Parser and HTML::Lint.
- RT #77115 - Added SQLite3fk emitter that supports foreign key
(thanks to Peter Langton).
0.20 Mon Jan 30 14:19:46 CET 2012
- Added `backticks` to constraint creation, drop table,
drop index for MySQL-InnoDB.
0.19 Tue Jan 24 13:19:12 CET 2012
- Added `backticks` support for MySQL-InnoDB (tables only).
0.18 Wed Jan 11 15:45:42 CET 2012
- Added support for table options (see
t/data/table_output_options.dia)
0.17 Wed Feb 16 11:02:44 CET 2011
- RT #58189: Enable log level in command line arguments.
(reported by ELACOUR@cpan.org)
- RT #62131 (reported by Felix Ostmann):
- Associations incorrectly named in many-to-many
relationships.
- Add --uml support.
- RT #57842 postgres: serial -> int not working
(reported by shemgp).
0.16 Fri May 21 07:20:43 CEST 2010
- RT #57182 Encoding for insert statements in UML components
(reported by Gaudenz Steinlin).
- Final preparations for debian release.
0.15 Thu Apr 15 22:32:41 CEST 2010
- RT #56357 - Detect Dia database shapes and added
experimental parsing (excluding associations)
(reported by John-Paul Drawneek).
- Added LICENSE to conform with debian standards.
0.14 Fri Feb 5 20:13:09 CET 2010
- RT #53782 - Add typemap support (reported by Jani Päijänen).
0.13 Sun Dec 20 13:01:41 CET 2009
- RT #52755 - Add support for Postgres unique constraints
using the smallpackage stereotype (reported by shemgp).
- RT #50906 - Added PostgreSQL synonyms int2, int4, int8 to
integer, smallint and bigint respectively (reported by Edy
Incoletti.
- Added ignore_type_mismatch option which allows foreign keys
to have a different + type than the primary key it
references
0.12 Thu Nov 12 10:51:28 CET 2009
- RT #51433 - Multipicity (sic) not handled correctly
(reported by Edy Incoletti and Jeff Chimene)
- Ensure all indices are created before foreign key
constraints (all db platforms, reported by Jeff Chimene)
0.11 Sun Jul 12 21:25:38 CEST 2009
- Bug #47593 Default type for PSQL 'serial' should be
'integer' not 'int' (thanks to Mart van de Wege).
- Added support for Dia 0.97 source files. Added verions
checks for each XML element containing it.
First reported in bug #47040: Associations are
not generated in Dia 0.97
0.10 Sat May 16 21:03:57 CEST 2009
- Use recent (6.50) EU::MM in build to get LICENCE
MIN_PERL_VERSION, META_MERGE correctly set.
0.09 Sat May 16 15:29:28 CEST 2009
- SQLite3: Fixed a bug in the update constraint trigger
- SQLite3: Added 'on delete cascade' support
- Added support for index options, which are modelled as
a comment on the operation (index).
- Fixed bug: Missing associations should bot prevent
index creation.
0.08 Tue Apr 14 14:12:00 CEST 2009
- Bugfix in Utils.pm (sqlite -> sqlite3).
- Updated Makefile.PL with META_MERGE and LICENSE.
- Added MANIFEST.SKIP
- Removed TODO in boilerplate test.
0.07 Wed Apr 1 09:47:50 CEST 2009
- Added experimental support for SQLite v.3 (thanks to Peter
Langton).
0.06 Mon Mar 30 09:59:53 CEST 2009
- Fixed bug 'missing role name on PK end' (thanks to Peter
Langton).
- Fixed foreign key bug for Sybase (case sensitivity issue).
- Removed 'experimental' tag on MySQL MyISAM and InnoDB.
- Use Text::Table for comment formatting.
0.05 Mon Mar 16 08:58:33 CET 2009
- Restrict length of foreign keys in drop statements (see 0.04)
0.04 Fri Mar 13 13:13:13 CET 2009
- Made foreign keys 18 chars or less on DB2 (overridable)
regardless of name length in dia file.
(sub _create_constraint_name)
- InnoDB: Added drop foreign keys support.
- Reduced number of columns in log output to screen.
0.03 Mon Mar 2 09:57:23 CET 2009
- Added table_postfix_options (e.g. 'ENGINE=InnoDB')
- Made documentation more consistent.
- Removed private subroutines from main documentation.
- Made sure parsing is finished before outputting,
and updated tests accordingly.
0.02 Fri Feb 27 10:29:36 CET 2009
- Fixed package name error.
- Added generate_small_package_sql() to Output.pm
- Fixed comma-comment bug.
- Added CLI client.
0.01 Mon Feb 23 08:18:14 CET 2009
- original version
|