Hi
> a proper properties dialog with possibility for modification should be easy
> to implement. should we add a featreq for that?
It would surely be better.
Should not be too difficult, must take care of the following points though :
- choose between "modify the connection" or
"add a new connection". Second is probably better but :
- if many layers use the same connection, need to find a way to
modify them all if one is modified (something similar is done to
retrieve files of a project when the files have moved)
Michaël
>
> ..ede
>
> On 07.04.2013 18:10, Michaël Michaud wrote:
>> Hi,
>>
>> Just made a hackish modification for database users.
>> Up to now, a project containing DataStoreDataSource
>> layers or DataStoreQueryDataSource layers could no
>> more be opened if connections become invalid.
>>
>> It now imports empty layers instead, keeping the invalid
>> connection and, more important, the SQL query and the
>> styles attached to the layer.
>> You still cannot connect to your new database, but you
>> can change connection parameters with the following
>> script (only tested with DataStoreQueryDataSource)
>>
>> need r3482
>>
>> Michaël
>>
>> // ----------------------------------------------
>> // This script will change database connections
>> // for selected layers
>> // Use case : you have an old project containing
>> // many database connections and/or queries, but
>> // your database, or password has changed.
>> // You can still load the project (it will throw
>> // exceptions and create empty layers), and use
>> // this script to change database connections.
>> // ----------------------------------------------
>> import
>> com.vividsolutions.jump.workbench.ui.plugin.datastore.DataStoreQueryDataSource;
>> for (lyr : wc.layerNamePanel.selectedLayers) {
>> ds = lyr.dataSourceQuery.dataSource;
>> if (ds instanceof DataStoreQueryDataSource || ds instanceof
>> DataStoreDataSource) {
>> //print(ds.properties.get("Connection
>> Descriptor").parameterList.schema.names);
>> ds.properties.get("Connection
>> Descriptor").parameterList.setParameter("Server", "new_server");
>> ds.properties.get("Connection
>> Descriptor").parameterList.setParameter("Server", "new_port");
>> ds.properties.get("Connection
>> Descriptor").parameterList.setParameter("Database","new_name");
>> ds.properties.get("Connection
>> Descriptor").parameterList.setParameter("User", "new_user");
>> ds.properties.get("Connection
>> Descriptor").parameterList.setParameter("Password","new_pwd");
>> }
>> }
>>
>> ------------------------------------------------------------------------------
>> Minimize network downtime and maximize team effectiveness.
>> Reduce network management and security costs.Learn how to hire
>> the most talented Cisco Certified professionals. Visit the
>> Employer Resources Portal
>> http://www.cisco.com/web/learning/employer_resources/index.html
>> _______________________________________________
>> Jump-pilot-devel mailing list
>> Jump-pilot-devel@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>>
> ------------------------------------------------------------------------------
> Minimize network downtime and maximize team effectiveness.
> Reduce network management and security costs.Learn how to hire
> the most talented Cisco Certified professionals. Visit the
> Employer Resources Portal
> http://www.cisco.com/web/learning/employer_resources/index.html
> _______________________________________________
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>
>
------------------------------------------------------------------------------
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
