[GIS] Deleting vector layer from GeoPackage using PyQGIS

deletegeopackagepyqgis-3pythonvector

Programmatically I have added the vector layers to an existing GeoPackage in QGIS 3.2 using Python. Similarly, I would like to delete a layer from the existing GeoPackage using Python code. But there is no example/help found online.

Here is my code to add the selected layers to an existing Geo package:

layer = self.iface.activeLayer() 
layer.startEditing()
gpkgPath='D:/AA/Layer/sample_gpkg'
options = QgsVectorFileWriter.SaveVectorOptions()
options.actionOnExistingFile =QgsVectorFileWriter.CreateOrOverwriteLayer   
options.layerName = 'test'
_writer=QgsVectorFileWriter.writeAsVectorFormat(layer,gpkgPath,options)

Best Answer

You can use the SpatiaLite execute SQL tool and drop table:

gpkg = '/home/bera/GIS/Data/testdata/overlaps.gpkg'
lyr = 'overlaps'

processing.run("native:spatialiteexecutesql", {'DATABASE':'{0}|layername={1}'.format(gpkg, lyr),
    'SQL':'drop table {0}'.format(lyr)})

Related Solutions

[GIS] QGIS – PYQGIS Import gpx as vector layer

This is only half an answer as the following code can be used to import waypoints, routes and tracks but not route_points or track_points (these seem to be replaced by the tracks layer).

import os

path = "path/to/gpx/folder"
names = ["waypoint", "route", "track", "route_point", "track_point"]

for dirpath, subdirs, files in os.walk(path):
    for f in files:
        for name in names:
            iface.addVectorLayer(os.path.join(dirpath, f)+"?type="+name, name, "gpx")

Not sure how to import the last two layers using PyQGIS. The code was adapted from this useful post:

iface.addVectorLayer on a gml file causes “Select vector layers to add” dialog (pyqgis).

[GIS] Deleting all Features of a Vector Layer in pyQGIS

You could use the following code which is heavily based on the answer from this post: How to delete selected features in QGIS using Python

layer = iface.activeLayer()
with edit(layer):   
    for feat in layer.getFeatures():
        layer.deleteFeature(feat.id())

Edit:

Thanks to @GermánCarrillo, a more efficient method could be to delete all features at once:

layer = iface.activeLayer()
with edit(layer):
    listOfIds = [feat.id() for feat in layer.getFeatures()]
    layer.deleteFeatures( listOfIds )

Best Answer

Related Solutions

[GIS] QGIS – PYQGIS Import gpx as vector layer

[GIS] Deleting all Features of a Vector Layer in pyQGIS

Related Question