Thomas Baumann @work thbaumann

Debugging QGIS 3.x python plugins on Windows 10 using VS Code

In QGIS install the plugin debugvs.

The debugvs plugin needs the python module ptvsd to function. This module is not installed by default.

C:\OSGeo4W64\apps\Python37\python.exe -m pip install ptvsd==4.3.2

{
    "name": "Python: Remote Attach",

	-- Table: public.qgis_log_table

	-- DROP TABLE IF EXISTS public.qgis_log_table;

	CREATE TABLE IF NOT EXISTS public.qgis_log_table
	(
	log_id integer NOT NULL DEFAULT nextval('qgis_log_table_log_id_seq'::regclass),
	"timestamp" timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
	username character varying(255) COLLATE pg_catalog."default" NOT NULL,
	message text COLLATE pg_catalog."default" NOT NULL,

	from PyQt5.QtSql import QSqlDatabase, QSqlQuery
	from PyQt5.QtCore import Qt, QTimer, QDateTime
	from qgis.core import QgsApplication, Qgis
	from qgis.utils import plugins
	import os
	import traceback


	# Variable to hold the connection
	message_log_connection = QgsApplication.messageLog()

	spaltenname = 'name'
	anzahl_spaltenzeichen = 8 # wieviele zeichen soll fuer die spaltenueberschrift verwendet werden. bsp 8
	datentyp = QVariant.Double # datentyp der zu erzeugenden Spalten

	vectorLayer = iface.activeLayer() # aktiver Layer
	idx = vectorLayer.fields().indexOf(spaltenname)
	values = vectorLayer.uniqueValues(idx)
	#print(values)
	provider = vectorLayer.dataProvider()

	# Iterating over the input layer :
	for m in municip.getFeatures():
	inh_center = m['EWZ']
	#
	# central municipalites with 0 inhabitants must be excluded; the value of "center_pos" will be set to -1.
	if inh_center == 0:
	center_pos = -1
	dict = {m.fieldNameIndex('center_pos'):center_pos}
	municip.dataProvider().changeAttributeValues({m.id(): dict}) \
	#

	# coding: utf-8
	from qgis.PyQt.QtCore import Qt
	from qgis.gui import QgsMapTool
	from qgis.utils import iface


	class SendPointToolCoordinates(QgsMapTool):
	""" Enable to return coordinates from clic in a layer.
	"""
	def __init__(self, canvas, layer):

	--DROP TABLE testlayer_polygone;

	CREATE TABLE testlayer_polygone
	(id NUMBER(20),
	name VARCHAR2(15) NOT NULL,
	geom "MDSYS"."SDO_GEOMETRY",
	CONSTRAINT testlayer_polygone_pk PRIMARY KEY (id)
	);
	--select * from all_sdo_geom_metadata WHERE table_name = upper('testlayer_polygone');

	{
	"telemetry.enableTelemetry": false,
	"python.defaultInterpreterPath": "C:\\OSGeo4W64\\apps\\Python37\\python.exe",
	"window.zoomLevel": 0,
	"terminal.integrated.shell.windows": "C:\\Windows\\System32\\cmd.exe",
	"git.path": "Z:\\Programme\\Git\\bin\\git.exe",

	"launch":
	{
	// Use IntelliSense to learn about possible attributes.

	if (
	distance(
	overlay_nearest(
	layer:='poligono',
	expression:= $geometry )[0], $geometry) <
	distance(
	overlay_nearest(
	layer:='linea',
	expression:= $geometry )[0], $geometry),overlay_nearest(
	layer:='poligono',