Ed Leafe wrote:
> On Apr 26, 2007, at 3:59 AM, Carl Karsten wrote:
>
>> In my BO, I do:
>> self.dbs = self.conn.cursor._records
>
> Two questions: why does you bizobj need the entire data set at once?
So all the DBs (probably around 20) can be displayed in in the grid, user uses
check box column in grid to pick which DBs are acted on in this loop:
def runCommandOnDBs(self):
# for each db the user has rights too...
for row in self.conn.cursor._records:
if row['selected']:
# use the db, execute the command
try:
self.conn.cursor.execute('use %(table_schema)s' % row )
self.conn.cursor.execute(self.sqlCmd)
(which now has:
if row['selected']:
you get a cookie for finding a bug :)
> And if it really does, why not use getDataSet()?
>
http://dabodev.com/wiki/DataSet
Um, because eve after reading
http://dabodev.com/wiki/DataSet
I don't know how. here is my try:
self.conn.getDBs(self.user)
# self.dbs = self.conn.cursor._records
# ({'table_schema': u'testdb1', 'selected': False},
self.dbs = self.getDataSet()
print self.dbs # None
How would I use it?
Carl K
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]