search

opengisch / OpenComptage

Neuchâtel "comptages"
2 stars 3 forks source link

Python warnings #110

Open marioba opened 4 years ago

marioba commented 4 years ago

Avec la LTR, python donne ces 3 warning concernant OpenComptages :

  1. warning:C:\apps\OSGEO4~1\apps\Python37\lib\site-packages\requests__init__.py:91: RequestsDependencyWarning: urllib3 (1.25.6) or chardet (3.0.4) doesn't match a supported version!

  2. Using or importing the ABCs from 'collections' instead of from 'collections.abc' is deprecated, and in 3.8 it will stop working

  3. inspect.getargspec() is deprecated, use inspect.signature() or inspect.getfullargspec()

Avec la version 3.10.0 il y a ce message qui apparaît image est-ce normal ? est-ce que tout fonctionne quand même correctement ?

marioba commented 4 years ago

Pour les macros, il est tout à fait normal que QGIS demande si tu veut les exécuter. Dans les options de QGIS il est possible de modifier ce comportement .

spch-GL commented 3 years ago

Avec Qgis 3.10.12 et le plug-in 0.7.6b (24.05.2020) les 3 warnings ci-dessus ont disparu. Par contre la connexion à la base provoque:

  1. ces Warnings PostGIS:

    2020-12-09T08:39:54     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='installation' AND f_geometry_column ='geometry' ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:54     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='section' AND f_geometry_column ='geometry' ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:54     WARNING    ATTENTION: row number 0 is out of range 0..-1
2020-12-09T08:39:54     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='lane' AND f_geometry_column IS NULL ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:54     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='count' AND f_geometry_column IS NULL ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:54     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='model' AND f_geometry_column IS NULL ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:54     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='device' AND f_geometry_column IS NULL ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:54     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='sensor_type' AND f_geometry_column IS NULL ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:55     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='class' AND f_geometry_column IS NULL ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:55     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='damage_log' AND f_geometry_column IS NULL ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:55     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='brand' AND f_geometry_column IS NULL ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:55     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='category' AND f_geometry_column IS NULL ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:55     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='special_period' AND f_geometry_column IS NULL ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:55     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='installation' AND f_geometry_column ='geometry' ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:55     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='section' AND f_geometry_column ='geometry' ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:55     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='lane' AND f_geometry_column IS NULL ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:55     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='count' AND f_geometry_column IS NULL ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:55     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='model' AND f_geometry_column IS NULL ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:55     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='device' AND f_geometry_column IS NULL ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:55     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='sensor_type' AND f_geometry_column IS NULL ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:55     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='class' AND f_geometry_column IS NULL ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:55     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='damage_log' AND f_geometry_column IS NULL ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:55     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='brand' AND f_geometry_column IS NULL ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:55     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='category' AND f_geometry_column IS NULL ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]
2020-12-09T08:39:55     WARNING    Requête erronée : SELECT styleQML FROM layer_styles WHERE f_table_catalog='spch' AND f_table_schema='comptages' AND f_table_name='special_period' AND f_geometry_column IS NULL ORDER BY CASE WHEN useAsDefault THEN 1 ELSE 2 END,update_time DESC LIMIT 1 a retourné 7 [ERREUR: droit refusé pour la relation layer_styles
         ]

  2. ce Warning Avertissement Python

    2020-12-09T08:39:54     WARNING    warning:C:/Users/GrelletP/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\comptages\core\layers.py:198: DeprecationWarning: QgsCoordinateReferenceSystem constructor is deprecated
          crs = QgsCoordinateReferenceSystem(epsg)

         traceback: File "C:/Users/GrelletP/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\comptages\comptages.py", line 167, in do_connect_db_action
          self.layers.load_layers()
          File "C:/Users/GrelletP/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\comptages\core\layers.py", line 56, in load_layers
          layer_definition['epsg'],
          File "C:/Users/GrelletP/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\comptages\core\layers.py", line 198, in load_layer
          crs = QgsCoordinateReferenceSystem(epsg)
spch-GL commented 3 years ago

Il y a les mêmes Warnings sous QGIS 3.16.1