Book a Demo

Author Topic: Representation of Repository in database table  (Read 3184 times)

MatthiasVDE

  • EA User
  • **
  • Posts: 196
  • Karma: +1/-0
    • View Profile
Representation of Repository in database table
« on: December 05, 2019, 01:04:32 am »
Which database table represents the 'repository' object? I mean properties like connectionstring, instanceguid, ...

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Representation of Repository in database table
« Reply #1 on: December 05, 2019, 01:10:38 am »
None,

Connectionstring is not a property of a repository, but of the connection the client uses to connect.

There is a unique ID of a repository however, and that is stored in the table usys_system

Code: [Select]
select * from usys_system where property ='projectGUID'
Geert

MatthiasVDE

  • EA User
  • **
  • Posts: 196
  • Karma: +1/-0
    • View Profile
Re: Representation of Repository in database table
« Reply #2 on: December 05, 2019, 01:13:32 am »
Thx Geert.

So the properties from the Repository object are stored in various tables?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Representation of Repository in database table
« Reply #3 on: December 05, 2019, 01:20:03 am »
Which properties are we talking about? A lot of the properties of EA.Repository are not actually not related to the database at all (such as LibraryVersion which is the version of the EA client used to connect to the database)

Geert

MatthiasVDE

  • EA User
  • **
  • Posts: 196
  • Karma: +1/-0
    • View Profile
Re: Representation of Repository in database table
« Reply #4 on: December 05, 2019, 01:23:47 am »
For example 'Models'. How are they related to the 'repository' in the database? Or does the database only represents one repository?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Representation of Repository in database table
« Reply #5 on: December 05, 2019, 01:41:48 am »
Models is the list of top level packages (t_package)

Geert