search

IKAMR / KDRS_Metadata

MIT License
0 stars 0 forks source link

Composite keys? #19

Closed PhillipTommerholt closed 2 years ago

PhillipTommerholt commented 3 years ago

Hi guys, Nice tool!

The first thing I notice is that it seems that composite keys is not shown in the output?

Best Phillip

solfeggietto commented 3 years ago

Please let us know if any SIARD file of any version or produced by any app/version does not get their primary, foreign or candidate keys properly stored in the Excel output file for the individual table tab in the spreadsheet.

The counter of keys present as you can see in the app dialog window at completed job and in the logfile, may have bugs as this is a feature added late in the latest version(s) and need be tested and possibly done bugfix on. I added it because those statistics give a good overview of the presence or lacking of the different keys in the tables.

Example from a logfile on KDRS Metadata v0.94:

Tables: 77 schema0: , rows: 373066, Total rows: 373066, Max rows: 124979, PKs: 40, FKs: 1, CKs: 94, noPKs: 37, noFKs: 0, noCKs: 0, yesFKs: 77, yesCKs: 77

PhillipTommerholt commented 3 years ago

This metadata.xml has a composite PK on tables "Orders". metadata.zip

<primaryKey>
            <name>PK_Orders</name>
            <column>OrderID</column>
    <column>CustomerID</column>

The output is: image Only showing one the columns of the PK.

solfeggietto commented 3 years ago

We must fix this bug coming week.

solfeggietto commented 2 years ago

Solved in version 0.9.5-RC1