On Tue, Aug 13, 2002 at 01:32:33PM -0400, Jim Penny wrote:
> Suppose, I have many ZSQL methods using the foo DA, and want to switch,
> or at least test the bar DA.
>
> How do I programatically make the switch?
>
> I could swear that this has come up before, but I cannot find it.
OK, this does the job
External method--
def switch_sql_connectionid(self):
objs = self.ZopeFind(self.this(), obj_metatypes=['Z SQL Method'],
search_sub=1)
message=''
for path, method in objs:
title=method.title
conn_id=method.connection_id
args=method.arguments_src
body=method.src
new_conn_id='Bar_database_connection'
message+='Changing %s from conn_id %s to conn_id%s'%(path,
conn_id, new_conn_id)
method.manage_edit(title, new_conn_id, args, body)
message +='.\n'
return message
Notes:
1) It is indeed a connection id that you need here, and not a
connection object.
2) search_sub=1 implies recursive, search_sub=0 imples this folder
only.
Jim Penny