dg:Funções de ingestão: mudanças entre as edições

De Documentação
Sem resumo de edição
Sem resumo de edição
Linha 1: Linha 1:
*Texto original: https://github.com/digital-guard/preserv/blob/main/docs/pt/man-ingestFunctions.md
SQL Schema <code>ingest</code>.
SQL Schema <code>ingest</code>.


Linha 192: Linha 194:
</tr>
</tr>
</table>
</table>
----
{| class="wikitable"
!Function / Description / Example
|-
|
any_load(text, text, text, text, bigint, text, ARRAY, integer, text, boolean) →  text
Load (into ingest.feature_asis) shapefile or any other non-GeoJSON, of a separated table. 
|-
|
any_load(text, text, text, text, text, text, ARRAY, integer, text, boolean) →  text
Wrap to ingest.any_load(1,2,3,4=real) using string format DD_DD. 
|-
|
any_load_debug(text, text, text, text, text, text, ARRAY, text, boolean) →  jsonb
|-
|
donated_packcomponent_distribution_prefixes(integer) →  _text
|-
|
donated_packcomponent_geomtype(bigint) →  _text
[Geomtype,ftname,class_ftname,shortname_pt] of a layer_file. 
|-
|
fdw_csv_paths(text, text, text) →  _text
|-
|
fdw_generate(text, text, text, ARRAY, boolean, text, text, boolean) →  text
Generates a structure FOREIGN TABLE for ingestion. 
|-
|
fdw_generate_direct_csv(text, text, text, boolean, boolean) →  text
Generates a FOREIGN TABLE for simples and direct CSV ingestion. 
|-
|
fdw_generate_getclone(text, text, text, ARRAY, ARRAY, text) →  text
Generates a clone-structure FOREIGN TABLE for ingestion. Wrap for fdw_generate(). 
|-
|
fdw_generate_getcsv(text, text, text, text) →  text
|-
|
feature_asis_assign(bigint) →  jsonb
|-
|
feature_asis_assign_format(bigint, text, text, text) →  text
|-
|
feature_asis_assign_signature(bigint) →  jsonb
|-
|
feature_asis_assign_volume(bigint, boolean) →  jsonb
|-
|
feature_asis_export(bigint, text, integer, jsonb, USER-DEFINED) →  record
|-
|
feature_asis_geohashes(bigint, integer) →  jsonb
|-
|
feature_asis_similarity(bigint, USER-DEFINED, ARRAY) →  jsonb
|-
|
geojson_load(text, integer, real, text, text, boolean) →  text
|-
|
getmeta_to_file(text, integer, bigint, text, integer, text) →  int8
Reads file metadata and inserts it into ingest.donated_PackComponent. If proc_step=1 returns valid ID else NULL. 
|-
|
getmeta_to_file(text, integer, bigint) →  int8
Reads file metadata and return id if exists in ingest.donated_PackComponent. 
|-
|
getmeta_to_file(text, text, bigint) →  int8
Wrap para ingest.getmeta_to_file(text,int,bigint) usando ftName ao invés de ftID. 
|-
|
getmeta_to_file(text, text, bigint, text, integer, text) →  int8
Wrap para ingest.getmeta_to_file() usando ftName ao invés de ftID. 
|-
|
insert_bytesize(jsonb) →  jsonb
|-
|
join(text, text, text, text, text, text) →  text
Join layer and cadlayer. 
|-
|
jplanet_inserts_and_drops(smallint, boolean) →  void
|-
|
jsonb_mustache_prepare(jsonb, text) →  jsonb
|-
|
lix_generate_make_conf_with_license(text, text) →  text
|-
|
lix_generate_make_conf_with_size(text, text) →  text
|-
|
lix_generate_makefile(text, text) →  text
|-
|
lix_generate_readme(text, text) →  text
|-
|
lix_insert(text) →  void
|-
|
load_codec_type(text, text, text) →  text
Load codec_type.csv. 
|-
|
load_hcode_parameters(text, text, text) →  text
Load hcode_parameters.csv. 
|-
|
osm_load(text, text, text, bigint, text, ARRAY, integer, text, boolean) →  text
|-
|
osm_load(text, text, text, text, text, ARRAY, integer, text, boolean) →  text
Wrap to ingest.osm_load(1,2,3,4=real) using string format DD_DD. 
|-
|
package_layers_summary(real, text, text) →  xml
|-
|
publicating_geojsons(bigint, text, text) →  text
|-
|
publicating_geojsons(text, text, text) →  text
Wrap to ingest.publicating_geojsons 
|-
|
publicating_geojsons_p1(bigint, text) →  text
|-
|
publicating_geojsons_p2(bigint, text, boolean) →  text
|-
|
publicating_geojsons_p3(bigint, text, text) →  text
|-
|
publicating_geojsons_p4(bigint, text, text) →  text
|-
|
qgis_vwadmin_feature_asis(text) →  text
|}
[[Categoria:Digital-guard]]
[[Categoria:Digital-guard]]

Edição das 15h58min de 3 de maio de 2023

SQL Schema ingest.

Function / Description / Example

any_load(text, text, text, text, bigint, text, ARRAY, integer, text, boolean) → text

Load (into ingest.feature_asis) shapefile or any other non-GeoJSON, of a separated table.

any_load(text, text, text, text, text, text, ARRAY, integer, text, boolean) → text

Wrap to ingest.any_load(1,2,3,4=real) using string format DD_DD.

any_load_debug(text, text, text, text, text, text, ARRAY, text, boolean) → jsonb

donated_packcomponent_distribution_prefixes(integer) → _text

donated_packcomponent_geomtype(bigint) → _text

[Geomtype,ftname,class_ftname,shortname_pt] of a layer_file.

fdw_csv_paths(text, text, text) → _text

fdw_generate(text, text, text, ARRAY, boolean, text, text, boolean) → text

Generates a structure FOREIGN TABLE for ingestion.

fdw_generate_direct_csv(text, text, text, boolean, boolean) → text

Generates a FOREIGN TABLE for simples and direct CSV ingestion.

fdw_generate_getclone(text, text, text, ARRAY, ARRAY, text) → text

Generates a clone-structure FOREIGN TABLE for ingestion. Wrap for fdw_generate().

fdw_generate_getcsv(text, text, text, text) → text

feature_asis_assign(bigint) → jsonb

feature_asis_assign_format(bigint, text, text, text) → text

feature_asis_assign_signature(bigint) → jsonb

feature_asis_assign_volume(bigint, boolean) → jsonb

feature_asis_export(bigint, text, integer, jsonb, USER-DEFINED) → record

feature_asis_geohashes(bigint, integer) → jsonb

feature_asis_similarity(bigint, USER-DEFINED, ARRAY) → jsonb

geojson_load(text, integer, real, text, text, boolean) → text

getmeta_to_file(text, integer, bigint, text, integer, text) → int8

Reads file metadata and inserts it into ingest.donated_PackComponent. If proc_step=1 returns valid ID else NULL.

getmeta_to_file(text, integer, bigint) → int8

Reads file metadata and return id if exists in ingest.donated_PackComponent.

getmeta_to_file(text, text, bigint) → int8

Wrap para ingest.getmeta_to_file(text,int,bigint) usando ftName ao invés de ftID.

getmeta_to_file(text, text, bigint, text, integer, text) → int8

Wrap para ingest.getmeta_to_file() usando ftName ao invés de ftID.

insert_bytesize(jsonb) → jsonb

join(text, text, text, text, text, text) → text

Join layer and cadlayer.

jplanet_inserts_and_drops(smallint, boolean) → void

jsonb_mustache_prepare(jsonb, text) → jsonb

lix_generate_make_conf_with_license(text, text) → text

lix_generate_make_conf_with_size(text, text) → text

lix_generate_makefile(text, text) → text

lix_generate_readme(text, text) → text

lix_insert(text) → void

load_codec_type(text, text, text) → text

Load codec_type.csv.

load_hcode_parameters(text, text, text) → text

Load hcode_parameters.csv.

osm_load(text, text, text, bigint, text, ARRAY, integer, text, boolean) → text

osm_load(text, text, text, text, text, ARRAY, integer, text, boolean) → text

Wrap to ingest.osm_load(1,2,3,4=real) using string format DD_DD.

package_layers_summary(real, text, text) → xml

publicating_geojsons(bigint, text, text) → text

publicating_geojsons(text, text, text) → text

Wrap to ingest.publicating_geojsons

publicating_geojsons_p1(bigint, text) → text

publicating_geojsons_p2(bigint, text, boolean) → text

publicating_geojsons_p3(bigint, text, text) → text

publicating_geojsons_p4(bigint, text, text) → text

qgis_vwadmin_feature_asis(text) → text

Function / Description / Example

any_load(text, text, text, text, bigint, text, ARRAY, integer, text, boolean) → text Load (into ingest.feature_asis) shapefile or any other non-GeoJSON, of a separated table.

any_load(text, text, text, text, text, text, ARRAY, integer, text, boolean) → text Wrap to ingest.any_load(1,2,3,4=real) using string format DD_DD.

any_load_debug(text, text, text, text, text, text, ARRAY, text, boolean) → jsonb

donated_packcomponent_distribution_prefixes(integer) → _text

donated_packcomponent_geomtype(bigint) → _text [Geomtype,ftname,class_ftname,shortname_pt] of a layer_file.

fdw_csv_paths(text, text, text) → _text

fdw_generate(text, text, text, ARRAY, boolean, text, text, boolean) → text Generates a structure FOREIGN TABLE for ingestion.

fdw_generate_direct_csv(text, text, text, boolean, boolean) → text Generates a FOREIGN TABLE for simples and direct CSV ingestion.

fdw_generate_getclone(text, text, text, ARRAY, ARRAY, text) → text Generates a clone-structure FOREIGN TABLE for ingestion. Wrap for fdw_generate().

fdw_generate_getcsv(text, text, text, text) → text

feature_asis_assign(bigint) → jsonb

feature_asis_assign_format(bigint, text, text, text) → text

feature_asis_assign_signature(bigint) → jsonb

feature_asis_assign_volume(bigint, boolean) → jsonb

feature_asis_export(bigint, text, integer, jsonb, USER-DEFINED) → record

feature_asis_geohashes(bigint, integer) → jsonb

feature_asis_similarity(bigint, USER-DEFINED, ARRAY) → jsonb

geojson_load(text, integer, real, text, text, boolean) → text

getmeta_to_file(text, integer, bigint, text, integer, text) → int8 Reads file metadata and inserts it into ingest.donated_PackComponent. If proc_step=1 returns valid ID else NULL.

getmeta_to_file(text, integer, bigint) → int8 Reads file metadata and return id if exists in ingest.donated_PackComponent.

getmeta_to_file(text, text, bigint) → int8 Wrap para ingest.getmeta_to_file(text,int,bigint) usando ftName ao invés de ftID.

getmeta_to_file(text, text, bigint, text, integer, text) → int8 Wrap para ingest.getmeta_to_file() usando ftName ao invés de ftID.

insert_bytesize(jsonb) → jsonb

join(text, text, text, text, text, text) → text Join layer and cadlayer.

jplanet_inserts_and_drops(smallint, boolean) → void

jsonb_mustache_prepare(jsonb, text) → jsonb

lix_generate_make_conf_with_license(text, text) → text

lix_generate_make_conf_with_size(text, text) → text

lix_generate_makefile(text, text) → text

lix_generate_readme(text, text) → text

lix_insert(text) → void

load_codec_type(text, text, text) → text Load codec_type.csv.

load_hcode_parameters(text, text, text) → text Load hcode_parameters.csv.

osm_load(text, text, text, bigint, text, ARRAY, integer, text, boolean) → text

osm_load(text, text, text, text, text, ARRAY, integer, text, boolean) → text Wrap to ingest.osm_load(1,2,3,4=real) using string format DD_DD.

package_layers_summary(real, text, text) → xml

publicating_geojsons(bigint, text, text) → text

publicating_geojsons(text, text, text) → text Wrap to ingest.publicating_geojsons

publicating_geojsons_p1(bigint, text) → text

publicating_geojsons_p2(bigint, text, boolean) → text

publicating_geojsons_p3(bigint, text, text) → text

publicating_geojsons_p4(bigint, text, text) → text

qgis_vwadmin_feature_asis(text) → text

Disponível em “https://wiki.addressforall.org/w/index.php?title=dg:Funções_de_ingestão&oldid=1100”