[QGIS-Developer] PyQGIS read project from postgresql database

[Alexandre Neto]

Hi,

Actually, after I turned off the computer, I saw the fileName() method in documentation.

I tried it and I realised that both my password and project name needed percent encoding some characters.

So I have parsed my uri string with urllob.parse.quote to make it work correctly.

Not sure if there's a more convenient way to do it.

Thanks for the help German.

Alex Neto

On Sat May 13, 2023, 02:23 AM GMT, Germán Carrillo <mailto:carrillo.german at gmail.com> wrote:
> Hi,
>
> what do you get if you run the following line on your QGIS Python console in a QGIS session where your project (the one stored in PG) is loaded?
>
> QgsProject.instance().fileName()
>
> Regards,
>
> Germán
>
>
> El vie, 12 may 2023 a las 19:22, Alexandre Neto via QGIS-Developer (<qgis-developer at lists.osgeo.org <mailto:qgis-developer at lists.osgeo.org>>) escribió:
>> Hi,
>>
>> I am trying to read a project that is stored in a postgreSQL/PostGIS database, but I am struggling with getting it correctly. I am using the following code
>>
>> project = QgsProject.instance()
>> uri = 'postgresql://my_user:my_pass@localhost:5432?sslmode=disable&dbname=my_database&schema=my_schema&project=my_project_name'
>> project.read(uri)
>>
>> The last command always return false, and no project is loaded
>>
>> The documentation of QgsProject.read() only mentions filenames, not uri, but this answer seems to propose this uri format that would work:
>>
>> https://gis.stackexchange.com/a/354615/6191 <https://gis.stackexchange.com/a/354615/6191>
>>
>> Any suggestions on how to solve or debug this? I get no error messages from the read method.
>>
>> Thanks,
>>
>> Aleandre Neto
>> _______________________________________________
>> QGIS-Developer mailing list
>> QGIS-Developer at lists.osgeo.org <mailto:QGIS-Developer at lists.osgeo.org>
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer <https://lists.osgeo.org/mailman/listinfo/qgis-developer>
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer <https://lists.osgeo.org/mailman/listinfo/qgis-developer>
>
>
> --
> -----------
> |\__
> (:>__)(
> |/
> Soluciones Geoinformáticas Libres
> http://geotux.tuxfamily.org/ <http://geotux.tuxfamily.org/>
> https://twitter.com/GeoTux2 <http://twitter.com/GeoTux2>
>
>
[image] <http://gis.stackexchange.com/users/4972/germ%c3%a1n-carrillo>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20230513/6424371d/attachment.htm>