Bug #56357 for Parse-Dia-SQL: parse dia not working for me with dia 0.97-3.5

Wed Apr 07 13:22:39 2010 john-paul.drawneek [...] classicstudios.co.uk - Ticket created

Subject:	parse dia not working for me with dia 0.97-3.5
Date:	Wed, 7 Apr 2010 18:20:50 +0100
To:	"bug-Parse-Dia-SQL [...] rt.cpan.org" <bug-Parse-Dia-SQL [...] rt.cpan.org>
From:	John-Paul Drawneek <john-paul.drawneek [...] classicstudios.co.uk>

Running openSuSE 11.2 64bit Output is: parsediasql --file bb-and-ss_1.dia --db mysql-myisam [WARN] associations is an empty ARRAY ref [WARN] classes is an empty ARRAY ref [WARN] classes is an empty ARRAY ref [ERROR] Views are not supported on MyISAM - Views not dropped. [WARN] classes is an empty ARRAY ref [WARN] classes is an empty ARRAY ref [ERROR] Views are not supported on MyISAM - Views not created. [WARN] classes is an empty ARRAY ref [WARN] components is an empty ARRAY ref [WARN] classes is an empty ARRAY ref [WARN] associations is an empty ARRAY ref -- Parse::SQL::Dia version 0.14 -- Documentation http://search.cpan.org/dist/Parse-Dia-SQL/ -- Environment Perl 5.010000, /usr/bin/perl -- Architecture x86_64-linux-thread-multi -- Target Database mysql-myisam -- Input file bb-and-ss_1.dia -- Generated at Wed Apr 7 18:14:48 2010 -- Typemap for mysql-myisam not found in input file -- get_constraints_drop -- get_permissions_drop -- get_view_drop -- get_schema_drop -- get_smallpackage_pre_sql -- get_schema_create -- get_view_create -- get_permissions_create -- get_inserts -- get_smallpackage_post_sql -- get_associations_create Classic Studios is the trading name of Classic Studios Limited. Registered in England. Number 05925634. This e-mail (and any attachments) are confidential and may be privileged. If you are not the intended recipient do not copy, use, or rely on them. We do not accept any legal responsibility for the contents of this communication due to the generally insecure nature of email. The views and opinions expressed within this email are those of the author and are not necessarily those of Classic Studios. If you received this email in error, please notify the sender immediately. Classic Studios have taken reasonable precaution to ensure that any attachment to this e-mail has been swept for viruses. However, Classic Studios cannot accept liability for any damage sustained as a result of software viruses and would advise that you carry out your own virus checks before opening any attachment. Show quoted text

______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email

______________________________________________________________________

Download bb-and-ss_1.dia
application/octet-stream 164.7k

Message body not shown because it is not plain text.

Wed Apr 07 14:27:48 2010 aff [...] cpan.org - Correspondence added

John-Paul, Thanks for your report. It looks like you have created your model using the 'database' shapes in dia. For historic reasons Parse-Dia-SQL supports the 'UML' shapes only. Please consult the t/data directory below for example models. http://cpansearch.perl.org/src/AFF/Parse-Dia-SQL-0.14/t/data/ Adding support for the 'database' shapes to PDS is probably a good long-term solution. Best regards, Andreas

Wed Apr 07 14:27:48 2010 The RT System itself - Status changed from 'new' to 'open'

Wed Apr 07 14:27:49 2010 aff [...] cpan.org - Status changed from 'open' to 'resolved'

Fri Apr 09 01:41:49 2010 aff [...] cpan.org - Correspondence added

On Wed Apr 07 14:27:48 2010, AFF wrote: Show quoted text

> It looks like you have created your model using the 'database' shapes in > dia. For historic reasons Parse-Dia-SQL supports the 'UML' shapes only.

Version 0.14_01 adds detection of 'database' shaped models and will respond with an informative error message. Best regards, Andreas

Fri Apr 09 01:41:51 2010 The RT System itself - Status changed from 'resolved' to 'open'

Fri Apr 09 01:42:07 2010 aff [...] cpan.org - Status changed from 'open' to 'resolved'

Sat Apr 10 09:02:29 2010 aff [...] cpan.org - Correspondence added

John-Paul, Please try the 0.14_02 version which has experimental support for the Dia database shape model. Best regards, Andreas --

Sat Apr 10 09:02:29 2010 The RT System itself - Status changed from 'resolved' to 'open'

Sat Apr 10 09:02:52 2010 aff [...] cpan.org - Status changed from 'open' to 'resolved'

Tue Apr 13 04:46:26 2010 john-paul.drawneek [...] classicstudios.co.uk - Correspondence added

Subject:	RE: [rt.cpan.org #56357] parse dia not working for me with dia 0.97-3.5
Date:	Tue, 13 Apr 2010 09:46:31 +0100
To:	"bug-Parse-Dia-SQL [...] rt.cpan.org" <bug-Parse-Dia-SQL [...] rt.cpan.org>
From:	John-Paul Drawneek <john-paul.drawneek [...] classicstudios.co.uk>

Hi Andreas. Sorry for the slow reply. Downloaded the dev version and sql code was produced. Will try to test this more, as I do have more ER diagrams to do at some point. Show quoted text

-----Original Message----- From: Andreas Faafeng via RT [mailto:bug-Parse-Dia-SQL@rt.cpan.org] Sent: 10 April 2010 14:02 To: John-Paul Drawneek Subject: [rt.cpan.org #56357] parse dia not working for me with dia 0.97-3.5 <URL: https://rt.cpan.org/Ticket/Display.html?id=56357 > John-Paul, Please try the 0.14_02 version which has experimental support for the Dia database shape model. Best regards, Andreas --

______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email

______________________________________________________________________ Classic Studios is the trading name of Classic Studios Limited. Registered in England. Number 05925634. This e-mail (and any attachments) are confidential and may be privileged. If you are not the intended recipient do not copy, use, or rely on them. We do not accept any legal responsibility for the contents of this communication due to the generally insecure nature of email. The views and opinions expressed within this email are those of the author and are not necessarily those of Classic Studios. If you received this email in error, please notify the sender immediately. Classic Studios have taken reasonable precaution to ensure that any attachment to this e-mail has been swept for viruses. However, Classic Studios cannot accept liability for any damage sustained as a result of software viruses and would advise that you carry out your own virus checks before opening any attachment.

______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email

______________________________________________________________________

Tue Apr 13 04:46:27 2010 The RT System itself - Status changed from 'resolved' to 'open'

Thu May 27 06:16:15 2010 aff [...] cpan.org - Status changed from 'open' to 'resolved'

Thu May 27 06:16:16 2010 aff [...] cpan.org - Fixed in 0.15 added