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.ger...@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@lists.osgeo.org <mailto:qgis-developer@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@lists.osgeo.org <mailto:QGIS-Developer@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>
_______________________________________________
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Reply via email to