...
| Code Block | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
<spatial:spatialengine id="sdbeos"> <dbtype>oracle</dbtype> <host>sdbeos</host> <port>1521</port> <database>staging</database> <user>data_viewer</user> <passwd>ENCSSJKXUMJBMTPGEJFGCXCQFXJJZUTMJZJ</passwd> <schema>ASSETS</schema> </spatial:spatialengine> |
Primary Key Metadata
If the primary key for a table can not be determined by Weave directly from the database then the information can be provided by creating a table or directly embedding the information in the spatial engine configuration.
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
CREATE TABLE gt_pk_metadata (
table_schema VARCHAR(32),
table_name VARCHAR(32) NOT NULL,
pk_column VARCHAR(32) NOT NULL,
pk_column_idx INTEGER,
pk_policy VARCHAR(32),
pk_sequence VARCHAR(64),
unique (table_schema, table_name, pk_column),
check (pk_policy in ('sequence', 'assigned', 'autogenerated'))
)
|
...
| Code Block |
|---|
<spatial:spatialengine id="sdbeos">
<dbtype>oracle</dbtype>
<host>sdbeos</host>
<port>1521</port>
<database>staging</database>
<user>data_viewer</user>
<passwd>ENCSSJKXUMJBMTPGEJFGCXCQFXJJZUTMJZJ</passwd>
<schema>ASSETS</schema>
<primarykeymetadata>
<table schema="ASSETS" name="PARK" column="GID" policy="autogenerated"/>
<table schema="ASSETS" name="PROPERTY" column="PARK_ID" type="autogenerated"/>
<table schema="ASSETS" name="ROAD" column="OBJECTID" type="autogenerated"/>
</primarykeymetadata>
</spatial:spatialengine> |
Geometry metadata
...
The Oracle data store will, by default, look into the MDSYS.USER_SDO* and MDSYS.ALL_SDO* views to determine the geometry type and native SRID of each geometry column. Those views are automatically populated with information about the geometry columns stored in tables that the current user owns (for the MDSYS.USER_SDO* views) or can otherwise access (for the MDSYS.ALL_SDO* views).
...