Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "BaSyx / Download / Components Setup"
m (Changes db entries to fit test cases) |
|||
| Line 47: | Line 47: | ||
INSERT INTO directory.directory ( "ElementID", "ElementRef" ) VALUES ( | INSERT INTO directory.directory ( "ElementID", "ElementRef" ) VALUES ( | ||
| − | 'urn:de.FHG:es.iese:aas:0.98:5:lab/microscope#A-19', ' | + | 'urn:de.FHG:es.iese:aas:0.98:5:lab/microscope#A-19', 'content.aas1' ); |
INSERT INTO directory.directory ( "ElementID", "ElementRef" ) VALUES ( | INSERT INTO directory.directory ( "ElementID", "ElementRef" ) VALUES ( | ||
| − | 'urn:de.FHG:es.iese:aas:0.98:5:lab/microscope#A-18', ' | + | 'urn:de.FHG:es.iese:aas:0.98:5:lab/microscope#A-18', 'content.aas2' ); |
INSERT INTO directory.directory ( "ElementID", "ElementRef" ) VALUES ( 'urn:de.FHG:es.iese:aas:0.98:5:lab/microscope#A-17', 'content.aas3' ); | INSERT INTO directory.directory ( "ElementID", "ElementRef" ) VALUES ( 'urn:de.FHG:es.iese:aas:0.98:5:lab/microscope#A-17', 'content.aas3' ); | ||
Revision as of 04:36, 29 July 2019
How to run the BaSyx Components
The Components package requires an SQL backend to be able to run the DirectorySQLProvider. This backend can for example be provided by postgreSQL.
Choose the following credentials:
user: postgres
password: admin
To setup the database for the test cases use the following commands:
|
Create configuration directory: initdb -D "*PATH*" -U *USER* default user: postgres Start database: pg_ctl -D "*PATH*" start Connect command line to running instance: psql -U *USER* Create and fill database: CREATE DATABASE "basyx-map"; \c basyx-map CREATE SCHEMA elements; CREATE DATABASE "basyx-directory"; \c basyx-directory CREATE SCHEMA directory; CREATE TABLE directory.directory ( "ElementRef" varchar(999999), "ElementID" varchar(999999) primary key ); INSERT INTO directory.directory ( "ElementID", "ElementRef" ) VALUES ( 'urn:de.FHG:es.iese:aas:0.98:5:lab/microscope#A-19', 'content.aas1' ); INSERT INTO directory.directory ( "ElementID", "ElementRef" ) VALUES ( 'urn:de.FHG:es.iese:aas:0.98:5:lab/microscope#A-18', 'content.aas2' ); INSERT INTO directory.directory ( "ElementID", "ElementRef" ) VALUES ( 'urn:de.FHG:es.iese:aas:0.98:5:lab/microscope#A-17', 'content.aas3' ); INSERT INTO directory.directory ( "ElementID", "ElementRef" ) VALUES ( 'urn:de.FHG:es.iese:aas:0.98:5:lab/microscope#A-16', 'content.aas4' ); INSERT INTO directory.directory ( "ElementID", "ElementRef" ) VALUES ( 'urn:de.FHG:es.iese:aas:0.98:5:lab/microscope#A-15', 'content.aas5' ); |