Le portail francophone de la géomatique

from PyQt5.QtCore import *
from PyQt5.QtGui import *
from qgis.core import *
from qgis.gui import *
from random import randrange
from os import path
from qgis.utils import iface
def run_script(iface):

    #con base de donnée

    uri = QgsDataSourceUri()
    uri.setDatabase('C:\\bckup\\dev\\admin\\QGIS_PE\\Sortie\\BDClient.sqlite')
    schema = ''
    geom_column = 'geom'#definit le nom de la colonne geometrique

    #choix de la table
    uri.setDataSource(schema, 'Part_de_Marche', geom_column) 

    #creation couche en definissant quel nom on lui donne
    layer = QgsVectorLayer(uri.uri(), 'Part de Marche', 'spatialite')
    
    #------affiche la couche avec une categorisation ----#
    fni =  layer.fields().indexFromName('Part_Marche') #renseigner le nom de la colonne a catégoriser
    unique_vals = layer.dataProvider().uniqueValues(fni)
    categories = []

    for val in unique_vals:
    # initialise the default symbol for this geometry type
        symbol = QgsSymbol.defaultSymbol(layer.geometryType())
        
    # configure a symbol layer
        layer_style = {}
        layer_style['color'] = '%d, %d, %d' % (randrange(0,256),randrange(0,256),randrange(0,256))
        layer_style['outline'] = '#000000'
        symbol_layer = QgsSimpleFillSymbolLayer.create(layer_style)

    # replace default symbol layer with the configured one

        if symbol_layer is not None:
            symbol.changeSymbolLayer(0, symbol_layer)
        else:
            print ("success")
    # create renderer object
        category = QgsRendererCategory(val, symbol, str(val))

    # entry for the list of category items
        categories.append(category)

 # create renderer object
    renderer = QgsCategorizedSymbolRenderer('Part_Marche', categories)#renseigner le nom de la colonne a catégoriser

# assign the created renderer to the layer
    if renderer is not None:
        layer.setRenderer(renderer)
    layer.triggerRepaint()



    #afficher carte 
    root = QgsProject.instance().layerTreeRoot()
    myGroup = root.addGroup('Carte Bonus')
    root = QgsProject.instance().layerTreeRoot()
    mygroup = root.findGroup('Carte Bonus')
    QgsProject.instance().addMapLayer(layer, False)
    mygroup.addLayer(layer)