Ważne

Tłumaczenie jest wysiłkiem społeczności QGISa przyłącz się. Ta strona jest obecnie przetłumaczona w 62.01%.

24.1.3. Baza danych

24.1.3.1. Export to PostgreSQL

Exports a vector layer to a PostgreSQL database, creating a new relation. If a relation with the same name exists, it can be removed before the new relation is created. Prior to this a connection between QGIS and the PostgreSQL database has to be created (see eg Creating a stored Connection).

Parametry

Etykieta	Nazwa	Typ	Opis
Layer to import	INPUT	[vector: any]	Vector layer to add to the database
Database (connection name)	DATABASE	[ciąg tekstowy]	Name of the database connection (not the database name). Existing connections will be shown in the combobox.
Schema (schema name) Opcjonalne	SCHEMA	[ciąg tekstowy] Default: «public»	Name of the schema to store the data. It can be a new one or already exist.
Table to import to (leave blank to use layer name) Opcjonalne	TABLENAME	[ciąg tekstowy] Domyślnie: «»	Defines a table name for the imported vector file. If nothing is added, the layer name will be used.
Primary key field Opcjonalne	PRIMARY_KEY	[tablefield: any]	Sets the primary key field from an existing field in the vector layer. A column with unique values can be used as Primary key for the database.
Geometry column	GEOMETRY_COLUMN	[ciąg tekstowy] Domyślnie: «geom»	Defines the name of the geometry column in the new PostGIS table. Geometry information for the features is stored in this column.
Kodowanie Opcjonalne	ENCODING	[ciąg tekstowy] Domyślnie: «UTF-8»	Defines the encoding of the output layer
Overwrite	OVERWRITE	[wartość logiczna] Domyślnie: True	If the specified table exists, setting this option to True will make sure that it is deleted and a new table will be created before the features are added. If this option is False and the table exists, the algorithm will throw an exception („relation already exists”).
Create spatial index	CREATEINDEX	[wartość logiczna] Domyślnie: True	Specifies whether to create a spatial index or not
Convert field names to lowercase	LOWERCASE_NAMES	[wartość logiczna] Domyślnie: True	Converts the field names of the input vector layer to lowercase
Drop length constraint on character fields	DROP_STRING_LENGTH	[wartość logiczna] Domyślnie: False	Should length constraints on character fields be dropped or not
Create single-part geometries instead of multi-part	FORCE_SINGLEPART	[wartość logiczna] Domyślnie: False	Should the features of the output layer be single-part instead of multi-part. By default the existing geometries information are preserved.

Wyniki

The algorithm has no output.

Kod pythona

ID algorytmu: qgis:importintopostgis

import processing
processing.run("algorithm_id", {parameter_dictionary})

The algorithm id is displayed when you hover over the algorithm in the Processing Toolbox. The parameter dictionary provides the parameter NAMEs and values. See Using processing algorithms from the console for details on how to run processing algorithms from the Python console.

24.1.3.2. Export to SpatiaLite

Exports a vector layer to a SpatiaLite database. Prior to this a connection between QGIS and the SpatiaLite database has to be created (see eg SpatiaLite Layers).

Parametry

Etykieta	Nazwa	Typ	Opis
Layer to import	INPUT	[vector: any]	Vector layer to add to the database
File database	DATABASE	[vector: any]	The SQLite/SpatiaLite database file to connect to
Table to import to (leave blank to use layer name) Opcjonalne	TABLENAME	[ciąg tekstowy] Domyślnie: «»	Defines the table name for the imported vector file. If nothing is specified, the layer name will be used.
Primary key field Opcjonalne	PRIMARY_KEY	[tablefield: any]	Use a field in the input vector layer as the primary key
Geometry column	GEOMETRY_COLUMN	[ciąg tekstowy] Domyślnie: «geom»	Defines the name of the geometry column in the new SpatiaLite table. Geometry information for the features is stored in this column.
Kodowanie Opcjonalne	ENCODING	[ciąg tekstowy] Domyślnie: «UTF-8»	Defines the encoding of the output layer
Overwrite	OVERWRITE	[wartość logiczna] Domyślnie: True	If the specified table exists, setting this option to True will make sure that it is deleted and a new table will be created before the features of the layer is added. If this option is False and the table exists, the algorithm will throw an exception („table already exists”).
Create spatial index	CREATEINDEX	[wartość logiczna] Domyślnie: True	Specifies whether to create a spatial index or not
Convert field names to lowercase	LOWERCASE_NAMES	[wartość logiczna] Domyślnie: True	Convert the field names of the input vector layer to lowercase
Drop length constraint on character fields	DROP_STRING_LENGTH	[wartość logiczna] Domyślnie: False	Should length constraints on character fields be dropped or not
Create single-part geometries instead of multi-part	FORCE_SINGLEPART	[wartość logiczna] Domyślnie: False	Should the features of the output layer be single-part instead of multi-part. By default the existing geometries information are preserved.

Wyniki

The algorithm has no output.

Kod pythona

ID algorytmu: qgis:importintospatialite

import processing
processing.run("algorithm_id", {parameter_dictionary})

The algorithm id is displayed when you hover over the algorithm in the Processing Toolbox. The parameter dictionary provides the parameter NAMEs and values. See Using processing algorithms from the console for details on how to run processing algorithms from the Python console.

24.1.3.3. Package layers

Adds layers to a GeoPackage.

If the GeoPackage exists and Overwrite existing GeoPackage is checked, it will be overwritten (removed and recreated). If the GeoPackage exists and Overwrite existing GeoPackage is not checked, the layer will be appended.

Parametry

Etykieta	Nazwa	Typ	Opis
Warstwy wejściowe	LAYERS	[vector: any] [list]	The (vector) layers to import into the GeoPackage. Raster layers are not supported. If a raster layer is added, a QgsProcessingException will be thrown.
Overwrite existing GeoPackage	OVERWRITE	[wartość logiczna] Domyślnie: False	If the specified GeoPackage exists, setting this option to True will make sure that it is deleted and a new one will be created before the layers are added. If set to False, layers will be appended.
Save layer styles into GeoPackage	SAVE_STYLES	[wartość logiczna] Domyślnie: True	Zapisz style warstwy
Save only selected features	SELECTED_FEATURES_ONLY	[wartość logiczna] Domyślnie: False	If a layer has a selection, setting this option to True will result in only selected features being saved. For layers without a selection all features will be saved.
Export related layers following relations defined in the project	EXPORT_RELATED_LAYERS	[wartość logiczna] Domyślnie: False	If an input layer has relations set in the project, setting this option to True will result in exporting also its related layer(s). If the layer has features selected, then only their related features will be exported unless the related layer was also an input layer.
Destination GeoPackage	OUTPUT	[plik] Domyślnie: [Zapisz do pliku tymczasowego]	Specify where to store the GeoPackage file. One of Zapisz do pliku tymczasowego Zapisz do pliku…

Wyniki

Etykieta	Nazwa	Typ	Opis
Layers within new package	OUTPUT_LAYERS	[string] [list]	The list of layers added to the GeoPackage.

Kod pythona

ID algorytmu: native:package

import processing
processing.run("algorithm_id", {parameter_dictionary})

The algorithm id is displayed when you hover over the algorithm in the Processing Toolbox. The parameter dictionary provides the parameter NAMEs and values. See Using processing algorithms from the console for details on how to run processing algorithms from the Python console.

24.1.3.4. PostgreSQL execute and load SQL

Allows a SQL database query to be performed on a PostgreSQL database connected to QGIS and loads the result. The algorithm won’t create a new layer: it is designed to run queries on the layer itself.

Przykład

1. Set all the values of an existing field to a fixed value. The SQL query string will be:

   UPDATE your_table SET field_to_update=20;
   

   In the example above, the values of the field field_to_update of the table your_table will be all set to 20.

2. Create a new area column and calculate the area of each feature with the ST_AREA PostGIS function.

   -- Create the new column "area" on the table your_table"
   ALTER TABLE your_table ADD COLUMN area double precision;
   -- Update the "area" column and calculate the area of each feature:
   UPDATE your_table SET area=ST_AREA(geom);
   

Zobacz także

PostgreSQL execute SQL, Wykonaj SQL, SpatiaLite execute SQL

Parametry

Etykieta	Nazwa	Typ	Opis
Database (connection name)	DATABASE	[ciąg tekstowy]	The database connection (not the database name). Existing connections will be shown in the combobox.
Zapytanie SQL	SQL	[ciąg tekstowy]	Defines the SQL query, for example 'UPDATE my_table SET field=10'.
Unique ID field name	ID_FIELD	[ciąg tekstowy] Domyślnie: id	Sets the primary key field (a column in the result table)
Geometry field name Opcjonalne	GEOMETRY_FIELD	[ciąg tekstowy] Domyślnie: «geom»	Name of the geometry column (a column in the result table)

Wyniki

Etykieta	Nazwa	Typ	Opis
SQL layer	OUTPUT	[vector: any]	The resulting vector layer to be loaded into QGIS.

Kod pythona

ID algorytmu: qgis:postgisexecuteandloadsql

import processing
processing.run("algorithm_id", {parameter_dictionary})

The algorithm id is displayed when you hover over the algorithm in the Processing Toolbox. The parameter dictionary provides the parameter NAMEs and values. See Using processing algorithms from the console for details on how to run processing algorithms from the Python console.

24.1.3.5. PostgreSQL execute SQL

Allows a SQL database query to be performed on a PostgreSQL database connected to QGIS. The algorithm won’t create a new layer: it is designed to run queries on the layer itself.

Przykład

1. Set all the values of an existing field to a fixed value. The SQL query string will be:

   UPDATE your_table SET field_to_update=20;
   

   In the example above, the values of the field field_to_update of the table your_table will be all set to 20.

2. Create a new area column and calculate the area of each feature with the ST_AREA PostGIS function.

   -- Create the new column "area" on the table your_table"
   ALTER TABLE your_table ADD COLUMN area double precision;
   -- Update the "area" column and calculate the area of each feature:
   UPDATE your_table SET area=ST_AREA(geom);
   

Zobacz także

PostgreSQL execute and load SQL, Wykonaj SQL, SpatiaLite execute SQL

Parametry

Etykieta	Nazwa	Typ	Opis
Database (connection name)	DATABASE	[ciąg tekstowy]	The database connection (not the database name). Existing connections will be shown in the combobox.
Zapytanie SQL	SQL	[ciąg tekstowy]	Defines the SQL query, for example 'UPDATE my_table SET field=10'.

Wyniki

No output is created. The SQL query is executed in place.

Kod pythona

ID algorytmu: native:postgisexecutesql

import processing
processing.run("algorithm_id", {parameter_dictionary})

The algorithm id is displayed when you hover over the algorithm in the Processing Toolbox. The parameter dictionary provides the parameter NAMEs and values. See Using processing algorithms from the console for details on how to run processing algorithms from the Python console.

24.1.3.6. SpatiaLite execute SQL

Allows a SQL database query to be performed on a SpatiaLite database. The database is determined by an input layer or file. The algorithm won’t create a new layer: it is designed to run queries on the layer itself.

Zobacz także

PostgreSQL execute SQL, Wykonaj SQL

For some SQL query examples see PostGIS SQL Query Examples.

Parametry

Etykieta	Nazwa	Typ	Opis
Database layer (or file)	DATABASE	[plik]	The SQLite/SpatiaLite database file to connect to
Zapytanie SQL	SQL	[ciąg tekstowy] Domyślnie: «»	Defines the SQL query, for example 'UPDATE my_table SET field=10'.

Wyniki

No output is created. The SQL query is executed in place.

Kod pythona

ID algorytmu: native:spatialiteexecutesql

import processing
processing.run("algorithm_id", {parameter_dictionary})

The algorithm id is displayed when you hover over the algorithm in the Processing Toolbox. The parameter dictionary provides the parameter NAMEs and values. See Using processing algorithms from the console for details on how to run processing algorithms from the Python console.

24.1.3.7. SpatiaLite execute SQL (registered DB)

Allows a SQL database query to be performed on a SpatiaLite database connected to QGIS. The algorithm won’t create a new layer: it is designed to run queries on the layer itself.

Zobacz także

PostgreSQL execute SQL, Wykonaj SQL

For some SQL query examples see PostGIS SQL Query Examples.

Parametry

Etykieta	Nazwa	Typ	Opis
Database	DATABASE	[wyliczenie] Default: not set	Select a SQLite/SpatiaLite database connected to the current session
Zapytanie SQL	SQL	[ciąg tekstowy] Domyślnie: «»	Defines the SQL query, for example 'UPDATE my_table SET field=10'.

Wyniki

No output is created. The SQL query is executed in place.

Kod pythona

ID algorytmu: native:spatialiteexecutesqlregistered

import processing
processing.run("algorithm_id", {parameter_dictionary})

The algorithm id is displayed when you hover over the algorithm in the Processing Toolbox. The parameter dictionary provides the parameter NAMEs and values. See Using processing algorithms from the console for details on how to run processing algorithms from the Python console.