Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Specify database requirements and complete necessary config settings


https://github.com/UnionVMS/UVMS-SalesModule-APP

QA Summary App: https://sonarcloud.io/dashboard?id=eu.europa.ec.fisheries.uvms.sales%3Asales
CI location App: https://jenkins.focus.fish/view/UVMS%20App/job/UVMS-SalesModule-APP/
Project Site reports App: https://jenkins.focus.fish/view/Site-Reports/job/UVMS-SalesModule-APP-Site-Reports/site/
Tattletale report: https://jenkins.focus.fish/view/Site-Reports/job/UVMS-SalesModule-APP-Site-Reports/ws/module/target/site/tattleTaleReport/index.html

Module description

Sales notes are required in respect of first sales of fish and fishery products. For the purposes of these requirements first sale fish is defined as fish being marketed for the first time. Sales notes provide an essential aid in cross checking the quantities of fish recorded in logbooks and on landing declarations as well as providing information about market prices and compliance with the Community's grading and price regulations.

...

Code Block
languagexml
themeConfluence
titleDatasources
<datasource jta="true" jndi-name="java:/jdbc/uvms_sales" pool-name="jdbc/uvms_sales" enabled="true" use-ccm="true">
     <connection-url>jdbc:postgresql://dburl/uvms?defaultSchema=sales</connection-url>
     <driver-class>org.postgresql.Driver</driver-class>
     <driver>postgresql</driver>
     <security>
          <user-name>sales</user-name>
          <password>sales</password>
     </security>
</datasource>

The sales application lets you free in choosing the schema name.
On the other side, this also means that the schema name is not included in queries, so make sure that the schema is on the user's search path.

Creating the database and filling it with dummy data

...

Type of settingKeyExample
global
flux_local_nation_code
BEL
global
currency
EUR
modulesales.flux_data_flowurn:un:unece:uncefact:fisheries:FLUX:SALES:EU:2
modulesales.ebc.proxy.endpointhttp://sdw-wsrest.ecb.europa.eu/service/data/EXR/D..EUR.SP00.A


Related plugins and proxies

...