Messages

1

General Board / Re: Migration from EA15 to EA16; What do we lose?

« on: May 05, 2022, 06:09:37 pm »

The 64 bit edition of Enterprise Architect does not support '.eapx' model files.
You can migrate this model to a compatible format now using this upgrade too. To proceed,
select a suitable format from the supported list below.

Note you existing model will not be affected  by this process and will remain available in its
current location.

That's the text on the dialog that is shown if you attempt to open an eapx file with EA 16 64 bit. (Along with additional explanatory text describing each of the formats it will offer.)

It's described as both a migrate and an upgrade, but other than that it's pretty clear about what is going on. I struggle to see any way you can describe this as "I didn't move to a different database - the upgrade itself did that without my asking."

I only meant that I chose to upgrade to EA16 64-bit and so I had no choice but to upgrade/migrate/move/whatever to a .qea file. I'm not complaining about it, only trying to point out to others that there may be some (considerable in my case) further activity involved in the process. I don't have access to any other 'proper' database because my client won't allow it.

2

General Board / Re: SQLite Can't add 1+1?

« on: May 05, 2022, 02:03:19 am »

Your query runs on my native SQLite (I don't have EA V16)

By ANSI SQL I meant

SELECT 1+1 AS "Two", typeof(1) AS "Type1", typeof(1+1) AS "Type2"

|Two|Type1  |Type2  |
|----|--------|---------|
|2   |integer |integer |

SQLite defaults to TEXT datatype whenever possible, so it may be the EA 16 SQLite driver that's playing games on you

OK thanks for the clarification. I still have the problem if I just issue:

SELECT 1 + 1

I'm sure it will be the EA16 driver as you say. I've reported a bug.

3

General Board / Re: Migration from EA15 to EA16; What do we lose?

« on: May 05, 2022, 12:13:16 am »

Probably not. Sparx is pretty good in keeping their versions backwards compatible.

Geert

OK, I have upgraded to EA16 and immediately many of my SQL queries (searches, fragments) do not work, as I suspected. Examples so far are 'wrong number of arguments to instr', 'no such function cstr', 'no such function mid'. Everyone should be aware that there will be possibly a lot of manual migration work after an upgrade from eapx to qea local file.

Sure, but you did more then upgrade.
You use database specific syntax in a query, then moved to a different database, and you are now surprised the other database complains about your syntax.
If I move to Oracle from SQL Server, lots of my queries will stop working as well. No need to upgrade to see that.

Geert

No, I didn't move to a different database - the upgrade itself did that without my asking. I'm not complaining and I'm not surprised. I only asked whether there was manual work needed as a result of the upgrade, which there is.

4

General Board / Re: SQLite Can't add 1+1?

« on: May 04, 2022, 09:01:10 pm »

Read up on sqlite.org, your syntax is off (SQLite is ANSI SQL, your query is not)

Please could you be more specific? What is the syntax I have done incorrectly?

5

General Board / SQLite Can't add 1+1?

« on: May 04, 2022, 08:44:00 pm »

I'm new to SQLite SQL so please can someone help explain why this SQL:

select 1 + 1 as two, typeof(1) as onetype, typeof(1 + 1) as twotype
from t_object
limit 1

returns 11, integer, text

Is there a very different approach to standard arithmetic in this database?

6

General Board / Re: Migration from EA15 to EA16; What do we lose?

« on: May 04, 2022, 07:56:32 pm »

You are using different database engines eap/eapx is essentially an Access database and qeapx are SQL Lite. This is why your SQL statements are broken.

Sparx is good with backwards compatibility but that does not apply and has never applied to SQL queries.

Thank you for your input. My original question asked whether the change from eapx to sqlite would require manual actions from me. I now know it does. Others may wish to know too.

7

General Board / Re: Migration from EA15 to EA16; What do we lose?

« on: May 04, 2022, 07:21:56 pm »

Are you using a proper database as the repository or have you moved/upgraded from eapx to qeapx files?

I moved an eapx file to a qea file. No proper database involved.

8

General Board / Re: Migration from EA15 to EA16; What do we lose?

« on: May 04, 2022, 06:46:15 pm »

Probably not. Sparx is pretty good in keeping their versions backwards compatible.

Geert

OK, I have upgraded to EA16 and immediately many of my SQL queries (searches, fragments) do not work, as I suspected. Examples so far are 'wrong number of arguments to instr', 'no such function cstr', 'no such function mid'. Everyone should be aware that there will be possibly a lot of manual migration work after an upgrade from eapx to qea local file.

9

General Board / Migration from EA15 to EA16; What do we lose?

« on: May 04, 2022, 03:16:36 am »

Does anyone know what things in EA15 are no longer supported in EA16 and what manual conversion activity is required to upgrade? Specifically, I'm concerned that my existing VBScript scripts might not be supported and that the SQL queries I have created on a .eapx file might need rewriting for SQLite database. Is there anything else I might need to rewrite or change?

10

Uml Process / Re: Relating Table Columns to Associations

« on: June 13, 2021, 09:29:16 pm »

Thanks very much. I have found a way to model exactly what I want, although it's not straightforward. I discovered that I can start a realisation connector from an association connector and target a table column, then reverse the direction of that connector so the column now realises the association. Here is an example diagram of what I want:

On the diagram, that is exactly what I want, but my remaining problem is how to get that model as text in a document with the description of each realisation e.g.
"Column CLUB_MEMBER.MEMBER_ID realises attribute Club Member (Member ID)
...
Column CLUB_MEMBER.CLUB_ID realises association Club Member member of Club
..."
I can see the realisation connectors in t_connector and I know there is a proxy connector object involved in the linkages now, and that t_xref might have some part to play, but I can't see how to join t_connector, t_object and t_attribute to get the above text for my documentation. Can anyone help with the SQL?

11

Uml Process / Re: Relating Table Columns to Associations

« on: June 13, 2021, 06:42:38 am »

Thanks very much for the suggestions. However, I would really like to be able to map columns back to relations and not classes or attributes, since the attributes represented by the column do not exist in the model except as associations, and I'd rather not modify my logical model (e.g. by converting all relations to attributes) just so I can map one particular physical model to it.

12

Uml Process / Re: Relating Table Columns to Associations

« on: May 11, 2021, 07:23:22 pm »

Thank Geert, that's helpful and I will try your add-in on my own copy of EA but I will not be able to modify the EA installation in my client's copy so unfortunately that won't work for me. Does anyone know a native EA way to do this, even if it is less straightforward than EA toolpack? I'd still like to know where EA records which features are connected by a connector using the feature matrix, and how the DDL transformer maps a column to an association.

13

Uml Process / Relating Table Columns to Associations

« on: May 11, 2021, 01:55:34 am »

In the feature matrix or a diagram, I can create a link between a table column and a class attribute that it realises. However, some attributes are implicit, such as associations. When I use the DDL transform, these implicit attributes are created as columns and a transform connector is created under the covers (I believe).
1. Is there a way for me to create a visible connector from an existing table column to an association/aggregation/composition between two classes to indicate that the column realises that relation?
2. I can see in the t_connector table that the feature matrix creates one connector for each attribute/column combination I link using the feature matrix, but I can't see how to find the attribute and column names that are at the connector ends - where is that? I'd like to show it in my documentation using a SQL fragment.