On Thursday 23 August 2007 17:48, Ed Leafe wrote: > dabo Commit > Revision 3330 > Date: 2007-08-23 17:48:03 -0700 (Thu, 23 Aug 2007) > Author: Ed > Trac: http://svn.dabodev.com/trac/dabo/changeset/3330 > > Changed: > U trunk/dabo/db/dbPostgreSQL.py > > Log: > Merged my changes with the ones John just committed. > > > Diff: > Modified: trunk/dabo/db/dbPostgreSQL.py > =================================================================== > --- trunk/dabo/db/dbPostgreSQL.py 2007-08-24 00:40:07 UTC (rev 3329) > +++ trunk/dabo/db/dbPostgreSQL.py 2007-08-24 00:48:03 UTC (rev 3330) > @@ -67,13 +67,13 @@ > rs = cursor.getDataSet() > tables = [] > for record in rs: > - tables.append(record[0]) > + tables.append(record["tablename"]) > return tuple(tables) > > > def getTableRecordCount(self, tableName, cursor): > cursor.execute("select count(*) as ncount from %s" % tableName) > - return cursor.getDataSet()[0][0] > + return cursor.getDataSet()[0]["ncount"] > > > def getFields(self, tableName, cursor): > @@ -106,15 +106,12 @@ > thePKFieldName = None > else: > #thestr = rs2[0][3] > - #thePKFieldName = thestr[thestr.find("(") + 1: > thestr.find(")")].split(", ") - #thePKFieldName = > rs2[0][3] > thePKFieldName = rs2[0]['column_name'] > > fields = [] > for r in rs: > - name = r['attname'] > - #fldType =r[2] > - fldType =r['typname'] > + name = r["attname"] > + fldType =r["typname"] > pk = False > if thePKFieldName is not None: > pk = (name in thePKFieldName)
Did I miss something? Why are double quotes important? -- John Fabiani _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev Searchable Archives: http://leafe.com/archives/search/dabo-dev This message: http://leafe.com/archives/byMID/dabo-dev/[EMAIL PROTECTED]
