Process for generation and optionally extraction of the RDBES table VD (Vessel Details).

rdbes_vd(
  observe_con,
  rdbes_table_cl = NULL,
  rdbes_table_ce = NULL,
  flag,
  hash_algorithms = NULL,
  encrypted_vessel_code_separator = ", ",
  export_path = NULL
)

Arguments

observe_con

list expected. Output of the function postgresql_dbconnection for a connection to the observe database.

rdbes_table_cl

data.frame or tibble expected. By default NULL. Table CL generated by the function rdbes_cl. Warning encrypted vessel code should be according to the database extraction (especially if there was hashing).

rdbes_table_ce

data.frame or tibble expected. By default NULL. Table CE generated by the function rdbes_ce. Warning encrypted vessel code should be according to the database extraction (especially if there was hashing).

flag

integer expected. Flag(s) selected associated to the databases queries extractions.

hash_algorithms

integer expected. By default NULL. The hashing algorithms to be used for the VDencrypVesIds variable. You can choose any modality of the argument "algo" or the function digest.

encrypted_vessel_code_separator

character expected. By default ", ". Which separator you want to use for the VDencrypVesIds variable.

export_path

character expected. By default NULL. Directory path associated for the export.

Value

A R object with the RDBES table VD with potentially a csv extraction associated.

Details

If the arguments "rdbes_table_cl", "rdbes_table_ce" or both are provided, the process generates a table VD according to input data of the data.frame/tibble associated (not from a database SQL extraction).