Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Richard Freggi

Pages: 1 2 [3] 4 5 ... 26
SQLite Studio is free I think and very good.
DBeaver works fine with SQLite.  That's what I use.
SQLite has a gajillion open source front ends and IDEs (SQLite is the most used DBMS in the world: your phone and computer have several instances of it running right now): you can google SQLite frontend or SQLite IDE.  Some are browser-based, others are clients

I do the same as Paolo - a real physical reverse engineering schema model and a clone (I use logical level for the clone since there is no benefit to include the physical detail).
For views that don't have keys or a real relationship to the tables, I use dependencies.  It's debatable if it's OK to show a dependency between view and queried tables in a physical data model, but it's definitely no issue in a logical model.

Then, I represent the logic transformations (usually they are external scripts that read/write to the database, like Python, .net etc.) with procedures and functions (theoretically I could use artifacts but never felt the need).  These are not real but again, OK at logical level.  I always postfix the name of these non-physical objects to differentiate them from the actual database object: even at logical level, I use a postfix to indicate that the object is just a convenient representation.  I also add some explanation in the comment fields.

I use associations to tables and views show which objects are read/written by the procedures etc.

When forward engineering to physical level, it's up to the data engineer to decide what to do with the prefixed object (implement outside the database schema, implement as a new procedure, as a lookup table, trigger etc.).  Works well for me, it's clean, maintainable/scalable etc.

That makes sense QWERTY thanks. 

I have a model query that lists all messages in a sequence diagram and their message number.
The diagram has new message groups, so the message numbers are: 1.0 1.1 1.2 2.0 2.1 2.2 2.3 2.4 3.0  etc etc

I query t_connector.SeqNo and the result is: 1.0 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 etc

New message groups are ignored.  Everything else is OK.  Any idea where I can get the message numbers the way they are displayed in the diagram?  EA 13.10  Thanks!!!

can the beta version be installed an uninstalled along the current office Integration MDG without issues?  Also how do we submit feedback and suggestions about the MDG - thanks!!

I held off upgrading from my version 1310 because I wanted to avoid the trap of "where did my menu go?" and did not see much benefit overall.  But I'm very eager to upgrade to EA 16 with SQLite repository.

However I just found out that my 1310 has a bug for "Import schema from ODBC" for PostgreSQL (I'm reverse engineering from v. 12.02).  The trace log shows ERROR(ERROR) 42702 'column reference "oid" is ambiguous' at this stage: 

Code: [Select]
[53.579]PQsendQuery: 09C69420 'BEGIN;declare "SQL_CUR09FBCC88" cursor with hold for SELECT
    n.nspname                                       AS ObjectSchema,    --1
    c.relname                                       AS ObjectName,      --2
WHEN c.relkind = 'r' THEN 'TABLE'
        WHEN c.relkind = 'v' THEN 'VIEW'
        WHEN c.relkind = 'S' THEN 'SEQUENCE'
    END                                             AS ObjectType,     --3
    COALESCE(OBJ_DESCRIPTION(c.oid),'')             AS Remarks,     --4
    COALESCE('TABLESPACE=' || t.spcname || ';','')  AS Properties     --5
    (SELECT *, oid
    FROM pg_class
    WHERE relkind IN ('r','v')
    ) c   
    (SELECT *, oid
    FROM    pg_namespace
    WHERE nspname IN ('schema_names') --WHERE   nspname NOT IN ('other_schema_names')
    ) n
    ON  c.relnamespace = n.oid
    pg_tablespace t
    c.reltablespace = t.oid
Order By n.nspname, c.relkind, c.relname;fetch 100 in "SQL_CUR09FBCC88"'
[53.822] ok: - 'C' - BEGIN
[53.822] ERROR(ERROR) 42702 'column reference "oid" is ambiguous'
[53.823]PQsendQuery: 09C69420 'ROLLBACK'

I don't have access to EA16 since my registration expired: can anyone confirm if EA16 has no issues reverse engineering from PostgreSQL?  Thanks!!!!

General Board / Re: Indexes and constraints
« on: October 27, 2021, 10:21:55 pm »
QWERTY's book has the answers to questions you don't even know you need to know.  A must if you are querying the repository.  I cannot recommend it enough!  (Saved my bacon a few times)

General Board / Re: EA 16
« on: October 04, 2021, 01:06:31 pm »
Great, thanks very much Wivel!

General Board / Re: EA 16
« on: October 03, 2021, 09:03:41 pm »
WHAT WHAT WHAT?  EA 16 will support SQLite for its repository?  If so I'm buying!!!!  TAKE MY MONEY!!

I requested SQlite a few times via email and on this forum... did not watch the announcement but can anyone confirm?  Will the repository support SQLite in-memory database so that very large models can be imported very quickly?

My 2cents,

Moving to Sqlite for local databases is going to be a real game changer. SQLite has database diff and merge tooling out of the box, there is even some git support for it somewhere. Sharing models and settings alongside source code, branching and merging models and settings across projects for small teams. All sorts of fun. As SQLite tooling is available on pretty much every platform, copies of model databases can potentially be used as a source artifacts or configuration artifacts by downstream tools, without the need to spin up an EA instance or export any XML...

It also looks like the desktop is including more Javascript driven UI components... Will we see a true cross platform EA? An Electron based Desktop version that uses Prolaborate UI technology?

I may be wrong but I suspect that you are using the use case scenario as a stand-in for sequence diagrams.
You can get the same result more easily by limiting the text description of the use case to just the end result the Actor wants, without reference to the steps to achieve it.  Then append a sequence diagram to the use case - sequence diagrams are perfect for describing steps, special logic, sub (scenarios (fragments)) etc.  Same result, but easier, cleaner and more extensible to changes, new requirements etc!

Uml Process / Re: Relating Table Columns to Associations
« on: August 28, 2021, 01:22:56 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?

The IDEA plugin provides an excellent GUI to do this (it's free, in the Sparx plugin web page).  I use Geert's EA mapping because I don't need the diagrams, it's excellent!

I had similar error importing from Eclipse Papyrus a few years back, from memory I just manually edited the XMI file with another UML version and EA imported it OK.  Search this forum for Papyrus, I think I may have posted about it here.

Thanks!   *DRAG AWAY!!!*

I'm working on extending a data model and I realized that if I drag a class attribute from a class already in the diagram or from any class in the project explorer to another class in the diagram, I'm creating a new copy of the attribute.  Which is very convenient for me so I can reuse the attribute names and datatypes.  And faster than copying/pasting in the project explorer. 

I'd like to check if this causes any risk at all for model integrity?  I don't think this is normal way to use EA but hey if it works...  Thanks for advice!

Although what the OP wants to do is useful, I'm not sure if it is compatible with UML metamodel.  This would explain the limited support by EA.  I'd much prefer keeping EA fully consistent with UML over adding functionalities.

Maybe some Sparxians can help me here, I remember that in UML 2.5 Actors are classifiers but use cases are not (maybe?) so the proper UML way would be to use a class diagram (with OCL if really needed) to document the requirements as constraints on the classes.  Also can use the use cases descriptions to fill in semantics, context etc.  That would be fully supported by EA even for very large models.

Pages: 1 2 [3] 4 5 ... 26