Once the dConnection object is instantiated, you should be able to:
cursor = dconnection.getDaboCursor()
cursor.superCursor.execute("set search_path...")
I tried this in security manager but got an error
File "main.py", line 88, in validateLogin
cursor.superCursor.execute("set search_path to public,firma1")
TypeError: unbound method execute() must be called with DictCursor instance
as first argument (got str instance instead)
So I think I neet to use my original code.
My validateLogin method is:
def validateLogin(self, user, password):
from dabo.db.dConnectInfo import dConnectInfo
from dabo.db.dConnection import dConnection
ci = self.Application.dbConnectionDefs["[EMAIL PROTECTED]"]
ci.Name = "mainConnection"
ci.User = user
ci.PlainTextPassword = password
import exceptions
try:
self.connection = dConnection(ci)
except exceptions.StandardError, err:
dabo.ui.exclaim( str(err))
return False
cursor = self.connection.getDaboCursor()
cursor.superCursor.execute("set search_path to public,firma1")
return True
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
